$1,499,000

Estimated payment $9,354/month

Total Views 4,118
4 Beds
5 Baths
3,747 Sq Ft
$400 Price per Sq Ft

Highlights

  • Pool House
  • Colonial Architecture
  • Vaulted Ceiling
  • View of Trees or Woods
  • Family Room with Fireplace
  • Wood Flooring

About This Home

An award-winning backyard oasis & over 5,000 sq. ft. of thoughtfully designed living space make this one of Coldstream's most exceptional homes. Set on a beautifully landscaped, level 1-acre lot in the highly regarded Forest Hills School District, just minutes from I-275, shopping & dining, this full-brick home offers luxury living & effortless entertaining. The resort-style backyard features a resurfaced 40,000-gal. gunite pool with spa, waterfall, pool house, pavilion, pergola, built-in grill, expansive paver patio & professional landscaping with irrigation. Inside, enjoy spacious living areas, a gourmet kitchen with custom cabinetry & premium appliances, vaulted sunroom with wet bar, luxurious primary suite with custom California Closet & spa-inspired bath, and finished lower level featuring a home theater, craft room with custom built-ins, kitchenette & flexible living space. A rare opportunity to enjoy resort-style living in one of Anderson Twp.'s premier communities.

Listing Agent

Julia Packer Wesselkamper

Coldwell Banker Realty License #0000339877 Listed on: 07/17/2026

Coldwell Banker Realty

Co-Listing Agent

Melissa Attewell

Coldwell Banker Realty License #2015000560

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $16,770

Year Built

  • Built in 1983

Lot Details

  • 1 Acre Lot
  • Aluminum or Metal Fence

Parking

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

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 3,747 Sq Ft Home
  • 2-Story Property
  • Bookcases
  • Chair Railings
  • Crown Molding
  • Vaulted Ceiling
  • Chandelier
  • Wood Burning Fireplace
  • Vinyl Clad Windows
  • French Doors
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room with Fireplace
  • Views of Woods

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Kitchen Island

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom
  • Jetted Tub in Primary Bathroom
  • Built-In Shower Bench

Laundry

  • Dryer
  • Washer

Finished Basement

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

Outdoor Features

  • Pool House
  • Patio
  • Outdoor Grill

Utilities

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

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$16,770

Year Built

Built in 1983

Lot Details

1 Acres

Parking

3

Listing Details

  • Suburb: Anderson Twp.
  • Buildings: Pool House
  • 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
  • Lot Area Realist: 43560.00
  • Suburb S I C: Anderson Twp.
  • Zoning: Residential
  • Basement Features: Finished, Walkout
  • Bathroom 4: Partial
  • Bathroom 4 Level: 1
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Dining Room Feat: Chair Rail, Chandelier, Wood Floor
  • Family Room Feat: Walkout, Fireplace
  • Living Great Rm Dim: 17 x 15
  • Living Room Feat: Fireplace, Wood Floor
  • Mechanical Systems: Water Softener
  • Single Family Desc: Single Family
  • Study Lib Den: 10x10 Level: 1
  • Study Lib Den Dim: 10 x 10
  • Water Heating: Gas, Tankless
  • Year Built: 1983
  • Architecture: Colonial
  • Full Bathrooms: 3
  • Half Bathrooms: 2
  • Bedrooms: 4
  • Directions: Ayers Road to Heathgate Road
  • Lot Measurement: Acres
  • Status: Active
  • On Market Date: 2026-07-17
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • Second Floor Area: 1502
  • ADU Y/N: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Crown Molding, French Doors
  • Bedroom 2: 14x13 Level: 2
  • Bedroom 3: 14x12 Level: 2
  • Bedroom 4: 12x12 Level: 2
  • Dining Room: 15x13 Level: 1
  • Family Room: 19x18 Level: 1
  • Living Room: 17x15 Level: 1
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $8385
  • Appliances: Dishwasher, Double Oven, Dryer, Gas Cooktop, Microwave, Refrigerator, Washer, Wine Cooler
  • Kitchen Features: Eat-In, Tile Floor, Island, Marble/Granite/Slate
  • Basement: Full
  • Study Features: Bookcases, French Doors
  • Entry: 12x10 Level: 1
  • Bathrooms: 5.00
  • Kitchen Dim: 26 x 13
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Partial
  • Bathroom 3 Level: 1
  • Laundry Room: 12x9 Level: 1
  • Laundryroom Dim: 12 x 9
  • Recreation Room Dim: 0 x 0
  • Fireplace: Wood
  • Fireplaces: 2
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 3747.00
  • Windows: Vinyl
  • PrimaryBedroomDim: 17 x 15
  • Primary Bathrooms: Built-In Shower Seat, Shower, Double Vanity, Jetted Tub
  • PrimaryBedFeat: Bath Adjoins, Walk-in Closet, Wall-to-Wall Carpet
  • P R I M A R Y B E D R O O M: 17x15 Level: 2

Exterior Features

  • View: Woods
  • Fencing: Metal
  • Roof: Shingle
  • Pool: Diving Board,In-Ground
  • Construction: Brick
  • Outside Features: BBQ Grill, Patio
  • Foundation: Poured
  • Listing Price: 1499000.00
  • Acres: 1.0000
  • New Construction: No

Garage/Parking

  • Garage Spaces: 3.00
  • Garage Carport: Side, Garage Attached
  • Parking: On 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: 43560.00
  • Total Assessed Value: 0

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Map

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

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 $16,771 $267,974 $44,100 $223,874
2024 $16,326 $267,974 $44,100 $223,874
2023 $15,512 $267,974 $44,100 $223,874
2022 $11,841 $182,063 $44,100 $137,963
2021 $11,571 $182,063 $44,100 $137,963
2020 $11,685 $182,063 $44,100 $137,963
2019 $12,261 $173,394 $42,000 $131,394
2018 $11,486 $173,394 $42,000 $131,394
2017 $10,843 $173,394 $42,000 $131,394
2016 $12,590 $196,725 $52,920 $143,805
2015 $12,220 $196,725 $52,920 $143,805
2014 $12,227 $196,725 $52,920 $143,805
2013 $9,183 $156,132 $42,000 $114,132
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
07/17/2026 07/17/26 For Sale $1,499,000 -- $400 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

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 $82,000 Unknown
Closed $150,000 Unknown
Source: Public Records

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1886734

MLS of Greater Cincinnati (CincyMLS)

APN: 500-0251-0005

Your Personal Tour Guide

Ask me questions while you tour the home.