Nickolas Welage
Plum Tree Realty
(513) 586-3385
129 Total Sales
1 in Mount Adams
$550,000 Price
1027 Celestial St Cincinnati, OH 45202
Mount Adams Neighborhood
2
Beds
2
Baths
1,664
Sq Ft
1916
Built
Highlights
- River View
- Balcony
- Central Air
- Walnut Hills High School Rated A+
- Porch
About This Home
As of December 2020Mount Adams duplex ready to move in. Lower unit was long term rental and upper unit is short term rental. Units can be combined to turn this back into a single family home or kept as long/short term rentals. Great view of the river from the back! Short distance to downtown. New roof 2019. Be sure to check out the virtual tour.
Last Agent to Sell the Property
Home Connections License #2014001607 Listed on: 09/23/2020
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
Property Details
Home Type
- Multi-Family
Est. Annual Taxes
- $6,022
Year Built
- Built in 1916
Lot Details
- Lot Dimensions are 27.19x87
Parking
- On-Street Parking
Home Design
- Duplex
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
Interior Spaces
- 1,664 Sq Ft Home
- 2-Story Property
- Non-Functioning Fireplace
- Vinyl Clad Windows
- River Views
- Basement Fills Entire Space Under The House
- Fire and Smoke Detector
Outdoor Features
- Balcony
- Porch
Utilities
- Central Air
- Heating System Uses Gas
Community Details
- Gross Income $28,800
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
Sep 23, 2020
Closed on
Dec 30, 2020
Sold by
Mccain Patrick and Tong Angie
Bought by
Seller's Agent
Paul Sian
Home Connections
Buyer's Agent
Lee Robinson
Robinson Sotheby's Internat'l
List Price
$320,000
Sold Price
$275,000
Premium/Discount to List
-$45,000
-14.06%
Purchase Details
Listed on
Jun 15, 2018
Closed on
Nov 30, 2018
Sold by
Zilli Mark P and Zilli Rachael
Bought by
Mccain Patrick and Tong Angie
Seller's Agent
Beth Silber
Coldwell Banker Realty
Buyer's Agent
Paul Sian
Home Connections
List Price
$349,000
Sold Price
$275,000
Premium/Discount to List
-$74,000
-21.2%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.00%
Original Mortgage
$206,250
Interest Rate
4.8%
Mortgage Type
Future Advance Clause Open End Mortgage
Purchase Details
Closed on
Sep 1, 2010
Sold by
Union Savings Bank
Bought by
Zilli Mark P and Zilli Kelly A
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$260,294
Interest Rate
4.5%
Mortgage Type
FHA
Purchase Details
Closed on
Dec 16, 2009
Sold by
Schifrin Kevin
Bought by
Union Savings Bank
Purchase Details
Closed on
Jun 16, 2000
Sold by
Holtz Rick and Holtz Richard P
Bought by
Schifrin Kevin L
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$161,550
Interest Rate
9.5%
Purchase Details
Closed on
Jun 14, 2000
Sold by
Mcdonald Gray Robert
Bought by
Holtz Rick and Holtz Richard P
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$161,550
Interest Rate
9.5%
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Mount Adams, OH
-
Nickolas Welage
-
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
525 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
-
Beth Silber
Beth Silber
Coldwell Banker Realty
(513) 650-7552
235 Total Sales
2 in Mount Adams
$615K - $750K Price Range
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 |
|---|---|---|---|
| $275,000 | Ivy Pointe Title Llc | ||
| Mccain Patrick | $275,000 | None Available | |
| Zilli Mark P | $263,800 | Prominent Title Agency Llc | |
| Union Savings Bank | $150,000 | None Available | |
| Schifrin Kevin L | $179,500 | -- | |
| Holtz Rick | $133,500 | -- |
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 |
|---|---|---|---|
| Previous Owner | $206,250 | ||
| Previous Owner | Zilli Kelly A | $239,000 | |
| Previous Owner | Zilli Mark P | $260,294 | |
| Previous Owner | Schifrin Kevin L | $340,000 | |
| Previous Owner | Schifrin Kevin L | $300,000 | |
| Previous Owner | Schifrin Kevin L | $240,000 | |
| Previous Owner | Schifrin Kevin L | $37,500 | |
| Previous Owner | Schifrin Kevin L | $200,000 | |
| Previous Owner | Schifrin Kevin L | $161,550 |
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 |
|---|---|---|---|---|---|
| 03/31/2021 03/31/21 | Off Market | $275,000 | -- | -- | |
| 12/30/2020 12/30/20 | Sold | $275,000 | -14.1% | $165 / Sq Ft | |
| 11/25/2020 11/25/20 | Pending | -- | -- | -- | |
| 11/09/2020 11/09/20 | For Sale | $320,000 | 0.0% | $192 / Sq Ft | |
| 11/03/2020 11/03/20 | Pending | -- | -- | -- | |
| 10/21/2020 10/21/20 | Price Changed | $320,000 | -2.1% | $192 / Sq Ft | |
| 09/23/2020 09/23/20 | For Sale | $327,000 | +18.9% | $197 / Sq Ft | |
| 03/03/2019 03/03/19 | Off Market | $275,000 | -- | -- | |
| 11/30/2018 11/30/18 | Sold | $275,000 | -11.3% | $165 / Sq Ft | View Prior Sale |
| 11/01/2018 11/01/18 | Pending | -- | -- | -- | |
| 09/22/2018 09/22/18 | Price Changed | $310,000 | -2.8% | $186 / Sq Ft | |
| 08/15/2018 08/15/18 | Price Changed | $319,000 | -6.1% | $192 / Sq Ft | |
| 07/23/2018 07/23/18 | Price Changed | $339,900 | +0.3% | $204 / Sq Ft | |
| 07/20/2018 07/20/18 | Price Changed | $339,000 | -2.9% | $204 / Sq Ft | |
| 06/15/2018 06/15/18 | For Sale | $349,000 | -- | $210 / 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 | $6,099 | $96,250 | $52,115 | $44,135 |
| 2023 | $5,925 | $96,250 | $52,115 | $44,135 |
| 2022 | $6,601 | $96,250 | $50,218 | $46,032 |
| 2021 | $6,388 | $96,250 | $50,218 | $46,032 |
| 2020 | $6,684 | $96,250 | $50,218 | $46,032 |
| 2019 | $6,028 | $81,214 | $47,376 | $33,838 |
| 2018 | $6,036 | $81,214 | $47,376 | $33,838 |
| 2017 | $5,752 | $81,214 | $47,376 | $33,838 |
| 2016 | $6,461 | $89,562 | $45,955 | $43,607 |
| 2015 | $5,811 | $89,562 | $45,955 | $43,607 |
| 2014 | $5,850 | $89,562 | $45,955 | $43,607 |
| 2013 | $6,135 | $92,330 | $47,376 | $44,954 |
Source: Public Records
Agents Affiliated with this Home
-
Paul Sian
Seller's Agent in 2020
Paul Sian
Home Connections
(513) 560-8002
21 Total Sales
-
Lee Robinson
Buyer's Agent in 2020
Lee Robinson
Robinson Sotheby's Internat'l
(513) 470-7700
16 in this area
148 Total Sales
-
Beth Silber
Seller's Agent in 2018
Beth Silber
Coldwell Banker Realty
(513) 317-6042
2 in this area
235 Total Sales
-
Traci Amend
Seller Co-Listing Agent in 2018
Traci Amend
Coldwell Banker Realty
(513) 608-0655
77 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1677070
APN: 073-0001-0175-00
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
- 330 Oregon St
- 1021 Saint Gregory St
- 1033 Saint Gregory St
- 387 Oregon St
- 399 Oregon St
- 1112 Fuller St
- 404 Baum St
- 1126 Fuller St
- 430 Oregon St
- 1130 Carney St
- 1224 Ida St
- 927 Paradrome St
- 991 Paradrome St
- 1238 Elsinore Ave
- 951 Parkside Place
- 945 Parkside Place
- 1022 Hatch St Unit 2
- 1261 Ida St
- 400 Pike St
- 817 Broadway St
- 1021 Celestial St
- 1023 Celestial St
- 9 Filson Place
- 1015 Celestial St
- 7 Filson Place
- 1029 Celestial St
- 8 Filson Place
- 1031 Celestial St
- 1031 Celestial St Unit 2
- 6 Filson Place
- 1018 Celestial St
- 1016 Celestial St
- 1026 Celestial St
- 1026 Celestial St Unit 1
- 1020 Celestial St
- 1014 Celestial St
- 4 Filson Place
- 1028 Celestial St
- 1022 Celestial St
- 1024 Celestial St
Your Personal Tour Guide
Ask me questions while you tour the home.