Wake up to Ohio River views with direct River access in this one of a kind retreat w/ ATTACHED 4 OVERSIZED CAR GARAGE + DETACHED 2 CAR GARAGE, built for your autos, toys & lifestyle. Bright, open flr plan w/ soaring ceilings, abundant natural light & cozy wood burning FP creates the perfect space to relax or entertain. Kitchen flows seamlessly into dining & living areas w/ custom ample cabinetry & counter space. Main lvl offers spacious BRs incl primary suite w/ private ensuite tile shower. LL delivers serious flexibility w/ massive garage/storage space ideal for luxury vehicles, boats, dirt bikes, side by sides & more, plus additional lower level full bath w/ shower that makes a great washing station for your furry friends, along w/ pellet stove (stays) for extra comfort. Step outside & this is where it all changes... large deck w/ GAS hookup for grilling & REMOTE LIGHTING, overlooking mature trees & sweeping river views. DIRECT RIVER ACCESS! Enjoy your FLOATING DOCK for fishing, relaxing, or letting the kids play, and take advantage of nearby Constance Marina for easy boat access for fishing boats. Perfect time of year to enjoy the river... imagine your own private retreat where every day feels like a vacation. From peaceful mornings w/ coffee overlooking the water to evenings w/ bonfires, friends & sunset views, this property offers a true escape right at home. All kitchen appliances stay incl GAS stove, W/D included, pellet stove stays, 2 BR TVs also included. 2 parcels included 070.05-00-007.03 & 070.05-00-007.00 (2nd lot adjacent & includes part of driveway). Convenient to shopping, dining, airport ,ferry & hwy access.