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 (25061443,24998226,25110959,25107290,24884452,24711814,25039864) ORDER BY b.price DESC, b.mls_id ASC

MLS® System Listings

Search
X
Sort By
Array
(
    [crea_id] => 25061443
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2011255
    [LASTUPDATED] => 2022-12-06
    [street_address] => 28 Auburn Meadows Green SE
    [city] => Calgary
    [province] => Alberta
    [postal] => T3M2H9
    [price] => 575900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1606.4 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638059362793170000/reb9/lowres/5/A2011255_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638059362793170000/reb9/medres/5/A2011255_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638059362793170000/reb9/highres/5/A2011255_1.jpg
)
$575,900
1606.4 sqft | 3 | 2.5
28 Auburn Meadows Green SE
Calgary, Alberta
T3M2H9
MLS#A2011255
Jenny Mayhew: 403.992.8811 / Email
Ashley Pepper: 403.700.1992 / Email
Array
(
    [crea_id] => 24998226
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2007170
    [LASTUPDATED] => 2022-12-05
    [street_address] => 1108, 920 5 Avenue SW
    [city] => Calgary
    [province] => Alberta
    [postal] => T2P5P6
    [price] => 475000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 951 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638058385251500000/reb9/lowres/0/A2007170_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638058385251500000/reb9/medres/0/A2007170_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638058385251500000/reb9/highres/0/A2007170_1.jpg
)
$475,000
951 sqft | 2 | 2
1108, 920 5 Avenue SW
Calgary, Alberta
T2P5P6
MLS#A2007170
Jenny Mayhew: 403.992.8811 / Email
Array
(
    [crea_id] => 25110959
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2014117
    [LASTUPDATED] => 2022-12-02
    [street_address] => 3732 26A Street SE
    [city] => Calgary
    [province] => Alberta
    [postal] => T2B2H8
    [price] => 475000.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1121.5 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638055912941030000/reb9/lowres/7/A2014117_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638055912941030000/reb9/medres/7/A2014117_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638055912941030000/reb9/highres/7/A2014117_1.jpg
)
$475,000
1121.5 sqft | 4 | 2.5
3732 26A Street SE
Calgary, Alberta
T2B2H8
MLS#A2014117
Jenny Mayhew: 403.992.8811 / Email
Ashley Pepper: 403.700.1992 / Email
Array
(
    [crea_id] => 25107290
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2013778
    [LASTUPDATED] => 2022-12-01
    [street_address] => 895 Cranston Avenue SE
    [city] => Calgary
    [province] => Alberta
    [postal] => T3M2V5
    [price] => 429900.00
    [bedroom_total] => 2
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1337 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638054941237170000/reb9/lowres/8/A2013778_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638054941237170000/reb9/medres/8/A2013778_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638054941237170000/reb9/highres/8/A2013778_1.jpg
)
$429,900
1337 sqft | 2 | 2.5
895 Cranston Avenue SE
Calgary, Alberta
T3M2V5
MLS#A2013778
Jenny Mayhew: 403.992.8811 / Email
Array
(
    [crea_id] => 24884452
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A1258320
    [LASTUPDATED] => 2022-09-19
    [street_address] => 1217, 604 East Lake Boulevard NE
    [city] => Airdrie
    [province] => Alberta
    [postal] => T4A0G5
    [price] => 235000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 978 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637991280315000000/reb9/lowres/0/A1258320_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637991280315000000/reb9/medres/0/A1258320_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637991280315000000/reb9/highres/0/A1258320_1.jpg
)
$235,000
978 sqft | 2 | 2
1217, 604 East Lake Boulevard NE
Airdrie, Alberta
T4A0G5
MLS#A1258320
Jenny Mayhew: 403.992.8811 / Email
Ben Escott: 403.452.4701 / Email
Array
(
    [crea_id] => 24711814
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A1243325
    [LASTUPDATED] => 2022-10-26
    [street_address] => 303, 1053 10 Street SW
    [city] => Calgary
    [province] => Alberta
    [postal] => T2R1S6
    [price] => 196900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 485.7 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638023404716070000/reb9/lowres/5/A1243325_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638023404716070000/reb9/medres/5/A1243325_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638023404716070000/reb9/highres/5/A1243325_1.jpg
)
$196,900
485.7 sqft | 1 | 1
303, 1053 10 Street SW
Calgary, Alberta
T2R1S6
MLS#A1243325
Jenny Mayhew: 403.992.8811 / Email
Array
(
    [crea_id] => 25039864
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2006443
    [LASTUPDATED] => 2022-11-28
    [street_address] => 5208, 27 Grier Place NE
    [city] => Calgary
    [province] => Alberta
    [postal] => T3K5Y5
    [price] => 179900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 825.2 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638052373069970000/reb9/lowres/3/A2006443_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638052373069970000/reb9/medres/3/A2006443_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638052373069970000/reb9/highres/3/A2006443_1.jpg
)
$179,900
825.2 sqft | 2 | 2
5208, 27 Grier Place NE
Calgary, Alberta
T3K5Y5
MLS#A2006443
Jenny Mayhew: 403.992.8811 / Email
Ashley Pepper: 403.700.1992 / Email
Sort By