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
Hamilton Twp
$ 365,000
- Type
- Single Family
Listed by Kevin Hildebrand of eXp Realty
Hamilton Twp
$ 650,000
- Type
- Single Family
Listed by Adam Marit of Real Link
Hamilton Twp
$ 395,000
- Type
- Single Family
Listed by Angela Apking of Coldwell Banker Realty
Hamilton Twp
$ 2,600,000
- Type
- Single Family
Listed by Adam Schupp of Sibcy Cline, Inc.
Hamilton Twp
$ 599,000
- Type
- Single Family
Listed by Mark Woodruff of Comey & Shepherd
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
$ 469,000
- Type
- Single Family
Listed by Sheila Siermann of Comey & Shepherd
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
$ 400,000
- Type
- Single Family
Listed by Teri Gillman of Comey & Shepherd