<% 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 ($380,000 and above)

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

 

$380,000

6789 West 1350 West, Cedar City

MLS#43883

4 bedrooms, 3.5 baths; built in 2006

Approx. 2730 s/f main level PLUS 495 s/f bonus room

1.06-acre lot w/ vinyl fencing

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

 

 

 

$399,900

991 E. Nichols Canyon Road, Cedar City

MLS#42406

5 bedrooms, 4 baths. (2 of these bedrooms are master suites)

Built in 2005; approx. 4022 s/f

0.32-acre lot fully landscaped and fully fenced block wall. Incredible yards!!

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

 

 

$399,900

1889 S. Westview Dr., Cedar City

MLS#45512

4 bedrooms, 4 baths. Built in 1994; Appx. 3490 s/f

2.50-acres, horse property

solid log, custom home with many unique and fun architectural amenities.

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

$424,900

117 E. Bear Flat Road unit #11B, Brian Head

MLS#45205

4 bedrooms, 2 baths

Built in 1983; approx. 2200 s/f

Right next to Brian Head Ski Resort!!

View Listing