Real Estate Services

29 Sundown Way SE, Calgary Listing #: C4202781

6 Beds
4 Baths
2,143 Sqft
4,435 Lot SqFt
1990 Built

Great MULTI generational property. Bring your measuring tape, sketch pad and creativity and make this home your own. All the expensive items have already been done. Just bring your finishing touches. FRESHLY PAINTED modern colours inside & out. GREAT FLOOR PLAN with 4 bedrooms up & 2 NC bedrooms down. Master suite features FRENCH DOORS & walk-in closet. New SPA LIKE master ensuite features a beautiful STAND ALONE soaker tub, CUSTOM SHOWER with shower panel & HEATED TOWEL RACK. 2 large bedrooms & a gorgeous DOUBLE VANITY bathroom finish the upstairs. All new TRIPLE GLAZED WINDOWS upstairs in 2018. SPACEOUS rec room, 2 large NC bedrooms & another fully UPDATED BATHROOM await downstairs. Newer HIGH EFFICIENCY furnace in 2012 & a Rinnai INSTANT HOT WATER heater gives you plenty of hot water anytime you need. The kids will have plenty of room to play in this LARGE BACKYARD. New maintenance free COMPOSITE DECK out front makes for a great place for coffee in the morning. Call for your private showing today!
  • Lake Privileges
  • See Remarks
  • Deck
  • Tankless Hot Water
  • Vacuum System-Roughed-In
  • Vaulted Ceiling
  • Vinyl Windows
Site Influences
  • Back Lane
  • Fenced
  • Flat Site
  • Landscaped
  • Level Land
  • Playground Nearby
  • 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:29:37' and '2018-10-22 11:29:37', 1, 0) as datematch, IF (inserted between '2018-10-19 11:29:37' and '2018-10-20 23:29:37', 1, 0) as datematch2, IF (inserted < '2018-10-19 11:29:37', DATEDIFF(inserted, '2018-10-22 11:29:37'), 0) as datematch3, IF (listprice_2 between 409900 and 559900, 1, 0) as pricematch, IF (bedrooms >= 6, 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 ('C4211084','C4194878','C4208780','C4206832','C4210005','C4205005','C4206019','C4206735','C4179165','C4197644','C4202781') order by datematch desc, datematch2 desc, datematch3 desc, pricematch desc, bedsmatch desc limit 3