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
Search
X
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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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] => 
)
$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
)
$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