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 (24989507,25089307,25083249,25165773,24998857,25151164,25162632,24997598,25099236,24996845,25145911,25209278,24998856,25099116) ORDER BY b.price DESC, b.mls_id ASC
X
Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
Sort By 
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
)
View
$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
)
View
$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-12-18
    [street_address] => 4406 40 Avenue S
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1K6Z9
    [price] => 625000.00
    [bedroom_total] => 5
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 2208 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638069250237670000/reb26/lowres/7/A2012667_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638069250237670000/reb26/medres/7/A2012667_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638069250237670000/reb26/highres/7/A2012667_1.jpg
)
View
$625,000
2208 sqft | 5 | 3.5
4406 40 Avenue S
Lethbridge, Alberta
T1K6Z9
MLS#A2012667
Glen Lengyel: 403.360.8546 / Email 
Array
(
    [crea_id] => 25165773
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2017575
    [LASTUPDATED] => 2023-02-21
    [street_address] => 529 20 Street S
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1J3H9
    [price] => 455000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1433 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638125338400130000/reb26/lowres/5/A2017575_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638125338400130000/reb26/medres/5/A2017575_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638125338400130000/reb26/highres/5/A2017575_1.jpg
)
View
$455,000
1433 sqft | 4 | 2
529 20 Street S
Lethbridge, Alberta
T1J3H9
MLS#A2017575
Glen Lengyel: 403.360.8546 / Email
Dillon Rochon: 587.982.2720 / Email 
Array
(
    [crea_id] => 24998857
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2008159
    [LASTUPDATED] => 2023-03-10
    [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/TS638140704469900000/reb26/lowres/9/A2008159_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638140704469900000/reb26/medres/9/A2008159_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638140704469900000/reb26/highres/9/A2008159_1.jpg
)
View
$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] => 25151164
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2011632
    [LASTUPDATED] => 2023-02-28
    [street_address] => 110 Cayuga Crescent W
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1K5H5
    [price] => 320000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 887 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638131356942200000/reb26/lowres/2/A2011632_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638131356942200000/reb26/medres/2/A2011632_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638131356942200000/reb26/highres/2/A2011632_1.jpg
)
View
$320,000
887 sqft | 4 | 2
110 Cayuga Crescent W
Lethbridge, Alberta
T1K5H5
MLS#A2011632
Glen Lengyel: 403.360.8546 / Email 
Array
(
    [crea_id] => 25162632
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2017323
    [LASTUPDATED] => 2023-03-22
    [street_address] => 126 Lynx Cove N
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1H6V5
    [price] => 289000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 1219 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638150340449830000/reb26/lowres/3/A2017323_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638150340449830000/reb26/medres/3/A2017323_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638150340449830000/reb26/highres/3/A2017323_1.jpg
)
View
$289,000
1219 sqft | 2 | 1.5
126 Lynx Cove N
Lethbridge, Alberta
T1H6V5
MLS#A2017323
Glen Lengyel: 403.360.8546 / Email 
Array
(
    [crea_id] => 24997598
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2007989
    [LASTUPDATED] => 2023-03-19
    [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/TS638147730506230000/reb26/lowres/9/A2007989_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638147730506230000/reb26/medres/9/A2007989_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638147730506230000/reb26/highres/9/A2007989_1.jpg
)
View
$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] => 2023-02-28
    [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] => 1044.71 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638131362626500000/reb26/lowres/5/A2013495_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638131362626500000/reb26/medres/5/A2013495_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638131362626500000/reb26/highres/5/A2013495_1.jpg
)
View
$194,900
1044.71 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] => 24996845
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2006739
    [LASTUPDATED] => 2023-03-19
    [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/TS638147742572270000/reb26/lowres/9/A2006739_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638147742572270000/reb26/medres/9/A2006739_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638147742572270000/reb26/highres/9/A2006739_1.jpg
)
View
$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] => 25145911
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2016125
    [LASTUPDATED] => 2023-02-08
    [street_address] => 1 Walking Plow  Acres
    [city] => Rural Pincher Creek No. 9, M.D. of
    [province] => Alberta
    [postal] => T0K0P0
    [price] => 125000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638071523245870000/reb26/lowres/5/A2016125_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638071523245870000/reb26/medres/5/A2016125_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638071523245870000/reb26/highres/5/A2016125_1.jpg
)
View
$125,000
| 0 | 0
1 Walking Plow Acres
Rural Pincher Creek No. 9, M.D. of, Alberta
T0K0P0
MLS#A2016125
Glen Lengyel: 403.360.8546 / Email
Dillon Rochon: 587.982.2720 / Email 
Array
(
    [crea_id] => 25209278
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2020549
    [LASTUPDATED] => 2023-03-18
    [street_address] => 4, 1327 Scenic Drive S
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1K1M3
    [price] => 112500.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 760.87 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638147449090030000/reb26/lowres/9/A2020549_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638147449090030000/reb26/medres/9/A2020549_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638147449090030000/reb26/highres/9/A2020549_1.jpg
)
View
$112,500
760.87 sqft | 2 | 1
4, 1327 Scenic Drive S
Lethbridge, Alberta
T1K1M3
MLS#A2020549
Glen Lengyel: 403.360.8546 / Email 
Array
(
    [crea_id] => 24998856
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A2008045
    [LASTUPDATED] => 2023-02-28
    [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/TS638131368323130000/reb26/lowres/5/A2008045_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638131368323130000/reb26/medres/5/A2008045_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638131368323130000/reb26/highres/5/A2008045_1.jpg
)
View
$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] => 2023-02-08
    [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
)
View
$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
Glen Lengyel
This site's content is the responsibility of Glen Lengyel | 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 © 2023 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.