Real Estate Services

1601 - 211 13 Avenue SE, Calgary Listing #: C4205583

$279,900
1 Bed
1 Bath
600 Sqft
2010 Built
$328.00 mnt. fees


Immaculate, one bedroom condo has several upgrades including full height kitchen cabinets, granite counters, select tile throughout , excluding the carpeted bedroom. This unit includes one heated underground parking stall. South facing, large floor to ceiling windows with exceptional views of the city. Nuera Tower is centrally located in downtown Calgary, within walking distance to all amenities including C-Train. Building has on site Security, electronic key entry, and the building is restricted 18 plus. Nuera has a well equipped exercise facility located on the second floor, with access to the common courtyard area. The Tower offers the following amenities: Central Air Conditioning * Balcony * 9 Foot Ceilings * In Suite Laundry * Storage Locker * Boardroom * Condo Fees cover Air/Heat/Water/Sewer.
Amenities: Exercise Room

Features
  • Balcony
  • No Animal Home
  • No Smoking Home
Site Influences
  • Playground Nearby
  • Schools
  • Shopping Nearby
  • View
  • View City
  • View Downtown

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:17:26' and '2018-10-22 11:17:26', 1, 0) as datematch, IF (inserted between '2018-10-19 11:17:26' and '2018-10-20 23:17:26', 1, 0) as datematch2, IF (inserted < '2018-10-19 11:17:26', DATEDIFF(inserted, '2018-10-22 11:17:26'), 0) as datematch3, IF (listprice_2 between 179900 and 329900, 1, 0) as pricematch, IF (bedrooms >= 1, 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 ('C4201500','C4209957','C4191588','C4208194','C4203041','C4166184','C4202820','C4202790','C4211452','C4209529','C4205583') order by datematch desc, datematch2 desc, datematch3 desc, pricematch desc, bedsmatch desc limit 3