Sign up
Log in
Results
View all 4 pictures
Size: 3.54 Acres
Type: House
Home: 5 beds - 8 full baths - 8,371 Sq Ft

Is this your property? Sell it faster with premium placement and targeted ads.

SINGLE_FAMILY - Other - Loveland, OH

New construction by Brookstone Homes featuring the Tranquility floorplan in The Estates at Bothe Farms, site of HOMEARAMA 2026. This luxury show home sits on a private 3.5-acre lot with 5 bedrooms, 8 full baths, and private guest quarters with elevator. Zero-entry first floor (including the owner's suite). Dramatic circular oak staircase. Open-concept kitchen with luxury appliances, butler's pantry, walk-in pantry, and wine room, flowing into a two-story family room with stone fireplace and walk-out access to the Veranda and Lanai. The second floor features three ensuite bedrooms, library, office, and balcony. Well appointed guest living quarters with elevator access. Finished walk-out basement includes 10' ceilings, sports bar, golf simulator, billiards room, well appointed cigar lounge/study, and family room. Outdoor living includes an in-ground pool, outdoor kitchen, fireplace, and mu...

Read More

From elevation to risk assessment

Search for detailed parcel information including; Elevation & Vegetation Maps, Ownership Information, Detailed Parcel Information, Crop History Map, Soil Survey Productivity Data, and more.

Research Parcel Information
Contact Seller

HMS Real Estate

License #193556

Cincinnati, OH

(513) 469-2400

Alexander Hencheck

HMS Real Estate
View Phone Number
By clicking the button, you agree to our Terms of Use and Privacy Policy.

Is this your property? Sell it faster with premium placement and targeted ads.

Provided By

HMS Real Estate, (513) 469-2400
Source: ListHub, MLS# 1866586
Listing status: Active
Listing last updated: January 19, 2026 at 12:36 PM
Listing last checked: January 19, 2026 at 6:30 PM
Report this listing

Other Land for Sale in Warren County