Completely reimagined waterfront residence on the Trent River (effective year 2015) offering rare privacy, immediate water access, and like-new condition in the desirable River Bend area of New Bern. Situated on 1.62 acres at the end of a quiet cul-de-sac, this exceptional property features approximately 200 feet of Trent River frontage plus an additional 295 feet along a protected cove/creek. Approximately 75% of the home was demolished and rebuilt during an extensive transformation completed in 2025. Following the 2018 flood event, the residence was elevated approximately 14 feet and comprehensively renovated with major improvements including new roof, HVAC systems, wiring, windows, doors, ceilings, added garage, and more. Never occupied since completion. Inside, approximately 4,010 square feet of light-filled living space offers an open floor plan, expansive windows, numerous skylights, and a dramatic oversized stone fireplace. Four bedrooms and three full baths include two spacious primary suites (dual master bedrooms), providing exceptional flexibility for guests, extended family, or multigenerational living. For boating enthusiasts, enjoy a private concrete boat ramp, approximately 4-5 feet of depth in the creek, and approximately 40 feet of depth on the Trent River. A rare opportunity to own a turnkey waterfront property combining privacy, convenience, and exceptional water access just minutes from shopping, medical, golf, airport, and historic downtown New Bern.