Introducing Le Reve (“The Dream”) an extraordinary custom-built waterfront estate set on 15 breathtaking acres along Bischoff Reservoir. Offering boating and fishing on the private no-wake lake, this one-of-a-kind luxury retreat blends timeless elegance, privacy, and resort-style living just an hour drive from Cincinnati, Florence, and Indianapolis. Spanning over 16,000 square feet across three levels, this spectacular estate was designed for both grand entertaining and refined everyday living. Inside, you’ll find 6 bedrooms, 8.5 baths, 2 home offices, a deluxe home theatre, 4 fireplaces, and a private elevator connecting all levels. The gourmet kitchen features premium appliances, custom cabinetry, and a butler’s pantry, opening into stunning gathering spaces with exceptional views from nearly every room. The luxurious main-level primary suite offers a private sitting room, oversized closets, separate his-and-her spa-inspired bathrooms, and panoramic reservoir views. The walkout lower level opens directly to the resort-style outdoor living spaces. Exterior amenities are equally impressive and include a private boat dock, swimming pool, greenhouse, outdoor fire pit, and a gorgeous horse barn complete with living quarters above. Enjoy the serene setting with unmatched beauty and privacy. Le Reve is more than a home, it is a legacy estate and a rare opportunity to own one of the region’s most remarkable luxury properties.
Date Added: 5/20/26 at 5:00 am
Last Update: 6/17/26 at 10:11 pm
Exterior
- GeneralNot Applicable
- StyleFrench Provincial
- Other StructuresPorch, Gazebo, Patio, Covered
- PoolDiving Board, Waterfall
- ParkingAttached, Detached
Location
- Road/AccessCounty Road
- Originating MLSmibor
- School DistrictBatesville Community School Corp
- CountyRipley
Lot
- TopographyVaried
- ZoningPt Swqr 34-10-12 14.9943 Ac, 690234300041003002
- FencingFence Complete
Utilities
- WaterPublic
- SewerPublic Sewer
Financial
- Sourcemibor
Interior
- GeneralBuilt-in Features, Ceiling Vaulted, Kitchen Island, Dumbwaiter, Elevator, Entrance Foyer, Paddle Fan, Hardwood Floors, Hi- Speed Internet Availbl, In- Law Arrangement, Pantry
- AppliancesDishwasher, Dryer, Disposal, Gas Water Heater, Microwave, Gas Oven, Refrigerator, Warming Drawer, Washer
- LaundryLaundry Closet, Main Level, Upper Level, In Basement
- BasementCeiling - 9+ feet, Egress Window(s), Exterior Entry, Finished, Full
- A/CCentral Air
- HeatingZoned, Forced Air, Geothermal
- FireplaceOther, Fireplaces: 4
- Half Baths1
Construction
- GeneralTwo, Concrete Perimeter
Schools
- DistrictBatesville Community School Corporation
- ElementaryBatesville Primary School
- MiddleBatesville Middle School
- HighBatesville High School
What's Nearby?
Restaurants
Error: Failed to fetch Yelp data or received unexpected response format.
Coffee Shops
Error: Failed to fetch Yelp data or received unexpected response format.
Grocery
Error: Failed to fetch Yelp data or received unexpected response format.
Education
Error: Failed to fetch Yelp data or received unexpected response format.
Park
Error: Failed to fetch Yelp data or received unexpected response format.















Listings courtesy of MIBOR Broker Listing Cooperative® as distributed by MLS GRID. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The use of the MLS GRID Data may be subject to an end user license agreement prescribed by the applicable MLS if any and as amended from time to time