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
X
Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
Jon Hull
Tel: 780.221.2129
Email: jon.hull@2percentrealty.ca
This site's content is the responsibility of Jon Hull | 2018 Privacy Policy
The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA.
Copyright © 2023 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.