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 (25185935,25146295,25241012,25115554,25162724,25053319,25158072,25247701,25216649,22047240) 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] => 25185935
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4324163
    [LASTUPDATED] => 2023-01-13
    [street_address] => 97 51052 RGE RD 225
    [city] => Rural Strathcona County
    [province] => Alberta
    [postal] => T8C1H1
    [price] => 774999.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 178.4 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638092102278500000/reb10/lowres/3/E4324163_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638092102278500000/reb10/medres/3/E4324163_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638092102278500000/reb10/highres/3/E4324163_1.jpg
)
View
$774,999
178.4 m2 | 5 | 2.5
97 51052 RGE RD 225
Rural Strathcona County, Alberta
T8C1H1
MLS#E4324163
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 25146295
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4322698
    [LASTUPDATED] => 2023-01-27
    [street_address] => 20836 130 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5S0L4
    [price] => 549900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 199.09 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638071654021770000/reb10/lowres/8/E4322698_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638071654021770000/reb10/medres/8/E4322698_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638071654021770000/reb10/highres/8/E4322698_1.jpg
)
View
$549,900
199.09 m2 | 3 | 2.5
20836 130 AV NW
Edmonton, Alberta
T5S0L4
MLS#E4322698
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 25241012
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4326229
    [LASTUPDATED] => 2023-02-02
    [street_address] => #317 1406 HODGSON WY NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6R3K1
    [price] => 400000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 121.7 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638109382043100000/reb10/lowres/9/E4326229_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638109382043100000/reb10/medres/9/E4326229_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638109382043100000/reb10/highres/9/E4326229_1.jpg
)
View
$400,000
121.7 m2 | 2 | 2
#317 1406 HODGSON WY NW
Edmonton, Alberta
T6R3K1
MLS#E4326229
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 25115554
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4321734
    [LASTUPDATED] => 2023-01-18
    [street_address] => 17 53218 RGE RD 14
    [city] => Rural Parkland County
    [province] => Alberta
    [postal] => T7Z1X2
    [price] => 339000.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 112.23 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638058226099600000/reb10/lowres/4/E4321734_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638058226099600000/reb10/medres/4/E4321734_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638058226099600000/reb10/highres/4/E4321734_1.jpg
)
View
$339,000
112.23 m2 | 3 | 1
17 53218 RGE RD 14
Rural Parkland County, Alberta
T7Z1X2
MLS#E4321734
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 25162724
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4323326
    [LASTUPDATED] => 2023-01-05
    [street_address] => #19 2803 JAMES MOWATT TR SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6W2P5
    [price] => 300000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 126.6 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638085009912000000/reb10/lowres/6/E4323326_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638085009912000000/reb10/medres/6/E4323326_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638085009912000000/reb10/highres/6/E4323326_1.jpg
)
View
$300,000
126.6 m2 | 3 | 2.5
#19 2803 JAMES MOWATT TR SW
Edmonton, Alberta
T6W2P5
MLS#E4323326
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 25053319
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4319842
    [LASTUPDATED] => 2022-12-11
    [street_address] => 5105 118 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5W1C1
    [price] => 220000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 74.52 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638036230321170000/reb10/lowres/2/E4319842_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638036230321170000/reb10/medres/2/E4319842_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638036230321170000/reb10/highres/2/E4319842_1.jpg
)
View
$220,000
74.52 m2 | 3 | 2
5105 118 AV NW
Edmonton, Alberta
T5W1C1
MLS#E4319842
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 25158072
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4323165
    [LASTUPDATED] => 2023-01-05
    [street_address] => #122 3357 16A AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6T0V4
    [price] => 177000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 75.5 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638083534121330000/reb10/lowres/5/E4323165_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638083534121330000/reb10/medres/5/E4323165_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638083534121330000/reb10/highres/5/E4323165_1.jpg
)
View
$177,000
75.5 m2 | 2 | 2
#122 3357 16A AV NW
Edmonton, Alberta
T6T0V4
MLS#E4323165
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 25247701
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4326506
    [LASTUPDATED] => 2023-02-04
    [street_address] => #418 2590 ANDERSON WY SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6W0R2
    [price] => 159900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 1
    [size_interior] => 54.6 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638110677836530000/reb10/lowres/6/E4326506_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638110677836530000/reb10/medres/6/E4326506_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638110677836530000/reb10/highres/6/E4326506_1.jpg
)
View
$159,900
54.6 m2 | 1 | 0.5
#418 2590 ANDERSON WY SW
Edmonton, Alberta
T6W0R2
MLS#E4326506
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 25216649
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4325362
    [LASTUPDATED] => 2023-01-25
    [street_address] => #119 11260 153 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5X6E7
    [price] => 149999.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 62.5 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638102038106800000/reb10/lowres/2/E4325362_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638102038106800000/reb10/medres/2/E4325362_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638102038106800000/reb10/highres/2/E4325362_1.jpg
)
View
$149,999
62.5 m2 | 1 | 1
#119 11260 153 AV NW
Edmonton, Alberta
T5X6E7
MLS#E4325362
Tanya Fowler: 780.910.5267 / 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] => 
)
View
$140,000
1019.35 m2 | 3 | 1.5
No Address Available


MLS#E4204281
Tanya Fowler: 780.910.5267 / Email
Sort By
Tanya Fowler
This site's content is the responsibility of Tanya Fowler | 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.