$875,000
SOLD AUG 14, 2026
4 Beds
3.5 Baths
4,245 Sq Ft
0.5 Acre Lot

Sale Details

Date Sold: August 14, 2026

$206 Per Sq Ft

12% Below List Price

16 Days on Market

Highlights

  • Gourmet Kitchen
  • View of Trees or Woods
  • Great Room with Fireplace
  • Mercer Elementary School Rated A
  • Deck
  • Wooded Lot

About This Home

As of August 2026

Rare opportunity to own a one-owner custom Zicka Walker ranch in Ivy Trails! Thoughtfully designed for executive living, this exceptional home offers approximately 4,030 finished sq. ft. on a private .49-acre wooded lot backing to 53+ acres of preserved woodlands with 2.5 miles of private trails. Rich walnut trim, custom built-ins, soaring ceilings, and expansive windows showcase the craftsmanship throughout. The expanded ranch floor plan offers 4 bedrooms, 3 full baths, private study, formal dining room, great room with stone fireplace, and a bright walkout lower level with home theater, recreation room, and abundant storage. Enjoy the screened porch with fireplace, composite deck, custom waterfall, and direct trail access. Located on a quiet cul-de-sac in the award-winning Forest Hills School District.

Last Agent to Sell the Property

Amy Broghamer

eXp Realty License #2005008894 Listed on: 07/01/2026

eXp Realty

Last Buyer's Agent

Karen Scherer

Coldwell Banker Realty License #0000426290

Coldwell Banker Realty

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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,572

Year Built

  • Built in 2005

Lot Details

  • 21,636 Sq Ft Lot
  • Cul-De-Sac
  • Sprinkler System
  • Wooded Lot

HOA Fees

  • $90 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway
  • Off-Street Parking

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 4,245 Sq Ft Home
  • Bookcases
  • Woodwork
  • Vaulted Ceiling
  • Chandelier
  • Stone Fireplace
  • Brick Fireplace
  • Gas Fireplace
  • Double Pane Windows
  • Double Hung Windows
  • Wood Frame Window
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Great Room with Fireplace
  • 2 Fireplaces
  • Views of Woods

Kitchen

  • Gourmet Kitchen
  • Double Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub

Laundry

  • Dryer
  • Washer

Partially Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Home Security

  • Smart Security System
  • Smart Thermostat

Outdoor Features

  • Deck
  • Enclosed Patio or Porch
  • Exterior Lighting

Utilities

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

Community Details

  • Association fees include association dues, professional mgt, walking trails
  • Town Properties Association
  • Ivy Trails Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,572

Year Built

Built in 2005

Lot Details

0.5 Acres

HOA Fees

$90 per month

Parking

2

Listing Details

  • Suburb: Anderson Twp.
  • Cross Street: Ravenwood
  • Topography: Cleared,Sloped
  • Land Description: Less than .5 Acre
  • Broker Approved: Yes
  • Census Tract Realist: 251.01
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 21636.00
  • Suburb S I C: Anderson Twp.
  • Zoning: Residential
  • Accessibility Features: No
  • Basement Features: Part Finished, Unfinished, Walkout, WW Carpet
  • Bathroom 4: Partial
  • Bathroom 4 Level: 1
  • Level 1 Bathroom Type: Full, Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Dining Room Feat: Chandelier, Wood Floor
  • Entry Foyer: Closet, Open Foyer, Wood Floor
  • Great Room Feat: Bookcases, Wall-to-Wall Carpet, Fireplace
  • Living Great Rm Dim: 0 x 0
  • Mechanical Systems: Garage Door Opener
  • Single Family Desc: Single Family
  • Smart Technology: Garage Door Opener, Security, Thermostat
  • Study Lib Den: 11x13 Level: 1
  • Study Lib Den Dim: 11 x 13
  • Water Heating: Gas
  • Year Built: 2005
  • H O A Paid By: Owner
  • Architecture: Ranch
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Bedrooms: 4
  • Directions: Eight Mile Road to Stoney Bridge to Ivy Trails to Ravenwood to R on Trailview, home on R
  • Lot Measurement: Acres
  • MLS Status: Sold
  • On Market Date: 2026-07-01
  • Property Subtype 1: Single Family Residence
  • Standard Status: Closed
  • Suburb (SIC): Ivy Trails
  • Occupancy: At Closing
  • ADU Y/N: No
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Multi Panel Doors, Natural Woodwork, Vaulted Ceiling
  • Bedroom 2: 13x14 Level: 1
  • Bedroom 3: 15x14 Level: Lower
  • Bedroom 4: 14x27 Level: Lower
  • Breakfast Room: 14x9 Level: 1
  • Dining Room: 14x12 Level: 1
  • Recreation Room: 23x31 Level: Lower
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $7786
  • Appliances: Dishwasher, Double Oven, Dryer, Garbage Disposal, Gas Cooktop, Microwave, Refrigerator, Washer
  • Kitchen Features: Pantry, Walkout, Gourmet, Island, Wood Cabinets, Wood Floor, Marble/Granite/Slate
  • Basement: Full
  • Study Features: Bookcases, Wall-to-Wall Carpet, French Doors, Panel Walls
  • Entry: 18x10 Level: 1
  • Bathrooms: 4.00
  • Great Room: 20x15 Level: 1
  • Kitchen Dim: 15 x 14
  • Levels: One
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 1
  • Bathroom 3: Full
  • Bathroom 3 Level: Lower
  • Laundry Room: 9x6 Level: 1
  • Laundryroom Dim: 9 x 6
  • Recreation Room Dim: 23 x 31
  • Fireplace: Brick, Stone, Gas
  • Fireplaces: 2
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 4245.00
  • Windows: Double Hung, Double Pane, Wood
  • PrimaryBedroomDim: 15 x 17
  • Primary Bathrooms: Shower, Tile Floor, Double Vanity, Tub
  • PrimaryBedFeat: Bath Adjoins, Walk-in Closet, Wall-to-Wall Carpet, Window Treatment
  • P R I M A R Y B E D R O O M: 15x17 Level: 1

