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 (21922914,22047240,25321511) ORDER BY b.price DESC, b.mls_id ASC
Search
X
Sort By
Array
(
    [crea_id] => 21922914
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4199836
    [LASTUPDATED] => 2020-06-10
    [street_address] => #39 9619 180 ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T4L9
    [price] => 192000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 90.6 m2
    [sequence_id] => 
    [thumbURL] => 
    [medURL] => 
    [largeURL] => 
)
$192,000
90.6 m2 | 3 | 1.5
#39 9619 180 ST NW
Edmonton, Alberta
T5T4L9
MLS#E4199836
Loral Walker: 780.232.2956 / Email
Array
(
    [crea_id] => 22047240
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4204281
    [LASTUPDATED] => 2020-07-01
    [street_address] => 
    [city] => 
    [province] => 
    [postal] => 
    [price] => 140000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 1019.35 m2
    [sequence_id] => 
    [thumbURL] => 
    [medURL] => 
    [largeURL] => 
)
$140,000
1019.35 m2 | 3 | 1.5
No Address Available


MLS#E4204281
Tanya Fowler: 780.910.5267 / Email
Array
(
    [crea_id] => 25321511
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4329442
    [LASTUPDATED] => 2023-06-07
    [street_address] => #307 11639 124 ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5M0Y3
    [price] => 59000.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 43.47 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638216940972600000/reb10/lowres/2/E4329442_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638216940972600000/reb10/medres/2/E4329442_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638216940972600000/reb10/highres/2/E4329442_1.jpg
)
$59,000
43.47 m2 | 1 | 1
#307 11639 124 ST NW
Edmonton, Alberta
T5M0Y3
MLS#E4329442
Tom Jastrzebski: 780.910.6348 / Email
Sort By