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 FROM tbl_CREA_0_agents a INNER JOIN tbl_CREA_0 b ON (a.crea_id = b.crea_id) LEFT JOIN tbl_CREA_0_photos c ON (a.crea_id = c.crea_id AND c.sequence_id = 1) WHERE a.crea_id IN (25213121,25050103,25071925) ORDER BY b.price DESC, b.mls_id ASC
Search
X
Sort By
Array
(
    [crea_id] => 25213121
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4325259
    [LASTUPDATED] => 2023-01-30
    [street_address] => 1269 WESTERRA CR
    [city] => Stony Plain
    [province] => Alberta
    [postal] => T7Z0B2
    [price] => 462900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 158.39 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638101425835670000/reb10/lowres/9/E4325259_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638101425835670000/reb10/medres/9/E4325259_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638101425835670000/reb10/highres/9/E4325259_1.jpg
)
$462,900
158.39 m2 | 3 | 2.5
1269 WESTERRA CR
Stony Plain, Alberta
T7Z0B2
MLS#E4325259
Nathanael Deuville: 780.707.0627 / Email
Array
(
    [crea_id] => 25050103
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4319754
    [LASTUPDATED] => 2022-12-19
    [street_address] => #19 17418 98A AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T6G2
    [price] => 384900.00
    [bedroom_total] => 2
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 107.2 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638035798031170000/reb10/lowres/4/E4319754_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638035798031170000/reb10/medres/4/E4319754_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638035798031170000/reb10/highres/4/E4319754_1.jpg
)
$384,900
107.2 m2 | 2 | 2.5
#19 17418 98A AV NW
Edmonton, Alberta
T5T6G2
MLS#E4319754
Nathanael Deuville: 780.707.0627 / Email
Array
(
    [crea_id] => 25071925
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4320419
    [LASTUPDATED] => 2023-01-16
    [street_address] => 12005 65 ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5W4L6
    [price] => 239900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 133.36 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638042157577970000/reb10/lowres/9/E4320419_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638042157577970000/reb10/medres/9/E4320419_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638042157577970000/reb10/highres/9/E4320419_1.jpg
)
$239,900
133.36 m2 | 3 | 2
12005 65 ST NW
Edmonton, Alberta
T5W4L6
MLS#E4320419
Nathanael Deuville: 780.707.0627 / Email
Sort By