Public Remarks: Serenity awaits on 3.17 private wooded acres! This immaculate ranch with loft offers approximately 4,800 sq. ft. of beautifully designed living space with spectacular views and abundant natural light from every window. Wide-plank hardwood floors and fresh paint welcome you inside. The soaring great room features skylights, a wood stove, and an open loft overlooking the main living area. The spacious kitchen offers white cabinetry, granite countertops, a full appliance package, and adjoins the bright breakfast room and screened porch, perfect for gathering with family and friends. A formal dining room and study with custom built-ins add versatility. The private primary suite features a fireplace, custom cabinetry, deluxe bath, walk-in closet, and walkout to the tiered deck. Two additional bedrooms, a finished walkout lower level, wooded acreage with a creek, fire pit, and convenient access to shopping, schools, and highways complete this exceptional property.
Serenity awaits on 3.17 private wooded acres! This immaculate ranch with loft offers approximately 4,800 sq. ft. of beautifully designed living space with spectacular views and abundant natural light from every window. Wide-plank hardwood floors and fresh paint welcome you inside. The soaring great room features skylights, a wood stove, and an open loft overlooking the main living area. The spacious kitchen offers white cabinetry, granite countertops, a full appliance package, and adjoins the bright breakfast room and screened porch, perfect for gathering with family and friends. A formal dining room and study with custom built-ins add versatility. The private primary suite features a fireplace, custom cabinetry, deluxe bath, walk-in closet, and walkout to the tiered deck. Two additional bedrooms, a finished walkout lower level, wooded acreage with a creek, fire pit, and convenient access to shopping, schools, and highways complete this exceptional property.
Cincy MLS #1887116
Aug 20, 2026
Contingent
—
Jul 16, 2026
Listed
$800,000
$299/sq ft
Public Records
Dec 14, 1992
Sold
$37,900
$14/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$7,061 (−2.5%)
$47,270 + $144,970
$192,240
2024
$7,246 (+125.3%)
$47,270 + $144,970
$192,240
2023
$3,217 (−50.0%)
$28,480 + $128,496
$156,976
2022
$6,433 (+7.8%)
$28,480 + $128,496
$156,976
2021
$5,969 (+3.9%)
$28,480 + $128,496
$156,976
2020
$5,747 (−0.6%)
$23,153 + $104,468
$127,621
2019
$5,780 (+10.4%)
$23,153 + $104,468
$127,621
2018
$5,237 (+1.3%)
$23,153 + $104,468
$127,621
2017
$5,172 (−3.3%)
$20,472 + $93,940
$114,412
2016
$5,346 (+5.5%)
$20,472 + $93,940
$114,412
2014
$5,069 (−0.1%)
$19,198 + $84,630
$103,828
2013
$5,075
$19,198 + $84,630
$103,828
Public record
Beds
3
Baths
3
Stories
1
Lot width
—
Lot depth
—
Lot size
3.18 Acres
Year renovated
—
Finished Sq. Ft.
2,673
Unfinished Sq. Ft.
—
Total Sq. Ft.
2,673
Year built
1995
Style
Single Family Residential
County
Warren County
APN
8073000340
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 25, 2026.
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
3/10 Heat Factor
6 days above 101° expected this year, 17 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
Lebanon, OH • 45036
Average low and high temperatures (°F)
33
16
43
24
61
39
69
47
71
52
84
64
87
70
82
62
82
58
70
46
54
38
43
28
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
93/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.7 hrs
5.6 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 1883 Greentree Rd
We cannot show automated home-value estimates for this home.
Nearby homes have recently sold between $399,900 and $800,000.
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $400K to $800K.