Just Listed
Address
10475 Harrison Road, Hamilton Twp, OH
Price
$ 2,600,000
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
Price
Year Built
Visits
In The Neighborhood
Just Listed
Hamilton Twp
$ 395,000
- Type
- Single Family
Listed by Angela Apking of Coldwell Banker Realty
Open House
Maineville
$ 500,000
- Type
- Single Family
Listed by Diane Gillespie of Coldwell Banker Realty, Anders
Just Listed
Hamilton Twp
$ 2,750,000
- Type
- Single Family
Listed by Eleanor Kowalchik of Keller Williams Pinnacle Group
Just Listed
Hamilton Twp
$ 524,900
- Type
- Single Family
Listed by H Joshua Blatt of Coldwell Banker Realty
Just Listed
Hamilton Twp
$ 489,900
- Type
- Single Family
Listed by H Joshua Blatt of Coldwell Banker Realty
Just Listed
Hamilton Twp
$ 484,900
- Type
- Single Family
Listed by H Joshua Blatt of Coldwell Banker Realty
Just Listed
Hamilton Twp
$ 939,900
- Type
- Single Family
Listed by Kendra Larrick of Keller Williams Pinnacle Group
© MLS Now, INC - Northern Ohio Regional Multiple Listing Service 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 consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective
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. Information on this
NORIS | Toledo Regional Association of REALTORS® 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 consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers
Information should be deemed reliable but not guaranteed, all representations are approximate, and individual verification is recommended. Copyright ©2017 All rights reserved.
