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
X

My MLS® System Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
Jacquie Smith
This site's content is the responsibility of Jacquie Smith | 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 © 2023 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.