% Set ListConn = Server.CreateObject("ADODB.Connection") ListConn.Open "remax" SQLQuery = "SELECT * FROM [Data Sheet] WHERE ID = "& request("ID") &"" Set list_query = ListConn.Execute(SQLQuery) response.write ("") %>
| Spectacular Views!! | ||
|
<%= list_query("Address") %>Address: 136 S. Marble Canyon Drive, Cedar City MLS# 43531 Price: $364,900
|
||
![]()
|
![]()
|
|
|
This beautiful, newer home built in 2005 boasts 3400 square feet and is built with high quality materials and amenities. The main level is 1700 s/f and consists of 3 bedrooms, 2.5 baths and a huge laundry room. Beautiful solid red oak flooring encompasses most of the main level. The kitchen has an island and the counters are all solid surface Corian. The appliances are all higher end stainless steal GE. The master suite is on the main level and very open and airy. The master bathroom has a marble shower and jetted tub and dual sinks. The 2- back covered decks have fabulous views of 3-peaks and Nevada. The large walk-out basement is 40% finished which includes the “preferred” Styrofoam block foundation for added insulation and is framed and electrically wired for 2 additional bedrooms and plumbed for 1 bathroom. This home also has a fresh air re-circulating air system to save on energy usage and don’t forget the oversized 2-car garage. **square footage an estimate--buyer to verify. Click here for printable brochure
Information deemed reliable but not guaranteed.
|
||
|
||