Active

10475 Harrison Road

Hamilton Twp, OH 45140
Mark as Favorite
Bed 4

Bed

Bath 5

Bath

SqFt5,091

Sqft

Acres4.01

Acres(Lot)

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.

Read More Expand
Tour with a ByOwner Agent

Detail Ic Property Details

Property Type : Residential

Price : $2,600,000

AD Id : 91363993

MLS Id : 1894058

Beds : 4

Lot Size : 4.01 Acres

Living Area Size : 5,091 Sq. Ft

Year Built : 2026

Garage : 4

County : Warren

  • Map Map

Map

Map What's Nearby

Map Nearby Areas

Feature Features

  • Bedroom Information

    Total beds: 4

    Bathroom Information

    Total Baths: 5 Full Baths: 4 Half Baths: 1

    Room Information

    Rooms Total: 15 Has Basement: Yes Basement: Partially Finished, Sump Pump, Full
  • Roofing Information

    Shingle
  • Interior Features

    Vaulted Ceiling(s), Eat-in Kitchen, Kitchen Island, Pantry, Walk-In Closet(s), Crown Molding, Natural Woodwork, Bookcases Roof: Shingle Appliances: Range, Oven, Humidifier, Dishwasher, Dryer, Microwave, Refrigerator, Washer, Wine Cooler
  • Heating & Cooling

    Has Heating: Yes Heating: Forced Air, Zoned Has Cooling: Yes Cooling: Central Air

  • Building Information

    Year Built: 2026 Construction Materials: Stone, Fiber Cement Patio And Porch Features: Patio, Porch Private Pool: No

  • Lot Information

    Lot Size Acres: 4.008 Lot Size Square Feet: 174588 Lot Description: Cleared, Level

  • Listing Price Information

    Listing Price: $2600000

  • Tax Information

    Parcel Number: 17-31-151-004

  • Parking Information

    Garage Door Opener, Off Street, Driveway, Attached

    Garage Information

    Has Garage: Yes Has Attached Garage: Yes Garage Space: 4

  • Utility Information

    Propane
  • Location Information

    Direction: From downtown Loveland, North on St.Rt.48, Right on Harrison Road. WaterSource: Public
Sell a home like this and save $155,501 Find out How

How much is this property worth?

Curious about this home's true market value? Use our free Home Evaluation Tool to instantly get a personalized Comparative Market Analysis (CMA) report. Make smarter, data-driven decisions before you buy.

Images
Loading, please wait...

The data relating to real estate for sale on this website 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 ByOwner are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. The properties displayed may not be all the properties available through Broker Reciprocity. 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. Data is deemed reliable but is not guaranteed accurate by the MLS. Copyright © 2026 MLS of Greater Cincinnati. All Rights Reserved.

ByOwner last updated this listing 10/06/2026 @ 08:02

MLS: 1894058 LISTED BY: Adam Schupp, Sibcy Cline, Inc. SOURCE: MLS of Greater Cincinnati (CincyMLS)

Selling? Save $155,501 when you sell a home like this

Tour with a ByOwner Agent