NOT LISTED FOR SALE

Estimated Value: $1,059,000 - $1,482,000

5 Beds
6 Baths
5,508 Sq Ft
$234/Sq Ft Est. Value

Sale Details

Date Sold: September 8, 2021

Last sale price $942,000 $171 Per Sq Ft

Est. 37% increase in value since last sale

Current estimated payment $8,809 / mo

48 Days on Market

Highlights

  • Eat-In Gourmet Kitchen
  • River View
  • Family Room with Fireplace
  • Ayer Elementary School Rated A
  • Deck
  • Wooded Lot

About This Home

As of September 2021

Amazing Coldstream property located on prestigious cul-de-sac street in one of with Anderson's most sought neighborhoods. Picturesque setting, expansive yard & outdoor spaces overlooking river view from the deck or screened porch. Light filled gourmet kitchen fit for any chef; Wolf range, Sub-zero refrigerator & spacious breakfast room. Meticulously maintained, with many upgrades in the last year. See aerial drone footage from in the virtual tour link. Many updates this year.

Last Agent to Sell the Property

John Mederer

eXp Realty License #0000325160 Listed on: 04/15/2021

eXp Realty

Last Buyer's Agent

Cathy Musgrave

Huff Realty License #2019000422

Huff 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

Year Built

  • Built in 1988

Lot Details

  • 1.02 Acre Lot
  • Lot Dimensions are 150 x 312.72
  • Cul-De-Sac
  • Sprinkler System
  • Wooded Lot

Parking

  • 3 Car Garage
  • Garage Door Opener
  • Driveway
  • On-Street Parking

Property Views

  • River
  • Woods

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Wood Siding
  • Stone

Interior Spaces

  • 5,508 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Bookcases
  • Chair Railings
  • Woodwork
  • Crown Molding
  • Beamed Ceilings
  • Cathedral Ceiling
  • Ceiling Fan
  • Skylights
  • Chandelier
  • Stone Fireplace
  • Brick Fireplace
  • Gas Fireplace
  • Double Pane Windows
  • Vinyl Clad Windows
  • Window Treatments
  • Bay Window
  • Wood Frame Window
  • Casement Windows
  • Panel Doors
  • Family Room with Fireplace
  • 2 Fireplaces
  • Formal Dining Room
  • Wood Flooring
  • Attic Fan

Kitchen

  • Eat-In Gourmet Kitchen
  • Double Oven
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Wood Cabinet
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet

Finished Basement

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

Outdoor Features

  • Deck
  • Enclosed Patio or Porch
  • Exterior Lighting

Utilities

  • 95% Forced Air Zoned Heating and Cooling System
  • Heating System Uses Gas
  • Gas Water Heater
  • Aerobic Septic System
  • Septic Tank

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Year Built

Built in 1988

Lot Details

1.02 Acres

Parking

3

Listing Details

  • Suburb: Anderson Twp.
  • Cross Street: Sunny Acres
  • Land Description: 1 to 4.9 Acres
  • Access: City Street
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt,Cable,Ceiling Fan,Recessed Lights,Smoke Alarm
  • Census Tract Realist: 251.04
  • Cooling: Attic fan, Ceiling Fans, Central Air
  • Heating: Forced Air, Gas, Gas Furn EF Rtd 95%+
  • Lot Area Realist: 44518.00
  • Property Ownership: Consumer
  • Suburb S I C: Anderson Twp.
  • Price Per Acre: 921722.11
  • Basement Features: Finished,Fireplace,Glass Blk Wind,Unfinished,Walkout,WW Carpet
  • Bathroom 4: Full
  • Bathroom 4 Level: Lower
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Dining Room Feat: Chair Rail,Chandelier,Window Treatment,Wood Floor
  • Entry Dim: 15 x 15
  • Entry Foyer: Closet,Marble/Slate,Transom/Sidelit
  • Family Room Feat: Bookcases,Fireplace,Skylight,Walkout,Wet Bar,Wood Floor
  • Living Great Rm Dim: 18 x 18
  • Living Room Feat: Window Treatment,Wood Floor
  • Mechanical Systems: Garage Door Opener
  • Single Family Desc: Single Family
  • Study Lib Den: 15x14 Level: 1
  • Study Lib Den Dim: 15 x 14
  • Water Heating: Gas
  • Year Built: 1988
  • Architecture: Traditional
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Bedrooms: 5
  • Directions: Beechmont Ave to Asbury Rd turn right on Ayers, left on Sunny Acres, left on Waterpoint Lane
  • Lot Measurement: Acres
  • Status: Sold
  • On Market Date: 2021-04-15
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • On Market: No
  • Third Party Approval Required: No
  • Second Floor Area: 1844
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Beam Ceiling, Cathedral Ceiling, Crown Molding, Multi Panel Doors, Natural Woodwork, Skylight, Vaulted Ceiling
  • Bedroom 2: 16x13 Level: 2
  • Bedroom 3: 15x13 Level: 2
  • Bedroom 4: 15x13 Level: 2
  • Bedroom 5: 12x10 Level: Lower
  • Breakfast Room: 14x13 Level: 1
  • Dining Room: 17x16 Level: 1
  • Family Room: 23x19 Level: 1
  • Living Room: 18x18 Level: 1
  • Recreation Room: 38x14 Level: Lower
  • Formal Dining Room: Yes
  • Property Type: Residential
  • Bathrooms Display: 6 (4 2)
  • Reciprocal Listing: No
  • School Name1: Call SD 513-231-3600
  • Semi Annual Taxes: of record
  • Kitchen: 19x15 Level: 1
  • Appliances: Dishwasher, Double Oven, Garbage Disposal, Microwave, Oven/Range, Refrigerator
  • Kitchen Features: Eat-In,Gourmet,Island,Marble/Granite/Slate,Wood Cabinets,Wood Floor
  • Basement: Full
  • Study Features: Bookcases,Wet/Dry Bar,Wood Floor
  • Entry: 15x15 Level: 1
  • Bathrooms: 6.00
  • Kitchen Dim: 19 x 15
  • 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: 14x7 Level: 1
  • Laundryroom Dim: 14 x 7
  • Recreation Room Dim: 38 x 14
  • Fireplace: Brick, Gas, Stone
  • Fireplaces: 2
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 5508.00
  • Windows: Bay/Bow, Casement, Double Pane, Vinyl, Wood
  • First Floor Family Room: Yes
  • PrimaryBedroomDim: 19 x 16
  • Primary Bathrooms: Built-In Shower Seat,Double Vanity,Marb/Gran/Slate,Tile Floor,Tub
  • PrimaryBedFeat: Bath Adjoins,Walk-in Closet,Wood Floor,WW Carpet
  • P R I M A R Y B E D R O O M: 19x16 Level: 2

