Seller's Agent in 2021
Michael Franz
Coldwell Banker Realty
(513) 259-7719
4 in this area
20 Total Sales
1059 Celestial St Cincinnati, OH 45202
Mount Adams NeighborhoodEstimated Value: $3,703,000 - $4,116,000
4
Beds
3.5
Baths
6,778
Sq Ft
$572/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
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
- 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
- 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
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
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 14, 2021
Closed on
Jun 18, 2021
Sold by
Lewis Bryan
Bought by
Bhandari Manish
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%
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
$854,586
Avg. Annual Appreciation
6.31%
Purchase Details
Listed on
Aug 6, 2012
Closed on
Apr 15, 2013
Sold by
The Joseph & Frances Jones Poetker Found
Bought by
Lewis Bryan
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
Coffey Thomas W
Bought by
Joseph and Foundatio Frances Jones
Purchase Details
Closed on
Mar 29, 1998
Sold by
Poetker Frances Jones
Bought by
Poetker Frances Jones
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 Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Bhandari Manish | $3,025,000 | Northwest Ttl Fam Of Compani | |
| Lewis Bryan | $520,000 | Attorney | |
| Joseph | -- | None Available | |
| Poetker Frances Jones | -- | -- |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 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 |
| 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 Compared to Growth
Tax History
| 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 |
|---|---|---|---|---|
| 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
-
-
Buyer's Agent in 2021
Heather Herr
Private Real Estate Collection
(513) 708-7770
14 in this area
621 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
-
Buyer's Agent in 2013
Susan Rissover
Keller Williams Advisors
(513) 886-7841
1 in this area
113 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 2025, 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
- A Oregon St
- 358 Oregon St
- 373 Oregon St Unit B
- 373 Oregon St
- 373 Oregon St Unit 369B
- 373 Oregon St Unit 1