Set on more than 5+ scenic acres, this 4-bedroom property offers space, updates, and standout outdoor features. A large, stocked pond anchors the landscape, complete with an aerator, lighting, electric box, 17'depth & dock. Inside, the family room showcases a vaulted ceiling and fireplace, creating a warm gathering space. The kitchen includes granite countertops, a breakfast area, and all new appliances. Recent improvements throughout the home include all new LVP flooring, fresh interior paint across the first and second floors, updated lighting, and new vanities, sinks, and faucets in all three bathrooms. Additional updates include new gutters and downspouts (2025). The new deck (2024) provides a great vantage point to take in the surrounding property, including the impressive 30x72 pole barn with two 10'x10' electric doors offering ample space for storage, hobbies, or equipment.
For sale
$700,000
5740 Hendrickson Rd, Franklin, OH 45005
4beds
2,335sqft
Est.:
Single Family Residence
Built in 1987
5.87 Acres Lot
$-- Zestimate®
$300/sqft
$-- HOA
What's special
Large stocked pondVaulted ceilingNew deckGranite countertopsFresh interior paintUpdated lightingBreakfast area
- 7 hours |
- 116 |
- 8 |
Zillow last checked: 7 hours ago
Listing updated: 14 hours ago
Listed by:
Lana M. Sprague 513-328-7676,
Keller Williams Advisors 513-874-3300,
Denise L Gifford 513-290-1443,
Keller Williams Advisors
Source: Cincy MLS,MLS#: 1871044
Originating MLS: Cincinnati Area Multiple Listing Service

Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Other
- Level: Second
- Area: 216
- Dimensions: 18 x 12
Bedroom 2
- Level: Second
- Area: 192
- Dimensions: 16 x 12
Bedroom 3
- Level: Second
- Area: 165
- Dimensions: 15 x 11
Bedroom 4
- Level: First
- Area: 110
- Dimensions: 10 x 11
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Shower, Other
Bathroom 1
- Features: Full
- Level: First
Bathroom 2
- Features: Full
- Level: Second
Bathroom 3
- Features: Full
- Level: Second
Dining room
- Features: Other
- Level: First
- Area: 120
- Dimensions: 12 x 10
Family room
- Features: Bookcases, Walkout, Fireplace, Other
- Area: 294
- Dimensions: 21 x 14
Kitchen
- Features: Eat-in Kitchen, Walkout, Marble/Granite/Slate, Other
- Area: 144
- Dimensions: 12 x 12
Living room
- Features: Other
- Area: 224
- Dimensions: 16 x 14
Office
- Area: 0
- Dimensions: 0 x 0
Heating
- Electric, Gas, Heat Pump
Cooling
- Central Air
Appliances
- Included: Dishwasher, Microwave, Oven/Range, Refrigerator, Gas Water Heater
Features
- Vaulted Ceiling(s), Ceiling Fan(s), Recessed Lighting
- Doors: French Doors, Multi Panel Doors
- Windows: Double Hung, Wood Frames, Insulated Windows
- Basement: Partial,Partially Finished,Walk-Out Access
- Attic: Storage
- Number of fireplaces: 1
- Fireplace features: Brick, Insert, Wood Burning, Family Room
Interior area
- Total structure area: 2,335
- Total interior livable area: 2,335 sqft
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Driveway, Garage Door Opener
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Porch
- Has view: Yes
- View description: Lake/Pond, Valley, Trees/Woods
- Has water view: Yes
- Water view: Lake/Pond
- Waterfront features: Lake/Pond
Lot
- Size: 5.87 Acres
- Features: 5 to 9.9 Acres
Details
- Additional structures: Pole Barn
- Parcel number: 0832176008
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Brick, Vinyl Siding
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 1987
Utilities & green energy
- Electric: 220 Volts
- Gas: Propane
- Sewer: Septic Tank, Other
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Franklin
Financial & listing details
- Price per square foot: $300/sqft
- Tax assessed value: $458,770
- Annual tax amount: $6,398
- Date on market: 3/12/2026
- Listing terms: No Special Financing
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 3/12/2026 | Listed for sale | $700,000+180%$300/sqft |
Source: | ||
| 6/2/1999 | Sold | $250,000$107/sqft |
Source: | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $6,383 +13.8% | $160,570 +25.8% |
| 2023 | $5,611 +1.2% | $127,650 +0% |
| 2022 | $5,544 +7.8% | $127,644 0% |
| 2021 | $5,143 +2.5% | $127,645 +23% |
| 2020 | $5,019 -0.6% | $103,775 |
| 2019 | $5,048 +10.1% | $103,775 |
| 2018 | $4,586 +1.4% | $103,775 +12.6% |
| 2017 | $4,523 -3.3% | $92,148 |
| 2016 | $4,676 -0.8% | $92,148 |
| 2015 | $4,713 | $92,148 +9% |
| 2014 | $4,713 +4.2% | $84,540 -14.7% |
| 2013 | $4,525 +3.7% | $99,060 |
| 2012 | $4,364 -3.2% | $99,060 -1.7% |
| 2011 | $4,509 +10.7% | $100,730 |
| 2010 | $4,072 -1.1% | $100,730 |
| 2009 | $4,117 +4.9% | $100,730 |
| 2008 | $3,925 | $100,730 |
| 2007 | -- | $100,730 +1.8% |
| 2006 | -- | $98,960 +2.9% |
| 2005 | -- | $96,170 |
| 2004 | -- | $96,170 |
| 2003 | -- | $96,170 +11.3% |
| 2002 | -- | $86,420 |
| 2001 | -- | $86,420 +7.4% |
| 2000 | -- | $80,470 +13.3% |
| 1999 | -- | $71,050 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$3,999/mo
Principal & interest
$3346
Property taxes
$653
More affordability tools
Climate risks
Neighborhood: 45005
Nearby schools
GreatSchools rating
- NABowman Primary SchoolGrades: PK-2Distance: 5.2 mi
- 5/10Lebanon Junior High SchoolGrades: 7-8Distance: 6 mi
- 8/10Lebanon High SchoolGrades: 8-12Distance: 7.1 mi







