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 (24821121,24523495,24731264,24871465,24854492,24796950,24820288,24783040,24858477,24699683,24615240,24924290,24851715,24856918,24592325,24699680,24774232,24644069,24350779) 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] => 24821121
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4311270
    [LASTUPDATED] => 2022-08-31
    [street_address] => 10903 176A AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5X6H4
    [price] => 675000.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 233.62 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637974886167130000/reb10/lowres/0/E4311270_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637974886167130000/reb10/medres/0/E4311270_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637974886167130000/reb10/highres/0/E4311270_1.jpg
)
View
$675,000
233.62 m2 | 4 | 3.5
10903 176A AV NW
Edmonton, Alberta
T5X6H4
MLS#E4311270
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24523495
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4298753
    [LASTUPDATED] => 2022-08-26
    [street_address] => 7906 GETTY PL NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T1M8
    [price] => 649900.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 239.41 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637971260042630000/reb10/lowres/3/E4298753_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637971260042630000/reb10/medres/3/E4298753_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637971260042630000/reb10/highres/3/E4298753_1.jpg
)
View
$649,900
239.41 m2 | 4 | 2.5
7906 GETTY PL NW
Edmonton, Alberta
T5T1M8
MLS#E4298753
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24731264
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4307524
    [LASTUPDATED] => 2022-09-22
    [street_address] => 5312 RUE EAGLEMONT
    [city] => Beaumont
    [province] => Alberta
    [postal] => T4X0H9
    [price] => 612900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 278 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637987855211970000/reb10/lowres/4/E4307524_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637987855211970000/reb10/medres/4/E4307524_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637987855211970000/reb10/highres/4/E4307524_1.jpg
)
View
$612,900
278 m2 | 3 | 2.5
5312 RUE EAGLEMONT
Beaumont, Alberta
T4X0H9
MLS#E4307524
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24871465
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4313427
    [LASTUPDATED] => 2022-09-14
    [street_address] => 11535 16 AV SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6W0Z9
    [price] => 575000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 223 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637987702238300000/reb10/lowres/7/E4313427_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637987702238300000/reb10/medres/7/E4313427_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637987702238300000/reb10/highres/7/E4313427_1.jpg
)
View
$575,000
223 m2 | 3 | 2.5
11535 16 AV SW
Edmonton, Alberta
T6W0Z9
MLS#E4313427
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24854492
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4312726
    [LASTUPDATED] => 2022-09-24
    [street_address] => 9536 73 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6E1A9
    [price] => 545000.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 131.8 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637983310140670000/reb10/lowres/6/E4312726_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637983310140670000/reb10/medres/6/E4312726_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637983310140670000/reb10/highres/6/E4312726_1.jpg
)
View
$545,000
131.8 m2 | 4 | 3.5
9536 73 AV NW
Edmonton, Alberta
T6E1A9
MLS#E4312726
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24796950
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4310358
    [LASTUPDATED] => 2022-09-16
    [street_address] => 20739 99B AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T7N1
    [price] => 509900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 171.03 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637967902162700000/reb10/lowres/8/E4310358_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637967902162700000/reb10/medres/8/E4310358_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637967902162700000/reb10/highres/8/E4310358_1.jpg
)
View
$509,900
171.03 m2 | 3 | 2.5
20739 99B AV NW
Edmonton, Alberta
T5T7N1
MLS#E4310358
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24820288
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4311238
    [LASTUPDATED] => 2022-09-13
    [street_address] => 7422 CREIGHTON PLACE SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6W3J6
    [price] => 495000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 146.9 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637974742154270000/reb10/lowres/8/E4311238_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637974742154270000/reb10/medres/8/E4311238_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637974742154270000/reb10/highres/8/E4311238_1.jpg
)
View
$495,000
146.9 m2 | 3 | 2.5
7422 CREIGHTON PLACE SW
Edmonton, Alberta
T6W3J6
MLS#E4311238
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24783040
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4309735
    [LASTUPDATED] => 2022-09-14
    [street_address] => 7717 SCHMID CR NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6R0K6
    [price] => 469900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 156.6 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637987009034530000/reb10/lowres/5/E4309735_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637987009034530000/reb10/medres/5/E4309735_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637987009034530000/reb10/highres/5/E4309735_1.jpg
)
View
$469,900
156.6 m2 | 3 | 2.5
7717 SCHMID CR NW
Edmonton, Alberta
T6R0K6
MLS#E4309735
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24858477
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4313002
    [LASTUPDATED] => 2022-09-24
    [street_address] => 21316 58 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6M0H4
    [price] => 414900.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/TS637984965935770000/reb10/lowres/2/E4313002_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637984965935770000/reb10/medres/2/E4313002_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637984965935770000/reb10/highres/2/E4313002_1.jpg
)
View
$414,900
127.56 m2 | 3 | 2.5
21316 58 AV NW
Edmonton, Alberta
T6M0H4
MLS#E4313002
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24699683
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4306265
    [LASTUPDATED] => 2022-08-08
    [street_address] => 1488 JEFFERYS CR NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6L6T1
    [price] => 374999.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 121.4 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637942054130430000/reb10/lowres/5/E4306265_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637942054130430000/reb10/medres/5/E4306265_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637942054130430000/reb10/highres/5/E4306265_1.jpg
)
View
$374,999
121.4 m2 | 3 | 2.5
1488 JEFFERYS CR NW
Edmonton, Alberta
T6L6T1
MLS#E4306265
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24615240
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4302645
    [LASTUPDATED] => 2022-08-23
    [street_address] => 27 FOREST DR
    [city] => St. Albert
    [province] => Alberta
    [postal] => T8N1X1
    [price] => 349900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 101.45 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637922973945200000/reb10/lowres/5/E4302645_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637922973945200000/reb10/medres/5/E4302645_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637922973945200000/reb10/highres/5/E4302645_1.jpg
)
View
$349,900
101.45 m2 | 3 | 2.5
27 FOREST DR
St. Albert, Alberta
T8N1X1
MLS#E4302645
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24924290
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4315314
    [LASTUPDATED] => 2022-09-29
    [street_address] => 14604 61A ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5A2A5
    [price] => 349900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 96.68 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638000734234930000/reb10/lowres/4/E4315314_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638000734234930000/reb10/medres/4/E4315314_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638000734234930000/reb10/highres/4/E4315314_1.jpg
)
View
$349,900
96.68 m2 | 3 | 2
14604 61A ST NW
Edmonton, Alberta
T5A2A5
MLS#E4315314
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24851715
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4312608
    [LASTUPDATED] => 2022-09-09
    [street_address] => 1536 80A ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6K4E2
    [price] => 339900.00
    [bedroom_total] => 2
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 93.4 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637982733918170000/reb10/lowres/8/E4312608_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637982733918170000/reb10/medres/8/E4312608_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637982733918170000/reb10/highres/8/E4312608_1.jpg
)
View
$339,900
93.4 m2 | 2 | 2.5
1536 80A ST NW
Edmonton, Alberta
T6K4E2
MLS#E4312608
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24856918
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4312884
    [LASTUPDATED] => 2022-09-22
    [street_address] => 18305 71A AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T5W6
    [price] => 299900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 99.87 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637993640008300000/reb10/lowres/4/E4312884_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637993640008300000/reb10/medres/4/E4312884_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637993640008300000/reb10/highres/4/E4312884_1.jpg
)
View
$299,900
99.87 m2 | 3 | 1.5
18305 71A AV NW
Edmonton, Alberta
T5T5W6
MLS#E4312884
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24592325
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4301671
    [LASTUPDATED] => 2022-09-23
    [street_address] => #303 9905 81 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6E1W5
    [price] => 264900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 108.9 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637917790119800000/reb10/lowres/1/E4301671_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637917790119800000/reb10/medres/1/E4301671_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637917790119800000/reb10/highres/1/E4301671_1.jpg
)
View
$264,900
108.9 m2 | 2 | 2
#303 9905 81 AV NW
Edmonton, Alberta
T6E1W5
MLS#E4301671
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24699680
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4306262
    [LASTUPDATED] => 2022-09-28
    [street_address] => 9203 172 ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T3C3
    [price] => 205000.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 98.62 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637942054117030000/reb10/lowres/2/E4306262_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637942054117030000/reb10/medres/2/E4306262_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637942054117030000/reb10/highres/2/E4306262_1.jpg
)
View
$205,000
98.62 m2 | 3 | 1
9203 172 ST NW
Edmonton, Alberta
T5T3C3
MLS#E4306262
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24774232
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4309408
    [LASTUPDATED] => 2022-09-13
    [street_address] => 79 BELMEAD GD NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T1J1
    [price] => 192500.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 91.86 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637961926182230000/reb10/lowres/8/E4309408_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637961926182230000/reb10/medres/8/E4309408_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637961926182230000/reb10/highres/8/E4309408_1.jpg
)
View
$192,500
91.86 m2 | 3 | 1.5
79 BELMEAD GD NW
Edmonton, Alberta
T5T1J1
MLS#E4309408
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24644069
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4303893
    [LASTUPDATED] => 2022-08-10
    [street_address] => #201 9725 82 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6E1Y6
    [price] => 158500.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 68.3 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637929166145300000/reb10/lowres/3/E4303893_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637929166145300000/reb10/medres/3/E4303893_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637929166145300000/reb10/highres/3/E4303893_1.jpg
)
View
$158,500
68.3 m2 | 2 | 1
#201 9725 82 AV NW
Edmonton, Alberta
T6E1Y6
MLS#E4303893
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24350779
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4291297
    [LASTUPDATED] => 2022-08-02
    [street_address] => #204 11430 40 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6J0R5
    [price] => 129900.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/TS637871927087900000/reb10/lowres/7/E4291297_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637871927087900000/reb10/medres/7/E4291297_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637871927087900000/reb10/highres/7/E4291297_1.jpg
)
View
$129,900
60.6 m2 | 1 | 1
#204 11430 40 AV NW
Edmonton, Alberta
T6J0R5
MLS#E4291297
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 © 2022 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.