string(1609) "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.property_type in ('Condo') AND r.area_name in ('Jordanelle') AND r.`status` in ('Active') HAVING 1=1 ORDER BY price DESC LIMIT 15"

Jordanelle Reservoir Area Condos

returned 25 results.
Thumbnails | List
$749,000
10784 N Hideout Trail T4
Jordanelle
Hideout Canyon
Hideout, UT
Condo
2800 sq ft
3 Beds / 4.00 Baths
0.00 acres
#11600469
Patrick-Howell - Mountain-Home-Real-Estate - (801) 671-5671
Days on Market - 382
$725,000
10786 N Hideout Trail T3
Jordanelle
Hideout Canyon
Hideout, UT
Condo
2800 sq ft
3 Beds / 4.00 Baths
0.00 acres
#11600467
Patrick-Howell - Mountain-Home-Real-Estate - (801) 671-5671
Days on Market - 382
$665,000
1138 W Cadence Court 47E
Jordanelle
Black Rock Ridge
Heber City, UT
Condo
3049 sq ft
4 Beds / 4.00 Baths
0.00 acres
#11701495
Keri-Holland - Engel---Voelkers-Park-City - (801) 821-9396
Days on Market - 27
$665,000
14422 N Buck Horn Trail 52A
Jordanelle
Black Rock Ridge
Heber City, UT
Condo
3049 sq ft
4 Beds / 5.00 Baths
0.00 acres
#11701973
Keri-Holland - Engel---Voelkers-Park-City - (801) 821-9396
Days on Market - 2
$650,000
1735 E Viewside 58
Jordanelle
Rustler at Hideout Canyon
Hideout, UT
Condo
2969 sq ft
3 Beds / 3.00 Baths
0.00 acres
#11601889
Mandy-Greenwood - Vision-Real-Estate-Park-City - (801) 473-7023
Days on Market - 175
$629,000
1289 Deer Park Circle 303
Jordanelle
Village at the Shores - Cedar Edition
Heber City, UT
Condo
1577 sq ft
3 Beds / 2.00 Baths
0.00 acres
#11603209
Mark-Sletten - Engel---Voelkers-Park-City - (435) 640-0930
Days on Market - 174
$625,000
1289 Deer Park Circle 301
Jordanelle
Village at the Shores - Cedar Edition
Heber City, UT
Condo
1578 sq ft
3 Beds / 2.00 Baths
0.00 acres
#11603204
Mark-Sletten - Engel---Voelkers-Park-City - (435) 640-0930
Days on Market - 208
$625,000
1144 W Cadence Court Trail 47D
Jordanelle
Black Rock Ridge
Heber City, UT
Condo
2735 sq ft
4 Beds / 4.00 Baths
0.00 acres
#11701497
Keri-Holland - Engel---Voelkers-Park-City - (801) 821-9396
Days on Market - 27
$599,900
14350 N Rendezvous Trail 35A
Jordanelle
Black Rock Ridge
Heber City, UT
Condo
2635 sq ft
3 Beds / 4.00 Baths
0.00 acres
#11701502
Keri-Holland - Engel---Voelkers-Park-City - (801) 821-9396
Days on Market - 25
$599,000
14145 N Council Fire
Jordanelle
Black Rock Ridge
Kamas, UT
Condo
2188 sq ft
3 Beds / 4.00 Baths
0.00 acres
#11701758
- -
Days on Market - 13
$589,000
1289 Deer Park Circle 302
Jordanelle
Village at the Shores - Cedar Edition
Heber City, UT
Condo
1584 sq ft
3 Beds / 2.00 Baths
0.00 acres
#11603205
Mark-Sletten - Engel---Voelkers-Park-City - (435) 640-0930
Days on Market - 174
$559,660
14340 N Rendezvous Trail 35C
Jordanelle
Black Rock Ridge
Heber City, UT
Condo
2494 sq ft
3 Beds / 3.00 Baths
0.00 acres
#11701477
Keri-Holland - Engel---Voelkers-Park-City - (801) 821-9396
Days on Market - 26
$559,450
14346 N Rendezvous Trail 35B
Jordanelle
Black Rock Ridge
Heber City, UT
Condo
2494 sq ft
3 Beds / 3.00 Baths
0.00 acres
#11701474
Keri-Holland - Engel---Voelkers-Park-City - (801) 821-9396
Days on Market - 26
$555,000
14155 N Council Fire Trail
Jordanelle
Black Rock Ridge
Heber City, UT
Condo
1982 sq ft
3 Beds / 3.00 Baths
0.00 acres
#11700637
Michael-McGurl - Summit-Sotheby's---Park-Ave - (435) 901-9300
Days on Market - 65
$540,000
1289 Deer Park Circle 201
Jordanelle
Village at the Shores - Cedar Edition
Heber City, UT
Condo
1578 sq ft
3 Beds / 2.00 Baths
0.00 acres
#11603210
Mark-Sletten - Engel---Voelkers-Park-City - (435) 640-0930
Days on Market - 174
Loading More Results
 
 
Existing user sign in: 
Forgot Password?