<% 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 ("") %>
 
Hidden Treasures

<%= list_query("Address") %>Address:  2355 West Cove Heights Circle

MLS# 45510

Price: $189,900
<%= list_query("school") %>

Beautiful 4BD/3BA home built in 1992.  Appx. 2260 square feet.  Sacramental pine laminate flooring throughout entire house.  Home is custom built and 6 feet wider than track homes in the neighborhood.  Amenities include: Kohler china bath fixtures, central vac, rounded walls/window wells, 2-inch Plantation blinds, upgraded lights, vaulted ceilings, plant shelves, granite countertops, bay & garden windows.  Master suite has walk-in closet and whirlpool tub.  Home also has extra insulation in both roof (R-40) and walls; 6500 cfm evaporative cooling, 50-gal water heater, 30-year architectural composition roof, and much more.  0.33-acre lot is fully fenced in 6’ chain link, beautifully landscaped in front, and has fantastic views of the mountains and Cedar City.

 **square footage an estimate--buyer to verify

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: