Welcome to this charming two-storey home nestled on a private treed lot in the heart of Shediac, featuring a large, fully operational heated in-ground swimming pool and beautiful water views from the second floor. Just a short walk to the Shediac Marina and downtown, and only minutes from Pointe-du-Chêne Wharf and Parlee Beach, this property is ideal as a year-round home, family cottage, or a turnkey Airbnb/VRBO investment. The upper level offers an open-concept kitchen, dining, and living area with water views, a spacious bedroom, and a renovated 3-piece bathroom. The main level features two additional bedrooms, a family room, gym area, 2-piece bathroom, and utility/storage room. Recent updates include a newly finished front deck, new lower-level flooring, new shed shingles, and an upgraded 200-amp electrical panel. Currently registered as Mixed Use, the property is operating as a successful Airbnb and is also listed on VRBO. The pool pump, heating system, and welded diving board are all in excellent working condition. Enjoy the fully fenced backyard complete with a pool house/storage shed and spacious patios, perfect for entertaining. Don't miss this rare opportunity to own a beautiful water-view property in one of Shediac's most desirable locations.