Robert Smith
Coldwell Banker Realty
(513) 599-1654
329 Total Sales
1 in Coldstream
$745,499 Price
8075 Hopper Rd Cincinnati, OH 45255
Coldstream NeighborhoodEstimated Value: $375,000 - $501,000
3
Beds
1.5
Baths
1,960
Sq Ft
$209/Sq Ft
Est. Value
Highlights
- Lake On Lot
- Ranch Style House
- Quartz Countertops
- Ayer Elementary School Rated A
- Wood Flooring
- No HOA
About This Home
As of May 2018Bring us an offer! Beautiful fully remodeled brick ranch in highly desirable area in Anderson. Comes fully loaded with the finest finishes. Granite/quartz countertops, hardwood floors, Calacatta marble, brand new appliances to name a few.
Last Agent to Sell the Property
Koogler-Eyre Realtors License #2017000589 Listed on: 12/18/2017
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 1955
Lot Details
- 0.86
Parking
- 2 Car Garage
- Oversized Parking
- Driveway
Home Design
- Ranch Style House
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
Interior Spaces
- 1,960 Sq Ft Home
- Ceiling height of 9 feet or more
- Marble Fireplace
- Brick Fireplace
- Double Hung Windows
- Family Room
- Living Room with Fireplace
- Formal Dining Room
- Wood Flooring
- Finished Basement
- Basement Fills Entire Space Under The House
Kitchen
- Oven or Range
- Microwave
- Dishwasher
- Quartz Countertops
- Solid Wood Cabinet
Bedrooms and Bathrooms
- 3 Bedrooms
- Walk-In Closet
Utilities
- Central Air
- Heating Available
- Gas Available at Street
- Electric Water Heater
- Septic Tank
Additional Features
- Lake On Lot
- 37,244 Sq Ft Lot
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
Mar 26, 2021
Sold by
Sanfflippo Frank S and Clayton Terri L
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
$205,500
Outstanding Balance
$180,768
Interest Rate
2.8%
Mortgage Type
New Conventional
Estimated Equity
$228,776
Purchase Details
Listed on
Dec 18, 2017
Closed on
May 25, 2018
Sold by
Willow Hills Of Montgomery Llc
Bought by
Sanfilippo Frank J and Clayton Terri L
Seller's Agent
Michael Fry
Koogler-Eyre Realtors
Buyer's Agent
Holly Pavone
Comey & Shepherd
List Price
$289,900
Sold Price
$260,000
Premium/Discount to List
-$29,900
-10.31%
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.64%
Original Mortgage
$208,000
Interest Rate
4.5%
Mortgage Type
Future Advance Clause Open End Mortgage
Purchase Details
Listed on
Jun 13, 2017
Closed on
Jul 13, 2017
Sold by
Delong John R
Bought by
Craftsman Properties Llc
Seller's Agent
Kendra McKeever
OwnerLand Realty, Inc.
Buyer's Agent
Sean Cole
Keller Williams Seven Hills Re
List Price
$200,000
Sold Price
$180,000
Premium/Discount to List
-$20,000
-10%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
51.16%
Original Mortgage
$157,165
Interest Rate
3.94%
Mortgage Type
Construction
Purchase Details
Listed on
Jun 13, 2017
Closed on
Jul 5, 2017
Sold by
Craftsman Properties Llc
Bought by
Willow Hills Of Montgomery Llc
Seller's Agent
Kendra McKeever
OwnerLand Realty, Inc.
Buyer's Agent
Sean Cole
Keller Williams Seven Hills Re
List Price
$200,000
Sold Price
$180,000
Premium/Discount to List
-$20,000
-10%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$157,165
Interest Rate
3.94%
Mortgage Type
Construction
Purchase Details
Closed on
Oct 10, 2002
Sold by
Delong John A and Delong Grace M
Bought by
Delong John A and Delong Grace M
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Coldstream, OH
-
Robert Smith
-
Cindy Shetterly
Cindy Shetterly
Keller Williams Realty Service
(513) 866-3124
525 Total Sales
3 in Coldstream
$134K - $830K Price Range
-
Kellie Barter
Kellie Barter
Weichert, REALTORS - R.E. 1790
(513) 572-6995
71 Total Sales
1 in Coldstream
$550,000 Price
-
Cheryl Boettger
Cheryl Boettger
Comey & Shepherd
(513) 854-0245
79 Total Sales
1 in Coldstream
$585,000 Price
-
Scott Ackerman
Scott Ackerman
Coldwell Banker Realty, Anders
(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
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 |
|---|---|---|---|
| -- | None Available | ||
| Sanfilippo Frank J | $260,000 | None Available | |
| Craftsman Properties Llc | $180,000 | American Homeland Title | |
| Willow Hills Of Montgomery Llc | $184,900 | None Available | |
| Delong John A | -- | -- |
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 | $104,000 | ||
| Open | Sanfilippo Frank J | $205,500 | |
| Closed | Sanfilippo Frank J | $208,000 | |
| Previous Owner | Craftsman Properties Llc | $157,165 | |
| Previous Owner | Anderson Hills Inc | $200,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 |
|---|---|---|---|---|---|
| 08/27/2018 08/27/18 | Off Market | $260,000 | -- | -- | |
| 05/25/2018 05/25/18 | Sold | $260,000 | -5.4% | $133 / Sq Ft | |
| 04/16/2018 04/16/18 | Pending | -- | -- | -- | |
| 03/26/2018 03/26/18 | Price Changed | $274,900 | -1.4% | $140 / Sq Ft | |
| 03/12/2018 03/12/18 | Price Changed | $278,900 | -0.4% | $142 / Sq Ft | |
| 02/16/2018 02/16/18 | Price Changed | $279,900 | -1.8% | $143 / Sq Ft | |
| 01/17/2018 01/17/18 | Price Changed | $284,900 | -1.7% | $145 / Sq Ft | |
| 12/18/2017 12/18/17 | For Sale | $289,900 | +61.1% | $148 / Sq Ft | |
| 10/01/2017 10/01/17 | Off Market | $180,000 | -- | -- | |
| 07/03/2017 07/03/17 | Sold | $180,000 | -10.0% | $92 / Sq Ft | View Prior Sale |
| 06/13/2017 06/13/17 | Pending | -- | -- | -- | |
| 06/13/2017 06/13/17 | For Sale | $200,000 | -- | $102 / 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 | $6,062 | $96,905 | $16,695 | $80,210 |
| 2024 | $5,892 | $96,905 | $16,695 | $80,210 |
| 2023 | $5,604 | $96,905 | $16,695 | $80,210 |
| 2022 | $5,908 | $91,000 | $16,415 | $74,585 |
| 2021 | $6,058 | $91,000 | $16,415 | $74,585 |
| 2020 | $5,990 | $91,000 | $16,415 | $74,585 |
| 2019 | $3,812 | $52,273 | $14,525 | $37,748 |
| 2018 | $3,576 | $52,273 | $14,525 | $37,748 |
| 2017 | $3,267 | $52,273 | $14,525 | $37,748 |
| 2016 | $3,293 | $51,486 | $14,816 | $36,670 |
| 2015 | $3,199 | $51,486 | $14,816 | $36,670 |
| 2014 | $3,201 | $51,486 | $14,816 | $36,670 |
| 2013 | $2,968 | $50,477 | $14,525 | $35,952 |
Source: Public Records
Agents Affiliated with this Home
-
Michael Fry
Seller's Agent in 2018
Michael Fry
Koogler-Eyre Realtors
(850) 225-8122
18 Total Sales
-
Holly Pavone
Buyer's Agent in 2018
Holly Pavone
Comey & Shepherd
(513) 262-3819
10 Total Sales
-
KM
Seller's Agent in 2017
Kendra McKeever
OwnerLand Realty, Inc.
-
Sean Cole
Buyer's Agent in 2017
Sean Cole
Keller Williams Seven Hills Re
(513) 477-9647
42 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1562874
APN: 500-0113-0016
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
- 684 Balbriggan Ct
- 8008 Hignite Ct
- 579 Ridgestone Dr
- 8041 Woodruff Rd
- 8017 Eastdale Dr
- 8074 Eastdale Dr
- 7976 Villas of Cross Creek
- 3601 Nine Mile Tobasco Rd
- 0 Forest Rd Unit 1884842
- 7977 Nagel Village Dr
- 8375 Brownsboro Place
- 8265 Forest Rd
- 8455 Brownsboro Place
- 830 Sunderland Dr
- 8650 Green Rd
- 136 Coldstream Villa Dr
- 7803 Ayers Rd
- 1080 Wittshire Ln
- 995 Nottingham Dr
- 8024 Witts Mill Ln Unit 171
- 8063 Hopper Rd
- 8085 Hopper Rd
- 615 Innisfree Ln
- 8057 Hopper Rd
- 8111 Hopper Rd
- 8020 Parkside Lake Dr Unit 1
- 8020 Parkside Lake Dr
- 8039 Hopper Rd
- 618 Balbriggan Ct
- 8119 Hopper Rd
- 620 Balbriggan Ct
- 610 Innisfree Ln
- 8010 Parkside Lake Dr
- 8010 Parkside Lake Dr Unit 2
- 627 Innisfree Ln
- 594 Forestedge Dr
- 590 Forestedge Dr Unit 4
- 620 Innisfree Ln
- 8036 Hopper Rd
- 623 Balbriggan Ct
Your Personal Tour Guide
Ask me questions while you tour the home.