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 (24905478,25089307,24989507,25083249,25082798,24801345,24810921,25080658,25058699,25010730,24884597,24930994,24983222,24998857,24641959,24966207,25096471,24952424,25050004,25079982,24643788,24997598,25099236,25082992,24996845,24998856,25099116) ORDER BY b.price DESC, b.mls_id ASC
Search
X
Sort By
Array
(
    [crea_id] => 24905478
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2003061
    [LASTUPDATED] => 2022-11-25
    [street_address] => 94070 RGE RD 21-0
    [city] => Rural Lethbridge County
    [province] => Alberta
    [postal] => T1M1M6
    [price] => 900000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1344 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638049810471830000/reb26/lowres/1/A2003061_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638049810471830000/reb26/medres/1/A2003061_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638049810471830000/reb26/highres/1/A2003061_1.jpg
)
$900,000
1344 sqft | 4 | 2
94070 RGE RD 21-0
Rural Lethbridge County, Alberta
T1M1M6
MLS#A2003061
Jaimie Slingerland: 403.330.7955 / Email
Array
(
    [crea_id] => 24989507
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2007617
    [LASTUPDATED] => 2022-10-20
    [street_address] => 14  Skyline Mews
    [city] => Claresholm
    [province] => Alberta
    [postal] => T0L0T0
    [price] => 850000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 2596.29 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638018617192170000/reb26/lowres/7/A2007617_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638018617192170000/reb26/medres/7/A2007617_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638018617192170000/reb26/highres/7/A2007617_1.jpg
)
$850,000
2596.29 sqft | 0 | 0
14 Skyline Mews
Claresholm, Alberta
T0L0T0
MLS#A2007617
Glen Lengyel: 403.360.8546 / Email
Dillon Rochon: 587.982.2720 / Email
Array
(
    [crea_id] => 25089307
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2012978
    [LASTUPDATED] => 2022-11-23
    [street_address] => 14 Skyline Mews
    [city] => Claresholm
    [province] => Alberta
    [postal] => T0L0T0
    [price] => 850000.00
    [bedroom_total] => 5
    [bathroom_total] => 5
    [half_bath_total] => 0
    [size_interior] => 2596.29 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638047446627270000/reb26/lowres/8/A2012978_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638047446627270000/reb26/medres/8/A2012978_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638047446627270000/reb26/highres/8/A2012978_1.jpg
)
$850,000
2596.29 sqft | 5 | 5
14 Skyline Mews
Claresholm, Alberta
T0L0T0
MLS#A2012978
Glen Lengyel: 403.360.8546 / Email
Array
(
    [crea_id] => 25083249
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2012667
    [LASTUPDATED] => 2022-11-21
    [street_address] => 4406 40 Avenue S
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1K6Z9
    [price] => 635000.00
    [bedroom_total] => 5
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 2208 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638045784751230000/reb26/lowres/7/A2012667_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638045784751230000/reb26/medres/7/A2012667_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638045784751230000/reb26/highres/7/A2012667_1.jpg
)
$635,000
2208 sqft | 5 | 3.5
4406 40 Avenue S
Lethbridge, Alberta
T1K6Z9
MLS#A2012667
Glen Lengyel: 403.360.8546 / Email
Array
(
    [crea_id] => 25082798
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2012605
    [LASTUPDATED] => 2022-11-20
    [street_address] => 32 Tudor Crescent S
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1K5C8
    [price] => 629000.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 2719 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638045490564270000/reb26/lowres/5/A2012605_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638045490564270000/reb26/medres/5/A2012605_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638045490564270000/reb26/highres/5/A2012605_1.jpg
)
$629,000
2719 sqft | 4 | 3.5
32 Tudor Crescent S
Lethbridge, Alberta
T1K5C8
MLS#A2012605
Glen Lengyel: 403.360.8546 / Email
Array
(
    [crea_id] => 24801345
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A1253366
    [LASTUPDATED] => 2022-09-26
    [street_address] => 232 Avro Anson Road
    [city] => Fort Macleod
    [province] => Alberta
    [postal] => T0L0Z0
    [price] => 625000.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1680.25 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637974852685830000/reb26/lowres/6/A1253366_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637974852685830000/reb26/medres/6/A1253366_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637974852685830000/reb26/highres/6/A1253366_1.jpg
)
$625,000
1680.25 sqft | 4 | 3
232 Avro Anson Road
Fort Macleod, Alberta
T0L0Z0
MLS#A1253366
Glen Lengyel: 403.360.8546 / Email
Brennan Reichard: 403.892.3219 / Email
Array
(
    [crea_id] => 24810921
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2000276
    [LASTUPDATED] => 2022-11-25
    [street_address] => 1315 7 Street N
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1H1Y8
    [price] => 549900.00
    [bedroom_total] => 5
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 1951 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638049810314570000/reb26/lowres/6/A2000276_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638049810314570000/reb26/medres/6/A2000276_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638049810314570000/reb26/highres/6/A2000276_1.jpg
)
$549,900
1951 sqft | 5 | 3.5
1315 7 Street N
Lethbridge, Alberta
T1H1Y8
MLS#A2000276
Jaimie Slingerland: 403.330.7955 / Email
Array
(
    [crea_id] => 25080658
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2012472
    [LASTUPDATED] => 2022-11-18
    [street_address] => 64064 845 Highway
    [city] => Rural Warner No. 5, County of
    [province] => Alberta
    [postal] => T0K2S0
    [price] => 525000.00
    [bedroom_total] => 6
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1734.43 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638043833623200000/reb26/lowres/2/A2012472_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638043833623200000/reb26/medres/2/A2012472_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638043833623200000/reb26/highres/2/A2012472_1.jpg
)
$525,000
1734.43 sqft | 6 | 3
64064 845 Highway
Rural Warner No. 5, County of, Alberta
T0K2S0
MLS#A2012472
Glen Lengyel: 403.360.8546 / Email
Dillon Rochon: 587.982.2720 / Email
Array
(
    [crea_id] => 25058699
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2011469
    [LASTUPDATED] => 2022-11-11
    [street_address] => 327 11b Street
    [city] => Nobleford
    [province] => Alberta
    [postal] => T0L1S0
    [price] => 499000.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1501 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638037683149430000/reb26/lowres/9/A2011469_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638037683149430000/reb26/medres/9/A2011469_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638037683149430000/reb26/highres/9/A2011469_1.jpg
)
$499,000
1501 sqft | 4 | 3
327 11b Street
Nobleford, Alberta
T0L1S0
MLS#A2011469
Brian Oudshoorn: 403.308.8521 / Email
Array
(
    [crea_id] => 25010730
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2008910
    [LASTUPDATED] => 2022-11-21
    [street_address] => 122014 Range Road 233
    [city] => Barons
    [province] => Alberta
    [postal] => T0L0G0
    [price] => 485000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1097.59 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638045838287600000/reb26/lowres/0/A2008910_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638045838287600000/reb26/medres/0/A2008910_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638045838287600000/reb26/highres/0/A2008910_1.jpg
)
$485,000
1097.59 sqft | 3 | 2.5
122014 Range Road 233
Barons, Alberta
T0L0G0
MLS#A2008910
Glen Lengyel: 403.360.8546 / Email
Brennan Reichard: 403.892.3219 / Email
Array
(
    [crea_id] => 24884597
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A1258355
    [LASTUPDATED] => 2022-10-07
    [street_address] => 504 Canal LANE
    [city] => Lomond
    [province] => Alberta
    [postal] => T0L1G0
    [price] => 450000.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1295.36 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638007450491800000/reb26/lowres/5/A1258355_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638007450491800000/reb26/medres/5/A1258355_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638007450491800000/reb26/highres/5/A1258355_1.jpg
)
$450,000
1295.36 sqft | 4 | 3
504 Canal LANE
Lomond, Alberta
T0L1G0
MLS#A1258355
Glen Lengyel: 403.360.8546 / Email
Array
(
    [crea_id] => 24930994
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2003538
    [LASTUPDATED] => 2022-11-11
    [street_address] => 684 Marie Van Haarlem  Crescent N
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1H6Z8
    [price] => 420000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1663.06 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638037642821230000/reb26/lowres/8/A2003538_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638037642821230000/reb26/medres/8/A2003538_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638037642821230000/reb26/highres/8/A2003538_1.jpg
)
$420,000
1663.06 sqft | 3 | 2.5
684 Marie Van Haarlem Crescent N
Lethbridge, Alberta
T1H6Z8
MLS#A2003538
Glen Lengyel: 403.360.8546 / Email
Array
(
    [crea_id] => 24983222
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2007130
    [LASTUPDATED] => 2022-11-22
    [street_address] => 429 10B Street
    [city] => Nobleford
    [province] => Alberta
    [postal] => T0L1S0
    [price] => 382500.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1485 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638047170782970000/reb26/lowres/0/A2007130_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638047170782970000/reb26/medres/0/A2007130_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638047170782970000/reb26/highres/0/A2007130_1.jpg
)
$382,500
1485 sqft | 5 | 3
429 10B Street
Nobleford, Alberta
T0L1S0
MLS#A2007130
Brian Oudshoorn: 403.308.8521 / Email
Array
(
    [crea_id] => 24998857
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2008159
    [LASTUPDATED] => 2022-11-15
    [street_address] => 3045 224 Street
    [city] => Bellevue
    [province] => Alberta
    [postal] => T0K0E0
    [price] => 370000.00
    [bedroom_total] => 5
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1058 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638041189096730000/reb26/lowres/9/A2008159_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638041189096730000/reb26/medres/9/A2008159_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638041189096730000/reb26/highres/9/A2008159_1.jpg
)
$370,000
1058 sqft | 5 | 2
3045 224 Street
Bellevue, Alberta
T0K0E0
MLS#A2008159
Glen Lengyel: 403.360.8546 / Email
Dillon Rochon: 587.982.2720 / Email
Array
(
    [crea_id] => 24641959
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A1237841
    [LASTUPDATED] => 2022-10-05
    [street_address] => 2308 12 Avenue S
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1K0P2
    [price] => 360000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 2
    [size_interior] => 1317 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638005573246900000/reb26/lowres/1/A1237841_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638005573246900000/reb26/medres/1/A1237841_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638005573246900000/reb26/highres/1/A1237841_1.jpg
)
$360,000
1317 sqft | 3 | 2
2308 12 Avenue S
Lethbridge, Alberta
T1K0P2
MLS#A1237841
Jaimie Slingerland: 403.330.7955 / Email
Array
(
    [crea_id] => 24966207
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2006119
    [LASTUPDATED] => 2022-11-05
    [street_address] => 19 Chilcotin Crescent W
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1K7G9
    [price] => 355000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1096.18 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638032704293400000/reb26/lowres/9/A2006119_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638032704293400000/reb26/medres/9/A2006119_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638032704293400000/reb26/highres/9/A2006119_1.jpg
)
$355,000
1096.18 sqft | 3 | 3
19 Chilcotin Crescent W
Lethbridge, Alberta
T1K7G9
MLS#A2006119
Glen Lengyel: 403.360.8546 / Email
Array
(
    [crea_id] => 25096471
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2013334
    [LASTUPDATED] => 2022-11-27
    [street_address] => 2209 17 Street
    [city] => Coaldale
    [province] => Alberta
    [postal] => T1M1E3
    [price] => 300000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 895.5 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638051646236300000/reb26/lowres/4/A2013334_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638051646236300000/reb26/medres/4/A2013334_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638051646236300000/reb26/highres/4/A2013334_1.jpg
)
$300,000
895.5 sqft | 4 | 2
2209 17 Street
Coaldale, Alberta
T1M1E3
MLS#A2013334
Jaimie Slingerland: 403.330.7955 / Email
Array
(
    [crea_id] => 24952424
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2005173
    [LASTUPDATED] => 2022-11-25
    [street_address] => 142 Oxford Road W
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1K4V4
    [price] => 299000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 1039 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638049810539570000/reb26/lowres/3/A2005173_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638049810539570000/reb26/medres/3/A2005173_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638049810539570000/reb26/highres/3/A2005173_1.jpg
)
$299,000
1039 sqft | 3 | 1.5
142 Oxford Road W
Lethbridge, Alberta
T1K4V4
MLS#A2005173
Jaimie Slingerland: 403.330.7955 / Email
Array
(
    [crea_id] => 25050004
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2011111
    [LASTUPDATED] => 2022-11-09
    [street_address] => 155 Ryerson Rd  W
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1K4N7
    [price] => 295000.00
    [bedroom_total] => 5
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1014 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638035546276870000/reb26/lowres/1/A2011111_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638035546276870000/reb26/medres/1/A2011111_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638035546276870000/reb26/highres/1/A2011111_1.jpg
)
$295,000
1014 sqft | 5 | 2
155 Ryerson Rd W
Lethbridge, Alberta
T1K4N7
MLS#A2011111
Glen Lengyel: 403.360.8546 / Email
Array
(
    [crea_id] => 25079982
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2012439
    [LASTUPDATED] => 2022-11-18
    [street_address] => 728 19 Street N
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1H3L2
    [price] => 282000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 947.4 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638043762547870000/reb26/lowres/9/A2012439_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638043762547870000/reb26/medres/9/A2012439_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638043762547870000/reb26/highres/9/A2012439_1.jpg
)
$282,000
947.4 sqft | 4 | 2
728 19 Street N
Lethbridge, Alberta
T1H3L2
MLS#A2012439
Jaimie Slingerland: 403.330.7955 / Email
Array
(
    [crea_id] => 24643788
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A1237911
    [LASTUPDATED] => 2022-11-02
    [street_address] => 204 14 Street N
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1H2V9
    [price] => 259000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 926 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638029824296000000/reb26/lowres/1/A1237911_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638029824296000000/reb26/medres/1/A1237911_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638029824296000000/reb26/highres/1/A1237911_1.jpg
)
$259,000
926 sqft | 3 | 2
204 14 Street N
Lethbridge, Alberta
T1H2V9
MLS#A1237911
Jaimie Slingerland: 403.330.7955 / Email
Array
(
    [crea_id] => 24997598
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2007989
    [LASTUPDATED] => 2022-10-24
    [street_address] => 404 4th Street
    [city] => Rural Pincher Creek No. 9, M.D. of
    [province] => Alberta
    [postal] => T0K1W0
    [price] => 250000.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 982.35 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638022318563130000/reb26/lowres/9/A2007989_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638022318563130000/reb26/medres/9/A2007989_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638022318563130000/reb26/highres/9/A2007989_1.jpg
)
$250,000
982.35 sqft | 1 | 1
404 4th Street
Rural Pincher Creek No. 9, M.D. of, Alberta
T0K1W0
MLS#A2007989
Glen Lengyel: 403.360.8546 / Email
Dillon Rochon: 587.982.2720 / Email
Array
(
    [crea_id] => 25099236
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2013495
    [LASTUPDATED] => 2022-11-27
    [street_address] => 50, 49 Keystone Terrace W
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1J5B8
    [price] => 194900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 935.26 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638051453276830000/reb26/lowres/5/A2013495_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638051453276830000/reb26/medres/5/A2013495_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638051453276830000/reb26/highres/5/A2013495_1.jpg
)
$194,900
935.26 sqft | 2 | 1.5
50, 49 Keystone Terrace W
Lethbridge, Alberta
T1J5B8
MLS#A2013495
Glen Lengyel: 403.360.8546 / Email
Dillon Rochon: 587.982.2720 / Email
Array
(
    [crea_id] => 25082992
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2012608
    [LASTUPDATED] => 2022-11-20
    [street_address] => 103 Railway Crescent
    [city] => Coaldale
    [province] => Alberta
    [postal] => T1M0A8
    [price] => 175000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1503 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638045520595630000/reb26/lowres/8/A2012608_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638045520595630000/reb26/medres/8/A2012608_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638045520595630000/reb26/highres/8/A2012608_1.jpg
)
$175,000
1503 sqft | 3 | 2
103 Railway Crescent
Coaldale, Alberta
T1M0A8
MLS#A2012608
Glen Lengyel: 403.360.8546 / Email
Array
(
    [crea_id] => 24996845
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2006739
    [LASTUPDATED] => 2022-10-21
    [street_address] => 601 Chinook Crescent
    [city] => Rural Pincher Creek No. 9, M.D. of
    [province] => Alberta
    [postal] => T0K1W0
    [price] => 165000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 1012.24 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638019706328230000/reb26/lowres/9/A2006739_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638019706328230000/reb26/medres/9/A2006739_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638019706328230000/reb26/highres/9/A2006739_1.jpg
)
$165,000
1012.24 sqft | 3 | 1.5
601 Chinook Crescent
Rural Pincher Creek No. 9, M.D. of, Alberta
T0K1W0
MLS#A2006739
Glen Lengyel: 403.360.8546 / Email
Dillon Rochon: 587.982.2720 / Email
Array
(
    [crea_id] => 24998856
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2008045
    [LASTUPDATED] => 2022-11-09
    [street_address] => 308 3 Avenue
    [city] => Rural Pincher Creek No. 9, M.D. of
    [province] => Alberta
    [postal] => T0K1W0
    [price] => 35000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638022318682800000/reb26/lowres/5/A2008045_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638022318682800000/reb26/medres/5/A2008045_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638022318682800000/reb26/highres/5/A2008045_1.jpg
)
$35,000
| 0 | 0
308 3 Avenue
Rural Pincher Creek No. 9, M.D. of, Alberta
T0K1W0
MLS#A2008045
Glen Lengyel: 403.360.8546 / Email
Dillon Rochon: 587.982.2720 / Email
Array
(
    [crea_id] => 25099116
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2013494
    [LASTUPDATED] => 2022-11-27
    [street_address] => 2 3 Avenue
    [city] => Rural Pincher Creek No. 9, M.D. of
    [province] => Alberta
    [postal] => t0k1w0
    [price] => 22000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638051046418430000/reb26/lowres/4/A2013494_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638051046418430000/reb26/medres/4/A2013494_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638051046418430000/reb26/highres/4/A2013494_1.jpg
)
$22,000
| 0 | 0
2 3 Avenue
Rural Pincher Creek No. 9, M.D. of, Alberta
t0k1w0
MLS#A2013494
Glen Lengyel: 403.360.8546 / Email
Dillon Rochon: 587.982.2720 / Email
Sort By