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
X

MLS® System Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
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
)
View
$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
)
View
$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
)
View
$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
)
View
$196,900
589 sqft | 1 | 1
604, 1225 15 Avenue SW
Calgary, Alberta
T2R0R5
MLS#A2018296
Jenny Mayhew: 403.992.8811 / Email
Sort By
Jenny Mayhew
#300, 5 Richard Way SW
Calgary
T3E 7M8
Tel: 403.992.8811
This site's content is the responsibility of Jenny Mayhew | 2018 Privacy Policy
The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA.
Copyright © 2023 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.