Lodge like home incorporating stone, Douglas fir beams, and Alderwood from Park City Utah. This custom designed home with Hardie Plank siding sits on 7 wooded acres in this beautiful nature preserve development. Custom kitchen features Wolf stove, Sub Zero refrigerator, with massive walk-in pantry, and coffee bar. The welcoming entry features a stone wall for plantings. First floor study features panoramic views and custom built-ins. Three porches (two screened) (one porch with a stone fireplace), offer panoramic views and an area perfect for winding down at the end of a busy work day. Curly maple wood floors add to the rustic appeal. 3 bedrooms feature walk in closets with custom cabinets. The 40 x 20 ft pool which with automatic cover, and flagstone decking surrounding the pool area which highlights the back yard. A 3 car garage adds additional storage for cars and outdoor toys. What a place to call home.
Lodge-like winter Riverview home. 7 acres of privacy & serenity; built in 2004. High end finishes, quality materials, one of a kind. Driving thru neighborhood feels like a state park! Beautiful!
Cincy MLS #854095
Mar 26, 2004
Sold
$275,000
$49/sq ft
Sep 11, 2003
Listed
$325,000
$58/sq ft
Gorgeous river/Kentucky view ,wooded lot. One of the last in Locust Hill- Private rural setting in area of noce homes. 25 minutes to downtown - near shopping in Anderson- A must see
Cincy MLS #829384
Sep 11, 2003
Listing Removed
—
Mar 28, 2003
Listed
$295,000
$52/sq ft
Public Records
Jul 14, 1986
Sold
$90,000
$16/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$19,167 (+6.7%)
$103,320 + $338,280
$441,600
2024
$17,965
$103,320 + $338,280
$441,600
2023
$17,962 (+28.3%)
$103,320 + $338,280
$441,600
2022
$13,998 (+1.7%)
$64,050 + $211,230
$275,280
2021
$13,767 (+0.3%)
$64,050 + $211,230
$275,280
2020
$13,728 (−4.7%)
$64,050 + $211,230
$275,280
2019
$14,410 (+0.1%)
$63,910 + $260,930
$324,840
2018
$14,395
$63,910 + $260,930
$324,840
2017
$14,409 (−4.4%)
$63,910 + $260,930
$324,840
2016
$15,076 (+8.7%)
$61,460 + $250,880
$312,340
2014
$13,863
$61,460 + $250,880
$312,340
Public record
Public record
Zoning
Beds
2
Baths
3.5
Stories
1
Lot width
—
Lot depth
—
Lot size
6.99 Acres
Year renovated
—
Finished Sq. Ft.
5,639
Unfinished Sq. Ft.
—
Total Sq. Ft.
5,639
Year built
2005
Style
Single Family Residential
County
Clermont County
APN
272811B057.
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 13, 2026.
SFR
Single-Family Residential District
The Single-Family Residential District is intended to serve as the primary single-family residential housing district in Pierce Township. This district provides for suburban density developments when developments have access to sewer while also providing for reasonable, low-density development in the rural areas of the Township.
Permitted uses
Include but are not limited to:
Housing-Single unit
Housing-Senior
Infrastructure
Public service
Recreation
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 102° expected this year, 19 days in 30 years
2/10 Wind Factor
1% chance of strong winds in next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 3 days in 30 years
Provided by First Street
Historical weather
Cincinnati, OH • 45245
Average low and high temperatures (°F)
34
19
44
27
62
40
69
49
71
54
84
65
88
70
83
63
82
59
70
48
55
39
44
30
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
67/ 100
Moderate sunlight
Sunscore
There appears to be some shading by surrounding buildings, terrain, and vegetation.
9 hrs
4.1 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 41 Locust Hill Rd
We cannot show automated home-value estimates for this home.
Nearby homes have recently sold between $720,000 and $1,100,000.
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $720K to $1.1M.