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 (25268601,25300251,25329036,25238893,25248672,25268603,25326415,25212404,25349600,25276419,25212405) ORDER BY b.price DESC, b.mls_id ASC

My MLS® System Listings

Search
X
Sort By
Array
(
    [crea_id] => 25268601
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4327353
    [LASTUPDATED] => 2023-02-21
    [street_address] => 16 GEORGE LD
    [city] => Spruce Grove
    [province] => Alberta
    [postal] => T7X0M2
    [price] => 624900.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 197.05 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638125020879270000/reb10/lowres/3/E4327353_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638125020879270000/reb10/medres/3/E4327353_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638125020879270000/reb10/highres/3/E4327353_1.jpg
)
$624,900
197.05 m2 | 4 | 3.5
16 GEORGE LD
Spruce Grove, Alberta
T7X0M2
MLS#E4327353
Jacquie Smith: 780.887.6493 / Email
Array
(
    [crea_id] => 25300251
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4328622
    [LASTUPDATED] => 2023-03-05
    [street_address] => 5 WAHSTAO CR NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T2W9
    [price] => 549000.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 126.59 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638127000891400000/reb10/lowres/2/E4328622_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638127000891400000/reb10/medres/2/E4328622_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638127000891400000/reb10/highres/2/E4328622_1.jpg
)
$549,000
126.59 m2 | 4 | 3
5 WAHSTAO CR NW
Edmonton, Alberta
T5T2W9
MLS#E4328622
Jacquie Smith: 780.887.6493 / Email
Array
(
    [crea_id] => 25329036
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4329783
    [LASTUPDATED] => 2023-03-03
    [street_address] => 6 WEDGEWOOD CR
    [city] => Fort Saskatchewan
    [province] => Alberta
    [postal] => T8L4R4
    [price] => 474900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 208.46 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638134510083000000/reb10/lowres/3/E4329783_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638134510083000000/reb10/medres/3/E4329783_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638134510083000000/reb10/highres/3/E4329783_1.jpg
)
$474,900
208.46 m2 | 3 | 2.5
6 WEDGEWOOD CR
Fort Saskatchewan, Alberta
T8L4R4
MLS#E4329783
Jacquie Smith: 780.887.6493 / Email
Array
(
    [crea_id] => 25238893
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4326134
    [LASTUPDATED] => 2023-03-05
    [street_address] => 92 CHELSEA WY
    [city] => Sherwood Park
    [province] => Alberta
    [postal] => T8H2K4
    [price] => 449900.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 124.77 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638135520592400000/reb10/lowres/4/E4326134_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638135520592400000/reb10/medres/4/E4326134_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638135520592400000/reb10/highres/4/E4326134_1.jpg
)
$449,900
124.77 m2 | 4 | 3
92 CHELSEA WY
Sherwood Park, Alberta
T8H2K4
MLS#E4326134
Jacquie Smith: 780.887.6493 / Email
Array
(
    [crea_id] => 25248672
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4326562
    [LASTUPDATED] => 2023-02-19
    [street_address] => 4613 CRABAPPLE RU SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6X0X8
    [price] => 449900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 133.7 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638111850700500000/reb10/lowres/2/E4326562_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638111850700500000/reb10/medres/2/E4326562_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638111850700500000/reb10/highres/2/E4326562_1.jpg
)
$449,900
133.7 m2 | 3 | 2.5
4613 CRABAPPLE RU SW
Edmonton, Alberta
T6X0X8
MLS#E4326562
Jacquie Smith: 780.887.6493 / Email
Array
(
    [crea_id] => 25268603
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4327355
    [LASTUPDATED] => 2023-02-17
    [street_address] => 21316 58 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6M0H4
    [price] => 412000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 127.56 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638116725864300000/reb10/lowres/5/E4327355_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638116725864300000/reb10/medres/5/E4327355_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638116725864300000/reb10/highres/5/E4327355_1.jpg
)
$412,000
127.56 m2 | 3 | 2.5
21316 58 AV NW
Edmonton, Alberta
T6M0H4
MLS#E4327355
Jacquie Smith: 780.887.6493 / Email
Array
(
    [crea_id] => 25326415
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4329675
    [LASTUPDATED] => 2023-03-05
    [street_address] => 22552 96 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T7K4
    [price] => 375000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 120 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638133861984270000/reb10/lowres/5/E4329675_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638133861984270000/reb10/medres/5/E4329675_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638133861984270000/reb10/highres/5/E4329675_1.jpg
)
$375,000
120 m2 | 3 | 2.5
22552 96 AV NW
Edmonton, Alberta
T5T7K4
MLS#E4329675
Jacquie Smith: 780.887.6493 / Email
Array
(
    [crea_id] => 25212404
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4325228
    [LASTUPDATED] => 2023-02-19
    [street_address] => 506 KING ST
    [city] => Spruce Grove
    [province] => Alberta
    [postal] => T7X1B1
    [price] => 359000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 132.85 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638100958030200000/reb10/lowres/8/E4325228_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638100958030200000/reb10/medres/8/E4325228_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638100958030200000/reb10/highres/8/E4325228_1.jpg
)
$359,000
132.85 m2 | 4 | 2
506 KING ST
Spruce Grove, Alberta
T7X1B1
MLS#E4325228
Jacquie Smith: 780.887.6493 / Email
Array
(
    [crea_id] => 25349600
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4330604
    [LASTUPDATED] => 2023-03-10
    [street_address] => 9457 156 ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5R1Z5
    [price] => 219900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 118 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638139909991830000/reb10/lowres/4/E4330604_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638139909991830000/reb10/medres/4/E4330604_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638139909991830000/reb10/highres/4/E4330604_1.jpg
)
$219,900
118 m2 | 3 | 2.5
9457 156 ST NW
Edmonton, Alberta
T5R1Z5
MLS#E4330604
Jacquie Smith: 780.887.6493 / Email
Array
(
    [crea_id] => 25276419
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4327692
    [LASTUPDATED] => 2023-02-17
    [street_address] => #408 10636 120 ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5H4L5
    [price] => 174900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 79 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638119894078570000/reb10/lowres/2/E4327692_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638119894078570000/reb10/medres/2/E4327692_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638119894078570000/reb10/highres/2/E4327692_1.jpg
)
$174,900
79 m2 | 2 | 2
#408 10636 120 ST NW
Edmonton, Alberta
T5H4L5
MLS#E4327692
Jacquie Smith: 780.887.6493 / Email
Array
(
    [crea_id] => 25212405
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4325229
    [LASTUPDATED] => 2023-01-30
    [street_address] => #204 11430 40 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6J0R5
    [price] => 114900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 60.6 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638106740390700000/reb10/lowres/9/E4325229_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638106740390700000/reb10/medres/9/E4325229_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638106740390700000/reb10/highres/9/E4325229_1.jpg
)
$114,900
60.6 m2 | 1 | 1
#204 11430 40 AV NW
Edmonton, Alberta
T6J0R5
MLS#E4325229
Jacquie Smith: 780.887.6493 / Email
Sort By