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
X

My MLS® System Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
John Reinbolt
This site's content is the responsibility of John Reinbolt | 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.