Exterior Features

  • View: Woods
  • Roof: Shingle
  • Construction: Brick
  • Outside Features: Cul de sac, Deck, Enclosed Porch, Sprinklers, Wooded Lot, Yard Lights
  • Foundation: Poured
  • Listing Price: 900000.00
  • Acres: 0.4967
  • New Construction: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage Carport: Built in, Front, Garage Attached
  • Parking: Off Street, Driveway

Utilities

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

Condo/Co-op/Association

  • HOA Fees: 1075.00
  • Fee Frequency: Annually
  • HOA Management Co: Town Properties
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service

Fee Information

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

Schools

  • District: Forest Hills Local S

Green Features

  • Energy Green Features: No

Lot Info

  • Lot Size Sq Ft: 21636.00
  • Total Assessed Value: Of Record

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 1, 2026
Closed on
Aug 13, 2026
Sold by
Cooper Randal B and Ann Ruth
Bought by
Seller's Agent
Amy Broghamer
eXp Realty
Buyer's Agent
Karen Scherer
Coldwell Banker Realty
List Price
$1,000,000
Sold Price
$875,000
Premium/Discount to List
-$125,000
-12.5%
Views
21

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
227.81%
Original Mortgage
$700,000
Outstanding Balance
$699,366
Interest Rate
6.49%
Mortgage Type
New Conventional
Estimated Equity
$297,705

Purchase Details

Closed on
Jan 16, 2006
Sold by
Zicka Walker Homes At Ivy Trails Llc
Bought by
Cooper Randal B

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$119,995
Interest Rate
6.37%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Aug 25, 2005
Sold by
Ivy Trails Llc
Bought by
Zicka Walker Homes At Ivy Trails Llc
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Dry Run, OH

See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Warranty Deed -- First Title Inc
Warranty Deed $170,600 None Available
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Closed $417,000 New Conventional
Closed $119,995 Credit Line Revolving
Closed $639,977 Fannie Mae Freddie Mac
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
08/14/2026 08/14/26 Sold $875,000 -2.8% $206 / Sq Ft
07/17/2026 07/17/26 Pending -- -- --
07/13/2026 07/13/26 Price Changed $900,000 -7.7% $212 / Sq Ft
07/08/2026 07/08/26 Price Changed $975,000 -2.5% $230 / Sq Ft
07/01/2026 07/01/26 For Sale $1,000,000 -- $236 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $15,573 $249,222 $55,934 $193,288
2024 $15,135 $249,222 $55,934 $193,288
2023 $14,395 $249,222 $55,934 $193,288
2022 $13,533 $208,657 $55,934 $152,723
2021 $13,213 $208,657 $55,934 $152,723
2020 $13,359 $208,657 $55,934 $152,723
2019 $13,376 $189,686 $50,848 $138,838
2018 $12,529 $189,686 $50,848 $138,838
2017 $11,816 $189,686 $50,848 $138,838
2016 $11,937 $187,237 $40,723 $146,514
2015 $11,593 $187,237 $40,723 $146,514
2014 $11,600 $187,237 $40,723 $146,514
2013 $11,308 $193,029 $41,983 $151,046
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1885188

MLS of Greater Cincinnati (CincyMLS)

APN: 500-0060-0291

Your Personal Tour Guide

Ask me questions while you tour the home.