1014 Celestial St, Cincinnati, OH 45202
OFF MARKET

1014 Celestial St
Cincinnati, OH 45202

Mt. Adams
  • 3 Beds
  • 2.5 Baths
  • 2,052 sqft
3 Beds
2.5 Baths
2,052 sqft

Homes for sale near 1014 Celestial St

Skip to last item
Skip to first item

Apartments for Rent

Skip to last item
Skip to first item

Local Information

Map showing home location
© Google
-- mins to
Commute Destination

Description

This 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.
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from July 01, 2025
Contact this Building
Property Website

Home Highlights

Parking
Open Parking
Outdoor
Patio
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago

Home Details for 1014 Celestial St

Interior Features

Interior Details
Basement: Partial,UnfinishedNumber of Rooms: 7Types of Rooms: Master Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Master Bathroom, Bathroom 1, Bathroom 2, Bathroom 3, Dining Room, Family Room, Kitchen, Living Room, Office
Beds & Baths
Number of Bedrooms: 3Number of Bathrooms: 3Number of Bathrooms (full): 2Number of Bathrooms (half): 1
Dimensions and Layout
Living Area: 2052 Square Feet
Appliances & Utilities
Appliances: Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Wine Cooler, Gas Water HeaterDishwasherDryerMicrowaveRefrigeratorWasher
Heating & Cooling
Heating: Forced Air,GasHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Forced Air
Fireplace & Spa
Fireplace: Dining Room, Living Room
Gas & Electric
Gas: Natural
Windows, Doors, Floors & Walls
Window: Aluminum Frames, Insulated Windows
Levels, Entrance, & Accessibility
Stories: 2Levels: Two
View
Has a ViewView: City

Exterior Features

Exterior Home Features
Roof: MembranePatio / Porch: PatioFencing: WoodExterior: OtherFoundation: StoneNo Private Pool
Parking & Garage
No CarportNo GarageNo Attached GarageHas Open ParkingParking: On Street
Frontage
Road Frontage: City Street
Water & Sewer
Sewer: Public Sewer
Surface & Elevation
Topography: Level

Property Information

Year Built
Year Built: 1873
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceStructure Type: HistoricalArchitecture: Traditional
Building
Construction Materials: Wood SidingNot a New Construction
Property Information
Parcel Number: 0730001003700

Price & Status

Price
List Price: $729,000Price Range: $0 - $729,000
Status Change & Dates
Possession Timing: Close Of Escrow

Active Status

MLS Status: Sold

Media

Location

Direction & Address
City: Cincinnati
School Information
High School District: Cincinnati City SD

Building

Building Area
Building Area: 2052 Square Feet

HOA

Association for this Listing: Cincinnati Area Multiple Listing ServiceNo HOA

Lot Information

Lot Area: 2003.76 sqft

Documents

Disclaimer: Information has not been verified, is not guaranteed and subject to change.<BR>Copyright</A> &copy;2025 <A name="trans">MLS of Greater Cincinnati, Inc. All rights reserved.</A><BR>

Offer

Listing Terms: No Special Financing, Conventional

Miscellaneous

BasementMls Number: 1839336Listing Url
Last check for updates: about 19 hours ago
Listed by Lauren E. Hoeffel, (513) 913-4710
Coldwell Banker Realty, (513) 891-8500
Bought with: Janice L Gerding, (513) 608-3770, Coldwell Banker Realty, (513) 321-9944
Originating MLS: Cincinnati Area Multiple Listing Service
Source: Cincy MLS, MLS#1839336
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 Zillow, Inc. 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. Zillow, Inc. 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

Price History for 1014 Celestial St

DatePriceEventSource
07/01/2025$690,000Sold
Cincy MLS #1839336
05/18/2025$729,000PendingCincy MLS #1839336
05/03/2025$729,000Listed For SaleCincy MLS #1839336
06/30/2024ListingRemovedCincy MLS #1804780
06/07/2024$729,000PriceChange
Cincy MLS #1804780
05/28/2024$739,000PriceChange
Cincy MLS #1804780
05/10/2024$749,000Listed For SaleCincy MLS #1804780
06/28/2023$414,000Sold
Cincy MLS #1774081
06/09/2023$469,900PendingCincy MLS #1774081
06/02/2023$469,900PriceChange
Cincy MLS #1774081
05/25/2023$484,900PendingCutler Real Estate #1770699
05/24/2023$484,900PendingToActiveCutler Real Estate #1770699
05/23/2023$484,900PendingCincy MLS #1770699
05/20/2023$484,900PriceChange
Cincy MLS #1770699
05/16/2023$489,900PriceChange
Cutler Real Estate #1770699
05/14/2023$534,900PriceChange
Cutler Real Estate #1770699
05/13/2023$489,900PriceChange
Cincy MLS #1770699
05/04/2023$534,900Listed For SaleCincy MLS #1770699
02/28/2018$407,000Sold
Cincy MLS #1557351
01/14/2018$424,500PendingAgent Provided
01/09/2018$424,500PriceChange
Agent Provided
12/05/2017$425,000PriceChange
Agent Provided
10/16/2017$446,250Listed For SaleAgent Provided
09/13/2017$2,850ListingRemovedN/A
07/21/2017$2,850Listed For RentN/A
10/27/2011$300,000Sold
N/A
06/18/2001$300,000Sold
N/A
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2024
Tax$8,009
Assessment$383,740
Home facts updated by county records

Comparable Sales for 1014 Celestial St

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
1109 Fuller St, Cincinnati, OH
0.13
Single-Family Home
$544,000
08/15/25
3
2.5
2,001
1125 Belvedere St, Cincinnati, OH
0.15
Single-Family Home
$655,000
12/23/25
3
3.5
2,176
961 Hatch St, Cincinnati, OH
0.20
Single-Family Home
$740,000
03/06/26
3
2.5
2,520
1222 Louden St, Cincinnati, OH
0.27
Single-Family Home
$505,000
09/04/25
3
2
1,967
1140 Carney St, Cincinnati, OH
0.23
Single-Family Home
$725,000
11/01/25
2
2.5
2,360
905 Paradrome St, Cincinnati, OH
0.27
Single-Family Home
$540,000
03/06/26
3
2
1,969
975 Hill St, Cincinnati, OH
0.12
Single-Family Home
$755,000
06/04/25
3
3
2,820
913 Paradrome St, Cincinnati, OH
0.27
Single-Family Home
$485,000
12/11/25
4
2.5
2,087

Assigned Schools

These are the assigned schools for 1014 Celestial St.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

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

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

Homes for rent near 1014 Celestial St

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

Off Market Homes Near 1014 Celestial St

Skip to last item
Skip to first item

Explore by feature

1014 Celestial St, Cincinnati, OH 45202 is a 3 bedroom, 3 bathroom, 2,052 sqft single-family home built in 1873. 1014 Celestial St is located in Mt. Adams, Cincinnati. This property is not currently available for sale. 1014 Celestial St was last sold on Jul 1, 2025 for $690,000 (5% lower than the asking price of $729,000).