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 (24904310,24904320,24588645,24899953,24666523) ORDER BY b.price DESC, b.mls_id ASC

MLS® System Listings

Search
X
Sort By
Array
(
    [crea_id] => 24904310
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4314603
    [LASTUPDATED] => 2022-09-23
    [street_address] => 3340 20 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6T0L4
    [price] => 569900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 191.22 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637995406377400000/reb10/lowres/3/E4314603_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637995406377400000/reb10/medres/3/E4314603_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637995406377400000/reb10/highres/3/E4314603_1.jpg
)
$569,900
191.22 m2 | 3 | 2.5
3340 20 AV NW
Edmonton, Alberta
T6T0L4
MLS#E4314603
Petterson Lam: 780.242.1628 / Email
Array
(
    [crea_id] => 24904320
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4314616
    [LASTUPDATED] => 2022-09-23
    [street_address] => 19055 72A AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T5S9
    [price] => 444900.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 104.5 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637995406429530000/reb10/lowres/6/E4314616_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637995406429530000/reb10/medres/6/E4314616_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637995406429530000/reb10/highres/6/E4314616_1.jpg
)
$444,900
104.5 m2 | 4 | 3
19055 72A AV NW
Edmonton, Alberta
T5T5S9
MLS#E4314616
Petterson Lam: 780.242.1628 / Email
Array
(
    [crea_id] => 24588645
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4301423
    [LASTUPDATED] => 2022-08-13
    [street_address] => #408 226 MACEWAN RD SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6W0C5
    [price] => 199400.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 81.3 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637916782468730000/reb10/lowres/3/E4301423_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637916782468730000/reb10/medres/3/E4301423_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637916782468730000/reb10/highres/3/E4301423_1.jpg
)
$199,400
81.3 m2 | 2 | 2
#408 226 MACEWAN RD SW
Edmonton, Alberta
T6W0C5
MLS#E4301423
Petterson Lam: 780.242.1628 / Email
Array
(
    [crea_id] => 24899953
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4314464
    [LASTUPDATED] => 2022-09-22
    [street_address] => #204 2203 44 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6T0T1
    [price] => 188900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 81.52 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637994542221770000/reb10/lowres/4/E4314464_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637994542221770000/reb10/medres/4/E4314464_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637994542221770000/reb10/highres/4/E4314464_1.jpg
)
$188,900
81.52 m2 | 2 | 2
#204 2203 44 AV NW
Edmonton, Alberta
T6T0T1
MLS#E4314464
Petterson Lam: 780.242.1628 / Email
Array
(
    [crea_id] => 24666523
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4304762
    [LASTUPDATED] => 2022-08-13
    [street_address] => #104 11330 108 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5H1B6
    [price] => 124900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 61.5 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637934278353370000/reb10/lowres/2/E4304762_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637934278353370000/reb10/medres/2/E4304762_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637934278353370000/reb10/highres/2/E4304762_1.jpg
)
$124,900
61.5 m2 | 1 | 1
#104 11330 108 AV NW
Edmonton, Alberta
T5H1B6
MLS#E4304762
Petterson Lam: 780.242.1628 / Email
Sort By