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 (278034)) 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

Office Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
Sort By 
Array
(
    [crea_id] => 25152080
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2468591
    [LASTUPDATED] => 2023-01-31
    [street_address] => 2404 28TH STREET
    [city] => Lister
    [province] => British Columbia
    [postal] => V0B1G2
    [price] => 1250000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 961.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638078270132000000/reb12/lowres/1/2468591_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638078270132000000/reb12/medres/1/2468591_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638078270132000000/reb12/highres/1/2468591_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$1,250,000
961.0000 | 2 | 2
2404 28TH STREET
Lister, British Columbia
V0B1G2
MLS#2468591
Trent Mason: 250.946.6608 / Email 
Array
(
    [crea_id] => 25225318
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 10268131
    [LASTUPDATED] => 2023-01-27
    [street_address] => 771 Clement Avenue,
    [city] => Kelowna
    [province] => British Columbia
    [postal] => V1Y7C9
    [price] => 1200000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 821 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638104302840830000/reb19/lowres/1/10268131_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638104302840830000/reb19/medres/1/10268131_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638104302840830000/reb19/highres/1/10268131_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$1,200,000
821 sqft | 2 | 1
771 Clement Avenue,
Kelowna, British Columbia
V1Y7C9
MLS#10268131
Dan Beekman: 250.777.7293 / Email 
Array
(
    [crea_id] => 25155890
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2468611
    [LASTUPDATED] => 2023-01-31
    [street_address] => 3686 SWEET ROAD
    [city] => Baynes Lake
    [province] => British Columbia
    [postal] => V0B1T4
    [price] => 799000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1718.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638082626272530000/reb12/lowres/1/2468611_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638082626272530000/reb12/medres/1/2468611_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638082626272530000/reb12/highres/1/2468611_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$799,000
1718.0000 | 3 | 2
3686 SWEET ROAD
Baynes Lake, British Columbia
V0B1T4
MLS#2468611
Trent Mason: 250.946.6608 / Email 
Array
(
    [crea_id] => 24451729
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2465127
    [LASTUPDATED] => 2023-01-31
    [street_address] => 67 WATTSVILLE ROAD
    [city] => Cranbrook
    [province] => British Columbia
    [postal] => V1C2A1
    [price] => 699000.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 2783.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637892490851600000/reb12/lowres/7/2465127_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637892490851600000/reb12/medres/7/2465127_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637892490851600000/reb12/highres/7/2465127_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$699,000
2783.0000 | 4 | 3
67 WATTSVILLE ROAD
Cranbrook, British Columbia
V1C2A1
MLS#2465127
Trent Mason: 250.946.6608 / Email 
Array
(
    [crea_id] => 25205832
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2468801
    [LASTUPDATED] => 2023-01-31
    [street_address] => 3309 MT FISHER DRIVE
    [city] => Cranbrook
    [province] => British Columbia
    [postal] => V1C6N6
    [price] => 645000.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 2898.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638098160164500000/reb12/lowres/1/2468801_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638098160164500000/reb12/medres/1/2468801_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638098160164500000/reb12/highres/1/2468801_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$645,000
2898.0000 | 5 | 3
3309 MT FISHER DRIVE
Cranbrook, British Columbia
V1C6N6
MLS#2468801
Dan Beekman: 250.777.7293 / Email 
Array
(
    [crea_id] => 25239533
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2468939
    [LASTUPDATED] => 2023-02-02
    [street_address] => 1 - 1005 Mount MOUNTAIN VIEW ROAD
    [city] => Rossland
    [province] => British Columbia
    [postal] => V0G1Y0
    [price] => 619000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1376.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638108876093530000/reb12/lowres/9/2468939_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638108876093530000/reb12/medres/9/2468939_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638108876093530000/reb12/highres/9/2468939_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$619,000
1376.0000 | 3 | 2
1 - 1005 Mount MOUNTAIN VIEW ROAD
Rossland, British Columbia
V0G1Y0
MLS#2468939
Dan Beekman: 250.777.7293 / Email 
Array
(
    [crea_id] => 24665538
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2466293
    [LASTUPDATED] => 2023-01-31
    [street_address] => 611 CRANBROOK STREET N
    [city] => Cranbrook North
    [province] => British Columbia
    [postal] => V1C3R8
    [price] => 600000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => Array
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637934167947630000/reb12/lowres/3/2466293_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637934167947630000/reb12/medres/3/2466293_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637934167947630000/reb12/highres/3/2466293_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$600,000
Array | 0 | 0
611 CRANBROOK STREET N
Cranbrook North, British Columbia
V1C3R8
MLS#2466293
Trent Mason: 250.946.6608 / Email 
Array
(
    [crea_id] => 24576975
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2465792
    [LASTUPDATED] => 2023-01-31
    [street_address] => 6990 HIGHWAY 3
    [city] => Kitchener
    [province] => British Columbia
    [postal] => V0B1W1
    [price] => 599000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => Array
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637915045822900000/reb12/lowres/2/2465792_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637915045822900000/reb12/medres/2/2465792_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637915045822900000/reb12/highres/2/2465792_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$599,000
Array | 0 | 0
6990 HIGHWAY 3
Kitchener, British Columbia
V0B1W1
MLS#2465792
Trent Mason: 250.946.6608 / Email 
Array
(
    [crea_id] => 24709396
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2466564
    [LASTUPDATED] => 2023-01-31
    [street_address] => 5080 ELSIE HOLMES ROAD
    [city] => Wynndel
    [province] => British Columbia
    [postal] => V0B2N1
    [price] => 514900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 2286.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637945141764700000/reb12/lowres/4/2466564_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637945141764700000/reb12/medres/4/2466564_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637945141764700000/reb12/highres/4/2466564_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$514,900
2286.0000 | 3 | 2
5080 ELSIE HOLMES ROAD
Wynndel, British Columbia
V0B2N1
MLS#2466564
Trent Mason: 250.946.6608 / Email 
Array
(
    [crea_id] => 25221214
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2468879
    [LASTUPDATED] => 2023-01-31
    [street_address] => 2432 MCLEARY CRESCENT
    [city] => Cranbrook
    [province] => British Columbia
    [postal] => V1C5Z5
    [price] => 474900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1844.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638106894346300000/reb12/lowres/9/2468879_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638106894346300000/reb12/medres/9/2468879_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638106894346300000/reb12/highres/9/2468879_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$474,900
1844.0000 | 3 | 2
2432 MCLEARY CRESCENT
Cranbrook, British Columbia
V1C5Z5
MLS#2468879
Giovanna Paz: 250.409.4455 / Email 
Array
(
    [crea_id] => 24888774
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2467522
    [LASTUPDATED] => 2023-01-31
    [street_address] => 61 - 724 INNES AVENUE
    [city] => Cranbrook
    [province] => British Columbia
    [postal] => V1C2A5
    [price] => 294900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 955.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637998336689270000/reb12/lowres/2/2467522_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637998336689270000/reb12/medres/2/2467522_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637998336689270000/reb12/highres/2/2467522_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$294,900
955.0000 | 2 | 2
61 - 724 INNES AVENUE
Cranbrook, British Columbia
V1C2A5
MLS#2467522
Giovanna Paz: 250.409.4455 / Email 
Array
(
    [crea_id] => 25219432
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2468875
    [LASTUPDATED] => 2023-01-31
    [street_address] => 9006 RAILWAY AVENUE
    [city] => Yahk
    [province] => British Columbia
    [postal] => V0B2P0
    [price] => 230000.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1606.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638102684112400000/reb12/lowres/5/2468875_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638102684112400000/reb12/medres/5/2468875_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638102684112400000/reb12/highres/5/2468875_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$230,000
1606.0000 | 1 | 1
9006 RAILWAY AVENUE
Yahk, British Columbia
V0B2P0
MLS#2468875
Trent Mason: 250.946.6608 / Email 
Array
(
    [crea_id] => 24874704
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2467456
    [LASTUPDATED] => 2023-01-31
    [street_address] => 6933 CUSTOMS ROAD
    [city] => Kingsgate
    [province] => British Columbia
    [postal] => V0B1V1
    [price] => 89900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => Array
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637988442309870000/reb12/lowres/6/2467456_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637988442309870000/reb12/medres/6/2467456_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637988442309870000/reb12/highres/6/2467456_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$89,900
Array | 0 | 0
6933 CUSTOMS ROAD
Kingsgate, British Columbia
V0B1V1
MLS#2467456
Trent Mason: 250.946.6608 / Email 
Array
(
    [crea_id] => 24246905
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2464045
    [LASTUPDATED] => 2023-01-31
    [street_address] => O3C - 1351 GERRY SORENSEN WAY
    [city] => Kimberley
    [province] => British Columbia
    [postal] => V1A2Y6
    [price] => 85000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1882.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637849752355400000/reb12/lowres/5/2464045_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637849752355400000/reb12/medres/5/2464045_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637849752355400000/reb12/highres/5/2464045_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$85,000
1882.0000 | 3 | 3
O3C - 1351 GERRY SORENSEN WAY
Kimberley, British Columbia
V1A2Y6
MLS#2464045
Trent Mason: 250.946.6608 / Email 
Array
(
    [crea_id] => 25099256
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2468364
    [LASTUPDATED] => 2023-01-31
    [street_address] => M3A - 1351 GERRY SORENSEN WAY
    [city] => Kimberley
    [province] => British Columbia
    [postal] => V1A2Y6
    [price] => 85000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1882.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638051468110200000/reb12/lowres/4/2468364_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638051468110200000/reb12/medres/4/2468364_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638051468110200000/reb12/highres/4/2468364_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$85,000
1882.0000 | 3 | 3
M3A - 1351 GERRY SORENSEN WAY
Kimberley, British Columbia
V1A2Y6
MLS#2468364
Trent Mason: 250.946.6608 / Email
Sort By
2% Realty Kootenays
3403 Beam Rd
Creston, British Columbia
V0B 1G1
Tel: 250.946.6608
Email: trent.mason@2percentrealty.ca
This site's content is the responsibility of 2% Realty Kootenays | 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 © 2023 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.