10475 Harrison Road, Hamilton Township, OH 45140 (MLS # 1894058)
Twitter
Facebook
Email
|
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.
| DAYS ON MARKET | 1 | LAST UPDATED | 9/19/2026 |
|---|---|---|---|
| YEAR BUILT | 2026 | COMMUNITY | Warren-E09 |
| GARAGE SPACES | 4.0 | COUNTY | Warren |
| STATUS | Active | PROPERTY TYPE(S) | Single Family |
| ADDITIONAL DETAILS | |
| AIR | Central Air |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Dishwasher, Dryer, Humidifier, Microwave, Oven, Range, Refrigerator, Washer, Wine Cooler |
| AREA | Warren-E09 |
| BASEMENT | Full, Partially Finished, Sump Pump, Yes |
| CONSTRUCTION | Fiber Cement, Stone |
| FIREPLACE | Yes |
| GARAGE | Attached Garage, Yes |
| HEAT | Forced Air, Zoned |
| INTERIOR | Bookcases, Crown Molding, Eat-in Kitchen, Kitchen Island, Natural Woodwork, Pantry, Vaulted Ceiling(s), Walk-In Closet(s) |
| LOT | 4.008 acre(s) |
| LOT DESCRIPTION | Cleared, Level |
| PARKING | Garage Door Opener, Off Street, Driveway, Attached |
| SEWER | Septic Tank |
| STORIES | 2 |
| STYLE | Transitional |
| UTILITIES | Propane |
| WATER | Public |
| ZONING | Residential |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for Wendi
Sheets to contact you even if your name is on a Federal or State
"Do not call List".
Listing provided by Sibcy Cline, Inc., Adam Schupp, phone# 513-460-5336
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati and the Dayton Area Board of Realtors® MLS IDX Database.
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. Information Deemed Reliable but Not Guaranteed.
Copyright© 2026 MLS of Greater Cincinnati, Inc. and Dayton Area Board of Realtors® All rights reserved.
Data last updated: 9/20/26 9:56 AM PDT
This IDX solution is (c) Diverse Solutions 2026.