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 (24848377,25088616) ORDER BY b.price DESC, b.mls_id ASC
Search
X
Sort By
Array
(
    [crea_id] => 24848377
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4312451
    [LASTUPDATED] => 2022-10-17
    [street_address] => 342 SOUTHFORK DR
    [city] => Leduc
    [province] => Alberta
    [postal] => T9E0T8
    [price] => 399000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 139.22 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637982374386570000/reb10/lowres/1/E4312451_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637982374386570000/reb10/medres/1/E4312451_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637982374386570000/reb10/highres/1/E4312451_1.jpg
)
$399,000
139.22 m2 | 3 | 2.5
342 SOUTHFORK DR
Leduc, Alberta
T9E0T8
MLS#E4312451
Nicole Mazurak: 780.222.2209 / Email
Array
(
    [crea_id] => 25088616
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4320860
    [LASTUPDATED] => 2022-11-22
    [street_address] => 11904 22 AV SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6T0M1
    [price] => 372000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 114.3 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638047318303400000/reb10/lowres/0/E4320860_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638047318303400000/reb10/medres/0/E4320860_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638047318303400000/reb10/highres/0/E4320860_1.jpg
)
$372,000
114.3 m2 | 3 | 2.5
11904 22 AV SW
Edmonton, Alberta
T6T0M1
MLS#E4320860
Nicole Mazurak: 780.222.2209 / Email
Sort By