Janelle Sprandel
Comey & Shepherd REALTORS
(513) 599-0248
334 Total Sales
1 in Coldstream
$685,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
Janelle Sprandel
Comey & Shepherd REALTORS
(513) 599-0248
334 Total Sales
1 in Coldstream
$685,000 Price
Michael Jennings
Plum Tree Realty
(513) 993-1409
114 Total Sales
1 in Coldstream
$180,000 Price
Patrick Lach
Sibcy Cline, Inc.
(513) 952-8835
107 Total Sales
1 in Coldstream
$4,578,000 Price
Julie Comella
Plum Tree Realty
(513) 866-7528
23 Total Sales
2 in Coldstream
$1M - $1.3M Price Range
Nancy Pater
Keller Williams Seven Hills Re
(513) 547-2505
32 Total Sales
2 in Coldstream
$725K - $800K Price Range
Steven Booth
Sibcy Cline, Inc.
(947) 210-5365
89 Total Sales
1 in Coldstream
$695,000 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.