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 IN (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] => 24299892
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2679444
    [LASTUPDATED] => 2022-09-18
    [street_address] => 12084 CARR STREET
    [city] => Mission
    [province] => British Columbia
    [postal] => V4S1B8
    [price] => 1899999.00
    [bedroom_total] => 8
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 4804 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637977217381670000/reb6/lowres/4/R2679444_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637977217381670000/reb6/medres/4/R2679444_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637977217381670000/reb6/highres/4/R2679444_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$1,899,999
4804 sqft | 8 | 4
12084 CARR STREET
Mission, British Columbia
V4S1B8
MLS#R2679444
Mark Sawatzky: 604.866.8670 / Email
Bernice Fetterly: 604.970.2410 / Email
Array
(
    [crea_id] => 24872326
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2723581
    [LASTUPDATED] => 2022-09-15
    [street_address] => 8869 TRATTLE STREET
    [city] => Langley
    [province] => British Columbia
    [postal] => V1M2R9
    [price] => 1799000.00
    [bedroom_total] => 4
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 2004 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637987801125570000/reb6/lowres/1/R2723581_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637987801125570000/reb6/medres/1/R2723581_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637987801125570000/reb6/highres/1/R2723581_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$1,799,000
2004 sqft | 4 | 1
8869 TRATTLE STREET
Langley, British Columbia
V1M2R9
MLS#R2723581
Mark Sawatzky: 604.866.8670 / Email
Array
(
    [crea_id] => 24726197
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2713426
    [LASTUPDATED] => 2022-09-13
    [street_address] => 23156 BILLY BROWN ROAD
    [city] => Langley
    [province] => British Columbia
    [postal] => V1M4G1
    [price] => 1299900.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 2080 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637950475369900000/reb6/lowres/6/R2713426_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637950475369900000/reb6/medres/6/R2713426_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637950475369900000/reb6/highres/6/R2713426_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$1,299,900
2080 sqft | 4 | 4
23156 BILLY BROWN ROAD
Langley, British Columbia
V1M4G1
MLS#R2713426
Mark Sawatzky: 604.866.8670 / Email
Array
(
    [crea_id] => 24300185
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2679496
    [LASTUPDATED] => 2022-09-13
    [street_address] => 7951 TOPPER DRIVE
    [city] => Mission
    [province] => British Columbia
    [postal] => V2V6Z3
    [price] => 1189900.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 2455 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637861483588130000/reb6/lowres/6/R2679496_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637861483588130000/reb6/medres/6/R2679496_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637861483588130000/reb6/highres/6/R2679496_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$1,189,900
2455 sqft | 5 | 3
7951 TOPPER DRIVE
Mission, British Columbia
V2V6Z3
MLS#R2679496
Mark Sawatzky: 604.866.8670 / Email
Array
(
    [crea_id] => 24762518
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2716082
    [LASTUPDATED] => 2022-09-13
    [street_address] => 4195 GOODCHILD STREET
    [city] => Abbotsford
    [province] => British Columbia
    [postal] => V3G1K2
    [price] => 939000.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1824 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637958329712800000/reb6/lowres/2/R2716082_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637958329712800000/reb6/medres/2/R2716082_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637958329712800000/reb6/highres/2/R2716082_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$939,000
1824 sqft | 4 | 3
4195 GOODCHILD STREET
Abbotsford, British Columbia
V3G1K2
MLS#R2716082
Mark Sawatzky: 604.866.8670 / Email
Array
(
    [crea_id] => 24599693
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2704245
    [LASTUPDATED] => 2022-09-13
    [street_address] => 119 32833 LANDEAU PLACE
    [city] => Abbotsford
    [province] => British Columbia
    [postal] => V2S6S6
    [price] => 499900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1323.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637920211240200000/reb6/lowres/5/R2704245_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637920211240200000/reb6/medres/5/R2704245_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637920211240200000/reb6/highres/5/R2704245_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$499,900
1323.0000 | 2 | 2
119 32833 LANDEAU PLACE
Abbotsford, British Columbia
V2S6S6
MLS#R2704245
Anthony Dyck: 604.439.1003 / Email
Array
(
    [crea_id] => 24601138
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2704487
    [LASTUPDATED] => 2022-09-13
    [street_address] => 209 20238 FRASER HIGHWAY
    [city] => Langley
    [province] => British Columbia
    [postal] => V3A4E6
    [price] => 469000.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 859 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637920301773130000/reb6/lowres/7/R2704487_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637920301773130000/reb6/medres/7/R2704487_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637920301773130000/reb6/highres/7/R2704487_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$469,000
859 sqft | 1 | 1
209 20238 FRASER HIGHWAY
Langley, British Columbia
V3A4E6
MLS#R2704487
Mark Sawatzky: 604.866.8670 / Email
Array
(
    [crea_id] => 24843268
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2721310
    [LASTUPDATED] => 2022-10-04
    [street_address] => 301 5465 201 STREET
    [city] => Langley
    [province] => British Columbia
    [postal] => V3A1P8
    [price] => 434900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 880 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637981519447600000/reb6/lowres/0/R2721310_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637981519447600000/reb6/medres/0/R2721310_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637981519447600000/reb6/highres/0/R2721310_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$434,900
880 sqft | 1 | 1
301 5465 201 STREET
Langley, British Columbia
V3A1P8
MLS#R2721310
Mark Sawatzky: 604.866.8670 / Email
Array
(
    [crea_id] => 24361840
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2684537
    [LASTUPDATED] => 2022-09-13
    [street_address] => 21 14600 MORRIS VALLEY ROAD
    [city] => Mission
    [province] => British Columbia
    [postal] => V0M1A1
    [price] => 319900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 456.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637873555973830000/reb6/lowres/7/R2684537_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637873555973830000/reb6/medres/7/R2684537_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637873555973830000/reb6/highres/7/R2684537_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$319,900
456.0000 | 1 | 1
21 14600 MORRIS VALLEY ROAD
Mission, British Columbia
V0M1A1
MLS#R2684537
Anthony Dyck: 604.439.1003 / Email
Array
(
    [crea_id] => 24349897
    [office_name] => 2 Percent Realty West Coast
    [office_id] => 279621
    [mls_id] => R2683855
    [LASTUPDATED] => 2022-09-13
    [street_address] => 41 14600 MORRIS VALLEY ROAD
    [city] => Mission
    [province] => British Columbia
    [postal] => V0M1A1
    [price] => 225900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 370 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637872037572670000/reb6/lowres/5/R2683855_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637872037572670000/reb6/medres/5/R2683855_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637872037572670000/reb6/highres/5/R2683855_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$225,900
370 sqft | 1 | 1
41 14600 MORRIS VALLEY ROAD
Mission, British Columbia
V0M1A1
MLS#R2683855
Anthony Dyck: 604.439.1003 / Email
Sort By