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] => 24459610
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2465161
    [LASTUPDATED] => 2022-11-15
    [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/TS637941390469870000/reb12/lowres/1/2465161_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637941390469870000/reb12/medres/1/2465161_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637941390469870000/reb12/highres/1/2465161_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$1,250,000
961.0000 | 2 | 2
2404 28TH STREET
Lister, British Columbia
V0B1G2
MLS#2465161
Trent Mason: 250.946.6608 / Email
Array
(
    [crea_id] => 24757657
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2466828
    [LASTUPDATED] => 2022-09-07
    [street_address] => 3686 SWEET ROAD
    [city] => Baynes Lake
    [province] => British Columbia
    [postal] => V0B1J0
    [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/TS637957399822400000/reb12/lowres/8/2466828_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637957399822400000/reb12/medres/8/2466828_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637957399822400000/reb12/highres/8/2466828_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$799,000
1718.0000 | 3 | 2
3686 SWEET ROAD
Baynes Lake, British Columbia
V0B1J0
MLS#2466828
Trent Mason: 250.946.6608 / Email
Array
(
    [crea_id] => 24451729
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2465127
    [LASTUPDATED] => 2022-11-30
    [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] => 24947178
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2467777
    [LASTUPDATED] => 2022-11-24
    [street_address] => 2F - 1005 MOUNTAIN VIEW ROAD
    [city] => Rossland
    [province] => British Columbia
    [postal] => V0G1Y0
    [price] => 649000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1376.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638008260772000000/reb12/lowres/7/2467777_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638008260772000000/reb12/medres/7/2467777_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638008260772000000/reb12/highres/7/2467777_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$649,000
1376.0000 | 3 | 2
2F - 1005 MOUNTAIN VIEW ROAD
Rossland, British Columbia
V0G1Y0
MLS#2467777
Dan Beekman: 250.777.7293 / Email
Array
(
    [crea_id] => 24665538
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2466293
    [LASTUPDATED] => 2022-07-14
    [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] => 
    [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
| 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] => 2022-09-16
    [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] => 25013730
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2468037
    [LASTUPDATED] => 2022-10-28
    [street_address] => Lot 1 TOBY HILL ROAD
    [city] => Wilmer
    [province] => British Columbia
    [postal] => V0A1K5
    [price] => 589000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => Array
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638025606696030000/reb12/lowres/7/2468037_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638025606696030000/reb12/medres/7/2468037_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638025606696030000/reb12/highres/7/2468037_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$589,000
Array | 0 | 0
Lot 1 TOBY HILL ROAD
Wilmer, British Columbia
V0A1K5
MLS#2468037
Giovanna Paz: 250.409.4455 / Email
Array
(
    [crea_id] => 24709396
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2466564
    [LASTUPDATED] => 2022-11-18
    [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] => 24962992
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2467852
    [LASTUPDATED] => 2022-11-30
    [street_address] => 2 - 1415 ALDER STREET
    [city] => Creston
    [province] => British Columbia
    [postal] => V0B1G4
    [price] => 299900.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 909.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638011772956200000/reb12/lowres/2/2467852_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638011772956200000/reb12/medres/2/2467852_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638011772956200000/reb12/highres/2/2467852_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$299,900
909.0000 | 2 | 1
2 - 1415 ALDER STREET
Creston, British Columbia
V0B1G4
MLS#2467852
Trent Mason: 250.946.6608 / Email
Array
(
    [crea_id] => 24888786
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2467514
    [LASTUPDATED] => 2022-12-05
    [street_address] => 441 4TH AVENUE
    [city] => Invermere
    [province] => British Columbia
    [postal] => V0A1K7
    [price] => 295000.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1020.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637992307722900000/reb12/lowres/4/2467514_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637992307722900000/reb12/medres/4/2467514_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637992307722900000/reb12/highres/4/2467514_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$295,000
1020.0000 | 3 | 1
441 4TH AVENUE
Invermere, British Columbia
V0A1K7
MLS#2467514
Giovanna Paz: 250.409.4455 / Email
Array
(
    [crea_id] => 24888774
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2467522
    [LASTUPDATED] => 2022-11-27
    [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] => 24874704
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2467456
    [LASTUPDATED] => 2022-09-15
    [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] => 
    [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
| 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] => 2022-10-11
    [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] => 2022-11-27
    [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