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 (25000984,25024015,25071868,24919996,25082657) ORDER BY b.price DESC, b.mls_id ASC
X
Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
Sort By 
Array
(
    [crea_id] => 25000984
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2008139
    [LASTUPDATED] => 2022-11-08
    [street_address] => 208 Silver Crest Road NW
    [city] => Calgary
    [province] => Alberta
    [postal] => T3B3M4
    [price] => 779000.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1282.7 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638035267416300000/reb9/lowres/9/A2008139_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638035267416300000/reb9/medres/9/A2008139_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638035267416300000/reb9/highres/9/A2008139_1.jpg
)
View
$779,000
1282.7 sqft | 4 | 2.5
208 Silver Crest Road NW
Calgary, Alberta
T3B3M4
MLS#A2008139
David Weber: 403.835.4903 / Email 
Array
(
    [crea_id] => 25024015
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2009537
    [LASTUPDATED] => 2022-11-23
    [street_address] => 27 Buckskin Way
    [city] => Cochrane
    [province] => Alberta
    [postal] => T4C2P1
    [price] => 635000.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 2227 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638048106938730000/reb9/lowres/7/A2009537_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638048106938730000/reb9/medres/7/A2009537_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638048106938730000/reb9/highres/7/A2009537_1.jpg
)
View
$635,000
2227 sqft | 4 | 3.5
27 Buckskin Way
Cochrane, Alberta
T4C2P1
MLS#A2009537
David Weber: 403.835.4903 / Email
Grahame Green: 403.606.3212 / Email 
Array
(
    [crea_id] => 25071868
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2012022
    [LASTUPDATED] => 2022-11-24
    [street_address] => 647, 101 Sunset Drive
    [city] => Cochrane
    [province] => Alberta
    [postal] => T4C0W8
    [price] => 415000.00
    [bedroom_total] => 3
    [bathroom_total] => 4
    [half_bath_total] => 2
    [size_interior] => 1352 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638048850912470000/reb9/lowres/2/A2012022_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638048850912470000/reb9/medres/2/A2012022_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638048850912470000/reb9/highres/2/A2012022_1.jpg
)
View
$415,000
1352 sqft | 3 | 3
647, 101 Sunset Drive
Cochrane, Alberta
T4C0W8
MLS#A2012022
David Weber: 403.835.4903 / Email
Grahame Green: 403.606.3212 / Email 
Array
(
    [crea_id] => 24919996
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2003537
    [LASTUPDATED] => 2022-10-05
    [street_address] => 503, 501 River Heights Drive
    [city] => Cochrane
    [province] => Alberta
    [postal] => T4C2L3
    [price] => 410000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1495 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638005747320300000/reb9/lowres/7/A2003537_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638005747320300000/reb9/medres/7/A2003537_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638005747320300000/reb9/highres/7/A2003537_1.jpg
)
View
$410,000
1495 sqft | 3 | 2.5
503, 501 River Heights Drive
Cochrane, Alberta
T4C2L3
MLS#A2003537
David Weber: 403.835.4903 / Email
Grahame Green: 403.606.3212 / Email 
Array
(
    [crea_id] => 25082657
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2012589
    [LASTUPDATED] => 2022-11-26
    [street_address] => 87, 5425 Pensacola Crescent SE
    [city] => Calgary
    [province] => Alberta
    [postal] => T2A2G7
    [price] => 220000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 1053.6 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638050632236330000/reb9/lowres/9/A2012589_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638050632236330000/reb9/medres/9/A2012589_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638050632236330000/reb9/highres/9/A2012589_1.jpg
)
View
$220,000
1053.6 sqft | 3 | 1.5
87, 5425 Pensacola Crescent SE
Calgary, Alberta
T2A2G7
MLS#A2012589
David Weber: 403.835.4903 / Email
Sort By
David Weber
This site's content is the responsibility of David Weber | 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 © 2022 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.