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
Property Type
Single Family Residential
New Construction
Yes
Bedrooms
4
Bathrooms
5
Baths Full
4
Half-baths
1
Bathroom Level 1
1
Lot Size
174,588
Levels
Two
County
Warren
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

Year Built
2026
Taxes
$4,044
Acres
4.01
Construction
Stone, Fiber Cement
Roof
Shingle
Basement Desc
Full
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
Water Heating
High Effic Heat Pump, Tankless
Primary Water Source
Public
School District
Little Miami Local S
Degree Complete
Completed
Entry
12x7 Level: 1
Dining Room
17x14 Level: 1
Study
15 x 12
Recreation Room
16x9 Level: 2
Laundry Room
10x9 Level: 1
Levels
Two
Foundation
Poured
Gas
Propane
Flex Rooms
Loft, Media Room, Exercise Room, Game Room
Entry Foyer
Closet, Open Foyer, Double Doors, Wood Floor
Living Room Feat
Bookcases, Walkout, Dry Bar
Dining Room Feat
Chandelier, Walkout, Wood Floor
Family Room Feat
Wet Bar, Wood Floor
Basement Features
Part Finished
Fireplaces
2
Fireplace
Gas, Wood
Inside Features
9Ft + Ceiling, Beam Ceiling, Crown Molding, Natural Woodwork, Vaulted Ceiling
Land Description
1 to 4.9 Acres
Miscellaneous
220 Volt, Recessed Lights
Appliances
Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Wine Cooler

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.