<% 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 ("") %>
 
Lease to Own!!

<%= list_query("Address") %>Address:  290 North Torrey Pines, Cedar City

MLS#45514

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

With full landscaping, front & back, there’s no comparison for this great buy!  It’s easy to see that this is the best value in the neighborhood!  Beautiful one-story twin home in The Terraces at Blackrock.  Home was built in 2005 and is in great condition!  3 bedrooms, 2 baths, and appx. 1260 square feet.  The home is beautifully finished in tile & carpet, very nice lighting fixtures, vaulted ceilings, and great color choices.  There are lots of windows allowing for great natural lighting and fantastic views.  0.09-acre lot (appx.) has automatic sprinklers.  1-car attached garage. **square footage an estimate--buyer to verify

Click here for printable brochure

Return to Listings

Quick Contact
Please contact me regarding this listing.

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