An exceptional 24 acre custom estate where timeless craftsmanship, thoughtful design, and modern innovation come together. Extensively renovated and expanded with a stunning 2021 addition, every detail reflects superior quality and intentional living. The thoughtfully designed floor plan offers a luxurious first-floor primary suite along with an additional second-floor ensuite, providing exceptional flexibility for family and guests. Built for beauty and efficiency, the home features geothermal heating and cooling, solar energy, and an integrated Control4 smart home system. Exceptional millwork, premium finishes, and seamless indoor-outdoor living define the residence. Resort-style amenities include heated saltwater pool with beautifully appointed pool house, stocked pond, climate controlled 30' x 60' barn/workshop and a vintage barn. A rare opportunity to own a meticulously engineered estate where craftsmanship, technology, and luxury living exist in perfect harmony.
Convection Oven, Dishwasher, Double Oven, Garbage Disposal, Gas Cooktop, Oven/Range, Refrigerator, Wine Cooler, Other
Interior Features
9Ft + Ceiling, Beam Ceiling, Crown Molding, French Doors, Heated Floors, Multi Panel Doors, Natural Woodwork
Fireplace Features
Stove, Gas, Wood
Fireplaces Total
4
Exterior
Roof
Shingle
Exterior Features
Covered Deck/Patio, Entertain Ctr, Fire Pit, Hot Tub, Patio, Porch, Sprinklers, Yard Lights
Construction Materials
Fiber Cement
Topography
Cleared, Lake/Pond, Pasture, Stream/Creek
Foundation Details
Poured
Parking
Parking Features
Concrete, Driveway
Utilities
Sewer
Septic Tank
Gas
Propane
Taxes
Property
11277
Area Information
State
OH
County
Warren
City
Hamilton Twp
Zip Code
45152
Area
Warren E09
Subarea
Warren E09
Community Name
Hamilton Twp.
School District
Little Miami Local S
High School
Little Miami Local S
Listing VS Median (in Hamilton Twp.)
Price: $3,470,000
low | high
Med: $466,000
100% of Average
sqft: 7,882
low | high
Med: 2,652
100% of Average
$ / sqft: $440
low | high
Med: $176
100% of Average
On site: 73
low | high
Med: 27
100% of Average
Sourced by Back At You
Market Activity 45152
Date
Sales
Avg $ Per SqFt
Min Sale Price
Max Sale Price
Med Sale Price
Date: Aug 2026
Sales: 1
Avg $ Per SqFt: $198.35
Min Sale Price: $240,000
Max Sale Price: $240,000
Med Sale Price: $240,000
Date: Jul 2026
Sales: 28
Avg $ Per SqFt: $201.77
Min Sale Price: $267,000
Max Sale Price: $950,000
Med Sale Price: $444,950
Date: Jun 2026
Sales: 38
Avg $ Per SqFt: $203.55
Min Sale Price: $150,000
Max Sale Price: $750,000
Med Sale Price: $422,656
Date: May 2026
Sales: 28
Avg $ Per SqFt: $204.35
Min Sale Price: $142,300
Max Sale Price: $1,170,000
Med Sale Price: $394,400
Date: Apr 2026
Sales: 23
Avg $ Per SqFt: $197.77
Min Sale Price: $220,000
Max Sale Price: $840,865
Med Sale Price: $392,000
Date: Mar 2026
Sales: 21
Avg $ Per SqFt: $199.6
Min Sale Price: $195,000
Max Sale Price: $1,385,000
Med Sale Price: $372,500
Date: Feb 2026
Sales: 12
Avg $ Per SqFt: $222.47
Min Sale Price: $210,000
Max Sale Price: $689,000
Med Sale Price: $378,750
Date: Jan 2026
Sales: 14
Avg $ Per SqFt: $178.52
Min Sale Price: $110,000
Max Sale Price: $539,000
Med Sale Price: $377,385
Date: Dec 2025
Sales: 14
Avg $ Per SqFt: $175.82
Min Sale Price: $83,000
Max Sale Price: $805,000
Med Sale Price: $332,500
Date: Nov 2025
Sales: 19
Avg $ Per SqFt: $192.88
Min Sale Price: $90,000
Max Sale Price: $1,318,961
Med Sale Price: $412,000
Date: Oct 2025
Sales: 22
Avg $ Per SqFt: $221.68
Min Sale Price: $231,777
Max Sale Price: $1,340,000
Med Sale Price: $402,450
Date: Sep 2025
Sales: 15
Avg $ Per SqFt: $249.5
Min Sale Price: $121,313
Max Sale Price: $2,800,000
Med Sale Price: $485,000
Sourced by Back At You
Aug 2026
Sales:
1
Avg $ Per SqFt:
$198.35
Min Sale Price:
$240,000
Max Sale Price:
$240,000
Med Sale Price:
$240,000
Jul 2026
Sales:
28
Avg $ Per SqFt:
$201.77
Min Sale Price:
$267,000
Max Sale Price:
$950,000
Med Sale Price:
$444,950
Jun 2026
Sales:
38
Avg $ Per SqFt:
$203.55
Min Sale Price:
$150,000
Max Sale Price:
$750,000
Med Sale Price:
$422,656
May 2026
Sales:
28
Avg $ Per SqFt:
$204.35
Min Sale Price:
$142,300
Max Sale Price:
$1,170,000
Med Sale Price:
$394,400
Apr 2026
Sales:
23
Avg $ Per SqFt:
$197.77
Min Sale Price:
$220,000
Max Sale Price:
$840,865
Med Sale Price:
$392,000
Mar 2026
Sales:
21
Avg $ Per SqFt:
$199.6
Min Sale Price:
$195,000
Max Sale Price:
$1,385,000
Med Sale Price:
$372,500
Feb 2026
Sales:
12
Avg $ Per SqFt:
$222.47
Min Sale Price:
$210,000
Max Sale Price:
$689,000
Med Sale Price:
$378,750
Jan 2026
Sales:
14
Avg $ Per SqFt:
$178.52
Min Sale Price:
$110,000
Max Sale Price:
$539,000
Med Sale Price:
$377,385
Dec 2025
Sales:
14
Avg $ Per SqFt:
$175.82
Min Sale Price:
$83,000
Max Sale Price:
$805,000
Med Sale Price:
$332,500
Nov 2025
Sales:
19
Avg $ Per SqFt:
$192.88
Min Sale Price:
$90,000
Max Sale Price:
$1,318,961
Med Sale Price:
$412,000
Oct 2025
Sales:
22
Avg $ Per SqFt:
$221.68
Min Sale Price:
$231,777
Max Sale Price:
$1,340,000
Med Sale Price:
$402,450
Sep 2025
Sales:
15
Avg $ Per SqFt:
$249.5
Min Sale Price:
$121,313
Max Sale Price:
$2,800,000
Med Sale Price:
$485,000
MLS Number: 1887134
Hillary Justice – hillary.justice@cbws.com
Coldwell Banker Realty – (513) 321-9944
Request a showing
Request a showing
The information is being provided by CincyMLS. Information deemed accurate but not guaranteed. Information is provided for consumers personal, non-commercial use, and may not be used for any purpose other than the identification of potential properties for purchase. Copyright 2026 CincyMLS. All Rights Reserved.