Welcome to a rare 9.57-acre waterfront estate in the heart of Asphodel-Norwood, where natural beauty, privacy, and exceptional opportunity come together. Set along the scenic Norwood Mill Pond and enhanced by the tranquil flow of the Ouse River through the property, this picturesque retreat features a beautiful pond, mature landscaping, open green spaces, and breathtaking views in every direction. The property offers a diverse collection of living spaces, including a three-bedroom main residence with a bachelor walkout apartment, three self-contained one-bedroom hotel-style suites, a detached three-car garage with a two-bedroom loft apartment above, and a one-bedroom container home. Together, these accommodations create outstanding income potential while offering flexibility for multi-generational living, guest accommodations, or a future family compound. Adding to the property's appeal, the owner has already severed two parcels of higher-density residential land, approximately 0.63 acres and 0.666 acres, with building permits in place, creating exciting possibilities for future development. Thoughtfully renovated and well maintained, this unique estate is quietly tucked away in a stunning natural setting, yet remains conveniently located near local amenities. Whether you're an investor, entrepreneur, retreat operator, or a family looking to create a lasting legacy property, this is a truly exceptional opportunity to own one of the area's most versatile and picturesque waterfront holdings.