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

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-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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$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
)
$185,000
98.62 m2 | 3 | 1
9203 172 ST NW
Edmonton, Alberta
T5T3C3
MLS#E4306262
Jacquie Smith: 780.887.6493 / Email
Sort By