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, d.thumbURL AS THUMBB, d.medURL AS MEDB, d.largeURL AS LARGEB FROM tbl_CREA_0_agents a INNER JOIN tbl_CREA_0 b ON (a.crea_id = b.crea_id AND a.office_id IN (277920)) LEFT JOIN tbl_CREA_0_photos c ON (a.crea_id = c.crea_id AND c.sequence_id = 1) LEFT JOIN tbl_CREA_0_photos d ON (a.crea_id = d.crea_id AND d.sequence_id = 0)ORDER BY b.price ASC, b.mls_id ASC
Agents of Change
100% Real Estate Agent Services | 100% REALTOR.CA Exposure | 3% Commission
Agents of Change
100% Real Estate Agent Services | 100% MLS System Exposure | 3% Commission
780.675.3332

Search Listings

Search
X
Sort By
Array
(
    [crea_id] => 24762608
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A1250599
    [LASTUPDATED] => 2023-05-23
    [street_address] => 40 654036 Range Road 222
    [city] => Rural Athabasca County
    [province] => Alberta
    [postal] => T9S2A5
    [price] => 54400.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638188230950830000/reb65/lowres/9/A1250599_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638188230950830000/reb65/medres/9/A1250599_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638188230950830000/reb65/highres/9/A1250599_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$54,400
| 0 | 0
40 654036 Range Road 222
Rural Athabasca County, Alberta
T9S2A5
MLS#A1250599
Pamela Ergang: 780.689.6856 / Email
Array
(
    [crea_id] => 25311932
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A2028140
    [LASTUPDATED] => 2023-05-27
    [street_address] => Lot 4 Canyon Road
    [city] => Athabasca
    [province] => Alberta
    [postal] => T9S1B4
    [price] => 85600.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638207958773130000/reb65/lowres/0/A2028140_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638207958773130000/reb65/medres/0/A2028140_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638207958773130000/reb65/highres/0/A2028140_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$85,600
| 0 | 0
Lot 4 Canyon Road
Athabasca, Alberta
T9S1B4
MLS#A2028140
Pamela Ergang: 780.689.6856 / Email
Array
(
    [crea_id] => 24711046
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A1243139
    [LASTUPDATED] => 2023-02-08
    [street_address] => Township Road 663A
    [city] => Rural Athabasca County
    [province] => Alberta
    [postal] => T9S1R6
    [price] => 87000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => Array
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637965276652630000/reb65/lowres/9/A1243139_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637965276652630000/reb65/medres/9/A1243139_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637965276652630000/reb65/highres/9/A1243139_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$87,000
Array | 0 | 0
Township Road 663A
Rural Athabasca County, Alberta
T9S1R6
MLS#A1243139
Derek Hall: 780.505.2030 / Email
Array
(
    [crea_id] => 24762684
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A1250626
    [LASTUPDATED] => 2023-05-23
    [street_address] => 16 654036 Range Road 222
    [city] => Rural Athabasca County
    [province] => Alberta
    [postal] => T9S2A5
    [price] => 87900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638188231002400000/reb65/lowres/6/A1250626_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638188231002400000/reb65/medres/6/A1250626_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638188231002400000/reb65/highres/6/A1250626_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$87,900
| 0 | 0
16 654036 Range Road 222
Rural Athabasca County, Alberta
T9S2A5
MLS#A1250626
Pamela Ergang: 780.689.6856 / Email
Array
(
    [crea_id] => 24839976
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A2000831
    [LASTUPDATED] => 2022-11-09
    [street_address] => 652034 Range Road 222.6
    [city] => Colinton
    [province] => Alberta
    [postal] => T0G0R0
    [price] => 118000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 896 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637980858620900000/reb65/lowres/1/A2000831_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637980858620900000/reb65/medres/1/A2000831_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637980858620900000/reb65/highres/1/A2000831_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$118,000
896 sqft | 2 | 1
652034 Range Road 222.6
Colinton, Alberta
T0G0R0
MLS#A2000831
Derek Hall: 780.505.2030 / Email
Array
(
    [crea_id] => 24994960
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A2007894
    [LASTUPDATED] => 2023-04-20
    [street_address] => 4913 49 Street
    [city] => Athabasca
    [province] => Alberta
    [postal] => T9S1C5
    [price] => 169500.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 2446 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638176074751700000/reb65/lowres/4/A2007894_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638176074751700000/reb65/medres/4/A2007894_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638176074751700000/reb65/highres/4/A2007894_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$169,500
2446 sqft | 0 | 0
4913 49 Street
Athabasca, Alberta
T9S1C5
MLS#A2007894
Pamela Ergang: 780.689.6856 / Email
Array
(
    [crea_id] => 24029301
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A1173990
    [LASTUPDATED] => 2023-02-28
    [street_address] => 4916A 49 Street
    [city] => Athabasca
    [province] => Alberta
    [postal] => T9S1C2
    [price] => 225000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 2333 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638131819450000000/reb65/lowres/0/A1173990_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638131819450000000/reb65/medres/0/A1173990_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638131819450000000/reb65/highres/0/A1173990_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$225,000
2333 sqft | 0 | 0
4916A 49 Street
Athabasca, Alberta
T9S1C2
MLS#A1173990
Pamela Ergang: 780.689.6856 / Email
Derek Hall: 780.505.2030 / Email
Array
(
    [crea_id] => 24672996
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A1240240
    [LASTUPDATED] => 2023-02-08
    [street_address] => 5002 51 Avenue
    [city] => Colinton
    [province] => Alberta
    [postal] => T0G0R0
    [price] => 249000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 2400 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637946305010900000/reb65/lowres/0/A1240240_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637946305010900000/reb65/medres/0/A1240240_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637946305010900000/reb65/highres/0/A1240240_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$249,000
2400 sqft | 0 | 0
5002 51 Avenue
Colinton, Alberta
T0G0R0
MLS#A1240240
Derek Hall: 780.505.2030 / Email
Array
(
    [crea_id] => 24808066
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A1254354
    [LASTUPDATED] => 2023-04-06
    [street_address] => 643026 Range Road 205
    [city] => Rural Athabasca County
    [province] => Alberta
    [postal] => T9A0M0
    [price] => 299900.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1324 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638163762897630000/reb65/lowres/4/A1254354_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638163762897630000/reb65/medres/4/A1254354_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638163762897630000/reb65/highres/4/A1254354_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$299,900
1324 sqft | 3 | 1
643026 Range Road 205
Rural Athabasca County, Alberta
T9A0M0
MLS#A1254354
Pamela Ergang: 780.689.6856 / Email
Array
(
    [crea_id] => 24952575
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A2005284
    [LASTUPDATED] => 2023-02-23
    [street_address] => 665015 Range Road 212.5
    [city] => Rural Athabasca County
    [province] => Alberta
    [postal] => T9S2A4
    [price] => 299900.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1392 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638127666786200000/reb65/lowres/4/A2005284_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638127666786200000/reb65/medres/4/A2005284_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638127666786200000/reb65/highres/4/A2005284_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$299,900
1392 sqft | 3 | 1
665015 Range Road 212.5
Rural Athabasca County, Alberta
T9S2A4
MLS#A2005284
Pamela Ergang: 780.689.6856 / Email
Array
(
    [crea_id] => 25117290
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A2009666
    [LASTUPDATED] => 2023-05-23
    [street_address] => 711 7th Street
    [city] => Smith
    [province] => Alberta
    [postal] => T0G2B0
    [price] => 349900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1094 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638171730306870000/reb65/lowres/6/A2009666_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638171730306870000/reb65/medres/6/A2009666_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638171730306870000/reb65/highres/6/A2009666_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$349,900
1094 sqft | 3 | 2
711 7th Street
Smith, Alberta
T0G2B0
MLS#A2009666
April Clements: 587.990.6725 / Email
Array
(
    [crea_id] => 24913772
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A2003056
    [LASTUPDATED] => 2023-05-23
    [street_address] => 694016 Main Street/Range Road 250
    [city] => Rural Lesser Slave River No. 124, M.D. of
    [province] => Alberta
    [postal] => T0G0N0
    [price] => 385000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 765.33 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638149081178200000/reb65/lowres/6/A2003056_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638149081178200000/reb65/medres/6/A2003056_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638149081178200000/reb65/highres/6/A2003056_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$385,000
765.33 sqft | 2 | 1
694016 Main Street/Range Road 250
Rural Lesser Slave River No. 124, M.D. of, Alberta
T0G0N0
MLS#A2003056
April Clements: 587.990.6725 / Email
Array
(
    [crea_id] => 24970544
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A2006404
    [LASTUPDATED] => 2023-05-16
    [street_address] => 4512 27 Street
    [city] => Athabasca
    [province] => Alberta
    [postal] => T9S1N5
    [price] => 437900.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 2666 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638198310741530000/reb65/lowres/4/A2006404_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638198310741530000/reb65/medres/4/A2006404_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638198310741530000/reb65/highres/4/A2006404_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$437,900
2666 sqft | 4 | 2.5
4512 27 Street
Athabasca, Alberta
T9S1N5
MLS#A2006404
Derek Hall: 780.505.2030 / Email
Array
(
    [crea_id] => 25176701
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A2018073
    [LASTUPDATED] => 2023-05-23
    [street_address] => 4208 Hees Court
    [city] => Athabasca
    [province] => Alberta
    [postal] => T9S1J3
    [price] => 439500.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 2114 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638197573079370000/reb65/lowres/3/A2018073_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638197573079370000/reb65/medres/3/A2018073_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638197573079370000/reb65/highres/3/A2018073_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$439,500
2114 sqft | 4 | 3.5
4208 Hees Court
Athabasca, Alberta
T9S1J3
MLS#A2018073
Pamela Ergang: 780.689.6856 / Email
Array
(
    [crea_id] => 25290753
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A2026120
    [LASTUPDATED] => 2023-05-23
    [street_address] => 671063 Range Road 242B
    [city] => West Baptiste
    [province] => Alberta
    [postal] => T9S2A8
    [price] => 449900.00
    [bedroom_total] => 2
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1405.7 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638192467953570000/reb65/lowres/0/A2026120_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638192467953570000/reb65/medres/0/A2026120_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638192467953570000/reb65/highres/0/A2026120_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$449,900
1405.7 sqft | 2 | 3
671063 Range Road 242B
West Baptiste, Alberta
T9S2A8
MLS#A2026120
Pamela Ergang: 780.689.6856 / Email
April Clements: 587.990.6725 / Email
Array
(
    [crea_id] => 24914696
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A2003416
    [LASTUPDATED] => 2023-05-23
    [street_address] => 2812 45 Avenue
    [city] => Athabasca
    [province] => Alberta
    [postal] => T9S1N6
    [price] => 457500.00
    [bedroom_total] => 5
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 2218 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638188219028700000/reb65/lowres/6/A2003416_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638188219028700000/reb65/medres/6/A2003416_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638188219028700000/reb65/highres/6/A2003416_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$457,500
2218 sqft | 5 | 3.5
2812 45 Avenue
Athabasca, Alberta
T9S1N6
MLS#A2003416
Pamela Ergang: 780.689.6856 / Email
Array
(
    [crea_id] => 24398817
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A1217062
    [LASTUPDATED] => 2023-05-25
    [street_address] => 1665 2 Street
    [city] => Calling Lake
    [province] => Alberta
    [postal] => T0G0K0
    [price] => 489900.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1399 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638206255429670000/reb65/lowres/2/A1217062_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638206255429670000/reb65/medres/2/A1217062_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638206255429670000/reb65/highres/2/A1217062_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$489,900
1399 sqft | 3 | 1
1665 2 Street
Calling Lake, Alberta
T0G0K0
MLS#A1217062
Derek Hall: 780.505.2030 / Email
Array
(
    [crea_id] => 25315656
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A2028434
    [LASTUPDATED] => 2023-05-24
    [street_address] => 46, 654036 Range Road 222
    [city] => Rural Athabasca County
    [province] => Alberta
    [postal] => T9S2A5
    [price] => 545000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1406 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638205415396930000/reb65/lowres/4/A2028434_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638205415396930000/reb65/medres/4/A2028434_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638205415396930000/reb65/highres/4/A2028434_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$545,000
1406 sqft | 3 | 2
46, 654036 Range Road 222
Rural Athabasca County, Alberta
T9S2A5
MLS#A2028434
Pamela Ergang: 780.689.6856 / Email
Array
(
    [crea_id] => 24665525
    [office_name] => 3% REALTY PROGRESS
    [office_id] => 277920
    [mls_id] => A1237676
    [LASTUPDATED] => 2023-04-12
    [street_address] => 6401 HIGHWAY 2
    [city] => Athabasca
    [province] => Alberta
    [postal] => T9S2B1
    [price] => 599900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1302 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638169019149730000/reb65/lowres/6/A1237676_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638169019149730000/reb65/medres/6/A1237676_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638169019149730000/reb65/highres/6/A1237676_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$599,900
1302 sqft | 3 | 2.5
6401 HIGHWAY 2
Athabasca, Alberta
T9S2B1
MLS#A1237676
Pamela Ergang: 780.689.6856 / Email
Sort By