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,24998682,24858477,24999172,25084136,24592325,24944096,25099275,25099534,24699680) 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-11-01
    [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-10-21
    [street_address] => 7906 GETTY PL NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T1M8
    [price] => 638500.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
$638,500
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-10-09
    [street_address] => 5312 RUE EAGLEMONT
    [city] => Beaumont
    [province] => Alberta
    [postal] => T4X0H9
    [price] => 599900.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
$599,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-10-22
    [street_address] => 11535 16 AV SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6W0Z9
    [price] => 559900.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
$559,900
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-10-06
    [street_address] => 9536 73 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6E1A9
    [price] => 535000.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
$535,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] => 24998682
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4318014
    [LASTUPDATED] => 2022-11-09
    [street_address] => 21223 92 AV NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T0W6
    [price] => 439900.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 98.76 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638020677970930000/reb10/lowres/4/E4318014_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638020677970930000/reb10/medres/4/E4318014_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638020677970930000/reb10/highres/4/E4318014_1.jpg
)
View
$439,900
98.76 m2 | 4 | 3
21223 92 AV NW
Edmonton, Alberta
T5T0W6
MLS#E4318014
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] => 24999172
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4318052
    [LASTUPDATED] => 2022-11-11
    [street_address] => 8 MEADOWPARK GA
    [city] => Spruce Grove
    [province] => Alberta
    [postal] => T7X0T8
    [price] => 324900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 122.91 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638021398035100000/reb10/lowres/2/E4318052_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638021398035100000/reb10/medres/2/E4318052_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638021398035100000/reb10/highres/2/E4318052_1.jpg
)
View
$324,900
122.91 m2 | 3 | 2.5
8 MEADOWPARK GA
Spruce Grove, Alberta
T7X0T8
MLS#E4318052
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 25084136
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4320752
    [LASTUPDATED] => 2022-11-21
    [street_address] => 27 FOREST DR
    [city] => St. Albert
    [province] => Alberta
    [postal] => T8N1X1
    [price] => 314900.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/TS638046310248400000/reb10/lowres/2/E4320752_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638046310248400000/reb10/medres/2/E4320752_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638046310248400000/reb10/highres/2/E4320752_1.jpg
)
View
$314,900
101.45 m2 | 3 | 2.5
27 FOREST DR
St. Albert, Alberta
T8N1X1
MLS#E4320752
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] => 24944096
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4316062
    [LASTUPDATED] => 2022-10-25
    [street_address] => #61 9520 174 ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T5Z3
    [price] => 259900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 119.2 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638005918090800000/reb10/lowres/2/E4316062_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638005918090800000/reb10/medres/2/E4316062_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638005918090800000/reb10/highres/2/E4316062_1.jpg
)
View
$259,900
119.2 m2 | 3 | 2.5
#61 9520 174 ST NW
Edmonton, Alberta
T5T5Z3
MLS#E4316062
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 25099275
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4321217
    [LASTUPDATED] => 2022-11-27
    [street_address] => #14 12050 17 AV SW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6W1X4
    [price] => 249900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 126 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638051494241000000/reb10/lowres/7/E4321217_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638051494241000000/reb10/medres/7/E4321217_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638051494241000000/reb10/highres/7/E4321217_1.jpg
)
View
$249,900
126 m2 | 3 | 2.5
#14 12050 17 AV SW
Edmonton, Alberta
T6W1X4
MLS#E4321217
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 25099534
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4321231
    [LASTUPDATED] => 2022-11-27
    [street_address] => #433 300 SPRUCE RIDGE RD
    [city] => Spruce Grove
    [province] => Alberta
    [postal] => T7X0H6
    [price] => 214900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 86.67 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638051710190970000/reb10/lowres/1/E4321231_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638051710190970000/reb10/medres/1/E4321231_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638051710190970000/reb10/highres/1/E4321231_1.jpg
)
View
$214,900
86.67 m2 | 2 | 2
#433 300 SPRUCE RIDGE RD
Spruce Grove, Alberta
T7X0H6
MLS#E4321231
Jacquie Smith: 780.887.6493 / Email 
Array
(
    [crea_id] => 24699680
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4306262
    [LASTUPDATED] => 2022-10-21
    [street_address] => 9203 172 ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5T3C3
    [price] => 185000.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
$185,000
98.62 m2 | 3 | 1
9203 172 ST NW
Edmonton, Alberta
T5T3C3
MLS#E4306262
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.