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
Search
X
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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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] => 
)
$140,000
1019.35 m2 | 3 | 1.5
No Address Available


MLS#E4204281
Tanya Fowler: 780.910.5267 / Email
Sort By