Real Estate Services

34 Sun Harbour Way SE, Calgary Listing #: C4198136

$659,000
5 Beds
4 Baths
2,609 Sqft
5,554 Lot SqFt
1989 Built


*** $20,000 REDUCTION!***Over 4100SF of living space in this Gorgeous 2 storey home in popular Sundance. Total 5 Bed and 3 1/2 Baths. Incredible CURB APPEAL with brick driveway, CONCRETE TILE roof and stunning CUSTOM SOLID ASH front door with high end hardware and handmade STAINED GLASS side panels. Welcome your guests into the expansive foyer with CATHEDRAL CEILINGS & marble floor. Bright & spacious Living room and dining room with gas fireplace and custom HARDWOOD Flooring. The fun & functional kitchen has brand new QUARTZ countertops & backsplash, SUB-ZERO Fridge, GAS STOVE with Oven, 2nd built-in Oven and a large bright EAT-IN BREAKFAST NOOK. Sunken family room with stone accent wall, GAS FIREPLACE and double french doors leading to the deck and backyard. Main floor Master Bedroom has large walk in and a 4 pc ensuite with awesome STEAM SHOWER. Main Floor Powder room, laundry and mud room leading to double attached garage completes the Main floor. NEW WINDOWS (2016) & more-ADDITIONAL REMARKS RMS = 2609
Features
  • Air Conditioning-Central
  • Deck
  • Fire Pit
  • No Animal Home
  • No Smoking Home
  • Vaulted Ceiling
  • Vinyl Windows
Site Influences
  • Back Lane
  • Beach Access
  • Fenced
  • Flat Site
  • Fruit Trees/Shrubs
  • Golf Nearby
  • Landscaped
  • Level Land
  • Playground Nearby
  • Public Transportation
  • Schools
  • Shopping Nearby
  • Treed Lot

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:25:09' and '2018-10-22 11:25:09', 1, 0) as datematch, IF (inserted between '2018-10-19 11:25:09' and '2018-10-20 23:25:09', 1, 0) as datematch2, IF (inserted < '2018-10-19 11:25:09', DATEDIFF(inserted, '2018-10-22 11:25:09'), 0) as datematch3, IF (listprice_2 between 559000 and 709000, 1, 0) as pricematch, IF (bedrooms >= 5, 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 ('C4203471','C4206194','C4203199','C4210046','C4205949','C4206077','C4210573','C4208797','C4208751','C4211038','C4198136') order by datematch desc, datematch2 desc, datematch3 desc, pricematch desc, bedsmatch desc limit 3