Discover the ultimate multi-generational property on 5 serene acres with river frontage. This unique estate features two distinct living spaces under one roof, offering flexibility for extended family living, rental opportunities, or running a home-based business. The main wing has been completely remodeled and boasts a ranch-style layout with a luxurious primary suite, a second bedroom with an en suite, and an open-concept kitchen perfect for hosting large gatherings. It also includes a spacious pantry, a theater room/den, and a convenient half bathroom, all finished with modern updates and thoughtful design. The second wing offers a two-story layout with three bedrooms on the main floor, four additional bedrooms upstairs, a large living room, and a bright, airy kitchen surrounded by windows on three sides, providing stunning views of the private yard. A basement adds extra storage or recreational space. Each wing is equipped with its own HVAC system and laundry room for comfort and convenience. This property is ideal for working from home or running a business, with a reception area and waiting space already in place. Two detached garages offer ample storage for vehicles or equipment. With endless possibilities for living and working, this riverside retreat combines space, function, and natural beauty. Fenced play area with equipment, tennis court, decks overlooking the river! Taxes are 100% homestead. Contact me today to schedule a private tour and explore all this property has to offer!