$1,800,000
SOLD MAY 29, 2026
5 Beds
7 Baths
8,154 Sq Ft
4.69 Acre Lot

Sale Details

Date Sold: May 29, 2026

$221 Per Sq Ft

7 Days on Market

Highlights

  • Eat-In Gourmet Kitchen
  • Sitting Area In Primary Bedroom
  • 4.69 Acre Lot
  • Ayer Elementary School Rated A
  • View of Trees or Woods
  • Fireplace in Primary Bedroom

About This Home

As of May 2026

Experience timeless elegance and exceptional privacy in this custom-built Ed Weber masterpiece, offering over 8,000 SF of refined living on 4.7 beautifully landscaped acres adjacent to Coldstream Country Club. A stately gated entrance welcomes you to a home featuring 5 bedrooms, 7 baths, and a dramatic two-story great room with coffered ceilings. The chef's kitchen with an expansive island and fireside sitting area is designed for both comfort and entertaining. The partially finished lower level offers endless potential for a golf simulator, theater, or fitness space. Outdoors, enjoy a resort-style gunite pool with waterfall, a redesigned paver patio, and lush, private surroundings. A rare offering in one of Cincinnati's most sought-after communities.

Last Agent to Sell the Property

Joseph Stevie

Sparen Realty License #2018002831 Listed on: 04/16/2026

Last Buyer's Agent

Bobbie Richerson

Fathom Realty Ohio License #2025003462

Fathom Realty Ohio

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $37,010

Year Built

  • Built in 1995

Lot Details

  • 4.69 Acre Lot

Parking

  • 3 Car Garage
  • Driveway
  • Off-Street Parking

Property Views

  • Woods
  • Valley

Home Design

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

Interior Spaces

  • 8,154 Sq Ft Home
  • 2-Story Property
  • Bookcases
  • Chandelier
  • Marble Fireplace
  • Stone Fireplace
  • Gas Fireplace
  • Double Hung Windows
  • Wood Frame Window
  • Casement Windows
  • Entrance Foyer
  • Family Room with Fireplace
  • 4 Fireplaces

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Kitchen Island

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Sitting Area In Primary Bedroom
  • Main Floor Bedroom
  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub
  • Built-In Shower Bench

Finished Basement

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

Utilities

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

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$37,010

Year Built

Built in 1995

Lot Details

4.69 Acres

Parking

3

Listing Details

  • Suburb: Anderson Twp.
  • Land Description: 1 to 4.9 Acres
  • Access: City Street
  • Broker Approved: Yes
  • Census Tract Realist: 275.00
  • Cooling: Central Air
  • Heating: Forced Air, Gas, Zoned
  • Lot Area Realist: 204253.00
  • Suburb S I C: Anderson Twp.
  • Zoning: Residential
  • Basement Features: Finished, Fireplace, Walkout, WW Carpet
  • Bathroom 4: Full
  • Bathroom 4 Level: 1
  • Level 1 Bathroom Type: Full, Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Dining Room Feat: Chandelier
  • Entry Foyer: Open Foyer, Tile Floor
  • Family Room Feat: Bookcases, Fireplace
  • Living Great Rm Dim: 0 x 0
  • Single Family Desc: Single Family
  • Study Lib Den: 15x11 Level: 1
  • Study Lib Den Dim: 15 x 11
  • Water Heating: Gas
  • Year Built: 1995
  • Architecture: Traditional, Transitional
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Bedrooms: 5
  • Directions: I-275 to Five Mile Rd, R on 5 Mile, L to property.
  • Lot Measurement: Acres
  • Status: Sold
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • Second Floor Area: 2423
  • ADU Y/N: No
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Bedroom 2: 14x13 Level: 1
  • Bedroom 3: 13x12 Level: 2
  • Bedroom 4: 15x12 Level: 2
  • Bedroom 5: 16x15 Level: 2
  • Dining Room: 16x15 Level: 1
  • Family Room: 16x12 Level: 1
  • Recreation Room: 34x18 Level: Lower
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $18505
  • Kitchen Features: Pantry, Counter Bar, Eat-In, Gourmet, Island, Marble/Granite/Slate
  • Basement: Full
  • Study Features: Bookcases, Window Treatment, Wood Floor
  • Entry: 18x9 Level: 1
  • Bathrooms: 7.00
  • Great Room: 23x21 Level: 1
  • Kitchen Dim: 24 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
  • Laundry Room: 9x7 Level: 1
  • Laundryroom Dim: 9 x 7
  • Recreation Room Dim: 34 x 18
  • Fireplace: Marble, Stone, Gas
  • Fireplaces: 4
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 8154.00
  • Windows: Casement, Double Hung, Wood
  • PrimaryBedroomDim: 29 x 28
  • Primary Bathrooms: Built-In Shower Seat, Shower, Double Vanity, Tub
  • PrimaryBedFeat: Bath Adjoins, Walk-in Closet, Fireplace, Sitting Room
  • P R I M A R Y B E D R O O M: 29x28 Level: 2

Exterior Features

  • View: Valley, Woods
  • Roof: Shingle
  • Construction: Brick
  • Foundation: Poured
  • Listing Price: 1799999.00
  • Acres: 4.6900
  • New Construction: No

Garage/Parking

  • Garage Spaces: 3.00
  • Garage Carport: Built in, Side
  • Parking: Off Street, Driveway

Utilities

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

Condo/Co-op/Association

  • HOA Yes/No: No
  • Association: Cincinnati Area Multiple Listing Service

Schools

  • District: Forest Hills Local S

Lot Info

  • Lot Size Sq Ft: 204296.00
  • Total Assessed Value: 1,732,860

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

Closed on
Mar 2, 2005
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,332,500
Interest Rate
5.41%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 9, 2000
Sold by
Bought by

Purchase Details

Closed on
Mar 24, 1995
Sold by
Bought by
Source: Public Records
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

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
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- --
Quit Claim Deed -- --
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
Previous Owner $1,332,500 New Conventional
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
05/29/2026 05/29/26 Sold $1,800,000 0.0% $221 / Sq Ft
04/23/2026 04/23/26 Pending -- -- --
04/16/2026 04/16/26 For Sale $1,799,999 -- $221 / 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 $37,975 $606,501 $80,248 $526,253
2024 $37,012 $606,501 $80,248 $526,253
2023 $35,139 $606,501 $80,248 $526,253
2022 $29,612 $455,001 $67,904 $387,097
2021 $28,986 $455,001 $67,904 $387,097
2020 $33,053 $514,851 $67,904 $446,947
2019 $24,813 $350,176 $61,730 $288,446
2018 $23,246 $350,176 $61,730 $288,446
2017 $21,972 $350,176 $61,730 $288,446
2016 $20,768 $322,834 $56,172 $266,662
2015 $20,138 $322,834 $56,172 $266,662
2014 $20,146 $322,834 $56,172 $266,662
2013 $20,944 $354,760 $61,726 $293,034
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1875623

MLS of Greater Cincinnati (CincyMLS)

APN: 500-0263-0005

Your Personal Tour Guide

Ask me questions while you tour the home.