<% 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 ("") %>
 
Stunning Success

<%= list_query("Address") %>Address: 1073 E. Nichols Canyon Road, Cedar City
<%= list_query("school") %>

Click here for more pictures

 

·          Beautiful, custom home built by Savage Development in 2004—unsurpassed quality and matchless design

·          3100 sq/ft convenient single-level living with 450 sq/ft detached casita (square footage appx.)

·          4 bedrooms, 3 1/2 baths

·          Large, open floor plan with tile floors & upgraded carpet throughout

·          Spacious master suite has sitting room with built-in cabinets/shelves & entertainment center, access to patio, & gas fireplace.  Master bath has large walk-in closet, steamer shower, garden tub, and a beautiful his/hers vanity

·          Expansive kitchen & dining area has access to covered patio and lots of windows.  Kitchen is finished with granite countertops & tile backsplash, knotty alder cabinets, custom range hood, and large island with seating.  All appliances are built-in & included in sale.

·          Family room has beautiful built-in entertainment center and a gas fireplace

·          Solid wood doors throughout

·          Tile countertops in laundry & baths plus custom tile work in showers

·          Large laundry room has lots of storage with built-in cabinets.  Washer & dryer are built-in and included in sale.

·          Detached casita houses 4th bedroom & 3rd full bath plus kitchenette.  Finishing includes all tile floors, shower, countertops, & backsplashes.  Plenty of storage with convenient bench window seats.

·          Home is finished with arched doorways, vaulted ceilings, interior rock work, wood shutters throughout, and intercom/sound system in the main living areas

·          Classic court yard & portico entry has gas fireplace and gated access 

·          Oversized 3-car garage has plenty of storage with built-in cabinets & shelves.  Also includes hot/cold water hookups plus floor drains for convenient car washing

·          0.37-acre lot fully landscaped and fenced in block wall

·          Large covered patio with access from multiple interior rooms

·          Exterior construction:  bartile roof, stucco & stone finish, and custom-built steel chimney cap

Click here for more pictures

Information deemed reliable but not guaranteed.