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


RE/MAX Renowned Properties

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

 

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

 

$599,000

1338 S. Southview Drive, Cedar City

MLS#46633

6 bedrooms, 3.5 baths with 100% finished basement

2.75-acre lot with fabulous views!!

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 %>

 

$599,900

2173 N. Ashdown Forest Road, Cedar City

MLS#42328

Large, open floor plan with amazing interior detail

Two-story home with unfinished basement

View Listing