SELECT DISTINCT(a.crea_id), a.office_name, a.office_id, b.crea_id, b.mls_id, STR_TO_DATE(b.last_updated,'%a, %d %b %Y') AS LASTUPDATED, b.street_address, b.city, b.province, b.postal, b.price, b.bedroom_total, b.bathroom_total, b.half_bath_total, b.size_interior, c.sequence_id, c.thumbURL, c.medURL, c.largeURL, d.thumbURL AS THUMBB, d.medURL AS MEDB, d.largeURL AS LARGEB FROM tbl_CREA_0_agents a INNER JOIN tbl_CREA_0 b ON (a.crea_id = b.crea_id AND a.office_id IN (287093)) LEFT JOIN tbl_CREA_0_photos c ON (a.crea_id = c.crea_id AND c.sequence_id = 1) LEFT JOIN tbl_CREA_0_photos d ON (a.crea_id = d.crea_id AND d.sequence_id = 0)ORDER BY b.price DESC, b.mls_id ASC
Search
X
Sort By
Array
(
    [crea_id] => 24687916
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 14410
    [LASTUPDATED] => 2022-11-12
    [street_address] => 56 RIVER ROAD
    [city] => Whitehorse South
    [province] => Yukon
    [postal] => Y0B1Y1
    [price] => 895000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 2783 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638038008411600000/reb62/lowres/0/14410_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638038008411600000/reb62/medres/0/14410_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638038008411600000/reb62/highres/0/14410_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$895,000
2783 sqft | 3 | 3
56 RIVER ROAD
Whitehorse South, Yukon
Y0B1Y1
MLS#14410
Judy Freake: 867.336.0631 / Email
Array
(
    [crea_id] => 25048043
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 14626
    [LASTUPDATED] => 2022-11-09
    [street_address] => 38 BAMBOO CRESCENT
    [city] => Whitehorse
    [province] => Yukon
    [postal] => Y1A0P5
    [price] => 768900.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638035974645470000/reb62/lowres/6/14626_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638035974645470000/reb62/medres/6/14626_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638035974645470000/reb62/highres/6/14626_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$768,900
| 5 | 3
38 BAMBOO CRESCENT
Whitehorse, Yukon
Y1A0P5
MLS#14626
Patrick Singh: 867.333.9315 / Email
Array
(
    [crea_id] => 25013959
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 14618
    [LASTUPDATED] => 2022-11-28
    [street_address] => 106 GENTIAN LANE
    [city] => Whitehorse South
    [province] => Yukon
    [postal] => Y1A6L6
    [price] => 749000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1077 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638024943805970000/reb62/lowres/8/14618_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638024943805970000/reb62/medres/8/14618_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638024943805970000/reb62/highres/8/14618_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$749,000
1077 sqft | 2 | 1
106 GENTIAN LANE
Whitehorse South, Yukon
Y1A6L6
MLS#14618
Judy Freake: 867.336.0631 / Email
Array
(
    [crea_id] => 24835798
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 14524
    [LASTUPDATED] => 2022-09-08
    [street_address] => 60 11TH AVENUE EAST
    [city] => Whitehorse
    [province] => Yukon
    [postal] => Y1A4H9
    [price] => 629000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1600 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637979898364100000/reb62/lowres/4/14524_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637979898364100000/reb62/medres/4/14524_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637979898364100000/reb62/highres/4/14524_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$629,000
1600 sqft | 3 | 2
60 11TH AVENUE EAST
Whitehorse, Yukon
Y1A4H9
MLS#14524
Judy Freake: 867.336.0631 / Email
Array
(
    [crea_id] => 24916852
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 14571
    [LASTUPDATED] => 2022-09-29
    [street_address] => 4 RAVEN CRESCENT
    [city] => Whitehorse South
    [province] => Yukon
    [postal] => Y0B1Y2
    [price] => 559900.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1128 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638000551442270000/reb62/lowres/1/14571_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638000551442270000/reb62/medres/1/14571_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638000551442270000/reb62/highres/1/14571_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$559,900
1128 sqft | 2 | 1
4 RAVEN CRESCENT
Whitehorse South, Yukon
Y0B1Y2
MLS#14571
Patrick Singh: 867.333.9315 / Email
Array
(
    [crea_id] => 25089552
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 14644
    [LASTUPDATED] => 2022-11-23
    [street_address] => 36 TESLIN ROAD
    [city] => Whitehorse
    [province] => Yukon
    [postal] => Y1A3M4
    [price] => 539000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638047584964100000/reb62/lowres/4/14644_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638047584964100000/reb62/medres/4/14644_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638047584964100000/reb62/highres/4/14644_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$539,000
| 4 | 2
36 TESLIN ROAD
Whitehorse, Yukon
Y1A3M4
MLS#14644
Judy Freake: 867.336.0631 / Email
Array
(
    [crea_id] => 24597922
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 14331
    [LASTUPDATED] => 2022-08-31
    [street_address] => 16-35 SYBIL CIRCLE
    [city] => Whitehorse
    [province] => Yukon
    [postal] => Y1A0R6
    [price] => 525000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1846 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637952172717200000/reb62/lowres/1/14331_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637952172717200000/reb62/medres/1/14331_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637952172717200000/reb62/highres/1/14331_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$525,000
1846 sqft | 3 | 3
16-35 SYBIL CIRCLE
Whitehorse, Yukon
Y1A0R6
MLS#14331
Judy Freake: 867.336.0631 / Email
Array
(
    [crea_id] => 25023437
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 14621
    [LASTUPDATED] => 2022-11-01
    [street_address] => 31 DONJEK ROAD
    [city] => Whitehorse
    [province] => Yukon
    [postal] => Y1A3P8
    [price] => 495000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 888 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638028552743970000/reb62/lowres/1/14621_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638028552743970000/reb62/medres/1/14621_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638028552743970000/reb62/highres/1/14621_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$495,000
888 sqft | 2 | 1
31 DONJEK ROAD
Whitehorse, Yukon
Y1A3P8
MLS#14621
Judy Freake: 867.336.0631 / Email
Array
(
    [crea_id] => 24767838
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 14476
    [LASTUPDATED] => 2022-08-29
    [street_address] => 190 DEEP CREEK
    [city] => Whitehorse North
    [province] => Yukon
    [postal] => Y1A6P7
    [price] => 489900.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637959312423230000/reb62/lowres/6/14476_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637959312423230000/reb62/medres/6/14476_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637959312423230000/reb62/highres/6/14476_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$489,900
| 2 | 1
190 DEEP CREEK
Whitehorse North, Yukon
Y1A6P7
MLS#14476
Patrick Singh: 867.333.9315 / Email
Array
(
    [crea_id] => 25082340
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 14639
    [LASTUPDATED] => 2022-11-19
    [street_address] => 171-58 FALCON DRIVE
    [city] => Whitehorse
    [province] => Yukon
    [postal] => Y1A6V6
    [price] => 449500.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1540 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638044681206570000/reb62/lowres/9/14639_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638044681206570000/reb62/medres/9/14639_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638044681206570000/reb62/highres/9/14639_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$449,500
1540 sqft | 3 | 3
171-58 FALCON DRIVE
Whitehorse, Yukon
Y1A6V6
MLS#14639
Judy Freake: 867.336.0631 / Email
Array
(
    [crea_id] => 24832772
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 14517
    [LASTUPDATED] => 2022-09-13
    [street_address] => 35-25 WANN ROAD
    [city] => Whitehorse
    [province] => Yukon
    [postal] => Y1A4A2
    [price] => 444000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1744 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637986816874300000/reb62/lowres/7/14517_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637986816874300000/reb62/medres/7/14517_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637986816874300000/reb62/highres/7/14517_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$444,000
1744 sqft | 3 | 2
35-25 WANN ROAD
Whitehorse, Yukon
Y1A4A2
MLS#14517
Patrick Singh: 867.333.9315 / Email
Array
(
    [crea_id] => 24642862
    [office_name] => 2% Realty Midnight Sun
    [office_id] => 287093
    [mls_id] => 13127
    [LASTUPDATED] => 2022-08-08
    [street_address] => 300 9TH STREET SOUTH
    [city] => Watson Lake
    [province] => Yukon
    [postal] => Y0A1C0
    [price] => 259000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 2728 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637955676770100000/reb62/lowres/7/13127_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637955676770100000/reb62/medres/7/13127_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637955676770100000/reb62/highres/7/13127_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$259,000
2728 sqft | 0 | 0
300 9TH STREET SOUTH
Watson Lake, Yukon
Y0A1C0
MLS#13127
Judy Freake: 867.336.0631 / Email
Sort By