<% Set ListConn = Server.CreateObject("ADODB.Connection") ListConn.Open "remax" SQLQuery = "SELECT * FROM [Data Sheet] WHERE ID = "& request("ID") &"" Set list_query = ListConn.Execute(SQLQuery) response.write ("") %>
 
Zion Inn Motel

<%= list_query("Address") %>Address:  222 South Main Street, Cedar City

MLS# 45517

Price: $395,000
<%= list_query("school") %>

 0.46- acre L-shaped lot with frontage on two busy streets--200 South and Main Street.  Great location in the downtown commercial district.  Property is within three blocks of Southern Utah University, the Utah Summer Games, and the Utah Shakespearean Festival.  It is also within three blocks of the Cedar City Historic Downtown, Lin's Marketplace, clothing & shoe retailers, jewelers,  restaurants, gas stations, and more.  Excellent visibility and high-traffic location.  Outstanding location for commercial application. (Structure on property was formally a 30-unit hotel--extensive fire damage in 2003).

Click here for printable brochure

Information deemed reliable but not guaranteed. 

Return to Listings

Quick Contact
Please contact me regarding this listing.

Your Name:
 Phone:
 Email:
Property:
 Other Comments: