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
Search
X
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
)
$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
)
$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
)
$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
)
$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
)
$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