Real Estate Services

119 Suncrest Way SE, Calgary Listing #: C4210776

$724,900
4 Beds
3 Baths
1,962 Sqft
6,189 Lot SqFt
1986 Built


SPACIOUS BUNGALOW w/over 3636 sq ft of DEVELOPED LIVING SPACE, 200M WALK to the LAKE on a LARGE CORNER LOT!!! MATURE TREES + Shrubs, O-SIZED DOUBLE GARAGE, + MORE!!! WELCOMING Entrance leads to the OPEN CONCEPT main flr w/VAULTED ceilings, Living rm w/LARGE windows + BEAUTIFUL H/W Floors, BRIGHT Dining rm, LOVELY Family rm feat corner FP w/STONE mantle, Kitchen w/GRANITE Countertops, MODERN Subway Tile b/s, ISLAND, CORNER Pantry, Windows over sink, MATCHING SS appl, (incl wall oven + microwave!), + DECK access, 3 Bdrm's incl LARGE Master w/W.I.C + 5 pc EN-SUITE (incl SOAKER TUB), 4 pc Main Bath w/GRANITE counter, + CONVENIENT Laundry/Mud rm. Bsmt feat WET BAR, BRICK feature walls, Family rm w/wall B/I, Flex rm w/access to STORAGE, HUGE office, add'l 4 pc Bath, Exercise/4th Bdrm COMBO, + DUAL Furnaces + DUAL H2O tanks. B-yard w/EXTENSIVE Deck incl BBQ Gas line hookup, TONS of TREES, LANDSCAPING, Veggie gardens + STORAGE Shed. SO CLOSE to SCHOOLS (K-12!), SHAWNESSY, RIGHT off MACLEOD + MOMENTS to STONEY TR.
Amenities
  • Beach Access
  • Cable
  • Club House
  • Fireplaces
  • Internet
  • Lake Privileges
  • Laundry Facility
  • Parking-Extra
  • Party Room
  • Playground
  • Private Fishing
  • Private Park Access
  • Racquet Courts
  • Recreation Room/Centre
  • Satelite Dish
  • Secured Parking
  • Storage-In-Suite
Features
  • Bar
  • Deck
  • Hot Water Tank - Energy Star
  • No Animal Home
  • No Smoking Home
  • Porch
  • Programmable Thermostat
  • Security Window Bars
  • Vacuum System-Roughed-In
  • Vaulted Ceiling
  • Wall Unit-Built-In
  • Vinyl Windows
Site Influences
  • Back Lane
  • Beach Access
  • Boating
  • Corner
  • Estate Property
  • Fenced
  • Flat Site
  • Fruit Trees/Shrubs
  • Golf Nearby
  • Lake Access Property
  • Landscaped
  • Level Land
  • Low Maintenance Landscape
  • Playground Nearby
  • Private Fishing
  • Public Transportation
  • Schools
  • Shopp

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:21:22' and '2018-10-22 11:21:22', 1, 0) as datematch, IF (inserted between '2018-10-19 11:21:22' and '2018-10-20 23:21:22', 1, 0) as datematch2, IF (inserted < '2018-10-19 11:21:22', DATEDIFF(inserted, '2018-10-22 11:21:22'), 0) as datematch3, IF (listprice_2 between 624900 and 774900, 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 ('C4208721','C4198136','C4203471','C4208087','C4210046','C4191171','C4206077','C4197794','C4208043','C4210573','C4210776') order by datematch desc, datematch2 desc, datematch3 desc, pricematch desc, bedsmatch desc limit 3