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 (25152668,25242558,25176013,25105834,25226459,25238895,25212401,25140188,25237455,25017142) ORDER BY b.price DESC, b.mls_id ASC
Search
X
Sort By
Array
(
    [crea_id] => 25152668
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4322901
    [LASTUPDATED] => 2023-01-24
    [street_address] => 9018 148 ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5R1A1
    [price] => 949900.00
    [bedroom_total] => 5
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 231.62 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638078494232130000/reb10/lowres/1/E4322901_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638078494232130000/reb10/medres/1/E4322901_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638078494232130000/reb10/highres/1/E4322901_1.jpg
)
$949,900
231.62 m2 | 5 | 4
9018 148 ST NW
Edmonton, Alberta
T5R1A1
MLS#E4322901
Jon Hull: 780.221.2129 / Email
Array
(
    [crea_id] => 25242558
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4326287
    [LASTUPDATED] => 2023-02-03
    [street_address] => 9755 65 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6E0K5
    [price] => 385900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 88.92 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638109529195530000/reb10/lowres/7/E4326287_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638109529195530000/reb10/medres/7/E4326287_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638109529195530000/reb10/highres/7/E4326287_1.jpg
)
$385,900
88.92 m2 | 4 | 2
9755 65 AV NW
Edmonton, Alberta
T6E0K5
MLS#E4326287
Jon Hull: 780.221.2129 / Email
Array
(
    [crea_id] => 25176013
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4323796
    [LASTUPDATED] => 2023-01-19
    [street_address] => 164 REED PL
    [city] => Leduc
    [province] => Alberta
    [postal] => T9E1B1
    [price] => 379900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 158.05 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638097463415330000/reb10/lowres/6/E4323796_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638097463415330000/reb10/medres/6/E4323796_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638097463415330000/reb10/highres/6/E4323796_1.jpg
)
$379,900
158.05 m2 | 3 | 2.5
164 REED PL
Leduc, Alberta
T9E1B1
MLS#E4323796
Jon Hull: 780.221.2129 / Email
Array
(
    [crea_id] => 25105834
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4321407
    [LASTUPDATED] => 2023-01-07
    [street_address] => #2 804 WELSH DR SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6X1Y8
    [price] => 299900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 131.96 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638054086181800000/reb10/lowres/7/E4321407_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638054086181800000/reb10/medres/7/E4321407_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638054086181800000/reb10/highres/7/E4321407_1.jpg
)
$299,900
131.96 m2 | 3 | 2.5
#2 804 WELSH DR SW
Edmonton, Alberta
T6X1Y8
MLS#E4321407
Jon Hull: 780.221.2129 / Email
Array
(
    [crea_id] => 25226459
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4325691
    [LASTUPDATED] => 2023-01-28
    [street_address] => #46 1391 STARLING DR NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5S0L3
    [price] => 299900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 136.5 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638105269167470000/reb10/lowres/1/E4325691_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638105269167470000/reb10/medres/1/E4325691_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638105269167470000/reb10/highres/1/E4325691_1.jpg
)
$299,900
136.5 m2 | 3 | 2.5
#46 1391 STARLING DR NW
Edmonton, Alberta
T5S0L3
MLS#E4325691
Jon Hull: 780.221.2129 / Email
Array
(
    [crea_id] => 25238895
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4326137
    [LASTUPDATED] => 2023-02-02
    [street_address] => 451 ASTER CL
    [city] => Leduc
    [province] => Alberta
    [postal] => T9E0E2
    [price] => 291900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 111.45 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638108734006700000/reb10/lowres/7/E4326137_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638108734006700000/reb10/medres/7/E4326137_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638108734006700000/reb10/highres/7/E4326137_1.jpg
)
$291,900
111.45 m2 | 3 | 1.5
451 ASTER CL
Leduc, Alberta
T9E0E2
MLS#E4326137
Jon Hull: 780.221.2129 / Email
Array
(
    [crea_id] => 25212401
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4325222
    [LASTUPDATED] => 2023-01-24
    [street_address] => #46 603 WATT BV SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6X0P3
    [price] => 284900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 119.95 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638100958024100000/reb10/lowres/2/E4325222_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638100958024100000/reb10/medres/2/E4325222_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638100958024100000/reb10/highres/2/E4325222_1.jpg
)
$284,900
119.95 m2 | 3 | 2.5
#46 603 WATT BV SW
Edmonton, Alberta
T6X0P3
MLS#E4325222
Jon Hull: 780.221.2129 / Email
Array
(
    [crea_id] => 25140188
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4322488
    [LASTUPDATED] => 2022-12-16
    [street_address] => #122 279 SUDER GREENS DR NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T6X6
    [price] => 219900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 115.24 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638067910140830000/reb10/lowres/8/E4322488_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638067910140830000/reb10/medres/8/E4322488_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638067910140830000/reb10/highres/8/E4322488_1.jpg
)
$219,900
115.24 m2 | 2 | 2
#122 279 SUDER GREENS DR NW
Edmonton, Alberta
T5T6X6
MLS#E4322488
Jon Hull: 780.221.2129 / Email
Array
(
    [crea_id] => 25237455
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4326070
    [LASTUPDATED] => 2023-02-01
    [street_address] => #115 612 111 ST SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6W1R9
    [price] => 182900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 77.82 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638108590013830000/reb10/lowres/0/E4326070_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638108590013830000/reb10/medres/0/E4326070_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638108590013830000/reb10/highres/0/E4326070_1.jpg
)
$182,900
77.82 m2 | 1 | 1
#115 612 111 ST SW
Edmonton, Alberta
T6W1R9
MLS#E4326070
Jon Hull: 780.221.2129 / Email
Array
(
    [crea_id] => 25017142
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4318606
    [LASTUPDATED] => 2022-12-07
    [street_address] => #109 10636 120 ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5H4L5
    [price] => 162000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 73.91 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638053165183470000/reb10/lowres/6/E4318606_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638053165183470000/reb10/medres/6/E4318606_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638053165183470000/reb10/highres/6/E4318606_1.jpg
)
$162,000
73.91 m2 | 2 | 1
#109 10636 120 ST NW
Edmonton, Alberta
T5H4L5
MLS#E4318606
Jon Hull: 780.221.2129 / Email
Sort By