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
Sort By
High to Low ($)
Low to High ($)
Recent High to Low ($)
Recent Low to High ($)
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
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
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
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
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
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
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
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
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
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
Sort By
High to Low ($)
Low to High ($)
Recent High to Low ($)
Recent Low to High ($)