Seller's Agent in 2025
Lauren Hoeffel
Coldwell Banker Realty
(513) 913-4710
2 in this area
17 Total Sales
1014 Celestial St Cincinnati, OH 45202
Mount Adams NeighborhoodEstimated Value: $656,000 - $810,000
3
Beds
2.5
Baths
2,052
Sq Ft
$345/Sq Ft
Est. Value
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
$18,491
Avg. Annual Appreciation
3.12%
Original Mortgage
$552,000
Outstanding Balance
$549,169
Interest Rate
6.86%
Mortgage Type
New Conventional
Estimated Equity
$159,322
Purchase Details
Listed on
Jun 2, 2023
Closed on
Jun 26, 2023
Sold by
Scudder-Marker Lisa
Bought by
Bauer Lafe
Seller's Agent
Don Johnson
Cutler Real Estate
Buyer's Agent
Lauren Hoeffel
Coldwell Banker Realty
List Price
$469,900
Sold Price
$414,000
Premium/Discount to List
-$55,900
-11.9%
Views
256
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
28.94%
Original Mortgage
$207,000
Interest Rate
6.57%
Mortgage Type
New Conventional
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
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 |
|---|---|---|---|
| Bramkamp Michael Dawson | $690,000 | 360 American Title | |
| Bauer Lafe | $414,000 | None Listed On Document | |
| Scudder Marker Lisa | $407,000 | Stewart Title Relocation | |
| Tran Tom | $300,000 | Attorney | |
| Cohen Tracy L | -- | Attorney | |
| Gittinger Steven C | $300,000 | Classic Title Agency Inc | |
| Cohen Tracy L | -- | -- | |
| Holohan Mary Jo | -- | -- |
Source: Public Records
Mortgage 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 | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Bramkamp Michael Dawson | $552,000 | |
| Previous Owner | Bauer Lafe | $207,000 | |
| Previous Owner | Scudder Marker Lisa | $265,000 | |
| Previous Owner | Tran Tom | $225,000 | |
| Previous Owner | Gittinger Steven C | $240,000 | |
| Closed | Gittinger Steven C | $30,000 |
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 | +76.1% | $355 / Sq Ft | |
| 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
| 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 | $8,259 | $134,309 | $56,595 | $77,714 |
| 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
72 Total Sales
-
Don Johnson
Seller's Agent in 2023
Don Johnson
Cutler Real Estate
(513) 703-0658
4 in this area
218 Total Sales
-
Evan Johnson
Seller Co-Listing Agent in 2023
Evan Johnson
Cutler Real Estate
(513) 703-0658
5 in this area
214 Total Sales
-
Michael Teggart
Seller's Agent in 2018
Michael Teggart
Comey & Shepherd
(513) 300-7644
1 in this area
75 Total Sales
-
Shawn Baker
Seller Co-Listing Agent in 2018
Shawn Baker
Comey & Shepherd
(513) 371-6566
1 in this area
58 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 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 1015 St Gregory St
- 330 Oregon St
- 949 Pavilion St
- 1054 Saint Paul Place
- 380 Baum St
- 380 Baum St Unit 5B
- 1112 Fuller St
- 310 Oregon St
- 328 Oregon St
- 387 Oregon St
- 1120 Fuller St
- 1126 Fuller St
- 502 Baum St
- 982 Hatch St
- 428 Oregon St
- 981 Paradrome St
- 1224 Ida St
- 985 Paradrome St
- 429 Oregon St
- 915 Paradrome St
- 1012 Celestial St
- 1016 Celestial St
- 1018 Celestial St
- 1008 Celestial St Unit C8
- 1008 Celestial St Unit C9
- 1008 Celestial St
- 1020 Celestial St
- 1017 Saint Gregory St
- 1017 Saint Gregory St Unit 2
- 1022 Celestial St
- 1019 Saint Gregory St
- 1011 Saint Gregory St
- 1021 Saint Gregory St
- 1004 Celestial St Unit B5
- 1004 Celestial St Unit 6
- 1004 Celestial St Unit B4
- 1004 Celestial St Unit A
- 1004 Celestial St Unit B
- 1004 Celestial St Unit 4
- 1024 Celestial St
Your Personal Tour Guide
Ask me questions while you tour the home.