Cindy Shetterly
Keller Williams Realty Service
(513) 866-3124
533 Total Sales
3 in Coldstream
$134K - $830K Price Range
6859 Five Mile Rd Cincinnati, OH 45230
Coldstream NeighborhoodEstimated Value: $613,000 - $733,989
4
Beds
3
Baths
3,542
Sq Ft
$190/Sq Ft
Est. Value
Highlights
- Views of Trees
- Heated Floors
- Deck
- Maddux Elementary School Rated A-
- 2.12 Acre Lot
- Family Room with Fireplace
About This Home
As of March 2023Nestled on an idyllic 2 acre lot in Anderson Township, this iconic red barn-inspired home is the perfect mix of nostalgic and modern. Expansive windows maximize views of the dramatic bluffs and park-like landscape! A mix of organic and minimalist finishes paired with contemporary styling create a magazine-worthy living + entertaining space! Get the best of both worlds w/country-like living (backs up the 207 acre Withrow nature preserve/5 mile creek) yet 13 min to downtown/18 min to CVG.
Last Agent to Sell the Property
ERA REAL Solutions Realty, LLC License #2009003765 Listed on: 01/25/2023
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
Est. Annual Taxes
- $11,672
Year Built
- Built in 1990
Lot Details
- 2.12 Acre Lot
- Wood Fence
- Aluminum or Metal Fence
Parking
- 2 Car Garage
- Oversized Parking
- Electric Vehicle Home Charger
- Side Facing Garage
- Driveway
Home Design
- Modern Architecture
- Slab Foundation
- Shingle Roof
- Wood Siding
Interior Spaces
- 3,542 Sq Ft Home
- 2-Story Property
- Elevator
- Cathedral Ceiling
- Gas Fireplace
- Vinyl Clad Windows
- Window Treatments
- Wood Frame Window
- French Doors
- Entryway
- Family Room with Fireplace
- 2 Fireplaces
- Great Room with Fireplace
- Living Room with Fireplace
- Dining Room
- Home Office
- Views of Trees
- Laundry Room
Kitchen
- Eat-In Kitchen
- Convection Oven
- Electric Cooktop
- Microwave
- Dishwasher
- Disposal
Flooring
- Wood
- Heated Floors
- Radiant Floor
- Concrete
Bedrooms and Bathrooms
- 4 Bedrooms
- 3 Full Bathrooms
Home Security
- Home Security System
- Smart Home
Eco-Friendly Details
- ENERGY STAR/CFL/LED Lights
Outdoor Features
- Balcony
- Deck
- Covered Patio or Porch
- Shed
Utilities
- Forced Air Heating and Cooling System
- Humidifier
- Heating System Uses Propane
- Geothermal Heating and Cooling
- Well
- Electric Water Heater
- Water Softener
Community Details
- No Home Owners Association
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
Apr 18, 2022
Sold by
Bought by
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$187,500
Outstanding Balance
$144,851
Interest Rate
3.5%
Mortgage Type
Balloon
Estimated Equity
$528,146
Purchase Details
Closed on
Feb 4, 2022
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
$580,000
Interest Rate
3.69%
Mortgage Type
Balloon
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Coldstream, OH
-
Cindy Shetterly
-
Kellie Barter
Kellie Barter
Weichert, REALTORS - R.E. 1790
(513) 572-6995
73 Total Sales
1 in Coldstream
$550,000 Price
-
Cheryl Boettger
Cheryl Boettger
Comey & Shepherd
(513) 854-0245
81 Total Sales
1 in Coldstream
$585,000 Price
-
Scott Ackerman
Scott Ackerman
Coldwell Banker Realty
(513) 586-2519
79 Total Sales
1 in Coldstream
$615,000 Price
-
Lori Williams
Lori Williams
Lohmiller Real Estate
(513) 854-1258
91 Total Sales
1 in Coldstream
$627,500 Price
-
Janelle Sprandel
Janelle Sprandel
Comey & Shepherd REALTORS
(513) 599-0248
333 Total Sales
1 in Coldstream
$685,000 Price
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 |
|---|---|---|---|
| $250,000 | None Listed On Document | ||
| $250 | None Listed On Document |
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 | $187,500 | ||
| Previous Owner | $580,000 | ||
| Previous Owner | $168,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 |
|---|---|---|---|---|
| 03/31/2023 03/31/23 | Sold | $1,195,000 | +9.1% | $337 / Sq Ft |
| 02/12/2023 02/12/23 | Pending | -- | -- | -- |
| 02/10/2023 02/10/23 | Price Changed | $1,095,000 | -12.4% | $309 / Sq Ft |
| 01/27/2023 01/27/23 | For Sale | $1,250,000 | -- | $353 / 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 | $10,854 | $173,096 | $27,020 | $146,076 |
| 2024 | $9,743 | $159,901 | $27,020 | $132,881 |
| 2023 | $9,260 | $159,901 | $27,020 | $132,881 |
| 2022 | $0 | $0 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Jon Decurtins
Seller's Agent in 2023
Jon Decurtins
ERA REAL Solutions Realty, LLC
(513) 600-7231
6 in this area
244 Total Sales
-
Elizabeth Gerbus Akeley
Buyer's Agent in 2023
Elizabeth Gerbus Akeley
Comey & Shepherd
(513) 535-2103
2 in this area
172 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1761401
APN: 500-0330-0130
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 807 Birney Ln
- 7118 Kellogg Rd
- 6971 Shadow Ridge Rd
- 6956 Shadow Ridge Rd
- 6690 Hitchingpost Ln
- 6840 Stonington Rd
- 6974 Stonington Rd
- 401 Sunny Acres Dr
- 953 Watch Creek Dr
- 1089 Stormy Way
- 480 Tam o Shanter Ct
- 6844 High Meadows Dr
- 820 Laverty Ln
- 1149 Lanette Dr
- 818 Rosetree Ln
- 436 Heathgate Rd
- 1190 Linden Hill Ln
- 1199 Linden Hill Ln
- 535 Rollingrock Ln
- 1046 Eastland Terrace
- 6859 Five Mile Rd Unit 2
- 6859 Five Mile Rd Unit 1
- 2.88ac Five Mile Rd
- 2.54ac Five Mile Rd
- 74 Five Mile Rd Unit 74
- 3 Whitney Estates
- 6870 5 Mile Rd
- 4 Whitney Estates
- 6840 5 Mile Rd
- 6916 5 Mile Rd
- Lot-2 Whitney Ln
- 6916 Five Mile Rd
- 2.889ac Five Mile Rd
- 6847 Five Mile Rd
- 6918 5 Mile Rd
- 6918 Five Mile Rd
- 640 Watch Hill Ln
- 6930 5 Mile Rd
- 6939 5 Mile Rd
- 6944 5 Mile Rd
Your Personal Tour Guide
Ask me questions while you tour the home.