Start of property details

Share this property:
10475 Harrison Road
Hamilton Twp, OH 45140
FOR SALE · Active
$2,600,000
4
Beds
5
Baths
4
Garage
4.01
Acres
2026
Yr. Built
MLS# 1894058
Cumulative Days on Market: 24 · Includes prior listings · Currently listed since 09/19/26 · Data provided by the MLS.

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.

Open House Announcements

Oct 18th 12:00pm to 2:00pm
In person. Please join us!

Property Highlights

Property Type
Residential
Property Sub Type
Single Family Residence
Architectural Style
Transitional
Bedrooms
4
Total Bathrooms
5
Living Area
5,091
Price / Sqft
$511
Acres
4.01
Year Built
2026
Cumulative Days On Market
24

Location

Area
Warren-E09
City/Township
Hamilton Twp
County
Warren

Property Details

Price
$2,600,000
Property Type
Residential
Property Sub Type
Single Family Residence
Suburb SIC
Hamilton Twp.

Building

Levels
Two

Community

Local Schools

School District
Little Miami Local S

Interior Features

Bedrooms and Bathrooms

Total Bathrooms
5
Full Bathrooms
4
1/2 Bathrooms
1
Bedrooms
4

Rooms and Basement

Total Rooms
15
Basement Features
Full, 2

Area and Spaces

Living Area
5,091

Appliances

Appliances
Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Wine Cooler

Interior Features

Interior Features
9Ft + Ceiling, Beam Ceiling, Crown Molding, Natural Woodwork, Vaulted Ceiling
Window Features
Window Film, Double Hung
Fireplace Features
Gas, Wood

Heating and Cooling

Heating Features
Forced Air, Gas Furn EF Rtd 95%+, Zoned
Fireplaces
2

Building Details

Construction

Architectural Style
Transitional
Year Built
2026
New Construction
Yes
Foundations
Poured

Materials

Construction Materials
Stone, Fiber Cement
Roof
Shingle

Terms

Terms

Cumulative Days On Market
24

Heating, Cooling & Utilities

Cooling Features
SEER Rated 13-15, Central Air, ENERGY STAR

Utilities

Sewer
Septic Tank
Water Source
Public

Lot

Acres
4.01
Lot Size Area Sq Ft
174,588
Lot Features
Cleared, Level

Exterior Features

Exterior Features
Fireplace
Patio And Porch Features
Covered, Patio

Parking

Garage Capacity
4
Parking Features
Off Street, Driveway
Listed by Adam A Schupp, Sibcy Cline, Inc., 513-385-0900
Listing Data last updated 10/13/2026 11:40 pm
Get a Link to this Property: Copy To Clipboard
QR Code link to this property

Phone:
Connect with:

Payment Calculator

per month. fixed. % interest.
$
%
$
%
Principal & Interest
+ Home Insurance
+ Property Tax
+ HOA Fees
per month
Total interest paid over s will be:
All estimates and provided for informational purposes only. Actual amounts may vary. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. Information, rates, programs and loan scenarios shown are for example only as of 14-Oct-2026 and are subject to change without notice. Interest rates provided by the St. Louis Federal Reserve Economic Data (FRED). All products are subject to credit and property approval. Not all products are available in all states or for all loan amounts. Other restrictions and limitations apply. Contact your preferred lender for the pricing associated with your specific transaction. Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. All calculations should be independently verified.
Get Walk Score Content

Property History

Today
Property information last updated
24 days ago
Status Active. This is the date the listing was placed on market.
82831 days ago
Date Sold
Cumulative Days on Market: 24 days (includes prior listings) · Currently listed since September 19, 2026. Data provided by the MLS.

Similar Properties