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


                               Commercial Listings

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

$395,000

222 South Main, Cedar City

MLS#45517

Outstanding location for commercial application

0.46-acre on Main Street with great business visibility

View Listing