Exterior Features

  • View: River, Woods
  • Roof: Shingle
  • Construction: Brick, Stone, Wood Siding
  • Outside Features: Cul de sac, Deck, Enclosed Porch, Patio, Sprinklers, Wooded Lot, Yard Lights
  • Foundation: Poured
  • Listing Price: 955000.00
  • Acres: 1.0220
  • New Construction: No

Garage/Parking

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

Utilities

  • Gas: Natural
  • Sewer: Septic Tank, Aerobic Septic
  • 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 Dimensions: 150 x 312.72
  • Lot Size Sq Ft: 44518.00
  • Total Assessed Value: of record
  • ResoLotSizeUnits: Acres

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
Apr 15, 2021
Closed on
Sep 1, 2021
Sold by
Bought by
Seller's Agent
John Mederer
eXp Realty
Buyer's Agent
Cathy Musgrave
Huff Realty
List Price
$995,000
Sold Price
$942,000
Premium/Discount to List
-$53,000
-5.33%
Current Estimated Value
$1,290,381

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$348,381
Avg. Annual Appreciation
6.56%
Original Mortgage
$894,900
Outstanding Balance
$794,891
Interest Rate
2.7%
Mortgage Type
New Conventional
Estimated Equity
$495,490

Purchase Details

Listed on
Mar 13, 2020
Closed on
May 7, 2020
Sold by
Bought by
Seller's Agent
Tracy Heller
Sibcy Cline, Inc.
Buyer's Agent
John Mederer
eXp Realty
List Price
$915,000
Sold Price
$930,000
Premium/Discount to List
$15,000
1.64%

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.96%
Original Mortgage
$505,000
Interest Rate
2.37%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 2, 2010
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
$114,462
Interest Rate
4.74%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Jan 26, 2010
Sold by
Bought by

Purchase Details

Closed on
Dec 15, 2005
Sold by
Bought by

Purchase Details

Closed on
Nov 15, 2005
Sold by
Bought by

Purchase Details

Closed on
Jul 31, 2003
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
$460,000
Interest Rate
4.25%
Mortgage Type
Unknown

Purchase Details

Closed on
Jan 23, 1999
Sold by
Bought by
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Coldstream, 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 Buyer Sale Price Title Company
$942,000 Lawyers Title
$930,000 Stewart Title
$625,250 Ohio Real Title
$525,000 None Available
$860,000 None Available
$860,000 None Available
$762,500 --
-- --
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 Borrower Loan Amount
Open $95,000
Open $894,900
Previous Owner $505,000
Previous Owner $370,000
Previous Owner $403,000
Previous Owner $114,462
Previous Owner $417,000
Previous Owner $608,000
Previous Owner $50,000
Previous Owner $460,000
Previous Owner $160,000
Previous Owner $500,000
Previous Owner $500,000
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 Prior Sale
09/08/2021 09/08/21 Sold $942,000 -5.3% $171 / Sq Ft
06/03/2021 06/03/21 Pending -- -- --
04/15/2021 04/15/21 For Sale $995,000 +7.0% $181 / Sq Ft
08/07/2020 08/07/20 Off Market $930,000 -- --
05/08/2020 05/08/20 Sold $930,000 +1.6% $169 / Sq Ft View Prior Sale
03/14/2020 03/14/20 Pending -- -- --
03/13/2020 03/13/20 For Sale $915,000 -- $166 / 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 $20,595 $329,700 $55,566 $274,134
2024 $20,015 $329,700 $55,566 $274,134
2023 $19,037 $329,700 $55,566 $274,134
2022 $21,100 $325,500 $55,566 $269,934
2021 $20,600 $325,500 $55,566 $269,934
2020 $20,837 $325,500 $55,566 $269,934
2019 $17,811 $252,571 $52,920 $199,651
2018 $16,683 $252,571 $52,920 $199,651
2017 $15,733 $252,571 $52,920 $199,651
2016 $17,579 $275,734 $66,679 $209,055
2015 $17,072 $275,734 $66,679 $209,055
2014 $17,083 $275,734 $66,679 $209,055
2013 $12,824 $218,838 $52,920 $165,918
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: 1696441

MLS of Greater Cincinnati (CincyMLS)

APN: 500-0252-0080

Your Personal Tour Guide

Ask me questions while you tour the home.