<% 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
<%= list_query("school") %>

 

·          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. 

Return to Listings

Quick Contact
Please contact me regarding this listing.

Your Name:
 Phone:
 Email:
Property:
 Other Comments: