NOT LISTED FOR SALE

Estimated Value: $711,000 - $965,000

5 Beds
4.5 Baths
4,282 Sq Ft
$203/Sq Ft Est. Value

Last Sold August 20, 2021

Last sale price $620,000 $145 Per Sq Ft

Est. 43% increase in value since last sale

Current estimated payment $5,944/month

Highlights

  • Eat-In Gourmet Kitchen
  • View of Trees or Woods
  • Family Room with Fireplace
  • Ayer Elementary School Rated A
  • Deck
  • Vaulted Ceiling

About This Home

As of August 2021

Incredible Coldstream home featuring breathtaking open floor plan, gleaming hardwood floors, ample size rooms, new gourmet kitchen, high ceilings, finished walk out lower level with a 5th bedroom, full bath. All located at end of quiet cul-de-sac. This is a special opportunity!

Last Agent to Sell the Property

Carol Rod

Sibcy Cline, Inc. License #0000320145 Listed on: 05/13/2021

Sibcy Cline, Inc.

Co-Listed By

Alexis Rod

Sibcy Cline, Inc. License #2020000486

Last Buyer's Agent

Jon Decurtins

ERA REAL Solutions Realty, LLC License #2009003765

ERA REAL Solutions Realty, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10

Year Built

  • Built in 1986

Lot Details

  • Lot Dimensions are 53 x 353
  • Cul-De-Sac

HOA Fees

  • $5 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Driveway
  • On-Street Parking

Home Design

  • Transitional Architecture
  • Shingle Roof
  • Cedar

Interior Spaces

  • 4,282 Sq Ft Home
  • 2-Story Property
  • Woodwork
  • Vaulted Ceiling
  • Wood Burning Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • Picture Window
  • Family Room with Fireplace
  • 2 Fireplaces
  • Great Room with Fireplace
  • Formal Dining Room
  • Views of Woods

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Double Convection Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Concrete

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet

Finished Basement

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

Outdoor Features

  • Deck
  • Porch

Utilities

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

Community Details

  • Association fees include association dues, landscapingcommunity

Home Details

Home Type

Single Family

Est. Annual Taxes

$10

Year Built

Built in 1986

Lot Details

0

HOA Fees

$5 per month

Parking

3

Listing Details

  • Suburb: Anderson Twp.
  • Cross Street: Bishopsbridge Dr.
  • Land Description: 1 to 4.9 Acres
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt,Cable,Ceiling Fan,Recessed Lights,Smoke Alarm
  • Basement Sq Ft: 1830
  • Census Tract Realist: 251.04
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 64730.00
  • Property Ownership: Consumer
  • Sub Lease Expiration Date: 1800-01-01T00:00:00-05:00
  • Suburb S I C: Anderson Twp.
  • Accessibility Features: No
  • Basement Features: Concrete Floor,Finished,Fireplace,Walkout,WW Carpet
  • Bathroom 4: Full
  • Bathroom 4 Level: Lower
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Bedroom 5 Area: 208
  • Level 1 Bedroom: No
  • Dining Room Feat: Wood Floor
  • Entry Area: 224
  • Entry Dim: 16 x 14
  • Entry Foyer: Closet,Open Foyer,Wood Floor
  • Family Room Feat: Bookcases,Fireplace,Walkout,WW Carpet
  • Great Room Feat: Bookcases,Fireplace,WW Carpet
  • Living Great Rm Dim: 0 x 0
  • Mechanical Systems: Garage Door Opener,Humidifier,Radon System
  • Single Family Desc: Single Family
  • Study Lib Den: 17x13 Level: 1
  • Study Lib Den Area: 221
  • Study Lib Den Dim: 17 x 13
  • Study Lib Den Len: 17
  • Water Heating: Gas
  • Year Built: 1986
  • Architecture: Transitional
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Bedrooms: 5
  • Directions: Asbury Rd, Turn Right onto Ayers Rd., Turn Left onto Bishopsbridge Dr., Turn Right onto Nottinghill Dr. to cul-de-sac.
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2021-05-12
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • On Market: No
  • Third Party Approval Required: No
  • Second Floor Area: 1572
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Natural Woodwork, Vaulted Ceiling
  • Bedroom 2: 14x11 Level: 2
  • Bedroom 3: 13x11 Level: 2
  • Bedroom 4: 13x11 Level: 2
  • Bedroom 5: 16x13 Level: Lower
  • Dining Room: 17x13 Level: 1
  • Family Room: 22x17 Level: Lower
  • Formal Dining Room: Yes
  • Property Type: Residential
  • Bathrooms Display: 5 (4 1)
  • Reciprocal Listing: No
  • School Name1: Call SD 513-231-3600
  • Semi Annual Taxes: $5,664.23
  • Kitchen: 26x16 Level: 1
  • Appliances: Convection Oven, Dishwasher, Double Oven, Garbage Disposal, Gas Cooktop, Microwave, Oven/Range, Refrigerator
  • Kitchen Features: Counter Bar,Eat-In,Gourmet,Island,Marble/Granite/Slate,Pantry,Planning Desk,Walkout,Wood Cabinets,Wood Floor
  • Bedroom 2 Area: 154
  • Basement: Full
  • Bedroom 3 Area: 143
  • Study Features: Wood Floor
  • Bedroom 4 Area: 143
  • Entry: 16x14 Level: 1
  • Bathrooms: 5.00
  • Great Room: 22x19 Level: 1
  • Kitchen Area: 416
  • Kitchen Dim: 26 x 16
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 2
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Diningroom Area: 221
  • Family Room Area: 374
  • Laundry Room: 13x9 Level: 1
  • Laundry Room Area: 117
  • Laundryroom Dim: 13 x 9
  • Recreation Room Dim: 0 x 0
  • Fireplace: Ceramic, Gas, Wood
  • Fireplaces: 2
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 4282.00
  • Total Rooms: 11
  • Windows: Casement, Insulated, Picture, Vinyl
  • First Floor Family Room: Yes
  • PrimaryBedroomArea: 437
  • PrimaryBedroomDim: 23 x 19
  • PrimaryBedroomLen: 23
  • Primary Bathrooms: Double Vanity,Shower,Tub
  • PrimaryBedFeat: Bath Adjoins,Dressing Area,Walk-in Closet,WW Carpet
  • P R I M A R Y B E D R O O M: 23x19 Level: 2

