Seller's Agent in 2021
Michael Franz
Coldwell Banker Realty
(513) 259-7719
4 in this area
19 Total Sales
1059 Celestial St Cincinnati, OH 45202
Mount Adams Neighborhood
2
Beds
1.5
Baths
2,234
Sq Ft
10,454
Sq Ft Lot
Highlights
- River View
- Deck
- 1 Fireplace
- Walnut Hills High School Rated A+
- Contemporary Architecture
- No HOA
About This Home
As of June 2021Large level lot with spectacular city and river view, home it be sold in As Is condition. 24 hour notice a must.
Last Agent to Sell the Property
Carolyn Caldwell
Kopf Real Estate License #0000221730 Listed on: 08/06/2012
Co-Listed By
William Kopf
Kopf Hunter Haas License #0000127087
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $13,448
Year Built
- Built in 1950
Lot Details
- Lot Dimensions are 50 x 203'
- Aluminum or Metal Fence
Parking
- 2 Car Garage
- Driveway
Property Views
- River
- City
Home Design
- Contemporary Architecture
- Membrane Roofing
Interior Spaces
- 2,234 Sq Ft Home
- 1-Story Property
- 1 Fireplace
- Picture Window
- Formal Dining Room
Bedrooms and Bathrooms
- 2 Bedrooms
- Bathtub with Shower
Unfinished Basement
- Walk-Out Basement
- Partial Basement
Outdoor Features
- Deck
- Patio
Utilities
- Forced Air Heating and Cooling System
- Hot Water Heating System
- Heating System Uses Gas
Community Details
- No Home Owners Association
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Jul 15, 2025
Sold by
Bhandari Manish
Bought by
Bhandari Family Charitable Remainder Unitrust and Gupta
Current Estimated Value
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%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.16%
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $3,650,000 | None Listed On Document | |
| Warranty Deed | $3,650,000 | None Listed On Document | |
| Warranty Deed | $3,025,000 | Northwest Ttl Fam Of Compani | |
| Warranty Deed | $520,000 | Attorney | |
| Interfamily Deed Transfer | -- | None Available | |
| Warranty Deed | -- | -- |
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
-
Michael Franz
-
Heather Herr
Buyer's Agent in 2021
Heather Herr
Private Real Estate Collection
(513) 708-7770
14 in this area
625 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
111 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1323742
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
- 328 Oregon St
- 310 Oregon St
- 397 Oregon St
- 395 Oregon St
- 399 Oregon St
- 502 Baum St
- 330 Oregon St
- 902 Monastery St
- 512 Baum St
- 327 Oregon St
- 325 Oregon St
- 429 Oregon St
- 909 Riverview Place
- 1054 Saint Paul Place
- 937 Monastery St
- 955 Pavilion St
- 953 Hill St
- 1125 Belvedere St
- 1109 Fuller St
- 1112 Fuller St