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 (24939672,24734563,24926244,24872918,24888005,24561467,22047240,24785679) 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] => 24939672
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4315885
    [LASTUPDATED] => 2022-10-04
    [street_address] => 53 SPRINGWOOD WY
    [city] => Spruce Grove
    [province] => Alberta
    [postal] => T7X0L4
    [price] => 385000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 131 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638005054098800000/reb10/lowres/5/E4315885_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638005054098800000/reb10/medres/5/E4315885_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638005054098800000/reb10/highres/5/E4315885_1.jpg
)
View
$385,000
131 m2 | 3 | 2.5
53 SPRINGWOOD WY
Spruce Grove, Alberta
T7X0L4
MLS#E4315885
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 24734563
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4307678
    [LASTUPDATED] => 2022-10-05
    [street_address] => 70 BELLEVILLE AV
    [city] => Spruce Grove
    [province] => Alberta
    [postal] => T7X1H7
    [price] => 367900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 95.6 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637951954167500000/reb10/lowres/8/E4307678_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637951954167500000/reb10/medres/8/E4307678_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637951954167500000/reb10/highres/8/E4307678_1.jpg
)
View
$367,900
95.6 m2 | 3 | 2
70 BELLEVILLE AV
Spruce Grove, Alberta
T7X1H7
MLS#E4307678
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 24926244
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4315382
    [LASTUPDATED] => 2022-09-30
    [street_address] => #19 2803 JAMES MOWATT TR SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6W2P5
    [price] => 319900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 152.59 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638001382155870000/reb10/lowres/2/E4315382_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638001382155870000/reb10/medres/2/E4315382_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638001382155870000/reb10/highres/2/E4315382_1.jpg
)
View
$319,900
152.59 m2 | 3 | 2.5
#19 2803 JAMES MOWATT TR SW
Edmonton, Alberta
T6W2P5
MLS#E4315382
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 24872918
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4313488
    [LASTUPDATED] => 2022-09-15
    [street_address] => #122 3357 16A AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6T0V4
    [price] => 177900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 75.17 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637987989907230000/reb10/lowres/8/E4313488_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637987989907230000/reb10/medres/8/E4313488_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637987989907230000/reb10/highres/8/E4313488_1.jpg
)
View
$177,900
75.17 m2 | 2 | 2
#122 3357 16A AV NW
Edmonton, Alberta
T6T0V4
MLS#E4313488
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 24888005
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4314071
    [LASTUPDATED] => 2022-09-19
    [street_address] => #119 11260 153 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5X6E7
    [price] => 159900.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/TS637992094263330000/reb10/lowres/1/E4314071_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637992094263330000/reb10/medres/1/E4314071_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637992094263330000/reb10/highres/1/E4314071_1.jpg
)
View
$159,900
62.5 m2 | 1 | 1
#119 11260 153 AV NW
Edmonton, Alberta
T5X6E7
MLS#E4314071
Tanya Fowler: 780.910.5267 / Email 
Array
(
    [crea_id] => 24561467
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4300456
    [LASTUPDATED] => 2022-07-25
    [street_address] => 1820 RUTHERFORD RD SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6W2K6
    [price] => 156900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 57.1 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637911526283700000/reb10/lowres/6/E4300456_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637911526283700000/reb10/medres/6/E4300456_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637911526283700000/reb10/highres/6/E4300456_1.jpg
)
View
$156,900
57.1 m2 | 1 | 1
1820 RUTHERFORD RD SW
Edmonton, Alberta
T6W2K6
MLS#E4300456
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 
Array
(
    [crea_id] => 24785679
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4309828
    [LASTUPDATED] => 2022-08-18
    [street_address] => 307 West Brook WY NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T1T5
    [price] => 43500.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 102.62 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637964302764870000/reb10/lowres/8/E4309828_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637964302764870000/reb10/medres/8/E4309828_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637964302764870000/reb10/highres/8/E4309828_1.jpg
)
View
$43,500
102.62 m2 | 3 | 1
307 West Brook WY NW
Edmonton, Alberta
T5T1T5
MLS#E4309828
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 © 2022 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.