F
<% 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 ($300,000 to $379,999)

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

 

SALE PENDING

4865 N. Horseshoe Drive, Enoch

MLS#44941

5 bedrooms, 3 baths

Approx. 2240 s/f plus 1550 s/f finished walk-out basement

1.75-acre lot; perfect horse property

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

$349,900

710 N. 75 W. Parowan

MLS#37579

4-plex investment opportunity with good rental history.

 

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

 

 

$364,900

2335 North 950 East, Cedar City

MLS#43723

4 bedrooms, 3 baths. Built in 2005

Approx. 2300 s/f with 1800 s/f unfinished basement

0.36-acre lot in cul-de-sac with access to walking trail

 

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

 

 

$364,900

136 S. Marble Canyon Drive, Cedar City

MLS#43531

5+ bedrooms; 3.5+ baths. Built in 2005

Approx. 1700 s/f main level & 1700 s/f 40% finished basement

0.23-acre lot with spectacular 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 %>

 

$364,900

160 S. Casa Loma Lane, Cedar City

MLS#45515

5 bedrooms; 3 baths. Built in 2003

Approx. 3289 s/f

0.23-acre lot fully landscaped & auto sprinklers

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

 

$369,900

1023 East 1975 North, Cedar City

MLS#44394

3 bedrooms, 2 baths. Built in 2005

Approx. 2288 s/f main level & 2320 s/f unfinished basement

0.25-acre lot

View Listing