10475 Harrison Road, Hamilton Twp, OH 45140

$2,600,000
4
BD
5
BA
1,142
SqFt

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

List Price
$2,600,000
Status
ACTIVE
MLS#
1894058
New Construction
Yes
Bedrooms
4
Bathrooms
5
Half-baths
1
Lot Size
174,588
Levels
Two
Region
Warren-E09

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.

Additional Information

Taxes
$4,044
Acres
4.01
Construction
Stone, Fiber Cement
Roof
Shingle
Fireplaces
2
Basement Desc
Full
Appliances
Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Wine Cooler
Garage Spaces
4
Cooling
SEER Rated 13-15, Central Air, ENERGY STAR
Heating
Forced Air, Gas Furn EF Rtd 95%+, Zoned
Sewer
Septic Tank
Water
Public
School District
Little Miami Local S

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks

Courtesy of Adam Schupp with Sibcy Cline, Inc.

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity™ program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than our company are marked with the Broker Reciprocity™ logo (the small house as shown to the left) and detailed information about them includes the name of the listing brokers. This data is up-to-date as of . Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved. Information deemed reliable but not guaranteed.