Welcome to one of New Brunswicks most compelling real estate opportunities - a fully loaded, resort-style waterfront estate in the heart of Cambridge Narrows. With a luxurious main residence, five stylish income-ready cottages, and a pool house loft suite, this rare offering blends upscale living with serious rental potential. The executive home, completed in 2019, offers over 2,400 sqft of bright, open living space featuring a chefs kitchen, oversized pantry, and a main floor primary suite with a spa-inspired ensuite and walk-in dressing area. Each of the five cottages (built in 2020) are turnkey, comfortably sleeping up to six guests and designed for privacy and relaxation. The pool house, completed in 2022, adds extra flexibility with a loft-style suite, king bed, kitchenette, and living area. Outdoors, the estate is pure paradise: sandy beach in a protected cove, removable dock, heated in-ground pool, hot tubs, pickleball court, playground, gazebo, and firepit. Perfect for swimming, boating, fishing, and unforgettable gatherings. Sale includes all cottage furnishings, appliances, dock, kayaks, hot tubs, and more. This is a property asset sale (not a business sale) and is not expected to fall under the Foreign Buyer Ban (buyer to confirm). A rare opportunity to own a multi-use estate in one of NBs most desirable locations! (id:39198)