Todd Blersch
Coldwell Banker Realty
(513) 866-7490
73 Total Sales
2 in Mount Adams
$645K - $800K Price Range
1059 Celestial St Cincinnati, OH 45202
Mount Adams NeighborhoodEstimated Value: $3,491,321
4
Beds
3.5
Baths
6,778
Sq Ft
$515/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- River View
- Deck
- Walnut Hills High School Rated A+
- 0.24 Acre Lot
- Contemporary Architecture
About This Home
As of June 20212017 Jose Garcia designed and built LEED Platinum architectural masterpiece for the most discerning buyer. 180 degree panoramic river and city views. Finest materials throughout with no expense spared. The BEST that Mt. Adams has to offer. A piece of art that you can live in. 6,700+ sqft, 3 car garage, double wide lot, custom finishes throughout, 14 years left of tax abatement, geothermal, solar panels, and so much more. A rare opportunity.
Last Agent to Sell the Property
Coldwell Banker Realty License #2016001788 Listed on: 05/14/2021
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
- $10
Year Built
- Built in 2017
Lot Details
- 10,585 Sq Ft Lot
- Lot Dimensions are 50' x 203'
Parking
- 3 Car Garage
- Driveway
- Off-Street Parking
Property Views
- River
- City
- Valley
Home Design
- Contemporary Architecture
- Brick Exterior Construction
- Poured Concrete
- Tile Roof
- Membrane Roofing
- Cedar
Interior Spaces
- 6,778 Sq Ft Home
- 3-Story Property
- Ceiling height of 9 feet or more
- Skylights
- Gas Fireplace
- Triple Pane Windows
- Insulated Windows
- Picture Window
- Sliding Windows
- Casement Windows
- Entrance Foyer
- Great Room with Fireplace
- Washer
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Bar
- Double Oven
- Gas Cooktop
- Microwave
- Dishwasher
- Wine Cooler
- ENERGY STAR Qualified Appliances
- Quartz Countertops
- Solid Wood Cabinet
- Disposal
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
Partially Finished Basement
- Walk-Out Basement
- Partial Basement
Eco-Friendly Details
- ENERGY STAR Qualified Equipment for Heating
- Solar Heating System
Outdoor Features
- Deck
- Patio
- Fire Pit
Utilities
- ENERGY STAR Qualified Air Conditioning
- Forced Air Zoned Heating and Cooling System
- Geothermal Heating and Cooling
- Gas Water Heater
Community Details
- No Home Owners Association
- Mt. Adams Subdivision
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
Jul 15, 2025
Sold by
Bought by
Current Estimated Value
Purchase Details
Listed on
May 14, 2021
Closed on
Jun 18, 2021
Sold by
Bought by
Seller's Agent
Michael Franz
Coldwell Banker Realty
Buyer's Agent
Heather Herr
Private Real Estate Collection
List Price
$3,249,000
Sold Price
$3,025,000
Premium/Discount to List
-$224,000
-6.89%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
2.84%
Purchase Details
Listed on
Aug 6, 2012
Closed on
Apr 15, 2013
Sold by
Bought by
Seller's Agent
Carolyn Caldwell
Kopf Real Estate
Buyer's Agent
Susan Rissover
Keller Williams Advisors
List Price
$800,000
Sold Price
$520,000
Premium/Discount to List
-$280,000
-35%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
24.02%
Purchase Details
Closed on
Oct 6, 2011
Sold by
Bought by
Purchase Details
Closed on
Mar 29, 1998
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Mount Adams, OH
-
Todd Blersch
-
DaVan Gassett
DaVan Gassett
Responds QuicklyKeller Williams Pinnacle Group
(513) 599-0218
56 Total Sales
1 in Mount Adams
$365,000 Price
-
Patrick Gunning
Patrick Gunning
Responds QuicklyColdwell Banker Realty
(513) 780-5066
96 Total Sales
1 in Mount Adams
$1,362,500 Price
-
Patrick Lach
Patrick Lach
Sibcy Cline, Inc.
(513) 952-8835
107 Total Sales
2 in Mount Adams
$710K - $2.2M Price Range
-
Kiley Johnson
Kiley Johnson
Coldwell Banker Heritage
(513) 655-2230
86 Total Sales
2 in Mount Adams
$290K - $295K Price Range
-
Megan Mull
Megan Mull
Plum Tree Realty
(513) 650-7793
32 Total Sales
1 in Mount Adams
$180,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 |
|---|---|---|---|
| $3,650,000 | None Listed On Document | ||
| $3,025,000 | Northwest Ttl Fam Of Compani | ||
| $520,000 | Attorney | ||
| -- | None Available | ||
| -- | -- |
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 |
|---|---|---|---|---|---|
| 06/18/2021 06/18/21 | Sold | $3,025,000 | -6.9% | $446 / Sq Ft | |
| 05/24/2021 05/24/21 | Pending | -- | -- | -- | |
| 05/14/2021 05/14/21 | For Sale | $3,249,000 | +524.8% | $479 / Sq Ft | |
| 07/15/2013 07/15/13 | Off Market | $520,000 | -- | -- | |
| 04/15/2013 04/15/13 | Sold | $520,000 | -35.0% | $233 / Sq Ft | View Prior Sale |
| 03/11/2013 03/11/13 | Pending | -- | -- | -- | |
| 08/06/2012 08/06/12 | For Sale | $800,000 | -- | $358 / 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 | $10,681 | $1,058,750 | $157,227 | $901,523 |
| 2024 | $10,356 | $1,058,750 | $157,227 | $901,523 |
| 2023 | $10,591 | $1,058,750 | $157,227 | $901,523 |
| 2022 | $11,313 | $969,885 | $151,508 | $818,377 |
| 2021 | $11,522 | $969,885 | $151,508 | $818,377 |
| 2020 | $60,638 | $969,885 | $151,508 | $818,377 |
| 2019 | $40,331 | $528,959 | $142,933 | $386,026 |
| 2018 | $40,363 | $200,589 | $142,933 | $57,656 |
| 2017 | $14,057 | $200,589 | $142,933 | $57,656 |
| 2016 | $12,936 | $182,001 | $138,646 | $43,355 |
| 2015 | $11,660 | $182,001 | $138,646 | $43,355 |
| 2014 | $11,744 | $182,001 | $138,646 | $43,355 |
| 2013 | $13,976 | $202,829 | $142,933 | $59,896 |
Source: Public Records
Agents Affiliated with this Home
-
Michael Franz
Seller's Agent in 2021
Michael Franz
Coldwell Banker Realty
(513) 259-7719
2 in this area
23 Total Sales
-
Heather Herr
Buyer's Agent in 2021
Heather Herr
Private Real Estate Collection
(513) 708-7770
10 in this area
651 Total Sales
-
C
Seller's Agent in 2013
Carolyn Caldwell
Kopf Real Estate
-
W
Seller Co-Listing Agent in 2013
William Kopf
Kopf Hunter Haas
-
Susan Rissover
Buyer's Agent in 2013
Susan Rissover
Keller Williams Advisors
(513) 886-7841
1 in this area
90 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1700222
APN: 073-0001-0209
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
- 1061 Celestial St
- 1055 Celestial St
- 1047 Celestial St
- 1045 Celestial St
- 376 Oregon St
- 378 Oregon St
- 1043 Celestial St
- 1 Celestial St
- C Celestial St
- 360 Oregon St
- 1041 Celestial St
- 329 Oregon St Unit 9
- 329 Oregon St Unit 8
- 329 Oregon St Unit 10
- 329 Oregon St
- 328 Oregon St
- 310 Oregon St
- A Oregon St
- 358 Oregon St
- 373 Oregon St Unit B
Your Personal Tour Guide
Ask me questions while you tour the home.