Spectacular executive walkout bungalow located only 20 minutes from Downtown Moncton! This stunner features many upgrades often sought but never found. Walking up to the front door you will notice the beautiful stone façade and stucco accents. The front door enters into a foyer which opens into the great room.This room features a floor to ceiling propane fireplace and lots of windows which overlook the backyard.Off the great room is a large eat-in- kitchen that has custom stained cabinets with lots of counter space. One end of this home has access to the double garage, 2PC bathroom, 4PC bathroom, access to a bonus room above the garage and two bedrooms. At the other end is another bedroom and a grand master bedroom that has patio doors which lead to the back deck. There is also a laundry area, walk in closet and spa like ensuite which features a walk-in shower, jet tub and custom tile work. The lower level consists of a bar area, large family room, 12 seat theater room, office and gym/storage room. You can walkout to the backyard from this level. Outside, there is a 25X29 detached garage, In ground pool sounded by stamped concrete and approximately 6.02 acres of land which goes all the way to the river! This is a rare find and will surely impress. Other features include: radiant in floor heat on the main level and built in surround sound.