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. Private 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 multiple patios. Over $400K in show discounts. This home offers way many luxuries to list!
General Information
Property Type
Residential
Style
Single Family Residence
County
Warren
Subdivision
Loveland
Zip Code
45140
School District
Little Miami Local S
Listing Number
1867257
Bedroom Information
Beds
5
Master Bedroom
17 x 18
L: 1
Bedroom 2
13 x 14
L: 2
Bedroom 3
13 x 14
L: 2
Bedroom 4
13 x 14
L: 2
Bedroom 5
14 x 15
L: 2
Bathroom Information
Baths
8.0
Property Features
Basement
Full
Garage
Garage Attached
Cars
3
Parking
Driveway
Windows
Wood
Heating
Gas, Electric
Cooling
Central Air
Fireplace
Gas, Stone
Additional Information
Levels
Two
Construction
Fiber Cement, Brick, Stone
Architecture
Traditional
Lot Dimensions
Irregular
Gas
Propane
Water
Public
Sewer
Other, Septic Tank
Foundation
Poured
Occupancy
At Closing
Semi-Annual Taxes
$0.00
Room Information
Rooms
21
Entry
19 x 15
L:
Dining
13 x 14
L: 1
Kitchen
14 x 17
L: 1
Breakfast
13 x 10
L: 1
Family
20 x 22
L: 1
Recreation Room
35 x 14
L: Lower
Study
16 x 15
L: 1
Laundry
11 x 12
L: 1
Additional Features
Basement Details
Finished, Other, Walkout
Entry Features
Open Foyer
Dining Room Features
Formal
Kitchen Features
Counter Bar, Walkout, Butler's Pantry, Marble/Granite/Slate, Gourmet, Pantry
Family Room Features
Walkout, Fireplace
Other Features
Smoke Alarm
HOA Fee - Annually
$2,600.00
Request more info about this property:
This listing courtesy of Alexander A Hencheck (513-469-2424), HMS Real Estate (513-469-2424). All Information is believed accurate, but is NOT guaranteed.
The data relating to the real estate for sale on this web site comes
in part from the Broker Reciprocity program of the MLS of Greater
Cincinnati, Inc. Real estate listings held by brokerage firms other
than Jordan Realtors are marked with the Broker Reciprocity logo
or Broker Reciprocity house icon. The properties displayed may not be
all the properties available through Broker Reciprocity.
