Active

Listing Tools

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.

Property Details

Interior Features

Community

Other Details

Map Location

Listed by Aaron Garrett of Lohmiller Real Estate (agarrett@lohmillerrealestate.com)

 Based on information submitted to MIBOR as of June 29, 2026 11:37 PM UTC . All data is obtained from various sources and has not been, and will not be, verified by broker or MIBOR.  All information should be independently reviewed and verified for accuracy.  Properties may or may not be listed by the office/agent presenting the information. NOTICE: Many homes contain recording devices, and buyers should be aware they may be recorded during a showing.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from CENTURY 21 Scheetz. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.