1027 Celestial St #2, Cincinnati, OH 45202
Property image
Property image
OFF MARKET

1027 Celestial St #2
Cincinnati, OH 45202

Mt. Adams
  • 1 Bed
  • 1 Bath
  • 700 sqft

$254,200

Trulia Estimate
as of Aug 23, 2026
Est. Refi. Payment $1,679/mo*
Refinance Your Home

$254,200

Trulia Estimate
as of Aug 23, 2026
Est. Refi. Payment $1,679/mo*
Refinance Your Home
1 Bed
1 Bath
700 sqft

Home Value

Trulia Estimate
$254K
Since last month
Decreased$165K (-39.4%)
Since last year
Decreased$102K (-28.6%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value decreased by -41% in the last 10 years
MonthEstimated value
2026
August 2026$254K
July 2026$419K
June 2026$260K
May 2026$395K
April 2026$426K
March 2026$272K
February 2026$234K
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
920 Riverview Pl, Cincinnati, OH
0.05
Multi-Family Home
$485,000
12/01/25
3
3
2,091
960 Paradrome St, Cincinnati, OH
0.28
Multi-Family Home
$414,900
08/29/25
2
2
1,952
15 E Court St #2, Cincinnati, OH
0.82
Multi-Family Home
$250,000
03/04/26
1
1
1,300
982 Hatch St, Cincinnati, OH
0.26
Multi-Family Home
$472,000
05/28/26
3
3
1,725
421 Oregon St, Cincinnati, OH
0.18
Multi-Family Home
$340,000
07/10/26
3
3
3,972
1114 Carney St, Cincinnati, OH
0.21
Multi-Family Home
$495,000
01/09/26
3
4
3,843
1240 Elsinore Ave, Cincinnati, OH
0.29
Multi-Family Home
$300,000
02/26/26
6
3
2,712
943 Paradrome St, Cincinnati, OH
0.25
Multi-Family Home
$423,000
04/30/26
8
4
3,730
2011 Highland Ave, Cincinnati, OH
0.89
Multi-Family Home
$85,000
10/14/25
3
2
1,520
229 E 5th St, Newport, KY
0.91
Multi-Family Home
$314,000
09/12/25
2
2
1,896

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
9 Filson Pl, Cincinnati, OH 45202
0.01
$910,100
3
3
2,352
Off Market
6 Filson Pl, Cincinnati, OH 45202
0.03
$753,000
2
2.5
2,700
Off Market
4 Filson Pl, Cincinnati, OH 45202
0.04
$661,500
3
-
2,400
Off Market
2 Filson Pl #3, Cincinnati, OH 45202
0.04
$295,900
1
1
684
Off Market
1031 Celestial St, Cincinnati, OH 45202
0.01
$636,600
3
3
3,034
Off Market
1014 Celestial St, Cincinnati, OH 45202
0.04
$710,800
3
2.5
2,052
Off Market
1004 Celestial St #A, Cincinnati, OH 45202
0.05
$427,000
2
1.5
1,500
Recently Sold
1004 Celestial St #B, Cincinnati, OH 45202
0.05
$330,800
2
2
1,140
Off Market
899 Riverview Pl, Cincinnati, OH 45202
0.06
$755,000
3
3
1,969
Recently Sold
1011 Jerome St, Cincinnati, OH 45202
0.04
$841,000
3
2
2,806
Off Market
1015 St Gregory Street, Cincinnati, OH 45202
0.06
-
2
1
1,397
Off Market
1015 Saint Gregory St #1, Cincinnati, OH 45202
0.06
$270,000
1
1
921
Recently Sold

Local Information

  • Map ViewExplore the area around 1027 Celestial St #2.
  • Schools2 Preschool Schools3 Elementary Schools12 Middle Schools12 High Schools
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Property Type
Multi-Family
Living Area
700 sqft
Price/Sqft
$363
Parking
None

About this House

This multi-family home is located at 1027 Celestial St #2, Cincinnati, OH. 1027 Celestial St #2 is in the Mt. Adams neighborhood in Cincinnati, OH and in ZIP code 45202. This property has 1 bedroom, 1 bathroom and approximately 700 sqft of floor space.
1027 Celestial St #2, Cincinnati, OH 45202 is a 1 bedroom, 1 bathroom, 700 sqft multi-family in Mt. Adams. More recently, it was listed as a rental in January 2021 with an asking price of $950 per month. That rental listing was removed on January 30, 2021. It is currently off market. The Trulia Estimate is $254,200, with a rent estimate of $1,309/month.

Home Details for 1027 Celestial St #2

Property Information

Property Type / Style
Property Type: Multi Family

Interior Features

Appliances & Utilities
Dishwasher
Levels, Entrance, & Accessibility
Floors: Carpet

Exterior Features

Parking & Garage
Parking: None

Price and Tax history

DateEventPrice
Jan 30, 2021
Source: Zillow Rental Network Premium
ListingRemoved
Jan 23, 2021
Source: Zillow Rental Network Premium
Listed For Rent
$950
Nov 16, 2018
Source: N/A
ListingRemoved
$1,300
Oct 22, 2018
Source: N/A
Listed For Rent
$1,300
Sep 22, 2018
Source: N/A
ListingRemoved
$1,300

Market trends in Cincinnati

Last updated July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$258K
$4.33KMoM
Sale-to-List Price
100.0%
Price per sq ft
$174
$3MoM
Available listings
1537
20MoM

Around this home

Neighborhood Overview

Mt. Adams
See Local Highlights
Neighborhood stats provided by third party data sources.

What Locals Say about Mt. Adams

At least 31 Trulia users voted on each feature.

  • 100 % Say it's dog friendly

  • 97 % Say there are sidewalks

  • 94 % Say it's walkable to restaurants

  • 90 % Say people would walk alone at night

  • 79 % Say streets are well-lit

  • 79 % Say car is needed

  • 65 % Say neighbors are friendly

  • 63 % Say there's holiday spirit

  • 62 % Say yards are well-kept

  • 58 % Say parking is easy

  • 57 % Say there's wildlife

  • 57 % Say there are community events

  • 47 % Say they plan to stay for at least 5 years

  • 39 % Say kids play outside

  • 34 % Say it's quiet

  • 25 % Say it's walkable to grocery stores

Sourced by Trulia users. Learn more about our methodology.
  • Trulia User
    "This is a great location with tons of local shops, bars, & restaurants. Very walkable and dog friendly. "
    0
    Flag
  • Rebecca V.
    "Mt Adams is a charming neighborhood full of green spaces, the arts, cafes, restaurants and bars. Pretty much everything you need is within walking distance. Its close to downtown and great access to 71/75 making it easy to get places. "
    1
    Flag
  • Kris M.
    "My neighborhood is within walking distance to downtown. The public transportation is easily accessible. I topically walk to my job downtown and occasionally ride my bike to near by neighborhoods and stores downtown. "
    1
    Flag
  • Nicholas
    "Great neighborhood for kids: safe, walkable, friendly neighbors, neighborhood events (outdoor movies, concerts, holidays) and easy access to great resources for kids (pool, museum, downtown). Increasing number of young families committed to raising their kids on the Hill, PLUS you can live adjacent to downtown, reducing your commute, maximizing your time at home."
    0
    Flag
  • Charles
    "Mt. Adams is a Cincinnati gem - great for families, singles, and empty nesters alike. This neighborhood is an artistic hub for the city - boasting both the Art Museum and the Playhouse (both embarking on major updates), as well as one of the city’s finest parks and the Krohn Conservatory. Charming streets, amazing views and one of the lowest crime rates in the city make Mt. Adams a truly special place to live. Not least of all is the convenience for work and play: downtown, The Banks and OTR are a 20 minute walk or a 3 minute drive."
    0
    Flag
  • Seaven C
    "The neighborhood has easy access to both major highways and quick to get downtown or over the river. "
    0
    Flag
  • katz
    "There are always events happening at the top of Mt Adams. My street has a coordinator and people are always getting together. There is a great art and music scene here as well."
    0
    Flag
  • Cleaningtaylor92
    "i enjoy dogs, no complaints. just pick up poop, make sure they are leashed or contained to yard. my dog barks alot but is also always in our home. so noise wont be a neighborhood issue "
    0
    Flag
  • Smelcerash
    "Mt.Adams is great because it has plenty of green space as well as businesses. It has restaurant and bars. It also has a UDF for those items you forgot at the grocery store. "
    9
    Flag
  • alisonnugent75
    "Not great if you have children. Loud bars in the area and traffic barreling down the street. I moved my children out to the suburbs. "
    4
    Flag

LGBTQ Local Legal Protections

Frequently asked questions about 1027 Celestial St #2

  • What is 1027 Celestial St #2 estimated to be worth?
    Trulia's estimated value for 1027 Celestial St #2 in Cincinnati, OH is $254,200.
  • Is Cincinnati a buyer's or seller's market?
    Cincinnati is currently a buyer's market, based on recent for-sale activity.
  • What's the median sale price in Cincinnati?
    The median sale price in Cincinnati is $258K. That is up $4.33K from the prior month.
  • What do residents say about the Mt. Adams neighborhood?
    Residents describe the Mt. Adams neighborhood in Cincinnati, OH as dog-friendly, pedestrian-friendly, and walkable to restaurants. See recently sold homes in Mt. Adams, Cincinnati.

Explore by feature - Pet Friendly

1087 pet-friendly rentals in Cincinnati, OH

Explore by feature - Garage

272 rentals with a garage in Cincinnati, OH

Explore by feature - Air Conditioning

1076 rentals with air conditioning in Cincinnati, OH

Explore by feature - Pool

120 rentals with a pool in Cincinnati, OH

Explore by feature - Washer/dryer

936 rentals with a washer/dryer in Cincinnati, OH

Explore by feature - Outdoor Space

149 rentals with an outdoor space in Cincinnati, OH

Apartments for Rent

Skip to last item
Skip to first item

Off Market Homes Near 1027 Celestial St #2

Skip to last item
Skip to first item

Homes for sale near 1027 Celestial St #2

Skip to last item
Skip to first item
Skip to last item
  • Results are loading
Skip to first item