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 (25199024,25110959,25204811,25245116,25226716,25188699,25039864) ORDER BY b.price DESC, b.mls_id ASC

MLS® System Listings

Search
X
Sort By
Array
(
    [crea_id] => 25199024
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2019518
    [LASTUPDATED] => 2023-01-19
    [street_address] => 803, 788 12 Avenue SW
    [city] => Calgary
    [province] => Alberta
    [postal] => T2R0H1
    [price] => 479900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1076 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638097283054670000/reb9/lowres/8/A2019518_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638097283054670000/reb9/medres/8/A2019518_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638097283054670000/reb9/highres/8/A2019518_1.jpg
)
$479,900
1076 sqft | 2 | 2
803, 788 12 Avenue SW
Calgary, Alberta
T2R0H1
MLS#A2019518
Jenny Mayhew: 403.992.8811 / Email
Array
(
    [crea_id] => 25110959
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2014117
    [LASTUPDATED] => 2023-02-06
    [street_address] => 3732 26A Street SE
    [city] => Calgary
    [province] => Alberta
    [postal] => T2B2H8
    [price] => 460000.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/TS638112204437570000/reb9/lowres/7/A2014117_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638112204437570000/reb9/medres/7/A2014117_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638112204437570000/reb9/highres/7/A2014117_1.jpg
)
$460,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] => 25204811
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2020246
    [LASTUPDATED] => 2023-01-25
    [street_address] => 223 Northmount Drive NW
    [city] => Calgary
    [province] => Alberta
    [postal] => T2K3G6
    [price] => 450000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 950 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638102496594700000/reb9/lowres/6/A2020246_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638102496594700000/reb9/medres/6/A2020246_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638102496594700000/reb9/highres/6/A2020246_1.jpg
)
$450,000
950 sqft | 3 | 1.5
223 Northmount Drive NW
Calgary, Alberta
T2K3G6
MLS#A2020246
Jenny Mayhew: 403.992.8811 / Email
Array
(
    [crea_id] => 25245116
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2022735
    [LASTUPDATED] => 2023-02-06
    [street_address] => 15 Kinlea Way NW
    [city] => Calgary
    [province] => Alberta
    [postal] => T3R0S2
    [price] => 415000.00
    [bedroom_total] => 2
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1242.5 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638113014882800000/reb9/lowres/5/A2022735_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638113014882800000/reb9/medres/5/A2022735_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638113014882800000/reb9/highres/5/A2022735_1.jpg
)
$415,000
1242.5 sqft | 2 | 2.5
15 Kinlea Way NW
Calgary, Alberta
T3R0S2
MLS#A2022735
Jenny Mayhew: 403.992.8811 / Email
Array
(
    [crea_id] => 25226716
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2021263
    [LASTUPDATED] => 2023-01-28
    [street_address] => 246, 165 Manora Place NE
    [city] => Calgary
    [province] => Alberta
    [postal] => T2A7X5
    [price] => 219900.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 941.9 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638104641432400000/reb9/lowres/3/A2021263_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638104641432400000/reb9/medres/3/A2021263_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638104641432400000/reb9/highres/3/A2021263_1.jpg
)
$219,900
941.9 sqft | 2 | 2
246, 165 Manora Place NE
Calgary, Alberta
T2A7X5
MLS#A2021263
Jenny Mayhew: 403.992.8811 / Email
Array
(
    [crea_id] => 25188699
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2018296
    [LASTUPDATED] => 2023-01-14
    [street_address] => 604, 1225 15 Avenue SW
    [city] => Calgary
    [province] => Alberta
    [postal] => T2R0R5
    [price] => 196900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 589 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638093012974900000/reb9/lowres/6/A2018296_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638093012974900000/reb9/medres/6/A2018296_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638093012974900000/reb9/highres/6/A2018296_1.jpg
)
$196,900
589 sqft | 1 | 1
604, 1225 15 Avenue SW
Calgary, Alberta
T2R0R5
MLS#A2018296
Jenny Mayhew: 403.992.8811 / Email
Array
(
    [crea_id] => 25039864
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2006443
    [LASTUPDATED] => 2023-02-06
    [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/TS638112318769600000/reb9/lowres/3/A2006443_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638112318769600000/reb9/medres/3/A2006443_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638112318769600000/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