- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
$2,600,000
Monthly Est:$12,941
4 Beds
5 Baths4 full baths + 1 half bath
5,091sqft
10475 Harrison Rd, Hamilton Twp, OH 45140
$2,600,000
$12,941/moEst:
Get Pre-Approved
Single Family Residence
Built in 2026
$-- HOA
4.01 acres lot
$511/sq.ft
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.
- Houzeo last checked: 1 hour ago
- Listing updated: October 18, 2026 at 5:13 pm
- Listing Provided by: Adam A Schupp (513) 460-5336 , Mark Schupp | Sibcy Cline, Inc.
- Source: Cincinnati MLS-OH | MLS#: 1894058
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
2026
HOA Fees
-
Finished Area
5,091 sqft
Lot Size
4.01 acres lot
Basement Area
- sqft
MLS Name
Cincinnati MLS
MLS Number
1894058
MLS Status
Active
Days on Market
40
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 5
Interior
Window Features
Double Hung, Window Film
Exterior Features
Fireplace
Heating
Forced Air, Gas Furn Ef Rtd 95%+, Zoned
Interior Features
9ft + Ceiling, Beam Ceiling, Natural Woodwork, Crown Molding, Vaulted Ceiling
Sewer
Septic Tank
Cooling
Seer Rated 13 15, Central Air, Energy Star
Appliances
Microwave, Oven/range, Dishwasher, Refrigerator, Dryer, Washer, Wine Cooler
Construction
Year Built
Year Built: 2026
Home type
Single Family Residence
Architectural Style
Transitional
Construction Materials
Stone, Fiber Cement
Roof
Shingle
Foundation Details
Poured
Utilities & Energy
Basement
Full, 2
Water Source
Public
Fireplace Features
Gas, Wood
Parking Features
Off Street, Driveway
Other Features
Lot Features
Cleared, Level
Patio And Porch Features
Covered, Patio
Price History
| Date | Event | Price |
|---|---|---|
10/18/2026 Source: | Listed for Sale | $2,600,000 $511/sqft |
Nearby Homes
Find Homes by Property Features in Hamilton Twp, OH
Nearby New Homes For Sale
Based on information from the Multiple Listing Service of Greater Cincinnati (alternatively the REALTOR Alliance of Greater Cincinnati) through Oct 29, 2026, 02:15PM. IDX information is provided exclusively for consumers’ personal, non-commercial use, it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and the data is deemed reliable but is not guaranteed accurate by the MLS. The listings of some real estate brokerage firms have been excluded. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Advertising Broker: Nicholas Huscroft | Chosen Realty
