Jennifer Allred
Coldwell Banker Realty
(513) 440-3615
176 Total Sales
2 in Coldstream
$425K - $695K Price Range
7149 Five Mile Rd Cincinnati, OH 45230
Coldstream NeighborhoodEstimated Value: $717,000 - $1,093,000
5
Beds
4.5
Baths
4,883
Sq Ft
$188/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- View of Trees or Woods
- Cathedral Ceiling
- Ayer Elementary School Rated A
- Heavily Wooded Lot
- Traditional Architecture
About This Home
As of September 2018Show stopper inside and out! Pristine condition, fully renovated designer dream home. Five beds, 1st floor two story master bedroom. An absolute must see!
Last Agent to Sell the Property
Kristin N Harper
Coldwell Banker Realty License #2014004784 Listed on: 08/07/2018
Last Buyer's Agent
Elizabeth Rabiner-Oligee
Comey & Shepherd License #2013003159
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,446
Year Built
- Built in 2004
Lot Details
- Lot Dimensions are 130 x 300
- Sloped Lot
- Heavily Wooded Lot
Parking
- 3 Car Garage
- Driveway
Home Design
- Traditional Architecture
- Poured Concrete
- Shingle Roof
- Stone
Interior Spaces
- 4,883 Sq Ft Home
- 2-Story Property
- Bookcases
- Crown Molding
- Beamed Ceilings
- Cathedral Ceiling
- Skylights in Kitchen
- Marble Fireplace
- Gas Fireplace
- Vinyl Clad Windows
- Window Treatments
- Picture Window
- Casement Windows
- Panel Doors
- Entrance Foyer
- Family Room with Fireplace
- Formal Dining Room
- Wood Flooring
- Views of Woods
- Finished Basement
- Basement Fills Entire Space Under The House
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Bar
- Butlers Pantry
- Oven or Range
- Gas Cooktop
- Microwave
- Dishwasher
- Kitchen Island
- Solid Wood Cabinet
- Disposal
Bedrooms and Bathrooms
- 5 Bedrooms
- Main Floor Bedroom
- Walk-In Closet
- Dressing Area
- In-Law or Guest Suite
Outdoor Features
- Patio
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
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
Listed on
Aug 7, 2018
Closed on
Sep 5, 2018
Sold by
Bought by
Seller's Agent
Kristin N Harper
Coldwell Banker Realty
Buyer's Agent
Elizabeth Rabiner-Oligee
Comey & Shepherd
List Price
$625,000
Sold Price
$610,000
Premium/Discount to List
-$15,000
-2.4%
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$307,980
Avg. Annual Appreciation
5.30%
Original Mortgage
$453,100
Interest Rate
4.6%
Mortgage Type
New Conventional
Purchase Details
Listed on
Sep 29, 2016
Closed on
Nov 18, 2016
Sold by
Bought by
Seller's Agent
Pamela Steiner
Comey & Shepherd
Buyer's Agent
Tammy Rennard
Huff Realty
List Price
$539,900
Sold Price
$525,000
Premium/Discount to List
-$14,900
-2.76%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.69%
Original Mortgage
$417,000
Interest Rate
3.25%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 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
$54,000
Interest Rate
4.99%
Mortgage Type
Unknown
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Coldstream, OH
-
Jennifer Allred
-
Tammie Iverson
Tammie Iverson
Keller Williams Seven Hills Re
(513) 993-5332
102 Total Sales
1 in Coldstream
$700,000 Price
-
Jeff Rosa
Jeff Rosa
eXp Realty
(513) 866-8760
94 Total Sales
1 in Coldstream
$635,000 Price
-
Cindy Shetterly
Cindy Shetterly
Keller Williams Realty Service
(513) 866-3124
529 Total Sales
3 in Coldstream
$134K - $830K Price Range
-
Kellie Barter
Kellie Barter
Weichert, REALTORS - R.E. 1790
(513) 572-6995
72 Total Sales
1 in Coldstream
$550,000 Price
-
Cheryl Boettger
Cheryl Boettger
Comey & Shepherd
(513) 854-0245
80 Total Sales
1 in Coldstream
$585,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 |
|---|---|---|---|
| $610,000 | None Available | ||
| $525,000 | -- | ||
| $72,000 | -- |
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 | $440,000 | ||
| Closed | $450,000 | ||
| Closed | $453,100 | ||
| Previous Owner | $411,000 | ||
| Previous Owner | $417,000 | ||
| Previous Owner | $370,000 | ||
| Previous Owner | $375,325 | ||
| Previous Owner | $73,223 | ||
| Previous Owner | $379,300 | ||
| Previous Owner | $55,400 | ||
| Previous Owner | $385,600 | ||
| Previous Owner | $385,000 | ||
| Previous Owner | $365,000 | ||
| Previous Owner | $50,000 | ||
| Previous Owner | $320,000 | ||
| Previous Owner | $285,000 | ||
| Previous Owner | $54,000 | ||
| Previous Owner | $55,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 |
|---|---|---|---|---|---|
| 12/09/2018 12/09/18 | Off Market | $610,000 | -- | -- | |
| 09/07/2018 09/07/18 | Sold | $610,000 | -2.4% | $125 / Sq Ft | |
| 08/09/2018 08/09/18 | Pending | -- | -- | -- | |
| 08/07/2018 08/07/18 | For Sale | $625,000 | +19.0% | $128 / Sq Ft | |
| 04/09/2017 04/09/17 | Off Market | $525,000 | -- | -- | |
| 11/18/2016 11/18/16 | Sold | $525,000 | -2.8% | $151 / Sq Ft | View Prior Sale |
| 10/13/2016 10/13/16 | Pending | -- | -- | -- | |
| 09/29/2016 09/29/16 | For Sale | $539,900 | -- | $156 / 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 | $12,946 | $207,232 | $30,030 | $177,202 |
| 2024 | $12,581 | $207,232 | $30,030 | $177,202 |
| 2023 | $11,967 | $207,232 | $30,030 | $177,202 |
| 2022 | $13,840 | $213,500 | $25,410 | $188,090 |
| 2021 | $13,512 | $213,500 | $25,410 | $188,090 |
| 2020 | $13,668 | $213,500 | $25,410 | $188,090 |
| 2019 | $12,957 | $183,750 | $23,100 | $160,650 |
| 2018 | $12,136 | $183,750 | $23,100 | $160,650 |
| 2017 | $11,445 | $183,750 | $23,100 | $160,650 |
| 2016 | $7,644 | $119,826 | $22,932 | $96,894 |
| 2015 | $7,424 | $119,826 | $22,932 | $96,894 |
| 2014 | $7,429 | $119,826 | $22,932 | $96,894 |
| 2013 | $7,718 | $131,677 | $25,200 | $106,477 |
Source: Public Records
Agents Affiliated with this Home
-
K
Seller's Agent in 2018
Kristin N Harper
Coldwell Banker Realty
-
E
Buyer's Agent in 2018
Elizabeth Rabiner-Oligee
Comey & Shepherd
-
Pamela Steiner
Seller's Agent in 2016
Pamela Steiner
Comey & Shepherd
(513) 608-3368
2 in this area
78 Total Sales
-
Mikaela Steiner
Seller Co-Listing Agent in 2016
Mikaela Steiner
Keller Williams Advisors
(513) 225-5629
25 Total Sales
-
T
Buyer's Agent in 2016
Tammy Rennard
Huff Realty
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1591383
APN: 500-0264-0006
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
- 480 Tam o Shanter Ct
- 401 Sunny Acres Dr
- 535 Rollingrock Ln
- 436 Heathgate Rd
- 7118 Kellogg Rd
- 6974 Stonington Rd
- 818 Rosetree Ln
- 7373 Woodcroft Dr
- 7397 Woodcroft Dr
- 6984 Old Kellogg Rd
- 6840 Stonington Rd
- 1046 Eastland Terrace
- 7392 Ridgepoint Dr
- 1086 Artwood Dr
- 807 Birney Ln
- 7382 Ridgepoint Dr
- 7343 Ridgepoint Dr
- 1084 Markley Rd
- 6844 High Meadows Dr
- 7976 Villas of Cross Creek
- 7149 5 Mile Rd
- 7155 Five Mile Rd
- 7137 5 Mile Rd
- 7155 5 Mile Rd
- 7251 Brixton Ln
- 7131 5 Mile Rd
- 7171 Five Mile Rd
- 7171 5 Mile Rd
- 7250 Brixton Ln
- 7186 5 Mile Rd
- 7259 Brixton Ln
- 7999 Ayers Rd
- 7252 Brixton Ln
- 28 Ayers Rd
- 431 Bittersea Ct
- 7217 Ayers Rd
- 7217 Ayers Rd Unit 77
- 7258 Brixton Ln
- 435 Bittersea Ct
- 7225 Five Mile Rd
Your Personal Tour Guide
Ask me questions while you tour the home.