Completely reimagined waterfront residence on the Trent River 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. Originally built in 1973 with an effective year of 2010, the home was extensively renovated and elevated approximately 14 feet following 2018 flooding, with completion in 2025. Improvements include new roof, HVAC, 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 primary suites, providing flexibility for guests or multigenerational living. For boating enthusiasts, enjoy a private concrete boat ramp, approximately 4-5 feet depth in the creek, and approximately 40 feet 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.