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-03-23
    [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] => 25332516
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2469346
    [LASTUPDATED] => 2023-03-07
    [street_address] => 1647 TRANQUILITY ROAD
    [city] => Baynes Lake
    [province] => British Columbia
    [postal] => V0B1T4
    [price] => 835000.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 2886.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638137987359230000/reb12/lowres/6/2469346_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638137987359230000/reb12/medres/6/2469346_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638137987359230000/reb12/highres/6/2469346_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$835,000
2886.0000 | 4 | 3
1647 TRANQUILITY ROAD
Baynes Lake, British Columbia
V0B1T4
MLS#2469346
Trent Mason: 250.946.6608 / Email
Giovanna Paz: 250.409.4455 / 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] => 25351407
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2469434
    [LASTUPDATED] => 2023-03-10
    [street_address] => 6421 BEECHNUT ROAD
    [city] => Wasa
    [province] => British Columbia
    [postal] => V0B2K0
    [price] => 750000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 894.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638140484127830000/reb12/lowres/4/2469434_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638140484127830000/reb12/medres/4/2469434_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638140484127830000/reb12/highres/4/2469434_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$750,000
894.0000 | 2 | 1
6421 BEECHNUT ROAD
Wasa, British Columbia
V0B2K0
MLS#2469434
Trent Mason: 250.946.6608 / Email
Array
(
    [crea_id] => 25306101
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2469223
    [LASTUPDATED] => 2023-03-12
    [street_address] => C - 1003 MOUNTAIN VIEW ROAD
    [city] => Rossland
    [province] => British Columbia
    [postal] => V0G1Y0
    [price] => 719000.00
    [bedroom_total] => 3
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 1598.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638142318697030000/reb12/lowres/3/2469223_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638142318697030000/reb12/medres/3/2469223_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638142318697030000/reb12/highres/3/2469223_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$719,000
1598.0000 | 3 | 4
C - 1003 MOUNTAIN VIEW ROAD
Rossland, British Columbia
V0G1Y0
MLS#2469223
Dan Beekman: 250.777.7293 / 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] => 25313150
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2469259
    [LASTUPDATED] => 2023-03-03
    [street_address] => 3018 HIGHWAY 6
    [city] => Slocan Park
    [province] => British Columbia
    [postal] => V0G2E0
    [price] => 689000.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1592.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638134566730400000/reb12/lowres/9/2469259_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638134566730400000/reb12/medres/9/2469259_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638134566730400000/reb12/highres/9/2469259_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$689,000
1592.0000 | 3 | 1
3018 HIGHWAY 6
Slocan Park, British Columbia
V0G2E0
MLS#2469259
Dan Beekman: 250.777.7293 / Email
Array
(
    [crea_id] => 25205832
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2468801
    [LASTUPDATED] => 2023-02-27
    [street_address] => 3309 MT FISHER DRIVE
    [city] => Cranbrook
    [province] => British Columbia
    [postal] => V1C6N6
    [price] => 639000.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] => 
)
$639,000
2898.0000 | 5 | 3
3309 MT FISHER DRIVE
Cranbrook, British Columbia
V1C6N6
MLS#2468801
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] => 25338354
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2469370
    [LASTUPDATED] => 2023-03-18
    [street_address] => B - 2520 MCLEARY CRESCENT
    [city] => Cranbrook
    [province] => British Columbia
    [postal] => V1C6R7
    [price] => 534900.00
    [bedroom_total] => 3
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 1918.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638137886196770000/reb12/lowres/0/2469370_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638137886196770000/reb12/medres/0/2469370_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638137886196770000/reb12/highres/0/2469370_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$534,900
1918.0000 | 3 | 4
B - 2520 MCLEARY CRESCENT
Cranbrook, British Columbia
V1C6R7
MLS#2469370
Giovanna Paz: 250.409.4455 / Email
Array
(
    [crea_id] => 25269402
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2469057
    [LASTUPDATED] => 2023-03-16
    [street_address] => 211 - 880 DOGWOOD DRIVE
    [city] => Kimberley
    [province] => British Columbia
    [postal] => V1A2Y4
    [price] => 454900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1205.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638142228431930000/reb12/lowres/7/2469057_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638142228431930000/reb12/medres/7/2469057_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638142228431930000/reb12/highres/7/2469057_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$454,900
1205.0000 | 3 | 2
211 - 880 DOGWOOD DRIVE
Kimberley, British Columbia
V1A2Y4
MLS#2469057
Giovanna Paz: 250.409.4455 / Email
Array
(
    [crea_id] => 25349831
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2469412
    [LASTUPDATED] => 2023-03-12
    [street_address] => 3845 LITTLE SLOCAN SOUTH ROAD
    [city] => Winlaw
    [province] => British Columbia
    [postal] => V0G2J0
    [price] => 410000.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1714.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638141640721870000/reb12/lowres/2/2469412_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638141640721870000/reb12/medres/2/2469412_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638141640721870000/reb12/highres/2/2469412_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$410,000
1714.0000 | 3 | 1
3845 LITTLE SLOCAN SOUTH ROAD
Winlaw, British Columbia
V0G2J0
MLS#2469412
Dan Beekman: 250.777.7293 / Email
Array
(
    [crea_id] => 25281670
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2469108
    [LASTUPDATED] => 2023-03-17
    [street_address] => 3 - 192 9TH STREET S
    [city] => Cranbrook
    [province] => British Columbia
    [postal] => V1C1P8
    [price] => 395000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1305.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638121888527070000/reb12/lowres/8/2469108_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638121888527070000/reb12/medres/8/2469108_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638121888527070000/reb12/highres/8/2469108_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$395,000
1305.0000 | 3 | 2
3 - 192 9TH STREET S
Cranbrook, British Columbia
V1C1P8
MLS#2469108
Giovanna Paz: 250.409.4455 / Email
Array
(
    [crea_id] => 25354601
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2469455
    [LASTUPDATED] => 2023-03-16
    [street_address] => 224 16TH AVENUE N
    [city] => Cranbrook
    [province] => British Columbia
    [postal] => V1C3W5
    [price] => 369900.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1597.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638141306338630000/reb12/lowres/5/2469455_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638141306338630000/reb12/medres/5/2469455_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638141306338630000/reb12/highres/5/2469455_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$369,900
1597.0000 | 3 | 1
224 16TH AVENUE N
Cranbrook, British Columbia
V1C3W5
MLS#2469455
Giovanna Paz: 250.409.4455 / Email
Array
(
    [crea_id] => 25333303
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2469350
    [LASTUPDATED] => 2023-03-22
    [street_address] => 127 14TH AVENUE
    [city] => Cranbrook
    [province] => British Columbia
    [postal] => V1C2X1
    [price] => 299900.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1229.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638136920090200000/reb12/lowres/0/2469350_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638136920090200000/reb12/medres/0/2469350_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638136920090200000/reb12/highres/0/2469350_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$299,900
1229.0000 | 3 | 1
127 14TH AVENUE
Cranbrook, British Columbia
V1C2X1
MLS#2469350
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-02-17
    [street_address] => 9006 RAILWAY AVENUE
    [city] => Yahk
    [province] => British Columbia
    [postal] => V0B2P0
    [price] => 190000.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] => 
)
$190,000
1606.0000 | 1 | 1
9006 RAILWAY AVENUE
Yahk, British Columbia
V0B2P0
MLS#2468875
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-03-14
    [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