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 AND a.office_id IN (286992)) 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
Search
X
Sort By
Array
(
    [crea_id] => 25103610
    [office_name] => 2 Percent Realty Group
    [office_id] => 286992
    [mls_id] => 919133
    [LASTUPDATED] => 2023-01-23
    [street_address] => 533 Alder St
    [city] => Campbell River
    [province] => British Columbia
    [postal] => V9W2N9
    [price] => 575000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 2027 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638053255122300000/reb1/lowres/3/919133_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638053255122300000/reb1/medres/3/919133_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638053255122300000/reb1/highres/3/919133_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$575,000
2027 sqft | 4 | 2
533 Alder St
Campbell River, British Columbia
V9W2N9
MLS#919133
Mike Rasmussen: 604.805.2086 / Email
Array
(
    [crea_id] => 25099640
    [office_name] => 2 Percent Realty Group
    [office_id] => 286992
    [mls_id] => 919377
    [LASTUPDATED] => 2023-02-02
    [street_address] => 306A 178 Back Rd
    [city] => Courtenay
    [province] => British Columbia
    [postal] => V9N3W6
    [price] => 249800.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1044 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638054976733130000/reb1/lowres/7/919377_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638054976733130000/reb1/medres/7/919377_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638054976733130000/reb1/highres/7/919377_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$249,800
1044 sqft | 2 | 1
306A 178 Back Rd
Courtenay, British Columbia
V9N3W6
MLS#919377
Mike Rasmussen: 604.805.2086 / Email
Sort By