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 (25299826,25199024,25334811,25188699) ORDER BY b.price DESC, b.mls_id ASC

MLS® System Listings

Search
X
Sort By
Array
(
    [crea_id] => 25299826
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2026791
    [LASTUPDATED] => 2023-03-16
    [street_address] => 414 Greenbriar Common NW
    [city] => Calgary
    [province] => Alberta
    [postal] => T3B6J4
    [price] => 478500.00
    [bedroom_total] => 2
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1043.7 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638145882936770000/reb9/lowres/1/A2026791_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638145882936770000/reb9/medres/1/A2026791_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638145882936770000/reb9/highres/1/A2026791_1.jpg
)
$478,500
1043.7 sqft | 2 | 3
414 Greenbriar Common NW
Calgary, Alberta
T3B6J4
MLS#A2026791
Jenny Mayhew: 403.992.8811 / Email
Ashley Pepper: 403.700.1992 / Email
Array
(
    [crea_id] => 25199024
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2019518
    [LASTUPDATED] => 2023-03-02
    [street_address] => 803, 788 12 Avenue SW
    [city] => Calgary
    [province] => Alberta
    [postal] => T2R0H1
    [price] => 468880.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1076 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638132946897370000/reb9/lowres/8/A2019518_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638132946897370000/reb9/medres/8/A2019518_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638132946897370000/reb9/highres/8/A2019518_1.jpg
)
$468,880
1076 sqft | 2 | 2
803, 788 12 Avenue SW
Calgary, Alberta
T2R0H1
MLS#A2019518
Jenny Mayhew: 403.992.8811 / Email
Array
(
    [crea_id] => 25334811
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2029784
    [LASTUPDATED] => 2023-03-15
    [street_address] => 310 Georgian Villas NE
    [city] => Calgary
    [province] => Alberta
    [postal] => T2A7E2
    [price] => 239900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 1063.4 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638144694601630000/reb9/lowres/4/A2029784_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638144694601630000/reb9/medres/4/A2029784_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638144694601630000/reb9/highres/4/A2029784_1.jpg
)
$239,900
1063.4 sqft | 3 | 1.5
310 Georgian Villas NE
Calgary, Alberta
T2A7E2
MLS#A2029784
Jenny Mayhew: 403.992.8811 / Email
Array
(
    [crea_id] => 25188699
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2018296
    [LASTUPDATED] => 2023-02-08
    [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
Sort By