Date
Details
Price
Change
Source
9/19/2026
Listed
$2,600,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/98
$2,600,000 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/98
Property Description
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.
Full Property Details
Full Property Details for 10475 Harrison Rd
General
- Price: $2,600,000
- Status: Active
- Type: Single Family
- Source: Cincinnati
- MLS ID: 1894058
- Updated: 9/21/2026
- Added to Site: 4 day(s) ago
Interior
- Number of Rooms: 15
- Rooms/Areas: Loft, Media Room, Exercise Room, Game Room
- Interior Features: High Ceiling (9 Feet or More), Beam Ceiling, Crown Molding, Natural Woodwork, Vaulted Ceiling
- Fireplace: Yes
- Number of Fireplaces: 2
- Fireplace(s): Gas, Wood-Burning
- Appliances: Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Wine Cooler
Rooms
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 4
- Half Bathrooms: 1
- Primary Bathroom: Built-In Shower Seat, Double Shower, Tile Floor, Double Vanity, Tub, Marb/Gran/Slate
- Bathroom 1: Full, Level 1
- Bathroom 2: Full, Level 2
- Bathroom 3: Full, Level 2
- Bathroom 4: Full, Lower
Bedrooms
- Total Bedrooms: 4
- Primary Bedroom: Adjoining Bathroom, Vaulted Ceiling, Walk-In Closet, Wood Floor, 23 x 16, Level 1, 368 Sq. Ft.
- Bedroom 2: 16 x 12, Level 2, 192 Sq. Ft.
- Bedroom 3: 16 x 12, Level 2, 192 Sq. Ft.
- Bedroom 4: 13 x 13, Level 2, 169 Sq. Ft.
Other Rooms
- Foyer/Entry: Closet, Open Foyer, Double Doors, Wood Floor, Level 1
- Living Room: Bookcases, Walk-Out, Dry Bar, 13 x 12, Level 1, 156 Sq. Ft.
- Great Room: Bookcases, Fireplace, Wood Floor, 23 x 20, Level 1
- Family Room: Wet Bar, Wood Floor, 21 x 17, Lower, 357 Sq. Ft.
- Kitchen: Butler's Pantry, Counter Bar, Eat-In, Gourmet, Island, Wood Cabinets, Wood Floor, 20 x 17, 20x17, 340 Sq. Ft.
- Dining Room: Chandelier, Walk-Out, Wood Floor, 17 x 14, Level 1, 238 Sq. Ft.
- Office/Den/Study: 15 x 12, Level 1, 180 Sq. Ft.
- Office: Bookcases, Wall-to-Wall Carpet
- Rec Room: 16 x 9, Level 2
- Laundry: 10 x 9, Level 1, 90 Sq. Ft.
Additional Information
- Mechanicals: Air Cleaner, Garage Door Opener, Humidifier, Sump Pum
- Other Features: 220 Volts, Recessed Lights
Exterior
- Exterior Features: Covered Deck/Patio, Fireplace, Patio, Porch
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 4
- Parking: Off-Street Parking, Driveway
- Garage Description: Side, Garage Attached
Location
- Area: Hamilton Twp.
- County: Warren
- Township: Hamilton Twp
- Suburb: Hamilton Twp.
- Driving Directions: From downtown Loveland, North on St.Rt.48, Right on Harrison Road.
School Information
- School District: Little Miami Local S
- High School District: Little Miami Local S
Community
- Home Owners Assn.: False
Heating & Cooling
- Central air: Yes
- Cooling Type: SEER Rated 13-15, Central Air Conditioning, ENERGY STAR
- Heating Type: Forced Air, Gas Furn EF Rtd 95%+, Zoned
- Heating Fuel: Propane
- Water Heater: High Effic Heat Pump, Tankless
Utilities
- Sewer: Septic Tank
- Water: Public
Structural Information
- Architectural Style: Two Story Transitional
- Description/Design: Single Family
- Construction Status: Completed
- Exterior Const.: Stone, Fiber Cement
- Basement: Yes
- Basement Desc.: Full, Partially Finished
- Foundation: Poured
- Roof: Shingle
- Windows: LowE, Double-Hung, Other
- Stories/Levels: Two
- Square Feet: 5,091
- Year Built: 2026
Lot Features
- Lot Size (Acres): 4.008
- Topography: Cleared, Level
- Zoning: Residential
- Lot Description: 1 to 4.9 Acres
Financial Considerations
- Semi-Annual Taxes: $2022
Disclosures and Reports
- APN: 17-31-151-004
Listed by Sibcy Cline, Inc. (513) 385-0900, Adam Schupp and Sibcy Cline, Inc. (513) 385-0900, Mark Schupp (513) 385-0900
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agents
— 10475 Harrison Rd —
Adam Schupp
Sibcy Cline, Inc.
513-385-0900
Mark Schupp
Sibcy Cline, Inc.
513-385-0900
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 10475 Harrison Rd
School District:Little Miami Local School District
| Name | Grades | Distance |
|---|---|---|
Little Miami Primary School 7247 Zoar Road, Maineville, OH 45039 | 2-3 | 3.6 mi |
Little Miami Intermediate Middle School 605 Welch Road, Morrow, OH 45152 | 4-5 | 6.4 mi |
Little Miami Early Childhood Center 609 Welch Road, Morrow, OH 45152 | PK-1 | 6.5 mi |
Little Miami Junior High School 5290 Morrow-Cozaddale Road, Morrow, OH 45152 | 6-8 | 6 mi |
Little Miami High School 3001 U.S. 22, Morrow, OH 45152 | 9-12 | 6.2 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 10475 Harrison Rd
Tax History
Tax History for 10475 Harrison Rd
Year
Property Taxes
Change
Tax Assessment
Change
2025
$4,202
112%
$92,740
112%
2024
$1,983
-30%
$43,743
-22%
2023
$2,848
2%
$55,794
—
2022
$2,802
5%
$55,794
—
2021
$2,670
—
$55,794
23%
2021
$2,682
3%
$45,360
—
2019
$2,597
2%
$45,360
—
2018
$2,546
13%
$45,360
13%
2017
$2,252
-2%
$40,268
—
2016
$2,307
31%
$40,268
—
2015
$1,767
-4%
$40,268
7%
2014
$1,832
2%
$37,562
—
2013
$1,802
—
$37,562
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 10475 Harrison Rd
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 7 days ago
- 4Beds
- 4Total Baths
- 5,640Sq. Ft.
- Single Family
- Active
- Updated 1 day ago
- 4Beds
- 7Total Baths
- 6,753Sq. Ft.
- Single Family
- Active
- 4Beds
- 5Total Baths
- 6,096Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 1 hour ago
- 3Beds
- 1Total Bath
- 1,400Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 4 days ago
- 3Beds
- 2Total Baths
- 1,584Sq. Ft.
- Condo
- Active
- Updated 4 days ago
- 2Beds
- 2Total Baths
- 1,171Sq. Ft.
- Single Family
- Active
- Updated 4 days ago
- 3Beds
- 4Total Baths
- 1,977Sq. Ft.
- Single Family
- Active
- Updated 4 hours ago
- 4Beds
- 1Total Bath
- 1,075Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 5Beds
- 5Total Baths
- 8,006Sq. Ft.
Listed by Michelle Hudepohl Group
10475 Harrison Road, Hamilton Township, OH 45140 (MLS# 1894058) is a Single Family property with 4 bedrooms, 4 full bathrooms and 1 partial bathroom. 10475 Harrison Road is currently listed for $2,600,000 and was received on September 19, 2026. Want to learn more about 10475 Harrison Road? Do you have questions about finding other Single Family real estate for sale in Hamilton Township? You can browse all Hamilton Township real estate or contact a Coldwell Banker agent to request more information.