It's in the top 10% of views. Tour it before it's gone!
Tomorrow:
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.
Development Opportunity! Approx. 4.008 acres conveniently located 5 minutes to downtown Loveland, level lot, current 8 x 24 tiny house is included, water available, plat attached. Great opportunity, Hurry!
Cincy MLS #1774349
Sep 13, 2023
Price Changed
$240,000
$210/sq ft
Aug 1, 2023
Sold
$240,000
$210/sq ft
Jun 8, 2023
Pending
—
Jun 6, 2023
Listed
$250,000
$219/sq ft
+1
Tear-down / development opportunity, fantastic Loveland location! Conveniently Located, Five Minutes to Downtown Loveland with Tons of Shopping and Restaurants! 4.008 acres in Two Parcels. NOTE: existing home is not accessible for showings. Property as-is.
Public Records
Aug 8, 2023
Sold
$240,000
$210/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$4,202 (+111.9%)
$92,740
2024
$1,983 (+40.9%)
$43,740
2023
$1,407 (−50.0%)
$28,455 + $27,339
$55,794
2022
$2,814 (+4.9%)
$28,455 + $27,339
$55,794
2021
$2,682 (+5.0%)
$28,455 + $27,339
$55,794
2020
$2,554 (−1.7%)
$23,135 + $22,225
$45,360
2019
$2,597 (+2.0%)
$23,135 + $22,225
$45,360
2018
$2,546 (+13.0%)
$23,135 + $22,225
$45,360
2017
$2,253 (−2.3%)
$20,185 + $20,083
$40,268
2016
$2,306 (+25.9%)
$20,185 + $20,083
$40,268
2014
$1,832 (+1.7%)
$19,306 + $18,256
$37,562
2013
$1,801
$19,306 + $18,256
$37,562
Public record
Public record
Zoning
Beds
2
Baths
1
Stories
1
Lot width
—
Lot depth
—
Lot size
4.01 Acres
Year renovated
1979
Finished Sq. Ft.
1,142
Unfinished Sq. Ft.
—
Total Sq. Ft.
1,142
Year built
1954
Style
Single Family Residential
County
Warren County
APN
17311510040
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 8, 2026.
R-1
Rural Residence
It is the purpose of the R-1 Rural Residence District to establish and maintain an area that allows residential development densities based on the urban service area boundary, with low density
residential development outside the urban service area boundary, protecting rural character, natural
areas and agriculture, and increased residential densities inside the urban service area.
Permitted uses
Include but are not limited to:
Agriculture-Other
Housing-Single unit
Park & open space
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
7 days above 101° expected this year, 19 days in 30 years
2/10 Wind Factor
1% chance of strong winds in next 30 years
4/10 Air Factor
4 unhealthy days expected this year, 6 days in 30 years
Provided by First Street
Historical weather
Loveland, OH • 45140
Average low and high temperatures (°F)
34
17
44
25
62
40
70
48
71
53
83
64
86
70
82
62
82
57
70
46
54
38
43
29
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.1 hours in
June and 3.1 hours in December, placing it below the
U.S. average for solar exposure.
9.1 hrs
3.1 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 10475 Harrison Rd
We cannot show automated home-value estimates for this home.
Nearby homes have recently sold between $275,000 and $1,280,000.
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $275K to $1.3M.