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

Office Listings

Search
X
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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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