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

MLS® System Listings

Search
X
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
)
$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
)
$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
)
$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
)
$294,900
955.0000 | 2 | 2
61 - 724 INNES AVENUE
Cranbrook, British Columbia
V1C2A5
MLS#2467522
Giovanna Paz: 250.409.4455 / Email
Sort By