Real Estate Services

1104 - 530 12 Avenue SW, Calgary Listing #: C4206548

2 Beds
2 Baths
1,097 Sqft
2008 Built
$711.00 mnt. fees

Northeast Corner Suite with Picturesque Downtown Views at Castello! Showcasing a modern aesthetic with clean lines and open space, this two bedroom and two bathroom residence makes living the urban life a delight. The kitchen features beautiful flat panel cabinetry, quartz countertops, stainless steel appliances, a huge kitchen island with breakfast bar. Floor-to-ceiling windows run the perimeter of the living and dining rooms, revealing city views, and bathing the space in light throughout the day. Also note engineered hardwood flooring, two titled parking stalls, one title storage locker, air conditioning, 9-ft ceilings, and a near 300 sq ft balcony. Castello also offers top tier amenities including a fitness centre, guest suite, car wash, and social room. All this, and only steps from downtown and Mission with its many great restaurants, cafes, boutiques and entertainment. Book an appointment to view!
  • Air Conditioning-Central
  • Balconies
  • Elevator Passenger
  • Exercise Room
  • Guest Suite
  • Handicap Access
  • Party Room
  • Secured Parking
  • Security Door
  • Storage-Locker Room
  • Balcony
  • Ceiling 9 ft.
  • Handicap Access
  • No Smoking Home
  • Sprinkler System-Fire
Site Influences
  • Back Lane
  • Flat Site
  • Low Maintenance Landscape
  • Paved Lane
  • Shopping Nearby
  • 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:26:43' and '2018-10-22 11:26:43', 1, 0) as datematch, IF (inserted between '2018-10-19 11:26:43' and '2018-10-20 23:26:43', 1, 0) as datematch2, IF (inserted < '2018-10-19 11:26:43', DATEDIFF(inserted, '2018-10-22 11:26:43'), 0) as datematch3, IF (listprice_2 between 525000 and 675000, 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 ('C4204159','C4213823','C4181956','C4191007','C4186053','C4209028','C4197703','C4206049','C4205633','C4178712','C4206548') order by datematch desc, datematch2 desc, datematch3 desc, pricematch desc, bedsmatch desc limit 3