% 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 ("") %>
| An Experience In Itself | ||
|
<%= list_query("Address") %>Address: 2173 N. Ashdown Forest Road, Cedar City MLS# 42328 Price: $599,900
|
||
|
|
![]()
|
|
|
· Walking into this home is an experience in itself. Beautiful, custom home built by Prema Communities in 2007 · 3600 sq/ft convenient two-story living with 2558 sq/ft unfinished basement all framed and ready to finish! (square footage appx.) · 5 bedrooms, 5 baths · Large, open floor plan with tile floors & wall-to-wall carpet throughout · Formal entry has amazing high ceilings which look up to the landing above with beautiful iron railing and rubbed bronze chandelier. · Upper level landing is large enough to have an additional TV area. · Amazing staircase with windows that bring in amazing light and has recessed areas for your art work. · Spacious master suite large enough for a sitting area + all your bedroom furniture. · Glass French doors access to outside deck from master suite and breakfast area. · Master bath has granite countertops, dual beige sinks, large walk-in tiled shower with his and her shower heads, jetted tub, spacious walk-in closet. To top it off is even a flow through gas fireplace. · Spacious den or office space with dark wood floors, high ceilings, and natural stained ceilings. · The kitchen has amazing craftsmanship. Knotty alder cabinets have “no slam” hinges, beadboard, corbel accents, and granite countertops. · Kitchen island has an additional work sink and built in microwave. · Dual ovens, countertop range, side-by-side refrigerator, and microwave are all Kitchen Aid appliances. · Mudroom with places for coats and shoes and there is also a drinking fountain! · Full laundry room has granite countertops, lots of cabinetry with a Lazy Susan, and windows that make it light and airy. · Central vac is also a main feature of this home. · Deep, 3-car garage · Situated on 0.49 of an acre and ready for you landscape ideas!! · For an audio tour of this home, please call 1-866-586-8059 x 1250. To view more photos of this home, click here Click here for printable brochure
Information deemed reliable but not guaranteed.
|
||
|
||