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

My Listings

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] => 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] => 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] => 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] => 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
Sort By