MLSM126585 - WATERFRONT PROPERTY at its finest!! This breathtaking executive style home overlooking the Shediac Bay and Marina is just stunning! The main floor offers an open concept space with windows lining from one end of the home to the other end allowing the most natural light as possible into the home. Just a spectacular design for relaxation and entertaining. Kitchen was built for a chef with its Heartland gas cook top, self-cleaning double ovens, Kitchen Aid warming tray, Granite countertops, a wine fridge & even a second sink. Now on to the great room with heated floors and a two stone-adorned propane fireplace with a cathedral ceiling. Formal dining room with a propane fireplace overlooking the Shediac bay where you can see the BOARDWALK TO WATERFRONT. As we ascend to the second floor, we have a very large master sweet that offers a walk-in closet, a propane fireplace and a private balcony overlooking the bay. Private access to the main 5pv bath from the Master bedroom which includes very spacious two-seater Jacuzzi Tub. An additional bedroom completes the second floor. Lower level features a living room showing casing a wood stove & plenty of additional space for a games room or gym. A hug storage room, 4pc bath, possible wine seller and additional storage areas complete the lower level. Attached is a 21 x 24 double car garage, dual-level deck in the backyard with a HOT TUB, Heat pump in the home to regulate the temperature through all seasons & located on a quiet cul de sac.