Waterfront Luxury on the Prestigious Shediac River. A remarkable expression of craftsmanship, design, and waterfront living, this custom-built residence sits on 2.89 acres along the Shediac River. Finished in Malbec siding and surrounded by natural beauty, this exceptional property offers a level of quality and attention to detail rarely found. Upon arrival, a grand 9-foot-high by 6-foot-wide mahogany entrance door sets the tone for the elegance that unfolds throughout the home. The spectacular chef's kitchen showcases custom Wildwood cabinetry complemented by quartz countertops, a waterfall island, premium Kindred sinks and a fully equipped walk-in pantry. Professional-grade appliances includes dual 36-inch built-in KitchenAid refrigerator and freezer units, an AGA Pro 36-inch gas range, a built-in wall oven and an AGA stainless-steel dishwasher. Designed to maximize both natural light and breathtaking river views, the open-concept main living area is highlighted by soaring ceilings, stainless steel tube railings, and a high-efficiency Opel wood-burning fireplace. The sunroom serves as a true showpiece featuring a custom wood-burning fireplace clad in imported Italian slate and panoramic views of the river. The main level also offers a luxurious primary suite complete with a spa-inspired ensuite and walk-in closet, an additional bedroom, a full bathroom, and a loft overlooking the living space below. The fully finished walk-out lower level features in-floor heating, 9-foot ceilings, fully equipped kitchen for an in-law suite. Additional spaces include a private office, a third bedroom, fitness room or office space, third full bathroom, wine cellar, and abundant storage. Completing the property are both an attached 25' x 23' garage and a detached 18' x 22' garage. A rare opportunity to own an extraordinary waterfront estate where timeless elegance, premium finishes, and unparalleled views come together in perfect harmony.