Chris Henkaline
eXp Realty
(513) 586-4061
128 Total Sales
1 in Mount Adams
$655,000 Price
1014 Celestial St Cincinnati, OH 45202
Mount Adams NeighborhoodEstimated Value: $541,000 - $712,000
3
Beds
2.5
Baths
2,052
Sq Ft
$320/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
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
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
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
Listed on
May 1, 2025
Closed on
Jul 1, 2025
Sold by
Bauer Lafe
Bought by
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
-$33,209
Avg. Annual Appreciation
-4.09%
Original Mortgage
$552,000
Outstanding Balance
$546,240
Interest Rate
6.86%
Mortgage Type
New Conventional
Estimated Equity
$110,551
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
Gittinger Steven C
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
$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
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Mount Adams, OH
-
Chris Henkaline
-
Nickolas Welage
Nickolas Welage
Plum Tree Realty
(513) 586-3385
129 Total Sales
1 in Mount Adams
$550,000 Price
-
Josh Endsley
Josh Endsley
Responds QuicklyLohmiller Real Estate
(513) 810-5723
108 Total Sales
1 in Mount Adams
$351,750 Price
-
Cindy Shetterly
Cindy Shetterly
Keller Williams Realty Service
(513) 866-3124
526 Total Sales
3 in Mount Adams
$510K - $2.7M Price Range
-
Maria Walley
Maria Walley
Comey & Shepherd
(513) 854-0440
104 Total Sales
1 in Mount Adams
$825,000 Price
-
Wendi Sheets
Wendi Sheets
eXp Realty
(513) 813-1446
214 Total Sales
1 in Mount Adams
$368,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 |
|---|---|---|---|
| $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 | |
| Cohen Tracy L | -- | -- | |
| Gittinger Steven C | $300,000 | Classic Title Agency Inc | |
| 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 | $552,000 | ||
| Previous Owner | Bauer Lafe | $207,000 | |
| Previous Owner | Scudder-Marker Lisa | $354,000 | |
| Previous Owner | Scudder Marker Lisa | $270,000 | |
| Previous Owner | Scudder Marker Lisa | $265,000 | |
| Previous Owner | Tran Tom | $225,000 | |
| Previous Owner | Cohen Tracy L | $378,900 | |
| Previous Owner | Cohen Tracy L | $279,000 | |
| Previous Owner | Cohen Tracy L | $65,000 | |
| Previous Owner | Cohen Tracy L | $277,000 | |
| Previous Owner | Cash Robert M | $39,650 | |
| Previous Owner | Cohen Tracy L | $275,000 | |
| Previous Owner | Gittinger Steven C | $240,000 | |
| Previous Owner | Holohan William J | $59,000 |
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 |
|---|---|---|---|---|---|
| 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
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 | $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
Seller's Agent in 2025
Lauren Hoeffel
Coldwell Banker Realty
(513) 913-4710
2 in this area
14 Total Sales
-
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
206 Total Sales
-
Evan Johnson
Seller Co-Listing Agent in 2023
Evan Johnson
Cutler Real Estate
(513) 703-0658
5 in this area
227 Total Sales
-
Michael Teggart
Seller's Agent in 2018
Michael Teggart
Comey & Shepherd
(513) 300-7644
1 in this area
70 Total Sales
-
Shawn Baker
Seller Co-Listing Agent in 2018
Shawn Baker
Comey & Shepherd
(513) 371-6566
1 in this area
52 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
- 1021 Saint Gregory St
- 1033 Saint Gregory St
- 330 Oregon St
- 949 Pavilion St
- 1112 Fuller St
- 387 Oregon St
- 1003 Hill St
- 1126 Fuller St
- 399 Oregon St
- 404 Baum St
- 1130 Carney St
- 430 Oregon St
- 1224 Ida St
- 927 Paradrome St
- 915 Monastery St
- 951 Parkside Place
- 1238 Elsinore Ave
- 945 Parkside Place
- 1022 Hatch St Unit 2
- 1261 Ida 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
- 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
- 1009 Saint Gregory St
Your Personal Tour Guide
Ask me questions while you tour the home.