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 (25165662) ORDER BY b.price DESC, b.mls_id ASC

My MLS® System Listings

Array
(
    [crea_id] => 25165662
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2017404
    [LASTUPDATED] => 2023-01-06
    [street_address] => 2 Richelieu Court SW
    [city] => Calgary
    [province] => Alberta
    [postal] => T3E7E9
    [price] => 589000.00
    [bedroom_total] => 2
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1594.47 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638086063552700000/reb9/lowres/4/A2017404_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638086063552700000/reb9/medres/4/A2017404_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638086063552700000/reb9/highres/4/A2017404_1.jpg
)
$589,000
1594.47 sqft | 2 | 3
2 Richelieu Court SW
Calgary, Alberta
T3E7E9
MLS#A2017404
John Reinbolt: 403.999.1279 / Email
John Reinbolt: 403.999.5959 / Email