string(1542) "SELECT r.*, CONCAT(a.first_name,' ',a.last_name) AS 'agent_name', a.agent_phone, a.agent_email, a.photo AS 'agent_photo', a.url AS 'agent_url', a.office_id AS 'agent_office_id' , o.office_name AS 'agent_office_name', o.office_phone AS 'agent_office_phone', o.office_address AS 'agent_office_address', o.office_city AS 'agent_office_city', o.office_state AS 'agent_office_state', o.office_zip AS 'agent_office_zip', o.office_website AS 'agent_office_url' , CONCAT(c.first_name,' ',c.last_name) AS 'co_agent_name', c.agent_phone as 'co_agent_phone', c.agent_email AS 'co_agent_email', c.photo AS 'co_agent_photo', c.url AS 'co_agent_url', c.office_id AS 'co_agent_office_id' , co.office_name AS 'co_agent_office_name', co.office_phone AS 'co_agent_office_phone', co.office_address AS 'co_agent_office_address', co.office_city AS 'co_agent_office_city', co.office_state AS 'co_agent_office_state', co.office_zip AS 'co_agent_office_zip', co.office_website AS 'co_agent_office_url' , SUBSTRING_INDEX(r.address,' ', 1) as 'house_number' FROM `agentsites`.`all_RElistingdata` r LEFT JOIN agentsites.all_agents a on r.mls_id=a.mls_id AND r.agent_code=a.agent_id LEFT JOIN agentsites.all_offices o ON a.mls_id=o.mls_id AND a.office_id=o.office_id LEFT JOIN agentsites.all_agents c on r.mls_id=c.mls_id AND r.co_agent_code=c.agent_id LEFT JOIN agentsites.all_offices co ON c.mls_id=co.mls_id AND c.office_id=co.office_id WHERE 1=1 AND r.mls_id in ('1') AND r.`status` in ('Active') HAVING 1=1 ORDER BY price DESC LIMIT 12"

Search Results

returned 2042 results.

Search for this exact phrase (uncheck if you are searching by comma seperated values)
Property Type:
Commercial
Condominium
Fractional Interest
Vacant Land
Single Family Home


Maximum Days on Market:
Sort:
Price: (ex. $100,000)
 to 
Minimum Bedrooms:
Minimum Bathrooms:
Minimum Square Feet:
Minimum Acres:
Area:
City:

Thumbnails | List
$25,000,000
3853 E Rockport Ridge
Promontory Area
Deer Crossing
Park City, UT
Single Family
7996 sq ft
4 Beds / 8.00 Baths
5.63 acres
#11502942
Alan-Long - - (435) 649-3680
Days on Market - 668
$24,995,000
1943 N Wolf Creek Ranch Road
Woodland and Francis
Wolf Creek Ranch
Woodland, UT
Single Family
17861 sq ft
8 Beds / 11.00 Baths
320.00 acres
#11604855
Will-Lange - Summit-Sotheby's---Park-Ave - (435) 640-0001
Days on Market - 236
$21,900,000
9806 N Summit View
Deer Crest
Deer Crest Estates
Park City, UT
Single Family
13536 sq ft
6 Beds / 10.00 Baths
0.64 acres
#11603764
Jeff-Spencer - Resorts-West-Real-Estate-LLC - (435) 640-4770
Days on Market - 784
$19,500,000
1886 S Geneva Road
Wasatch Front (Salt Lake City - Ogden - Provo)
Wasatch Front Ar 38
Other City - Utah, UT
Single Family
21998 sq ft
9 Beds / 20.00 Baths
18.77 acres
#11504659
Kerry-Oman - Summit-Sotheby's---Park-Ave - (801) 369-2507
Days on Market - 366
$17,900,000
174 White Pine Canyon
The Canyons
Colony At White Pine Canyon
Park City, UT
Single Family
15743 sq ft
9 Beds / 14.00 Baths
5.31 acres
#11606092
Erik-Asarian - Keller-Williams-Park-City-RE - (435) 659-9900
Days on Market - 315
$17,500,000
2189 White Pine Canyon
The Canyons
The Canyons Area
Park City, UT
Single Family
5715 sq ft
4 Beds / 4.00 Baths
106.94 acres
#11604164
Peggy-Marty - BHHS-Utah-Properties---SV - (435) 640-0794
Days on Market - 215
$16,485,000
9151 S Wasatch
Wasatch Front (Salt Lake City - Ogden - Provo)
Wasatch Front Ar 38
Other City - USA, UT
Land
0 sq ft
0 Beds / 0.00 Baths
31.40 acres
#11700248
James-Williams - Williams-Realty-Park-City - (801) 244-6444
Days on Market - 2025
$14,900,000
1401 W Two Creeks
Old Ranch Road
Two Creeks
Park City, UT
Single Family
8503 sq ft
6 Beds / 9.00 Baths
7.34 acres
#11606100
Paul-Benson - Engel---Voelkers-Park-City - (435) 640-7441
Days on Market - 154
$13,950,000
40 Red Cloud
Empire Pass
Red Cloud
Park City, UT
Single Family
9693 sq ft
8 Beds / 11.00 Baths
1.08 acres
#11504690
Jeff-Spencer - Resorts-West-Real-Estate-LLC - (435) 640-4770
Days on Market - 804
$13,000,000
Situs Address
Other Utah
Other(Areas 23-41)
Other City - Utah, UT
Land
0 sq ft
0 Beds / 0.00 Baths
365.00 acres
#11605532
Benjamin-Dickamore - Summit-Sotheby's---Park-Ave - (801) 643-2215
Days on Market - 18
$12,900,000
91 White Pine Canyon Road
The Canyons
Colony At White Pine Canyon
Park City, UT
Single Family
14384 sq ft
9 Beds / 12.00 Baths
8.45 acres
#11700206
CJ-Johnson - BHHS-Utah-Properties---SV - (435) 901-7171
Days on Market - 1
$12,900,000
7 Roamer Court
Upper Deer Valley Resort
Bald Eagle Club
Park City, UT
Single Family
14100 sq ft
7 Beds / 10.00 Baths
1.57 acres
#11605837
Paul-Benson - Engel---Voelkers-Park-City - (435) 640-7441
Days on Market - 175
Loading More Results