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 (25001229,24737244,25067574,25000417,25102248) ORDER BY b.price DESC, b.mls_id ASC

MLS® System Listings

Search
X
Sort By
Array
(
    [crea_id] => 25001229
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4318105
    [LASTUPDATED] => 2022-12-03
    [street_address] => 1924 74 ST SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6X0K3
    [price] => 382500.00
    [bedroom_total] => 3
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 104.44 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638022190234800000/reb10/lowres/5/E4318105_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638022190234800000/reb10/medres/5/E4318105_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638022190234800000/reb10/highres/5/E4318105_1.jpg
)
$382,500
104.44 m2 | 3 | 3.5
1924 74 ST SW
Edmonton, Alberta
T6X0K3
MLS#E4318105
Steve Kehoe: 780.660.0222 / Email
Array
(
    [crea_id] => 24737244
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4307745
    [LASTUPDATED] => 2022-10-27
    [street_address] => 21356 90 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T6Y8
    [price] => 359900.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 96.87 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637952206488530000/reb10/lowres/5/E4307745_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637952206488530000/reb10/medres/5/E4307745_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637952206488530000/reb10/highres/5/E4307745_1.jpg
)
$359,900
96.87 m2 | 3 | 1
21356 90 AV NW
Edmonton, Alberta
T5T6Y8
MLS#E4307745
Steve Kehoe: 780.660.0222 / Email
Array
(
    [crea_id] => 25067574
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4320311
    [LASTUPDATED] => 2022-11-15
    [street_address] => 9518 96 ST
    [city] => Morinville
    [province] => Alberta
    [postal] => T8R1H8
    [price] => 334900.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 115.09 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638041279157300000/reb10/lowres/1/e4320311_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638041279157300000/reb10/medres/1/e4320311_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638041279157300000/reb10/highres/1/e4320311_1.jpg
)
$334,900
115.09 m2 | 4 | 2.5
9518 96 ST
Morinville, Alberta
T8R1H8
MLS#E4320311
Steve Kehoe: 780.660.0222 / Email
Array
(
    [crea_id] => 25000417
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4318090
    [LASTUPDATED] => 2022-12-01
    [street_address] => #23 1140 CHAPPELLE BV SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6W2Z3
    [price] => 289900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 102.78 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638022118286000000/reb10/lowres/0/E4318090_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638022118286000000/reb10/medres/0/E4318090_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638022118286000000/reb10/highres/0/E4318090_1.jpg
)
$289,900
102.78 m2 | 3 | 2.5
#23 1140 CHAPPELLE BV SW
Edmonton, Alberta
T6W2Z3
MLS#E4318090
Steve Kehoe: 780.660.0222 / Email
Array
(
    [crea_id] => 25102248
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4321300
    [LASTUPDATED] => 2022-12-05
    [street_address] => #411 9910 107 ST
    [city] => Morinville
    [province] => Alberta
    [postal] => T8R0A3
    [price] => 154900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 79.72 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638058619107830000/reb10/lowres/0/E4321300_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638058619107830000/reb10/medres/0/E4321300_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638058619107830000/reb10/highres/0/E4321300_1.jpg
)
$154,900
79.72 m2 | 2 | 2
#411 9910 107 ST
Morinville, Alberta
T8R0A3
MLS#E4321300
Steve Kehoe: 780.660.0222 / Email
Sort By