$833,000
SOLD OCT 16, 2025
5 Beds
4.5 Baths
6,064 Sq Ft
2005 Built

Recently Sold

$137 Per Sq Ft

7% Below List Price

120 Days on Market

Highlights

  • Deck
  • Transitional Architecture
  • Wood Flooring
  • Sherwood Elementary School Rated A
  • Cathedral Ceiling
  • Main Floor Bedroom

About This Home

As of October 2025

Stately 5-bedroom home, where elegance meets comfort. As you enter, you'll be greeted by a spacious open foyer that leads to soaring cathedral ceilings, creating an inviting atmosphere perfect for entertaining guests. The luxurious primary suite is a true retreat, featuring a cozy lounging area and expansive walk-in closet. The full finished basement is an entertainer's dream. Complete with a service bar and pool table, it's the ideal space for hosting large gatherings or enjoying a quiet night in. Step outside to the wrap-around rear porch, where you can unwind and enjoy the private and serene surroundings. The generous 3-car garage offers ample space for vehicles and storage, making this home as practical as it is beautiful. Don't miss the opportunity to make this showpiece property yours! Schedule a showing to experience all this home has to offer.

Last Agent to Sell the Property

Natasha Young

Plum Tree Realty License #2018004798 Listed on: 05/24/2025

Plum Tree Realty

Last Buyer's Agent

Jamie Wagenlander

Huff Realty License #2007002881

Huff Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,668

Year Built

  • Built in 2005

HOA Fees

  • $480 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Driveway
  • Off-Street Parking

Home Design

  • Transitional Architecture
  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 6,064 Sq Ft Home
  • 2-Story Property
  • Cathedral Ceiling
  • Ceiling Fan
  • Double Hung Windows
  • Picture Window
  • Wood Flooring

Kitchen

  • Breakfast Bar
  • Convection Oven
  • Electric Cooktop
  • Warming Drawer
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom
  • Jetted Tub in Primary Bathroom

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Outdoor Features

  • Balcony
  • Deck
  • Patio

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Tankless Water Heater

Community Details

  • Association fees include association dues, landscapingcommunity, professional mgt
  • Apple Hill Farm HOA

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,668

Year Built

Built in 2005

Lot Details

0

HOA Fees

$480 per month

Parking

3

Listing Details

  • Suburb: Anderson Twp.
  • Broker Approved: Yes
  • Miscellaneous: Ceiling Fan
  • Census Tract Realist: 275.00
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 24786.00
  • Suburb S I C: Anderson Twp.
  • Zoning: Residential
  • Basement Features: Finished, WW Carpet
  • Bathroom 4: Full
  • Bathroom 4 Level: Basement
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Living Great Rm Dim: 18 x 13
  • Mechanical Systems: Sump Pump
  • Single Family Desc: Single Family
  • Study Lib Den: 12x9 Level: 1
  • Study Lib Den Dim: 12 x 9
  • Water Heating: Tankless
  • Year Built: 2005
  • H O A Paid By: Owner
  • Architecture: Traditional, Transitional
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Bedrooms: 5
  • Directions: Left on Kellogg Ave/Ohio River Scenic Byway, then take Salem Rd. exit and then turn onto Apple Farm Lane
  • Lot Measurement: Acres
  • Status: Sold
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • ADU Y/N: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Cathedral Ceiling
  • Bedroom 2: 14x12 Level: 2
  • Bedroom 3: 16x12 Level: 2
  • Bedroom 4: 16x13 Level: 2
  • Bedroom 5: 19x17 Level: 2
  • Dining Room: 17x11 Level: 1
  • Living Room: 18x13 Level: 1
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $4334
  • Appliances: Convection Oven, Dishwasher, Electric Cooktop, Garbage Disposal, Microwave, Refrigerator, Warming Drawer
  • Kitchen Features: Pantry, Counter Bar, Island, Wood Floor
  • Basement: Full
  • Bathrooms: 5.00
  • Kitchen Dim: 18 x 13
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Laundryroom Dim: 0 x 0
  • Recreation Room Dim: 0 x 0
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 6064.00
  • Windows: Picture, Double Hung
  • PrimaryBedroomDim: 17 x 17
  • Primary Bathrooms: Shower, Double Vanity, Jetted Tub
  • PrimaryBedFeat: Bath Adjoins, Walk-in Closet
  • P R I M A R Y B E D R O O M: 17x17 Level: 1

