% 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 ("") %>
| Won't Break You | |
|
<%= list_query("Address") %>Address: 408 S. Casa Loma Lane, Cedar City MLS# 43517 Price: $219,888
|
|
|
|
|
|
This 5 bedroom, 3 bath home is approx. 2800 square feet on two levels and situated on 0.50-acre lot. 3 of the bedrooms are on the main level which includes the master bedroom and master bathroom. The other two bedrooms are conveniently located opposite the home from the master with the 2nd upstairs bathroom. The remaining 2 of the 5 total bedrooms are downstairs with an additional bathroom and walk-out basement. The master has a walk-out uncovered deck with great views!! The basement was finished in 2002 and the additional bathroom and door to walk-out basement was done in the past 2 years. The gas furnace is new in 2002 plus a humidifier, newer roof, newer carpet in the family room, and newer kitchen cabinets. This home also has an extra large family room and main floor laundry. The yard is fenced and has mature fruit trees. **square footage an estimate--buyer to verify Click here for printable brochure
Information deemed reliable but not guaranteed.
|
|
|