This one-of-a-kind property offers rare combination of architectural excellence, waterfront beauty, and equestrian functionality, complete with an indoor riding arena, 3-stall stable, and exceptional amenities throughout. Inside, main floor welcomes you with open and impressive layout designed to showcase the view. The chefs kitchen features fantastic finishes and flows seamlessly into stunning great room, where soaring ceilings, exposed beams, and floor-to-ceiling windows frame sweeping water views. Custom Italian staircase leads to beautiful lofted retreat, adding dramatic architectural focal point to the home. Primary suite feels like private spa, offering soaker tub, walk-in shower, and direct access to electric-screened sunroom and maintenance-free deck. In-floor radiant heat adds comfort and warmth throughout the seasons. Walkout lower level expands living space with two guest bedrooms, family room, 3-piece bath, and outstanding lifestyle features including home theatre with fireplace, gym, and 6-person sauna. Outdoors, enjoy screened lanai surrounded by lush landscaping, where gentle brook winds beneath handcrafted stone bridges, creating a setting that feels peaceful, private, and truly unforgettable. Completing this extraordinary estate is 3-bay garage with 50KW automatic generator, plus beautifully finished stable with hay and tack rooms and a cozy lounge. The stable connects by breezeway to the bright indoor riding arena, featuring insulated walls and automated windows. A true New Brunswick masterpiece crafted for those who value privacy, quality, nature, and a lifestyle that simply cannot be duplicated. (id:60457) Location - Route 695 to Route 715 (Lower Cambridge Road)