Real Estate Services

902 - 924 14 Avenue SW, Calgary Listing #: C4208433

$190,000
2 Beds
1 Bath
843 Sqft
1981 Built
$522.00 mnt. fees


Get into the Beltline for under $200,000! Great location with city views, walk to downtown or trendy 17th Ave. This 2 bedroom unit is South facing, comes with a titled, underground stall and the building comes equipped with an exercise room, party room with pool table, library and squash court.
Features: Balcony

Amenities
  • Balconies
  • Elevator Passenger
  • Exercise Room
  • Party Room
Site Influences
  • Playground Nearby
  • Public Transportation
  • Schools
  • Shopping Nearby

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND city = 'Calgary' AND class = '2' ' at line 8SELECT listingid, inserted, listprice_2, bedrooms, IF (inserted between '2018-10-20 23:20:21' and '2018-10-22 11:20:21', 1, 0) as datematch, IF (inserted between '2018-10-19 11:20:21' and '2018-10-20 23:20:21', 1, 0) as datematch2, IF (inserted < '2018-10-19 11:20:21', DATEDIFF(inserted, '2018-10-22 11:20:21'), 0) as datematch3, IF (listprice_2 between 90000 and 240000, 1, 0) as pricematch, IF (bedrooms >= 2, 1, 0) as bedsmatch FROM boards.listings WHERE `table` in () AND city = 'Calgary' AND class = '2' AND `status` = 'Active' AND reciprocity = 'Yes' AND listingid not in ('C4201971','C4205368','C4199140','C4191698','C4177838','C4201929','C4201039','C4161887','C4197273','C4204664','C4208433') order by datematch desc, datematch2 desc, datematch3 desc, pricematch desc, bedsmatch desc limit 3