Skip to content

Request a tour

Tell us when, and we'll take it from there.

Optional - usually gets you a faster reply.

· Terms of Use

← Back to search
1 / 98
For Sale
63 days on market
$2,600,000

10475 Harrison Road, Hamilton Twp, OH, 45140

4
Beds
4.5
Baths
5,091
Sq ft
Type
Single Family Residence
Year built
Built in 2026
Lot
4.01 acres
Price per sq ft
$511/sq ft
HOA
None
Garage
4-car garage

Buyer BriefThe facts on this home and a current CMA, talked through with you by one of our agents. The brief is at no cost to you.

Get the Buyer Brief

About this home

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.

Facts & features

Bedrooms & bathrooms
Bedrooms
4
Bathrooms
4 full · 1 half
Primary bedroom
Bath Adjoins, Vaulted Ceiling, Walk-in Closet, Wood Floor
Primary bathroom
Marb/Gran/Slate, Built-In Shower Seat, Double Shower, Double Vanity, Tile Floor, Tub
Rooms
Primary bedroom
23 x 16 · Level 1
Bedroom 2
16 x 12 · Level 2
Bedroom 3
16 x 12 · Level 2
Bedroom 4
13 x 13 · Level 2
Kitchen
20 x 17
Dining room
17 x 14 · Level 1
Living / great room
13 x 12
Family room
21 x 17 · Level Lower
Study / den
15 x 12 · Level 1
Recreation room
16 x 9 · Level 2
Laundry room
10 x 9 · Level 1
Entry
12 x 7 · Level 1
Interior
Kitchen
Butler's Pantry, Counter Bar, Eat-In, Gourmet, Island, Wood Cabinets, Wood Floor
Appliances
Microwave, Oven/Range, Dishwasher, Refrigerator, Dryer, Washer, Wine Cooler
Interior features
9Ft + Ceiling, Beam Ceiling, Natural Woodwork, Crown Molding, Vaulted Ceiling
Basement
Full, Finished - Partial
Levels
Two
Fireplaces
2
Fireplace features
Gas, Wood
Heating, cooling & utilities
Heating
Forced Air, Gas Furn EF Rtd 95%+, Zoned
Cooling
SEER Rated 13-15, Central Air, ENERGY STAR
Water heater
High Effic Heat Pump, Tankless
Gas
Propane
Water
Public
Sewer
Septic Tank
Parking
Garage
4-car garage
Garage details
Garage Attached, Side
Parking
Off Street, Driveway
Exterior & lot
Style
Transitional
Construction
Stone, Fiber Cement
Roof
Shingle
Foundation
Poured
Windows
Double Hung, Window Film
Exterior features
Fireplace
Lot size
4.01 acres
HOA & taxes
HOA
None
Property
Type
Single Family Residence
Year built
Built in 2026
Price per sq ft
$511/sq ft
Days on market
63
County
Warren
High school district
Little Miami Local S (verify with the district)
MLS #
1894058

Sale history

  1. Sep 19, 2026Listed
    Source: CincyMLS
    $2,600,000
  2. Feb 14, 2025Sold
    Listing courtesy of Jordan, Inc. · 513-791-0281 · Listed by Michael W Jordan · 513-520-2000 · Source: CincyMLS
    Deed recorded Mar 20, 2025 at $332,500 · Warranty deed · Source: Warren County Auditor
    $332,500
  3. Aug 1, 2023Sold
    Listing courtesy of OwnerLand Realty, Inc. · 513-896-1200 · Listed by Allyson E Moryl · 513-227-1516 · Source: CincyMLS
    Deed recorded Aug 8, 2023 at $240,000 · Warranty deed · Source: Warren County Auditor
    $240,000
  4. Jan 21, 2015Transfer
    Certificate of transfer · Source: Warren County Auditor
    —
  5. Dec 6, 2012Transfer
    Affidavit · Source: Warren County Auditor
    —

Sold history: Warren County Auditor public records, updated Nov 14, 2026.

Listing dates and prices from CincyMLS. MLS sales shown are from the last 5 years.

Public-record transfers include non-sale deeds; a Transfer shows no price. Sold or Transfer follows each county's own sale-validity flag where it publishes one. Sale and deed dates are as recorded by each source; a price change is dated when our listing feed first showed it.

Location

Hamilton Twp, OH 45140

Drive time

See the drive from this home to a place you go often.

Or try:

Estimated drive without traffic. Check the drive at the time you'd travel. Kept on this device; we don't save the address. Routes: © OpenStreetMap contributors

Check it yourself

This home is in Warren County.

Opens FEMA's flood map and USDA's eligibility map. FEMA's map is a starting point — your lender's flood check is final. USDA's map covers the location only; income limits and the lender's review also apply.

Map shows the approximate property location.

Listed by Adam A Schupp · 513-460-5336. Listing courtesy of Sibcy Cline, Inc. · 513-385-0900. Data via Cincinnati Multiple Listing Service.

Broker Reciprocity — MLS of Greater Cincinnati

The data relating to real estate appearing on this site comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati. Properties marked with the Broker Reciprocity icon are provided courtesy of the MLS of Greater Cincinnati. Information is deemed reliable but not guaranteed — independently verify all details. IDX information is provided exclusively 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. Equal Housing Opportunity. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved.

CincyMLS data last updated November 21, 2026 at 4:15 AM ET.

$2,600,000
For Sale

Buyer Brief

Get a Buyer Brief on a home you're considering.

One of our agents will call to hear what you'd like to know. Then we put together the facts on the home and a current CMA: recent sales of similar homes nearby. The brief is at no cost to you.

If this is your home and it's listed with another brokerage, your listing agent is the right person to talk with about pricing.

So we can call you back — in 10 minutes or less, 8am–8pm ET, 7 days.
Add a question about the home (optional)