This home boast one of the longest waterfront shorelines in River Bend and offers living at its finest! Don't worry about the cost of the roof because the sellers have installed new shingles this year on the main house, boat lift and carport for a fortified roof rating! This beautifully maintained two-story brick home with a walk-out basement sits on approximately 0.78 acres along the scenic Trent River and has no history of flooding. Offering 4 bedrooms, 3 full baths, and 2 half baths, this exceptional property combines timeless charm with modern updates and outstanding outdoor amenities including a new deep well for cost free water access. The updated kitchen is a chef's dream, featuring stunning quartzite countertops, a natural gas cooktop, double wall ovens, a pantry, and a spacious eat-in area. A convenient mudroom provides abundant cabinetry and storage, while the formal dining room showcases elegant wainscoting and a built-in china cabinet. The home offers multiple inviting gathering spaces, including a living room with extensive built-ins and a cozy family room with a wood-burning fireplace that opens to a spacious deck overlooking the beautifully landscaped backyard and breathtaking river views. The primary suite is a private retreat with dual closets, dual vanities, and an oversized tiled walk-in shower. Upstairs, three guest bedrooms share a well-appointed full bath with double vanities and a tiled tub/shower combination. The flex room that is currently being used as a in-laws quarter on the first floor includes a closet and full bath with a step-in shower, providing excellent space for guests, a home office, or recreation. The walk-out basement is designed for entertaining and functionality, featuring a large patio, half bath, dedicated workshop area, and a pool table that conveys with the home. Additional highlights include plantation shutters throughout much of the home, new exterior doors, a whole-house generator, and a washer and gas dryer that convey. Outdoor enthusiasts will appreciate the covered 10,000-pound boat lift, private dock, detached carport, and versatile detached flex building complete with a porch overlooking the Trent River. Conveniently located just around the corner from River Bend Country Club, this remarkable waterfront property offers the perfect blend of comfort, recreation, and stunning natural beauty.