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
X
Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$259,000
2728 sqft | 0 | 0
300 9TH STREET SOUTH
Watson Lake, Yukon
Y0A1C0
MLS#13127
Judy Freake: 867.336.0631 / Email
Sort By
2% Realty Midnight Sun
Suite 204 - 211 Main St
Whitehorse, Yukon
Y1A 2B2
Tel: 867.668.2323
Email: bob.kostelnik@2percentrealty.ca
This site's content is the responsibility of 2% Realty Midnight Sun | 2018 Privacy Policy
The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA.
Copyright © 2022 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.