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

$100,000 to $199,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 %>

 

$124,900

117 E. Bear Flat Road unit #6A, Brian Head

MLS#45193

1 Bedroom, 1 Bath

Appx. 703 s/f; built in 1983

right next to Brian Head Ski resort

 

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

 

 

$148,500

90 N. Silverspur Drive, Cedar City

MLS#45585

3 Bedrooms, 2 Baths; appx. 1548 s/f

Built in 1984; 2-car garage with circular driveway

0.27-acre, partially fenced and landscaped; RV hook-ups

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

$149,900

290 North Torrey Pines

MLS#45514

3 Bedrooms, 2 Baths

Appx. 1260 s/f; built in 2005

Landscaped front & back;

LEASE TO OWN!!

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

$149,900

545 N 300 W.  Cedar City

MLS#46220

4 Bedrooms, 2 Baths

Appx. 1092 s/f

New kitchen; cabinets, countertops, & fixtures!

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

$159,900

225 West 300 South, Parowan

MLS#46429

3 Bedrooms, 2 Baths

Appx. 1248 s/f; built in 2006

Hard to tell its a modular!! Great home!

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

$159,900

677 E. Rose Lane, Cedar City

MLS#45948

3 Bedrooms, 2 Baths

Large open floor plan, approx 1600 s/f, and all appliances stay.

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

$159,900

2018 East 2100 South,       Brian Head Area

MLS#45509

2 Bedrooms, 1 bath

Views of Brian Head Peak and within walking distance of Mammoth Creek

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

 

$183,900

 

1514 Southern View Drive, Cedar City

MLS#45511

3 Bedrooms, 2 Baths

Appx. 1270 s/f; built in 2006

Attractive home in excellent condition

 

 

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

$189,900

2355 West Cove Heights Cir. Cedar City

MLS#45510

4 Bedrooms, 3 Baths.  Appx. 2260 s/f; built in 1992

Sacramental pine laminate flooring throughout

 

View Listing