Welcome to this stunning GATED & PRIVATE, 1,961 sq. ft. waterfront home offering 180 feet of frontage on the Northumberland Strait located DIRECTLY IN SHEDIAC, NB (RARE OPPORTUNITY)!. The main floor features a spacious rear entrance, a large eat-in kitchen with adjoining dining area, a bright living room with propane fireplace, and an impressive 13' x 33' family room with cathedral ceiling and sweeping water views. A five-piece bath serves the level along with two bedrooms, including a primary suite with private three piece ensuite. The lower level offers a generous in-law suite with its own private entrance, a full kitchen, living area, bedroom, three-piece bath, and bright windows in this raised basement. Both units enjoy their own laundry, and the home is heated with geothermal plus two mini-split heat pumps. A detached studio (12' x 24') with open bedroom and three-piece bath adds versatile space for guests or a private office. Additional highlights include an updated kitchen (approx. 9 years ago), a large storage shed (25' x 14'), and stairs leading directly to the shoreline; perfect for enjoying all the beauty of coastal living. Great rental potential.