Rare opportunity to own highly sought-after Ohio River frontage in Prospect! Situated on a double-wide lot directly on the water, this unique property offers breathtaking river views, direct river access, an attached garage, inground pool, concrete shoreline wall, and access to a gated private boat ramp at the end of the street. Owned by the same family for generations, the home features 4 bedrooms, 2 full baths, and a flexible layout ideal for multi-generational living, a vacation retreat, or future renovation. The first floor offers a living room with new wood-burning stove, bedroom, full bath, den, and partial kitchen. Upstairs includes 3 bedrooms, full bath, kitchen, living room, and large screened porch overlooking the river. Recent updates include a new HVAC system and two new wood-burning stove, bedroom, full bath, den, and partial kitchen. Upstairs includes 3 bedrooms, full bath, kitchen, living room, and large screened porch overlooking the river. Recent updates include a new HVAC system and two new wood-burning stoves (2025). Three existing docks may be transferable with approval from the U.S. Army Corps of Engineers and are currently in need of repair. Many neighboring properties have been renovated, elevated, or rebuilt into luxury riverfront homes, making this an exceptional opportunity to renovate, invest, or build your dream waterfront residence. Let your imagination lead the way on this one and check out the staged photos seeing the potential this home has with some new life. Sold As-Is.