Seller's Agent in 2025
Lauren Hoeffel
Coldwell Banker Realty
(513) 913-4710
2 in this area
19 Total Sales
1014 Celestial St Cincinnati, OH 45202
Mount Adams Neighborhood
3
Beds
2.5
Baths
2,052
Sq Ft
2,004
Sq Ft Lot
Highlights
- City View
- Dining Room with Fireplace
- Traditional Architecture
- Walnut Hills High School Rated A+
- Marble Flooring
- Quartz Countertops
About This Home
As of July 2025This Mt. Adams beauty underwent a stunning renovation! High end finishes include quartz countertops, beautiful hardwood floors, large bathrooms with marble tile, waterfall shower heads and a soaking tub. With an open living concept, tall ceilings, built in bar, inviting paver patio and a meticulously landscaped yard, this house is perfect for entertaining. All of this, in the heart of Mt Adams! Build a rooftop deck to enjoy exceptional views of downtown, the Ohio River, and firework displays at Great American Ballpark and the Riverfront! One off street parking space available, and plenty of on street parking with easy access to your new home.
Last Agent to Sell the Property
Coldwell Banker Realty License #2016003662 Listed on: 05/01/2025
Home Details
Home Type
- Single Family
Year Built
- Built in 1873
Lot Details
- 2,004 Sq Ft Lot
- Lot Dimensions are 25x95
- Wood Fence
- Level Lot
- Historic Home
Parking
- On-Street Parking
Home Design
- Traditional Architecture
- Stone Foundation
- Membrane Roofing
- Wood Siding
Interior Spaces
- 2,052 Sq Ft Home
- 2-Story Property
- Dry Bar
- Insulated Windows
- Living Room with Fireplace
- Dining Room with Fireplace
- City Views
- Unfinished Basement
- Partial Basement
Kitchen
- Breakfast Bar
- Oven or Range
- Microwave
- Dishwasher
- Wine Cooler
- Kitchen Island
- Quartz Countertops
- Solid Wood Cabinet
Flooring
- Wood
- Marble
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- Dual Vanity Sinks in Primary Bathroom
- Bathtub
Laundry
- Dryer
- Washer
Outdoor Features
- Patio
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
Community Details
- No Home Owners Association
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 1, 2025
Closed on
Jul 1, 2025
Sold by
Bauer Lafe
Bought by
Bramkamp Michael Dawson
Seller's Agent
Lauren Hoeffel
Coldwell Banker Realty
Buyer's Agent
Janice Gerding
Coldwell Banker Realty
List Price
$729,000
Sold Price
$690,000
Premium/Discount to List
-$39,000
-5.35%
Views
21
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
-$43,967
Avg. Annual Appreciation
-12.57%
Original Mortgage
$552,000
Outstanding Balance
$551,067
Interest Rate
6.86%
Mortgage Type
New Conventional
Estimated Equity
$94,966
Purchase Details
Closed on
Oct 21, 2017
Sold by
Tran Tom and Wong Lok Sze
Bought by
Scudder Marker Lisa
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$265,000
Interest Rate
4.04%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 7, 2011
Sold by
Cohen Tracy L
Bought by
Tran Tom
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$225,000
Interest Rate
4.12%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 3, 2011
Sold by
Holohan Mary Jo
Bought by
Cohen Tracy L
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$225,000
Interest Rate
4.12%
Mortgage Type
New Conventional
Purchase Details
Closed on
May 31, 2001
Sold by
Jo Holohan Mary
Bought by
Gittinger Steven C
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$240,000
Interest Rate
7.16%
Purchase Details
Closed on
Nov 28, 2000
Sold by
Estate Of William J Holohan
Bought by
Holohan Mary Jo
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 | $690,000 | 360 American Title | |
| Warranty Deed | $407,000 | Stewart Title Relocation | |
| Warranty Deed | $300,000 | Attorney | |
| Quit Claim Deed | -- | Attorney | |
| Warranty Deed | $300,000 | Classic Title Agency Inc | |
| Warranty Deed | -- | -- | |
| Certificate Of Transfer | -- | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $552,000 | New Conventional | |
| Previous Owner | $265,000 | New Conventional | |
| Previous Owner | $225,000 | New Conventional | |
| Previous Owner | $240,000 | No Value Available | |
| Closed | $30,000 | No Value Available |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 07/01/2025 07/01/25 | Sold | $690,000 | -5.3% | $336 / Sq Ft | |
| 05/17/2025 05/17/25 | Pending | -- | -- | -- | |
| 05/01/2025 05/01/25 | For Sale | $729,000 | 0.0% | $355 / Sq Ft | |
| 06/29/2024 06/29/24 | Rented | $4,500 | -4.3% | -- | |
| 06/29/2024 06/29/24 | Under Contract | -- | -- | -- | |
| 06/21/2024 06/21/24 | Price Changed | $4,700 | -6.0% | $2 / Sq Ft | |
| 06/07/2024 06/07/24 | For Rent | $5,000 | 0.0% | -- | |
| 06/28/2023 06/28/23 | Sold | $414,000 | -11.9% | $202 / Sq Ft | View Prior Sale |
| 06/09/2023 06/09/23 | Pending | -- | -- | -- | |
| 06/02/2023 06/02/23 | For Sale | $469,900 | +15.5% | $229 / Sq Ft | |
| 05/29/2018 05/29/18 | Off Market | $407,000 | -- | -- | |
| 02/28/2018 02/28/18 | Sold | $407,000 | -4.1% | $215 / Sq Ft | View Prior Sale |
| 01/12/2018 01/12/18 | Pending | -- | -- | -- | |
| 01/08/2018 01/08/18 | Price Changed | $424,500 | -0.1% | $224 / Sq Ft | |
| 12/04/2017 12/04/17 | Price Changed | $425,000 | -4.8% | $224 / Sq Ft | |
| 10/16/2017 10/16/17 | For Sale | $446,250 | -- | $235 / 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 | $8,009 | $134,309 | $56,595 | $77,714 |
| 2023 | $8,190 | $134,309 | $56,595 | $77,714 |
| 2022 | $9,681 | $142,450 | $54,537 | $87,913 |
| 2021 | $9,325 | $142,450 | $54,537 | $87,913 |
| 2020 | $9,597 | $142,450 | $54,537 | $87,913 |
| 2019 | $8,119 | $110,219 | $51,450 | $58,769 |
| 2018 | $8,132 | $110,219 | $51,450 | $58,769 |
| 2017 | $7,727 | $110,219 | $51,450 | $58,769 |
| 2016 | $7,466 | $105,001 | $49,907 | $55,094 |
| 2015 | $6,729 | $105,001 | $49,907 | $55,094 |
| 2014 | $6,777 | $105,001 | $49,907 | $55,094 |
| 2013 | $7,480 | $113,911 | $51,450 | $62,461 |
Source: Public Records
Agents Affiliated with this Home
-
Lauren Hoeffel
-
Janice Gerding
Buyer's Agent in 2025
Janice Gerding
Coldwell Banker Realty
(513) 608-3770
1 in this area
73 Total Sales
-
Non Member
N
Buyer Co-Listing Agent in 2024
Non Member
NonMember Firm
-
Don Johnson
Seller's Agent in 2023
Don Johnson
Cutler Real Estate
(513) 703-0658
4 in this area
221 Total Sales
-
Evan Johnson
Seller Co-Listing Agent in 2023
Evan Johnson
Cutler Real Estate
(513) 703-0658
5 in this area
195 Total Sales
-
Michael Teggart
Seller's Agent in 2018
Michael Teggart
Comey & Shepherd
(513) 300-7644
1 in this area
76 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1839336
APN: 073-0001-0037
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
- 330 Oregon St
- 341 Oregon St
- 327 Oregon St
- 325 Oregon St
- 953 Hill St
- 1054 Saint Paul Place
- 955 Pavilion St
- 310 Oregon St
- 328 Oregon St
- 397 Oregon St
- 1109 Fuller St
- 399 Oregon St
- 1125 Belvedere St
- 1112 Fuller St
- 900 Adams Crossing
- 502 Baum St
- 506 Baum St Unit 1
- 902 Monastery St
- 512 Baum St
- 961 Hatch St