Julie Comella
Plum Tree Realty
(513) 866-7528
21 Total Sales
1 in Coldstream
$1,340,077 Price
7800 Hopper Rd Cincinnati, OH 45255
Coldstream NeighborhoodEstimated Value: $1,529,000 - $1,905,487
5
Beds
6
Baths
5,989
Sq Ft
$285/Sq Ft
Est. Value
Highlights
- Spa
- Eat-In Gourmet Kitchen
- 3.32 Acre Lot
- Ayer Elementary School Rated A
- View of Trees or Woods
- Fireplace in Primary Bedroom
About This Home
As of May 2020Exceptional custom-built brick & stone home on 3.3 acres of privacy adjacent to Coldstream CC*High-end 1-floor living*Luxurious 1st fl master ste*Gourmet eat-in KIT open to great rm*Expansive fin walkout LL*Spectacular outdoor living spaces incl gunite pool w/adjoining spa/enclosed deck w/fireplace/cabana/firepit*4-car GAR*A vacation-like escape!
Last Agent to Sell the Property
Comey & Shepherd License #2003012566 Listed on: 02/18/2020
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
- $20
Year Built
- Built in 2007
Lot Details
- 3.32 Acre Lot
- Wooded Lot
Parking
- 4 Car Garage
- Driveway
Home Design
- Ranch Style House
- Transitional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Stone
Interior Spaces
- 5,989 Sq Ft Home
- Wet Bar
- Bookcases
- Dry Bar
- Chair Railings
- Woodwork
- Crown Molding
- Beamed Ceilings
- Ceiling height of 9 feet or more
- Ceiling Fan
- Chandelier
- Wood Burning Fireplace
- Gas Fireplace
- Double Pane Windows
- Window Treatments
- Wood Frame Window
- Casement Windows
- French Doors
- Panel Doors
- Entrance Foyer
- Great Room with Fireplace
- 4 Fireplaces
- Family Room
- Living Room with Fireplace
- Formal Dining Room
- Wood Flooring
- Views of Woods
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Bar
- Oven or Range
- Microwave
- Dishwasher
- Wine Cooler
- Kitchen Island
- Solid Wood Cabinet
- Disposal
Bedrooms and Bathrooms
- 5 Bedrooms
- Fireplace in Primary Bedroom
- Walk-In Closet
Partially Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Outdoor Features
- Spa
- Covered Deck
- Patio
- Outdoor Fireplace
- Fire Pit
Utilities
- Forced Air Zoned Heating and Cooling System
- Heating System Uses Gas
- Programmable Thermostat
- Gas Water Heater
- Septic Tank
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
Feb 18, 2020
Closed on
May 21, 2020
Sold by
Mcintyre Stacey L
Bought by
Seller's Agent
Bob Dorger
Comey & Shepherd
Buyer's Agent
Bob Dorger
Comey & Shepherd
List Price
$1,250,000
Sold Price
$1,050,000
Premium/Discount to List
-$200,000
-16%
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
$659,829
Avg. Annual Appreciation
8.09%
Original Mortgage
$750,000
Outstanding Balance
$651,346
Interest Rate
3.3%
Mortgage Type
New Conventional
Estimated Equity
$1,058,483
Purchase Details
Listed on
Feb 18, 2020
Closed on
May 12, 2020
Sold by
Ryan Robert M and Ryan Katherine S
Bought by
Mclntyre Stacley L
Seller's Agent
Bob Dorger
Comey & Shepherd
Buyer's Agent
Bob Dorger
Comey & Shepherd
List Price
$1,250,000
Sold Price
$1,050,000
Premium/Discount to List
-$200,000
-16%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$750,000
Outstanding Balance
$651,346
Interest Rate
3.3%
Mortgage Type
New Conventional
Estimated Equity
$1,058,483
Purchase Details
Closed on
Aug 10, 2006
Sold by
Ryan Robert M and Ryan Katherine S
Bought by
Ryan Robert M and Ryan Katherine S
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,230,000
Interest Rate
6.83%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jan 28, 2005
Sold by
Sullivan Wendall and Sullivan Marilyn J
Bought by
Ryan Robert M and Ryan Katherine S
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$320,000
Interest Rate
5.83%
Mortgage Type
Seller Take Back
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Coldstream, OH
-
Julie Comella
-
Nancy Pater
Nancy Pater
Keller Williams Seven Hills Re
(513) 547-2505
31 Total Sales
2 in Coldstream
$725K - $800K Price Range
-
Steven Booth
Steven Booth
Sibcy Cline, Inc.
(947) 210-5365
91 Total Sales
1 in Coldstream
$695,000 Price
-
Jennifer Allred
Jennifer Allred
Coldwell Banker Realty
(513) 440-3615
174 Total Sales
2 in Coldstream
$425K - $695K Price Range
-
Tammie Iverson
Tammie Iverson
Keller Williams Seven Hills Re
(513) 993-5332
100 Total Sales
1 in Coldstream
$700,000 Price
-
Jeff Rosa
Jeff Rosa
eXp Realty
(513) 866-8760
93 Total Sales
1 in Coldstream
$635,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 |
|---|---|---|---|
| $1,050,000 | None Available | ||
| Tobin Duke W | -- | None Available | |
| Mclntyre Stacley L | -- | None Available | |
| Ryan Robert M | -- | None Available | |
| Ryan Robert M | $400,000 | None Available |
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 | $750,000 | ||
| Previous Owner | Ryan Robert M | $700,000 | |
| Previous Owner | Ryan Robert M | $176,525 | |
| Previous Owner | Ryan Robert M | $1,230,000 | |
| Previous Owner | Ryan Robert M | $345,000 | |
| Previous Owner | Ryan Robert M | $320,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 |
|---|---|---|---|---|
| 08/19/2020 08/19/20 | Off Market | $1,050,000 | -- | -- |
| 05/21/2020 05/21/20 | Sold | $1,050,000 | -8.7% | $175 / Sq Ft |
| 04/20/2020 04/20/20 | Price Changed | $1,150,000 | -8.0% | $192 / Sq Ft |
| 04/17/2020 04/17/20 | Pending | -- | -- | -- |
| 02/18/2020 02/18/20 | For Sale | $1,250,000 | -- | $209 / 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 | $25,865 | $414,180 | $110,170 | $304,010 |
| 2024 | $25,153 | $414,180 | $110,170 | $304,010 |
| 2023 | $23,912 | $414,180 | $110,170 | $304,010 |
| 2022 | $23,820 | $367,500 | $99,575 | $267,925 |
| 2021 | $23,268 | $367,500 | $99,575 | $267,925 |
| 2020 | $23,536 | $367,500 | $99,575 | $267,925 |
| 2019 | $21,064 | $298,512 | $88,120 | $210,392 |
| 2018 | $19,730 | $298,512 | $88,120 | $210,392 |
| 2017 | $18,615 | $298,512 | $88,120 | $210,392 |
| 2016 | $14,247 | $222,951 | $88,239 | $134,712 |
| 2015 | $13,830 | $222,951 | $88,239 | $134,712 |
| 2014 | $13,838 | $222,951 | $88,239 | $134,712 |
| 2013 | $13,339 | $227,500 | $90,041 | $137,459 |
Source: Public Records
Agents Affiliated with this Home
-
Bob Dorger
Seller's Agent in 2020
Bob Dorger
Comey & Shepherd
(513) 518-8080
8 in this area
353 Total Sales
-
Robbie Dorger
Seller Co-Listing Agent in 2020
Robbie Dorger
Comey & Shepherd
(513) 504-9135
8 in this area
276 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1651017
APN: 500-0190-0061
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
- 7976 Villas of Cross Creek
- 3601 Nine Mile Tobasco Rd
- 0 Forest Rd Unit 1884842
- 7977 Nagel Village Dr
- 830 Sunderland Dr
- 8041 Woodruff Rd
- 8008 Hignite Ct
- 8017 Eastdale Dr
- 535 Rollingrock Ln
- 8074 Eastdale Dr
- 863 Woodlyn Dr S
- 7373 Woodcroft Dr
- 684 Balbriggan Ct
- 436 Heathgate Rd
- 480 Tam o Shanter Ct
- 7382 Ridgepoint Dr
- 7382 Ridgepoint Dr
- 136 Coldstream Villa Dr
- 871 Markley Woods Way
- 7859 Ayerdayl Ln
- 7729 Coldstream Woods Dr
- 1711 8 Mile Rd
- 7957 Villas at Cross Creek Unit 39112326
- 7957 Villas at Cross Creek Unit 39112316
- 7957 Villas at Cross Creek Unit 39112266
- 0 Shade Rd Unit 1751087
- 7711 Coldstream Woods Dr
- 612 Asbury Rd
- 7747 Coldstream Woods Dr
- 608 Asbury Rd
- 7730 Coldstream Woods Dr
- 7665 Coldstream Woods Dr
- 7712 Coldstream Woods Dr
- 598 Asbury Rd
- 623 Asbury Rd
- 613 Asbury Rd
- 7748 Coldstream Woods Dr
- 590 Asbury Rd
- 7757 Coldstream Woods Dr
- 7740 Hopper Rd
Your Personal Tour Guide
Ask me questions while you tour the home.