Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2788 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2788 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2788 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1310 S State St
Orderville, UT 84758

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,850,000
Beds: --
Baths: --
Status: Active
SqFt: 876862 Square Feet
Agency: RED ROCK REAL ESTATE
Agency Phone: (435) 275-2775

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 17 acre(s)
Property Type: Other-Other
Year Built: --
Notes: Property is located at the ''hub'' of what the national parks system refers to as The Grand Circle of National Parks and Monuments. Within this ''Grand Circle'' are 12 national parks and monuments all within a one hour drive of this property's location. Zion National Park's visitor count is now over 5 million visits per year. With the massive tourist congestion taking place on the west side of Zion,1310 South State in Orderville is 20 minutes from the east side of Zion National Park entrance and is destined to become a new center for tourist's gathering to the desert southwest regions. With a spectacular view of the 2000 foot tall tan, yellow, and red sandstone cliffs seen from this property (views from a hotel room looking east would be incredible), they mark the boundary to the Grand Staircase/Escalante National Monument. With this property in the hands of the right developer, the east side of Zion NP can now become a place for visitors to be able to "spread out" and linger for days in a region "filled with geological wonder" without feeling like they are "on top of each other" waiting in line for hours for a bus ride into Zion NP canyon. <br /> <br /> Located just 20 minutes from the East entrance of Zion National Park and the proposed new East ZNP visitor center. This beautiful property with views is one of the last larger commercially zoned parcels close to Zion NP. Easy access right off highway 89 and is perfect for tourism-based businesses. The property includes 50 shares of pressurized irrigation along with culinary water & power. Additional shares are available. Includes partially built concrete structures.<br /> <br /> Seller willing to consider Seller Financing.<br /> <br /> Minimum 24 hour notice for showing/meeting on site.
MlsNumber: --
ListingId: 23-245196


Listing Provided By: RED ROCK REAL ESTATE, original listing
Phone: (801) 859-3232
Office Phone: (435) 275-2775
Agent Name: DAVID WHITEHEAD
Disclaimer: Copyright © 2024 Washington County Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App