Exterior Features

  • View: Woods
  • Roof: Shingle
  • Construction: Cedar
  • Outside Features: Cul de sac, Deck, Porch, Tiered Deck, Wooded Lot
  • Foundation: Poured
  • Listing Price: 625000.00
  • New Construction: No

Garage/Parking

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

Utilities

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

Condo/Co-op/Association

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

Fee Information

  • Inc.In HOA/Condo Fee: AssociationDues, LandscapingCommunity

Schools

  • District: Forest Hills Local S

Lot Info

  • Lot Dimensions: 53 X 353
  • Total Assessed Value: Of Record
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Abatement: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 13, 2021
Closed on
Aug 20, 2021
Sold by
Maier Elizabeth R and Maier Travis
Bought by
Niemeyer Gregory Bruce and Tenkman Allegra Rose
Seller's Agent
Carol Rod
Sibcy Cline, Inc.
Buyer's Agent
Jon Decurtins
ERA REAL Solutions Realty, LLC
List Price
$625,000
Sold Price
$620,000
Premium/Discount to List
-$5,000
-0.8%
Current Estimated Value
$883,876

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$263,876
Avg. Annual Appreciation
8.89%
Original Mortgage
$496,000
Outstanding Balance
$454,264
Interest Rate
2.8%
Mortgage Type
New Conventional
Estimated Equity
$416,672

Purchase Details

Closed on
Jul 29, 2019
Sold by
Barber Robert S and Barber Elizabeth R
Bought by
Barber Elizabeth R

Home Financials for this Owner

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

Purchase Details

Listed on
Jan 30, 2015
Closed on
Mar 31, 2015
Sold by
Brookfield Relocation Inc
Bought by
Barber Robert S and Barber Elizabeth R
Seller's Agent
Ellie Reiser
Comey & Shepherd
Buyer's Agent
Carol Rod
Sibcy Cline, Inc.
List Price
$480,000
Sold Price
$480,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.91%
Original Mortgage
$384,000
Interest Rate
3.64%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jan 30, 2015
Closed on
Mar 4, 2015
Sold by
Singh Manjit
Bought by
Brookfield Relocation Inc
Seller's Agent
Ellie Reiser
Comey & Shepherd
Buyer's Agent
Carol Rod
Sibcy Cline, Inc.
List Price
$480,000
Sold Price
$480,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$384,000
Interest Rate
3.64%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 15, 2012
Sold by
Singh Manjit and Skinner Charlotte E
Bought by
Singh Manjit

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$399,400
Interest Rate
2.62%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 1, 2006
Sold by
Poe Julie L
Bought by
Singh Manjit and Skinner Charlotte E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$440,000
Interest Rate
6.37%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Jan 21, 2000
Sold by
Poe Harold F and Poe Julie L
Bought by
Poe Julie L

Purchase Details

Closed on
Feb 23, 1998
Sold by
Poe Julie L and Poe Julie L
Bought by
Poe Harold F and Poe Julie L
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Niemeyer Gregory Bruce $620,000 Prominent Title Agency Llc
Barber Elizabeth R -- Servicelink
Barber Robert S $460,000 Attorney
Brookfield Relocation Inc $480,000 Attorney
Singh Manjit -- Servicelink
Singh Manjit -- None Available
Poe Julie L -- --
Poe Harold F -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Niemeyer Gregory Bruce $496,000
Previous Owner Barber Elizabeth R $73,000
Previous Owner Barber Elizabeth R $402,800
Previous Owner Barber Scott $50,000
Previous Owner Barber Robert S $384,000
Previous Owner Singh Manjit $399,400
Previous Owner Singh Manjit $409,600
Previous Owner Singh Manjit $440,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/20/2021 08/20/21 Sold $620,000 -0.8% $145 / Sq Ft
05/14/2021 05/14/21 Pending -- -- --
05/13/2021 05/13/21 For Sale $625,000 +30.2% $146 / Sq Ft
07/01/2015 07/01/15 Off Market $480,000 -- --
03/31/2015 03/31/15 Sold $480,000 0.0% $112 / Sq Ft
02/10/2015 02/10/15 Pending -- -- --
01/30/2015 01/30/15 For Sale $480,000 -- $112 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Tax History Compared to Growth

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 $13,202 $217,001 $54,905 $162,096
2023 $12,549 $217,001 $54,905 $162,096
2022 $11,781 $181,378 $54,905 $126,473
2021 $11,514 $176,401 $54,905 $121,496
2020 $11,313 $176,401 $54,905 $121,496
2019 $11,870 $168,000 $52,290 $115,710
2018 $11,119 $168,000 $52,290 $115,710
2017 $10,495 $168,000 $52,290 $115,710
2016 $10,711 $168,000 $65,884 $102,116
2015 $13,408 $206,787 $65,884 $140,903
2014 $13,394 $206,787 $65,884 $140,903
2013 $9,482 $154,179 $52,290 $101,889
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1700142

MLS of Greater Cincinnati (CincyMLS)

APN: 500-0264-0019