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 (24801345,24884597,24712849,24808942,24561117) ORDER BY b.price DESC, b.mls_id ASC
Search
X
Sort By
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] => 24884597
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A1258355
    [LASTUPDATED] => 2022-09-26
    [street_address] => 504 Canal LANE
    [city] => Lomond
    [province] => Alberta
    [postal] => T0L1G0
    [price] => 460000.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/TS637991428476400000/reb26/lowres/5/A1258355_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637991428476400000/reb26/medres/5/A1258355_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637991428476400000/reb26/highres/5/A1258355_1.jpg
)
$460,000
1295.36 sqft | 4 | 3
504 Canal LANE
Lomond, Alberta
T0L1G0
MLS#A1258355
Glen Lengyel: 403.360.8546 / Email
Array
(
    [crea_id] => 24712849
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A1242429
    [LASTUPDATED] => 2022-09-09
    [street_address] => 110 Cayuga Crescent W
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1K5H5
    [price] => 330000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 886.88 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637982640738600000/reb26/lowres/9/A1242429_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637982640738600000/reb26/medres/9/A1242429_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637982640738600000/reb26/highres/9/A1242429_1.jpg
)
$330,000
886.88 sqft | 4 | 2
110 Cayuga Crescent W
Lethbridge, Alberta
T1K5H5
MLS#A1242429
Glen Lengyel: 403.360.8546 / Email
Array
(
    [crea_id] => 24808942
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A1254461
    [LASTUPDATED] => 2022-09-11
    [street_address] => 228 Armstrong Street
    [city] => Carmangay
    [province] => Alberta
    [postal] => T0L0N0
    [price] => 298000.00
    [bedroom_total] => 5
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 1390 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637984452726130000/reb26/lowres/1/A1254461_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637984452726130000/reb26/medres/1/A1254461_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637984452726130000/reb26/highres/1/A1254461_1.jpg
)
$298,000
1390 sqft | 5 | 3.5
228 Armstrong Street
Carmangay, Alberta
T0L0N0
MLS#A1254461
Glen Lengyel: 403.360.8546 / Email
Brennan Reichard: 403.892.3219 / Email
Array
(
    [crea_id] => 24561117
    [office_name] => 2 PERCENT REALTY
    [office_id] => 284869
    [mls_id] => A1230655
    [LASTUPDATED] => 2022-09-08
    [street_address] => 20, 45 Keystone Terrace W
    [city] => Lethbridge
    [province] => Alberta
    [postal] => T1J5B8
    [price] => 225000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 1181.07 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637982568184000000/reb26/lowres/5/A1230655_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637982568184000000/reb26/medres/5/A1230655_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637982568184000000/reb26/highres/5/A1230655_1.jpg
)
$225,000
1181.07 sqft | 3 | 1.5
20, 45 Keystone Terrace W
Lethbridge, Alberta
T1J5B8
MLS#A1230655
Glen Lengyel: 403.360.8546 / Email
Sort By