10475 Harrison Road

Hamilton Twp, OH
$ 2,600,000 Beds 4 Baths 4.5 Sq 5,091 Virtual Tour
Monthly Estimate* How much can I afford?

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.

Active

  • Price
  • $ 2,600,000
  • City
  • Hamilton Twp
  • Bedrooms
  • 4
  • Full Bathrooms
  • 4
  • County
  • WARREN
  • Half Bathrooms
  • 1
  • Area
  • Warren
  • Lot Size
  • 4.008 Acres
  • Zip
  • 45140
  • Sqr Footage
  • 5,091
  • Year Built
  • 2026
  • Style
  • Transitional
  • MLS#
  • 1894058
Listed By: Sibcy Cline, Inc.;
Data Source: MLS of Greater Cincinnati (CABR)

Features

General

Sewer Septic Tank
Heating Forced Air,Gas Furn EF Rtd 95%+,Zoned
Cooling SEER Rated 13-15,Central Air,ENERGY STAR
Roof Shingle
Appliances Dishwasher,Dryer,Microwave,Oven/Range,Refrigerator,Washer,Wine Cooler
HOA Fee 0.0
Garage Spaces 4.0
Architectural Style Transitional
Construction Materials Stone,Fiber Cement
Year Built 2026
Levels Two
Property Subtype Single Family Residence
County Warren
Property Type Residential
HOA No
Total Rooms 15
Full Baths 4
Close Price 0.0
Status Active
Directions From downtown Loveland,North on St.Rt.48,Right on Harrison Road.
City Hamilton Twp
High School District Little Miami Local S
MLS Area Warren-E09
Lot Size Units Acres
Lot Size Square Feet 174588.0
Carport Spaces 0.0

Interior Features

Interior Amenities 9Ft + Ceiling,Beam Ceiling,Crown Molding,Natural Woodwork,Vaulted Ceiling
Basement Full
Total Fireplaces 2
Fireplace Features Gas,Wood
Window Features LowE,Double Hung,Other
Total Bedrooms 4

Exterior Features

Exterior Amenities Covered Deck/Patio,Fireplace,Patio,Porch
Parking Features Off Street,Driveway
Water Source Public
Foundation Details Poured
Lot Size Acres 4.008

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Affordability Calculator

$3,786

Per Month

Based on the average sale price from the Cincinnati, OH office

  • Monthly Principal & interest $2,658
  • Monthly Property Taxes $1,062
  • Monthly Home Insurance $67
Adjust Payment Options
Agent Photo

Let's determine your purchasing power. Working with my mortgage partner, you'll have the information you need to shop for a home with confidence.

Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA, or jumbo loans.

Mortgage calculator provided courtesy of Inside Real Estate.

Schools

Elementary School Unknown Elementary School
Middle School Unknown Middle School
High School Unknown High School

Price History

9/19/2026 Listed $2,600,000

Property vs Zip Code Average in 45140

Price
AVG $910K
$2.6M
Year Built
AVG 1991
2026
Visits
AVG 131
17
Data Provided by Inside Real Estate®

Areas That We Cover

10475 Harrison Road Hamilton Twp, OH is a Single Family Home for sale at $2600000 with 5091 sqft and a lot size of 4.008 Acres Acre(s). 10475 Harrison Road Hamilton Twp has 4 bedrooms, 4 baths and was built in 2026. The property's zip code is 45140 which is in Hamilton Twp, OH

*Information deemed reliable but not guaranteed.

Financial calculator disclaimer: Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.

Mortgage calculator provided courtesy of Inside Real Estate.

All information deemed reliable, but not guaranteed, and should be independently verified. The real estate information and related content displayed on this site is provided 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.