Property Attributes
- MLS#1894058
- TypeSingle Family
- Listing Status Active
- CountyWARREN
- CityHamilton Twp
- AreaWarren
- NeighborhoodHamilton Township
- Zip45140
- StyleTransitional
- Year Built2026
- Price$ 2,600,000
- Bedrooms4
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage1142
- Lot Size4.008 Acres
Data Source:
MLS of Greater Cincinnati (CABR)
Property Description
Set on 4 private acres just minutes from downtown Loveland, this exceptional Stonehaven Modern Manor by Old World Custom Homes presents a rare opportunity to own a completed, move in ready custom home with immediate availability. Blending timeless architecture with luxury craftsmanship, the home offers over 5,000 finished square feet highlighted by a breathtaking vaulted kitchen featuring exposed timber trusses, custom Amish built cabinetry, oversized quartzite islands, adjoining scullery, and dramatic arched stone window wall. The open design flows seamlessly into the Great Room and covered outdoor living area with a see through fireplace. Additional highlights include a luxurious First floor Primary Suite, Private Study, dedicated lounge, finished lower level with bar and fitness space, and a 4 car garage. A truly rare opportunity to enjoy the craftsmanship of Old World Custom Homes on a scale and setting seldom available.
| Price History | |
|---|---|
| 9/19/2026 | Listed $2,600,000 |
General Features
| Sewer | Septic Tank |
|---|---|
| Heating | Forced Air,Gas Furn EF Rtd 95%+,Zoned |
| Cooling | SEER Rated 13-15,Central Air,ENERGY STAR |
| Roof | Shingle |
| Appliances | Dishwasher,Dryer,Microwave,Oven/Range,Refrigerator,Washer,Wine Cooler |
| HOA Fee | 0.0 |
| Garage Spaces | 4.0 |
| Architectural Style | Transitional |
| Construction Materials | Stone,Fiber Cement |
| Year Built | 2026 |
| Levels | Two |
| Property Subtype | Single Family Residence |
| County | Warren |
| Property Type | Residential |
| HOA | No |
| Total Rooms | 15 |
| Full Baths | 4 |
| Close Price | 0.0 |
| Status | Active |
| Directions | From downtown Loveland,North on St.Rt.48,Right on Harrison Road. |
| City | Hamilton Twp |
| High School District | Little Miami Local S |
| MLS Area | Warren-E09 |
| Lot Size Units | Acres |
| Lot Size Square Feet | 174588.0 |
| Carport Spaces | 0.0 |
Interior Features
| Interior Amenities | 9Ft + Ceiling,Beam Ceiling,Crown Molding,Natural Woodwork,Vaulted Ceiling |
|---|---|
| Basement | Full |
| Total Fireplaces | 2 |
| Fireplace Features | Gas,Wood |
| Window Features | LowE,Double Hung,Other |
| Total Bedrooms | 4 |
Exterior Features
| Exterior Amenities | Covered Deck/Patio,Fireplace,Patio,Porch |
|---|---|
| Parking Features | Off Street,Driveway |
| Water Source | Public |
| Foundation Details | Poured |
| Lot Size Acres | 4.008 |
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
$ 395,000
- Type
- Single Family
Listed by Angela Apking of Coldwell Banker Realty
Maineville
$ 500,000
- Type
- Single Family
Listed by Diane Gillespie of Coldwell Banker Realty, Anders
Hamilton Twp
$ 2,750,000
- Type
- Single Family
Listed by Eleanor Kowalchik of Keller Williams Pinnacle Group
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
© 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 Comey & Shepherd, REALTORS 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
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawl. Neither listing broker(s) nor SE IN BD REALTORS shall be held responsible for typographical errors, misinformation, misprints and shall be held totally harmless.