10475 Harrison Road, Hamilton Twp, OH, 45140
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 BriefAbout 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
See more of this home
Enter your email to see the rest of this home's photos and history.
You can request a tour, call, or contact an agent without doing this.
Sale history
- Sep 19, 2026ListedSource: CincyMLS$2,600,000
- Feb 14, 2025SoldListing courtesy of Jordan, Inc. · 513-791-0281 · Listed by Michael W Jordan · 513-520-2000 · Source: CincyMLSDeed recorded Mar 20, 2025 at $332,500 · Warranty deed · Source: Warren County Auditor$332,500
- Aug 1, 2023SoldListing courtesy of OwnerLand Realty, Inc. · 513-896-1200 · Listed by Allyson E Moryl · 513-227-1516 · Source: CincyMLSDeed recorded Aug 8, 2023 at $240,000 · Warranty deed · Source: Warren County Auditor$240,000
- Jan 21, 2015TransferCertificate of transfer · Source: Warren County Auditor—
- Dec 6, 2012TransferAffidavit · 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
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.
About Loveland
What Loveland is like, what homes sell for there, and what is nearby. Neighborhood guide →Listed by Adam A Schupp · 513-460-5336. Listing courtesy of Sibcy Cline, Inc. · 513-385-0900. Data via Cincinnati Multiple Listing Service.
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.