Exterior Features

  • Roof: Shingle
  • Construction: Brick
  • Outside Features: Balcony, Deck, Patio
  • Foundation: Poured
  • Listing Price: 850000.00
  • New Construction: No

Garage/Parking

  • Garage Spaces: 3.00
  • Garage Carport: Oversized, Garage Attached
  • Parking: Off Street, Driveway

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 1440.00
  • Fee Frequency: Quarterly
  • HOA Management Co: Apple Hill Farm HOA
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service

Fee Information

  • Inc.In HOA/Condo Fee: Association Dues, LandscapingCommunity, Professional Mgt

Schools

  • District: Forest Hills Local S

Lot Info

  • Total Assessed Value: of record

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 24, 2025
Closed on
Oct 16, 2025
Sold by
Leith Ryan and Ly Phuong
Bought by
Lynch Family Trust and Lynch
Seller's Agent
Natasha Young
Plum Tree Realty
Buyer's Agent
Jamie Wagenlander
Huff Realty
List Price
$899,000
Sold Price
$833,000
Premium/Discount to List
-$66,000
-7.34%
Views
304
Current Estimated Value
$877,521

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$44,521
Avg. Annual Appreciation
17.67%

Purchase Details

Listed on
Apr 16, 2021
Closed on
May 28, 2021
Sold by
Scheidt Dale R and Scheidt Kim
Bought by
Leith Ryan and Ly Phuong
Seller's Agent
Kathy Bryant
eXp Realty
Buyer's Agent
Natasha Young
Plum Tree Realty
Sold Price
$815,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.50%

Purchase Details

Closed on
Jul 28, 2004
Sold by
Fifth Third Bank
Bought by
Scheidt Dale R and Scheidt Kim

Purchase Details

Closed on
May 23, 2000
Sold by
Apple Hill Development Company
Bought by
Fifth Third Bank
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Deed $833,000 None Listed On Document
Warranty Deed $815,000 Parkway Title Llc
Fiduciary Deed $107,000 --
Warranty Deed $234,400 --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/16/2025 10/16/25 Sold $833,000 -2.0% $137 / Sq Ft
09/21/2025 09/21/25 Pending -- -- --
08/15/2025 08/15/25 Price Changed $850,000 -4.0% $140 / Sq Ft
07/18/2025 07/18/25 Price Changed $885,000 -1.6% $146 / Sq Ft
07/08/2025 07/08/25 For Sale $899,000 0.0% $148 / Sq Ft
07/06/2025 07/06/25 Pending -- -- --
06/19/2025 06/19/25 Price Changed $899,000 -2.8% $148 / Sq Ft
05/24/2025 05/24/25 For Sale $925,000 +13.5% $153 / Sq Ft
05/28/2021 05/28/21 Sold $815,000 +1.9% $134 / Sq Ft View Prior Sale
04/23/2021 04/23/21 Pending -- -- --
04/23/2021 04/23/21 For Sale -- -- --
04/22/2021 04/22/21 For Sale -- -- --
04/21/2021 04/21/21 For Sale -- -- --
04/20/2021 04/20/21 For Sale -- -- --
04/16/2021 04/16/21 For Sale $799,900 -- $132 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $17,821 $285,250 $40,096 $245,154
2024 $17,318 $285,250 $40,096 $245,154
2023 $16,473 $285,250 $40,096 $245,154
2022 $17,754 $273,841 $41,192 $232,649
2021 $17,333 $273,841 $41,192 $232,649
2020 $17,533 $273,841 $41,192 $232,649
2019 $17,089 $242,337 $36,453 $205,884
2018 $16,007 $242,337 $36,453 $205,884
2017 $15,095 $242,337 $36,453 $205,884
2016 $13,993 $219,454 $37,083 $182,371
2015 $13,590 $219,454 $37,083 $182,371
2014 $13,599 $219,454 $37,083 $182,371
2013 $12,248 $209,003 $35,315 $173,688
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1841852

MLS of Greater Cincinnati (CincyMLS)

APN: 500-0480-0235