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,24810921,24641959,25096471,24952424,25079982,24643788) ORDER BY b.price DESC, b.mls_id ASC
X

My Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
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
)
View
$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] => 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
)
View
$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] => 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
)
View
$360,000
1317 sqft | 3 | 2
2308 12 Avenue S
Lethbridge, Alberta
T1K0P2
MLS#A1237841
Jaimie Slingerland: 403.330.7955 / 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
)
View
$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
)
View
$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] => 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
)
View
$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
)
View
$259,000
926 sqft | 3 | 2
204 14 Street N
Lethbridge, Alberta
T1H2V9
MLS#A1237911
Jaimie Slingerland: 403.330.7955 / Email
Sort By
Jaimie Slingerland
This site's content is the responsibility of Jaimie Slingerland | 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 © 2022 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.