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 (272778,284370,279621)) 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] => 25353575
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2758898
    [LASTUPDATED] => 2023-03-19
    [street_address] => 24184 66 AVENUE
    [city] => Langley
    [province] => British Columbia
    [postal] => V2Y2H2
    [price] => 2748000.00
    [bedroom_total] => 6
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 4068 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638140705066530000/reb6/lowres/8/R2758898_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638140705066530000/reb6/medres/8/R2758898_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638140705066530000/reb6/highres/8/R2758898_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$2,748,000
4068 m2 | 6 | 4
24184 66 AVENUE
Langley, British Columbia
V2Y2H2
MLS#R2758898
Mark Sawatzky: 604.866.8670 / Email
Array
(
    [crea_id] => 25299284
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2754531
    [LASTUPDATED] => 2023-03-10
    [street_address] => 23148 BILLY BROWN ROAD
    [city] => Langley
    [province] => British Columbia
    [postal] => V1M4G1
    [price] => 1355800.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 2185 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638126804101930000/reb6/lowres/1/R2754531_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638126804101930000/reb6/medres/1/R2754531_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638126804101930000/reb6/highres/1/R2754531_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$1,355,800
2185 sqft | 4 | 4
23148 BILLY BROWN ROAD
Langley, British Columbia
V1M4G1
MLS#R2754531
Mark Sawatzky: 604.866.8670 / Email
Array
(
    [crea_id] => 25310759
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2755410
    [LASTUPDATED] => 2023-02-27
    [street_address] => 21437 THACKER MTN ROAD
    [city] => Hope
    [province] => British Columbia
    [postal] => V0X1L1
    [price] => 985000.00
    [bedroom_total] => 3
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 2264 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638130951755870000/reb4/lowres/0/r2755410_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638130951755870000/reb4/medres/0/r2755410_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638130951755870000/reb4/highres/0/r2755410_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$985,000
2264 sqft | 3 | 4
21437 THACKER MTN ROAD
Hope, British Columbia
V0X1L1
MLS#R2755410
Mark Sawatzky: 604.866.8670 / Email
Array
(
    [crea_id] => 25275972
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2752683
    [LASTUPDATED] => 2023-02-14
    [street_address] => 119 32833 LANDEAU PLACE
    [city] => Abbotsford
    [province] => British Columbia
    [postal] => V2S6S6
    [price] => 325000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1323.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638119843256330000/reb6/lowres/3/R2752683_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638119843256330000/reb6/medres/3/R2752683_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638119843256330000/reb6/highres/3/R2752683_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$325,000
1323.0000 | 2 | 2
119 32833 LANDEAU PLACE
Abbotsford, British Columbia
V2S6S6
MLS#R2752683
Anthony Dyck: 604.439.1003 / Email
Sort By