Real Estate Services

29 Sunvista Crescent SE, Calgary Listing #: C4209857

4 Beds
4 Baths
2,094 Sqft
5,016 Lot SqFt
1992 Built

Open House: Sunday 28th October: 2:00-4:00pm
Great opportunity to own a fully developed 3132 square foot, 2 Storey family home in the established lake community of Sundance. Main floor features a sunny living room/dining room, bright kitchen with ample cupboard space, great room with gas fireplace, laundry, mud room & 2 piece bath. Upstairs boasts a large master bedroom with walk in closet and ensuite, 3 additional good sized bedrooms and 4 piece bath. Lower level is fully finished with 5th bedroom (flex room), rec room area, 4 piece bath and loads of storage! Double attached garage. Fully fenced and landscaped west facing backyard, perfect for entertaining. Close to schools, shopping and transit. Enjoy lake community living with year round activities including skating, swimming and more! Fabulous family home!
Features: Deck

Site Influences
  • Back Lane
  • Fenced
  • 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 = '1' ' at line 8SELECT listingid, inserted, listprice_2, bedrooms, IF (inserted between '2018-10-20 23:28:53' and '2018-10-22 11:28:53', 1, 0) as datematch, IF (inserted between '2018-10-19 11:28:53' and '2018-10-20 23:28:53', 1, 0) as datematch2, IF (inserted < '2018-10-19 11:28:53', DATEDIFF(inserted, '2018-10-22 11:28:53'), 0) as datematch3, IF (listprice_2 between 399900 and 549900, 1, 0) as pricematch, IF (bedrooms >= 4, 1, 0) as bedsmatch FROM boards.listings WHERE `table` in () AND city = 'Calgary' AND class = '1' AND `status` = 'Active' AND reciprocity = 'Yes' AND listingid not in ('C4206832','C4210005','C4203396','C4202727','C4208780','C4193971','C4210973','C4205005','C4205860','C4196701','C4209857') order by datematch desc, datematch2 desc, datematch3 desc, pricematch desc, bedsmatch desc limit 3