% 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
|
||
![]()
|
![]()
|
|
|
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 |
||
|
||