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
X
Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$325,000
1323.0000 | 2 | 2
119 32833 LANDEAU PLACE
Abbotsford, British Columbia
V2S6S6
MLS#R2752683
Anthony Dyck: 604.439.1003 / Email
Sort By
2% Realty West Coast
404-1688 152nd St.
Surrey, British Columbia
V4A 4N2
Tel: 604.340.1575
Fax: 604.398.2365
Email: info@2percentwestcoast.ca
This site's content is the responsibility of 2% Realty West Coast | 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 © 2023 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.