$1,145,000
$50K PRICE DROP

Estimated payment $7,541/month

Total Views 2,583
4 Beds
3.5 Baths
4,695 Sq Ft
$244 Price per Sq Ft

Highlights

  • Eat-In Gourmet Kitchen
  • Deck
  • Outdoor Fireplace
  • Mercer Elementary School Rated A
  • 2-Story Property
  • Wood Flooring

About This Home

Stunning custom-built ranch by John Hueber offering over 4,500 sq ft of luxury living. The main level features a spacious owner's suite with custom stained-glass bath, a guest suite with ensuite, private study, formal dining room, and an open family room with gas fireplace and walkout to an expansive composite deck. The gourmet kitchen showcases Thermador/Sub-Zero appliances, double ovens, six-burner gas range, dual sinks, custom cabinetry, and new quartz countertops (2025). The walk-out lower level is perfect for entertaining with a wet bar, dishwasher, beverage cooler, 200-bottle wine cellar, two bedrooms, full bath, gas fireplace, and large storage room. Step outside to a professionally landscaped, terraced backyard featuring a putting green, wood-burning fireplace, and tranquil KOI pond. Meticulously maintained with new roof (2023), HVAC (2024), exterior paint (2024).Expansive storage space w/painted flr & built in work bench. The 3-car garage w/epoxy flrs & 8-zone surround sound

Listing Agent

Susan Huff

Huff Realty License #0000361432 Listed on: 10/15/2025

Huff Realty

Co-Listing Agent

Maria Schilling

Huff Realty License #2022005043

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $16,992

Year Built

  • Built in 2008

HOA Fees

  • $90 Monthly HOA Fees

Parking

  • 3 Car Garage

Home Design

  • 2-Story Property
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 4,695 Sq Ft Home
  • Wet Bar
  • Insulated Windows
  • Window Treatments
  • Family Room with Fireplace
  • Formal Dining Room

Kitchen

  • Eat-In Gourmet Kitchen
  • Double Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Quartz Countertops
  • Solid Wood Cabinet

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Dual Vanity Sinks in Primary Bathroom
  • Jetted Tub in Primary Bathroom

Laundry

  • Dryer
  • Washer

Finished Basement

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

Outdoor Features

  • Deck
  • Patio
  • Outdoor Fireplace

Utilities

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

Home Details

Home Type

Single Family

Est. Annual Taxes

$16,992

Year Built

Built in 2008

Lot Details

0

HOA Fees

$90 per month

Parking

3

Listing Details

  • Suburb: Anderson Twp.
  • Broker Approved: Yes
  • Miscellaneous: Other
  • Census Tract Realist: 251.01
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 21432.00
  • Suburb S I C: Anderson Twp.
  • Zoning: Residential
  • Basement Features: Finished, Walkout
  • Bathroom 4: Partial
  • Bathroom 4 Level: 1
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Dining Room Feat: Window Treatment, Wood Floor, Formal
  • Entry Foyer: Wood Floor
  • Family Room Feat: Walkout, Fireplace, Wood Floor
  • Great Room Feat: Walkout, Wall-to-Wall Carpet, Wet Bar
  • Living Great Rm Dim: 0 x 0
  • Single Family Desc: Single Family
  • Study Lib Den Dim: 0 x 0
  • Water Heating: Gas
  • Year Built: 2008
  • Architecture: Ranch
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Bedrooms: 4
  • Directions: Follow I-275 E to OH-32 W/State Rte 32 W in Union Township. Take exit 63A-B from I-275 E Continue on OH-32 W/State Rte 32 W. Drive to Ivy Trails.
  • Lot Measurement: Acres
  • Status: Active
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • ADU Y/N: No
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Bedroom 2: 13x15 Level: 1
  • Bedroom 3: 11x14 Level: Lower
  • Bedroom 4: 15x12 Level: Lower
  • Dining Room: 13x16 Level: 1
  • Family Room: 18x18 Level: 1
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $8496
  • Appliances: Dishwasher, Double Oven, Dryer, Gas Cooktop, Microwave, Refrigerator, Washer, Wine Cooler
  • Kitchen Features: Pantry, Quartz Counters, Eat-In, Tile Floor, Gourmet, Wood Cabinets
  • Basement: Full
  • Entry: 11x13 Level: 1
  • Bathrooms: 4.00
  • Great Room: 22x14 Level: Lower
  • Kitchen Dim: 14 x 19
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 1
  • Bathroom 3: Full
  • Bathroom 3 Level: Lower
  • Laundry Room: 14x7 Level: 1
  • Laundryroom Dim: 14 x 7
  • Recreation Room Dim: 0 x 0
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 4695.00
  • Windows: Insulated
  • PrimaryBedroomDim: 14 x 20
  • Primary Bathrooms: Shower, Tile Floor, Double Vanity, Jetted Tub, Window Treatment
  • PrimaryBedFeat: Bath Adjoins, Wall-to-Wall Carpet, Window Treatment
  • P R I M A R Y B E D R O O M: 14x20 Level: 1

Exterior Features

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

Garage/Parking

  • Garage Spaces: 3.00
  • Garage Carport: Built in

Utilities

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

Condo/Co-op/Association

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

Schools

  • District: Forest Hills Local S

Lot Info

  • Total Assessed Value: 279962

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Map

Range of Values:

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

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
2024 $16,992 $279,962 $55,405 $224,557
2023 $16,162 $279,962 $55,405 $224,557
2022 $14,370 $221,673 $55,405 $166,268
2021 $14,029 $221,673 $55,405 $166,268
2020 $14,191 $221,673 $55,405 $166,268
2019 $14,209 $201,520 $50,369 $151,151
2018 $13,308 $201,520 $50,369 $151,151
2017 $12,551 $201,520 $50,369 $151,151
2016 $14,116 $221,484 $40,611 $180,873
2015 $13,709 $221,484 $40,611 $180,873
2014 $13,718 $221,484 $40,611 $180,873
2013 $13,358 $228,333 $41,867 $186,466
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/03/2025 11/03/25 Price Changed $1,145,000 -4.2% $244 / Sq Ft
10/15/2025 10/15/25 For Sale $1,195,000 -- $255 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Purchase History

Date Type Sale Price Title Company
Warranty Deed $391,893 Attorney
Warranty Deed $201,200 None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $2,500,000 Unknown
Source: Public Records

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1858298

MLS of Greater Cincinnati (CincyMLS)

APN: 500-0060-0299