Jeff Rosa
eXp Realty
(513) 866-8760
94 Total Sales
1 in Coldstream
$635,000 Price
Magazine worthy-world class European inspired home!Situated on 2.88 lush acreas on one of Anderson Twp's most coveted streets with commanding river & valley views!Approx 7750 square feet of pure luxury.1st floor living w/1st flr primary, laundry, minimal steps,& elevator to all floors!This is the 1st time this original owner-custom built-property & true gem has been made available.The spectacular site offers amazing privacy.The open floor plan built by Joe Stewart celebrates the expansive view, grounds, stream,& gardens.Multiple outdoor living spaces w/mature landscaping provide the perfect backdrop to the solid brick masterpiece. Irreplaceable & original architectural details take center stage. An oversized 3 car garage compliments the main house. A truly once in a lifetime opportunity to own one of Cincinnati & Anderson Twp's finest homes.Gun cabinet in family room-lockable.Active wine cellar-tasting room.Peaceful screened porch.2 kitchens.Sauna.Exercise rm w/ballet bar.2 studies!
Last Agent to Sell the Property
Coldwell Banker Realty License #0000339877 Listed on: 05/22/2026
Jeff Rosa
eXp Realty
(513) 866-8760
94 Total Sales
1 in Coldstream
$635,000 Price
Cindy Shetterly
Keller Williams Realty Service
(513) 866-3124
535 Total Sales
3 in Coldstream
$134K - $830K Price Range
Kellie Barter
Weichert, REALTORS - R.E. 1790
(513) 572-6995
73 Total Sales
1 in Coldstream
$550,000 Price
Cheryl Boettger
Comey & Shepherd
(513) 854-0245
81 Total Sales
1 in Coldstream
$585,000 Price
Scott Ackerman
Coldwell Banker Realty
(513) 586-2519
79 Total Sales
1 in Coldstream
$615,000 Price
Lori Williams
Lohmiller Real Estate
(513) 854-1258
91 Total Sales
1 in Coldstream
$627,500 Price
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 |
|---|---|---|---|---|
| 06/25/2026 06/25/26 | Sold | $1,593,400 | -0.1% | $336 / Sq Ft |
| 05/26/2026 05/26/26 | Pending | -- | -- | -- |
| 05/22/2026 05/22/26 | For Sale | $1,594,900 | -- | $337 / Sq Ft |
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 | $26,250 | $429,622 | $107,604 | $322,018 |
| 2023 | $24,336 | $429,622 | $107,604 | $322,018 |
| 2022 | $20,181 | $318,931 | $107,604 | $211,327 |
| 2021 | $19,740 | $318,931 | $107,604 | $211,327 |
| 2020 | $19,921 | $318,931 | $107,604 | $211,327 |
| 2019 | $20,878 | $303,744 | $102,480 | $201,264 |
| 2018 | $19,559 | $303,744 | $102,480 | $201,264 |
| 2017 | $18,473 | $303,744 | $102,480 | $201,264 |
| 2016 | $23,224 | $370,637 | $129,126 | $241,511 |
| 2015 | $22,532 | $370,637 | $129,126 | $241,511 |
| 2014 | $22,543 | $370,637 | $129,126 | $241,511 |
| 2013 | $16,821 | $294,154 | $102,480 | $191,674 |
Seller's Agent in 2026
Julia Packer Wesselkamper
Coldwell Banker Realty
(513) 720-4496
2 in this area
283 Total Sales
Buyer's Agent in 2026
Jon Decurtins
ERA REAL Solutions Realty, LLC
(513) 600-7231
6 in this area
244 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1880135
APN: 500-0252-0074
Ask me questions while you tour the home.