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 (24970469,25095809,25012554,24944843,24893492,25008197) ORDER BY b.price DESC, b.mls_id ASC

My MLS® System Listings

Search
X
Sort By
Array
(
    [crea_id] => 24970469
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2006388
    [LASTUPDATED] => 2022-10-15
    [street_address] => 2 Richelieu Court SW
    [city] => Calgary
    [province] => Alberta
    [postal] => T3E7E9
    [price] => 599900.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/TS638013913103470000/reb9/lowres/8/A2006388_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638013913103470000/reb9/medres/8/A2006388_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638013913103470000/reb9/highres/8/A2006388_1.jpg
)
$599,900
1594.47 sqft | 2 | 3
2 Richelieu Court SW
Calgary, Alberta
T3E7E9
MLS#A2006388
John Reinbolt: 403.999.1279 / Email
John Reinbolt: 403.999.5959 / Email
Array
(
    [crea_id] => 25095809
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2012833
    [LASTUPDATED] => 2022-11-25
    [street_address] => 237 Scotia Point NW
    [city] => Calgary
    [province] => Alberta
    [postal] => T3L2B1
    [price] => 549900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1608.72 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638049654543270000/reb9/lowres/3/A2012833_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638049654543270000/reb9/medres/3/A2012833_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638049654543270000/reb9/highres/3/A2012833_1.jpg
)
$549,900
1608.72 sqft | 3 | 2.5
237 Scotia Point NW
Calgary, Alberta
T3L2B1
MLS#A2012833
John Reinbolt: 403.999.1279 / Email
John Reinbolt: 403.999.5959 / Email
Array
(
    [crea_id] => 25012554
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2008902
    [LASTUPDATED] => 2022-11-19
    [street_address] => 10 Evansmeade Close NW
    [city] => Calgary
    [province] => Alberta
    [postal] => T3P1C2
    [price] => 475000.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1212.29 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638044614788000000/reb9/lowres/2/A2008902_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638044614788000000/reb9/medres/2/A2008902_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638044614788000000/reb9/highres/2/A2008902_1.jpg
)
$475,000
1212.29 sqft | 4 | 2.5
10 Evansmeade Close NW
Calgary, Alberta
T3P1C2
MLS#A2008902
John Reinbolt: 403.999.1279 / Email
John Reinbolt: 403.999.5959 / Email
Array
(
    [crea_id] => 24944843
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2004797
    [LASTUPDATED] => 2022-10-06
    [street_address] => 303, 1027 1 Avenue NW
    [city] => Calgary
    [province] => Alberta
    [postal] => T2N0A8
    [price] => 275000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 788.77 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638006097118370000/reb9/lowres/7/A2004797_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638006097118370000/reb9/medres/7/A2004797_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638006097118370000/reb9/highres/7/A2004797_1.jpg
)
$275,000
788.77 sqft | 2 | 1
303, 1027 1 Avenue NW
Calgary, Alberta
T2N0A8
MLS#A2004797
John Reinbolt: 403.999.1279 / Email
John Reinbolt: 403.999.5959 / Email
Array
(
    [crea_id] => 24893492
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2002387
    [LASTUPDATED] => 2022-09-21
    [street_address] => 301, 128 15 Avenue SW
    [city] => Calgary
    [province] => Alberta
    [postal] => T2R0P5
    [price] => 235000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 776.67 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637993454832530000/reb9/lowres/7/A2002387_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637993454832530000/reb9/medres/7/A2002387_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637993454832530000/reb9/highres/7/A2002387_1.jpg
)
$235,000
776.67 sqft | 2 | 1
301, 128 15 Avenue SW
Calgary, Alberta
T2R0P5
MLS#A2002387
John Reinbolt: 403.999.1279 / Email
John Reinbolt: 403.999.5959 / Email
Array
(
    [crea_id] => 25008197
    [office_name] => 2% REALTY
    [office_id] => 242110
    [mls_id] => A2008661
    [LASTUPDATED] => 2022-11-19
    [street_address] => 203, 5204 Dalton Drive NW
    [city] => Calgary
    [province] => Alberta
    [postal] => T3A3H1
    [price] => 162900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 614 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638044458399030000/reb9/lowres/1/A2008661_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638044458399030000/reb9/medres/1/A2008661_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638044458399030000/reb9/highres/1/A2008661_1.jpg
)
$162,900
614 sqft | 1 | 1
203, 5204 Dalton Drive NW
Calgary, Alberta
T3A3H1
MLS#A2008661
John Reinbolt: 403.999.1279 / Email
John Reinbolt: 403.999.5959 / Email
Sort By