Skip to content

Request a tour

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

Optional - usually gets you a faster reply.
← Back to search
1 / 98
For Sale
$2,600,000

10475 Harrison Road, Hamilton Twp, OH, 45140

4
Beds
4.5
Baths
5,091
Sq ft

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.

Details

Type
Single Family Residence
Full baths
4
Half baths
1
Year built
2026
Lot (acres)
4.008
Days on market
4
MLS #
1894058
County
Warren

Sale history

  1. Sep 19, 2026Listed
    Source: CincyMLS
    $2,600,000
  2. Mar 20, 2025Sold
    Warranty deed · Source: Warren County Auditor
    $332,500
  3. Aug 8, 2023Sold
    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 Sep 14, 2026.

Listing dates and prices from CincyMLS.

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

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 September 23, 2026 at 9:16 AM ET.

$2,600,000
For Sale
Request a tour