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 (275007)) 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] => 24798711
    [office_name] => 2 Percent Westview Realty
    [office_id] => 275007
    [mls_id] => R2718332
    [LASTUPDATED] => 2022-09-13
    [street_address] => 42 2469 164 STREET
    [city] => Surrey
    [province] => British Columbia
    [postal] => V3Z3T4
    [price] => 978899.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1559.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637986697266500000/reb6/lowres/2/R2718332_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637986697266500000/reb6/medres/2/R2718332_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637986697266500000/reb6/highres/2/R2718332_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$978,899
1559.0000 | 3 | 3
42 2469 164 STREET
Surrey, British Columbia
V3Z3T4
MLS#R2718332
David Foster: 604.649.0149 / Email
Array
(
    [crea_id] => 24993111
    [office_name] => 2 Percent Westview Realty
    [office_id] => 275007
    [mls_id] => R2733073
    [LASTUPDATED] => 2022-10-21
    [street_address] => 802 3557 SAWMILL CRESCENT
    [city] => Vancouver
    [province] => British Columbia
    [postal] => V5S0E2
    [price] => 629900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 669 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638018941321670000/reb89/lowres/3/R2733073_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638018941321670000/reb89/medres/3/R2733073_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638018941321670000/reb89/highres/3/R2733073_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$629,900
669 sqft | 1 | 1
802 3557 SAWMILL CRESCENT
Vancouver, British Columbia
V5S0E2
MLS#R2733073
David Foster: 604.649.0149 / Email
Array
(
    [crea_id] => 24831051
    [office_name] => 2 Percent Westview Realty
    [office_id] => 275007
    [mls_id] => R2720354
    [LASTUPDATED] => 2022-10-26
    [street_address] => 316 7631 STEVESTON HIGHWAY
    [city] => Richmond
    [province] => British Columbia
    [postal] => V7A4L7
    [price] => 528000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 982 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637977233775800000/reb89/lowres/4/R2720354_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637977233775800000/reb89/medres/4/R2720354_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637977233775800000/reb89/highres/4/R2720354_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$528,000
982 sqft | 2 | 2
316 7631 STEVESTON HIGHWAY
Richmond, British Columbia
V7A4L7
MLS#R2720354
David Foster: 604.649.0149 / Email
Sort By