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

My MLS® System Listings

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