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 FROM tbl_CREA_0_agents a INNER JOIN tbl_CREA_0 b ON (a.crea_id = b.crea_id) LEFT JOIN tbl_CREA_0_photos c ON (a.crea_id = c.crea_id AND c.sequence_id = 1) WHERE a.crea_id IN (24792438,25013730,24888786,24888774) ORDER BY b.price DESC, b.mls_id ASC
X

MLS® System Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
Sort By 
Array
(
    [crea_id] => 24792438
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2467030
    [LASTUPDATED] => 2022-11-19
    [street_address] => 586 WOODLAND DRIVE
    [city] => Cranbrook
    [province] => British Columbia
    [postal] => V1C6V2
    [price] => 625000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 2399.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637966045874500000/reb12/lowres/0/2467030_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637966045874500000/reb12/medres/0/2467030_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637966045874500000/reb12/highres/0/2467030_1.jpg
)
View
$625,000
2399.0000 | 3 | 3
586 WOODLAND DRIVE
Cranbrook, British Columbia
V1C6V2
MLS#2467030
Giovanna Paz: 250.409.4455 / 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
)
View
$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] => 24888786
    [office_name] => 2 Percent Realty Kootenay Inc.
    [office_id] => 278034
    [mls_id] => 2467514
    [LASTUPDATED] => 2022-11-26
    [street_address] => 441 4TH AVENUE
    [city] => Invermere
    [province] => British Columbia
    [postal] => V0A1K7
    [price] => 305000.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
)
View
$305,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
)
View
$294,900
955.0000 | 2 | 2
61 - 724 INNES AVENUE
Cranbrook, British Columbia
V1C2A5
MLS#2467522
Giovanna Paz: 250.409.4455 / Email
Sort By
Giovanna Paz
This site's content is the responsibility of Giovanna Paz | 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.