Property Attributes
- MLS#1894385
- TypeSingle Family
- Listing Status Active
- CountyWARREN
- CityHamilton Twp
- AreaWarren
- NeighborhoodHamilton Township
- Zip45140
- StyleTransitional
- Price$ 2,750,000
- Bedrooms5
- Full Bathrooms5
- Half Bathrooms1
- Sqr Footage7080
- Lot Size2.0614 Acres
Data Source:
MLS of Greater Cincinnati (CABR)
Property Description
Unparalleled luxury and craftsmanship! John Hill Construction presents its 2026 Homearama entry, The Legacy. This show-stopping custom new build boasts over 7000 sqft of living space and offers a thoughtfully-planned layout complete w/1st flr study, great rm w/dramatic stone FP, gourmet eat-in kitchen w/oversized quartz island + butlers pantry, 1st flr primary suite w/walk-in closet + spa-like bath, gorgeous 1st flr guest suite, two 2nd flr bdrm suites, pocket ofc, lg laundry rm (w/dog shower!), and finished LL incl wet bar/home gym/addt'l egress bdrm/full bath. Truly stunning architectural features + upscale designer finishes at every turn. The luxe experience continues outdoors, featuring an inviting front porch, expansive rear patio, and incredible covered space w/FP + outdoor kitchen. Plus a 3-car garage w/zero-step entry. All situated on a prime 2+ acre lot in the new Estates at Bothe Farms community, conveniently located just 3 miles from all that downtown Loveland has to offer!
| Price History | |
|---|---|
| 9/18/2026 | Listed $2,750,000 |
General Features
| Sewer | Septic Tank |
|---|---|
| Heating | Forced Air,Gas |
| Cooling | Central Air |
| Roof | Shingle |
| Appliances | Dishwasher,Double Oven,Garbage Disposal,Gas Cooktop,Microwave,Refrigerator,Wine Cooler |
| HOA Fee | 650.0 |
| Garage Spaces | 3.0 |
| Association Fee Includes | AssociationDues,LandscapingCommunity |
| Architectural Style | Transitional |
| Construction Materials | Stone,Wood Siding,Other |
| View | Other |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Assoc Fee Paid Per | Quarterly |
| County | Warren |
| Property Type | Residential |
| HOA | Yes |
| Subdivision Name | Estates at Bothe Farms |
| Total Rooms | 13 |
| Full Baths | 5 |
| Close Price | 0.0 |
| Status | Active |
| Directions | Cozaddale-Murdock to Christian Court |
| City | Hamilton Twp |
| High School District | Little Miami Local S |
| MLS Area | Warren-E09 |
| Lot Size Units | Acres |
| Lot Size Square Feet | 89795.0 |
| Carport Spaces | 0.0 |
Interior Features
| Interior Amenities | 9Ft + Ceiling,Beam Ceiling,Crown Molding,French Doors,Heated Floors,Multi Panel Doors |
|---|---|
| Basement | Full |
| Total Fireplaces | 2 |
| Fireplace Features | Stone,Gas,Wood |
| Window Features | Vinyl/Alum Clad,Wood |
| Total Bedrooms | 5 |
Exterior Features
| Exterior Amenities | BBQ Grill,Covered Deck/Patio,Fireplace,Kitchen – Outdoor,Patio,Porch,Yard Lights |
|---|---|
| Parking Features | On Street,Driveway |
| Water Source | Public |
| Foundation Details | Poured |
| Lot Dimensions | Irregular |
| Lot Size Acres | 2.0614 |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 45140
In The Neighborhood
Maineville
$ 500,000
- Type
- Single Family
Listed by Diane Gillespie of Coldwell Banker Realty, Anders
Hamilton Twp
$ 524,900
- Type
- Single Family
Listed by H Joshua Blatt of Coldwell Banker Realty
Hamilton Twp
$ 489,900
- Type
- Single Family
Listed by H Joshua Blatt of Coldwell Banker Realty
Hamilton Twp
$ 484,900
- Type
- Single Family
Listed by H Joshua Blatt of Coldwell Banker Realty
Hamilton Twp
$ 939,900
- Type
- Single Family
Listed by Kendra Larrick of Keller Williams Pinnacle Group
Hamilton Twp
$ 425,000
- Type
- Single Family
Listed by Marcia Greenwald of Sibcy Cline, Inc.
Hamilton Twp
$ 439,900
- Type
- Single Family
Listed by Daniel Kaiser of Coldwell Banker Realty
© 2026 Dayton Area Board of Realtors. All rights reserved. Information deemed to be reliable but not guaranteed. The data relating to real estate for sale on this website comes from Dayton Area Board of Realtors and the Broker Reciprocity Program.sm. Real estate listings held by brokerage firms other than Plum Tree Realty - Cincinnati are marked with the BR logo and detailed information about them includes the name of the listing brokers. Listing broker has attempted to offer accurate data, but