% 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
|
||
![]()
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. |
||