<% Set ListConn = Server.CreateObject("ADODB.Connection") ListConn.Open "remax" SQLQuery = "SELECT * FROM [Data Sheet] WHERE style = 'savage' ORDER by price" Set list_query = ListConn.Execute(SQLQuery) response.write ("") %>


Residential Homes for Sale

Residential Listings
Lots & Land Listings
Commercial Listings
Water Rights Listings
What's New?
Build A New Home
Tips For Buyers
Customer Testimonials
Buyer's Packet
Relocation Packet
MLS Search
Home Page

$250,000 to $299,999

<% row=0 while not list_query.eof if row=3 then response.write "" row=0 end if %> <% row=row+1 list_query.movenext %> <% wend %>

$255,000

713 E. Nichols Canyon Road, Cedar City

MLS#45508

3 bedrooms, 2 baths

Appx. 1698 s/f; built in 2003

Upstairs bonus room!!

View Listing

<% row=0 while not list_query.eof if row=3 then response.write "" row=0 end if %> <% row=row+1 list_query.movenext %> <% wend %>

 

$290,000

1358 South 550 West, Cedar City

MLS#44839

4 bedrooms; 3 baths. Built in 2006

Approx. 15060 s/f plus 1506 s/f 100% finished basement

0.28-acre lot completely landscaped

View Listing