Seller's Agent in 2025
Lauren Hoeffel
Coldwell Banker Realty
(513) 913-4710
2 in this area
16 Total Sales
1014 Celestial St Cincinnati, OH 45202
Mount Adams NeighborhoodEstimated Value: $661,000 - $742,000
3
Beds
2.5
Baths
2,052
Sq Ft
$336/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
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
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
-$325
Avg. Annual Appreciation
-0.05%
Original Mortgage
$552,000
Interest Rate
0.0686%
Mortgage Type
New Conventional
Purchase Details
Listed on
Jun 2, 2023
Closed on
Jun 26, 2023
Sold by
Bought by
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
0.0657%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 21, 2017
Sold by
Bought by
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
0.0404%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 7, 2011
Sold by
Bought by
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
0.0412%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 3, 2011
Sold by
Bought by
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
0.0412%
Mortgage Type
New Conventional
Purchase Details
Closed on
May 31, 2001
Sold by
Bought by
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
0.0716%
Purchase Details
Closed on
Nov 28, 2000
Sold by
Bought by
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 |
|---|---|---|---|
| $690,000 | 360 American Title | ||
| $414,000 | None Listed On Document | ||
| $407,000 | Stewart Title Relocation | ||
| $300,000 | Attorney | ||
| -- | Attorney | ||
| -- | -- | ||
| $300,000 | Classic Title Agency Inc | ||
| -- | -- |
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 |
|---|---|---|---|
| Closed | $552,000 | ||
| Closed | $207,000 | ||
| Closed | $354,000 | ||
| Closed | $270,000 | ||
| Closed | $265,000 | ||
| Closed | $225,000 | ||
| Closed | $378,900 | ||
| Closed | $279,000 | ||
| Closed | $65,000 | ||
| Closed | $277,000 | ||
| Closed | $39,650 | ||
| Closed | $275,000 | ||
| Closed | $240,000 | ||
| Closed | $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
-
Janice Gerding
Buyer's Agent in 2025
Janice Gerding
Coldwell Banker Realty
(513) 608-3770
1 in this area
73 Total Sales
-
Don Johnson
Seller's Agent in 2023
Don Johnson
Cutler Real Estate
(513) 703-0658
4 in this area
210 Total Sales
-
Evan Johnson
Seller Co-Listing Agent in 2023
Evan Johnson
Cutler Real Estate
(513) 703-0658
5 in this area
221 Total Sales
-
Michael Teggart
Seller's Agent in 2018
Michael Teggart
Comey & Shepherd
(513) 300-7644
1 in this area
74 Total Sales
-
Shawn Baker
Seller Co-Listing Agent in 2018
Shawn Baker
Comey & Shepherd
(513) 371-6566
1 in this area
57 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
- 1029 Celestial St
- 1027 Celestial St
- 1031 Celestial St
- 1031 Celestial St Unit 2
- 1023 Celestial St
- 9 Filson Place
- 7 Filson Place
- 1033 Celestial St
- 1021 Celestial St
- 1 Filson Place Unit 1
- 1 Filson Place
- 1 Filson Place
- 1 Filson Place
- 1 Filson Place Unit 3B
- 1 Filson Place Unit 3A
- 1034 Celestial St
- 1032 Celestial St
- 1041 Celestial St
- 1028 Celestial St
- 1026 Celestial St
Your Personal Tour Guide
Ask me questions while you tour the home.