1041 Celestial St, Cincinnati, OH 45202
OFF MARKET

1041 Celestial St
Cincinnati, OH 45202

Mt. Adams
  • 4 Beds
  • 5 Baths
  • 4,475 sqft (on 0.27 acres)

$1,782,500

Trulia Estimate
as of Jun 12, 2025
Est. Refi. Payment $11,351/mo*
Refinance Your Home

$1,782,500

Trulia Estimate
as of Jun 12, 2025
Est. Refi. Payment $11,351/mo*
Refinance Your Home
4 Beds
5 Baths
4,475 sqft
(on 0.27 acres)

Homes for Sale Near 1041 Celestial St

Skip to last item
Skip to first item

Local Information

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

Description

This property is no longer available to rent or to buy. This description is from May 26, 2022
Unique and spacious Mount Adams home! Great Room features city & river views. Includes 3 lots below on Oregon to protect these views. Walk out to a multi level deck & inground pool. Over 4400 SF living space (per Hamilton Co. Auditor) w/huge bdrm suite, multiple walk in closets, 2nd flr office w/view & finished LL. Elevator from LL to 2nd floor. 3rd floor guest bdrm w/bath. A great mix of Mt. Adams charm & modern living spaces! Oversized 2 car garage and paver driveway.
Property Website

Home Highlights

Parking
Garage
Outdoor
Porch, Deck, Pool
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago

Home Details for 1041 Celestial St

Interior Features

Interior Details
Basement: Full,Finished,WW CarpetNumber of Rooms: 12Types of Rooms: Master Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Master Bathroom, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Dining Room, Family Room, Great Room, Kitchen, Living Room, Office
Beds & Baths
Number of Bedrooms: 4Number of Bathrooms: 5Number of Bathrooms (full): 4Number of Bathrooms (half): 1
Dimensions and Layout
Living Area: 4475 Square Feet
Appliances & Utilities
Appliances: Dishwasher, Oven/Range, Refrigerator, Gas Water HeaterDishwasherRefrigerator
Heating & Cooling
Heating: Baseboard,Hot WaterHas CoolingAir Conditioning: Central Air,Window Unit(s)Has HeatingHeating Fuel: Baseboard
Fireplace & Spa
Number of Fireplaces: 3Fireplace: Brick, Marble, Great RoomHas a Fireplace
Gas & Electric
Gas: Natural
Windows, Doors, Floors & Walls
Window: Double Hung
Levels, Entrance, & Accessibility
Stories: 3Elevator
View
Has a ViewView: City, River

Exterior Features

Exterior Home Features
Roof: ShinglePatio / Porch: Deck, PorchFencing: WoodFoundation: Concrete PerimeterHas a Private Pool
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageNo Attached GarageHas Open ParkingParking Spaces: 2Parking: Driveway,On Street,Garage Door Opener
Pool
Pool: Heated, In GroundPool
Water & Sewer
Sewer: Public Sewer

Property Information

Year Built
Year Built: 1914
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Traditional
Building
Construction Materials: BrickNot a New Construction
Property Information
Parcel Number: 0730001017100

Price & Status

Price
List Price: $1,995,000Price Range: $0 - $1,995,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: 4475 Square Feet

HOA

Association for this Listing: Cincinnati Area Multiple Listing ServiceNo HOA

Lot Information

Lot Area: 0.27 acres

Documents

Disclaimer: Information has not been verified, is not guaranteed and subject to change.

Offer

Listing Terms: No Special Financing, Cash

Miscellaneous

BasementMls Number: 1730478Listing UrlWater ViewWater View: River
Last check for updates: about 3 hours ago
Listed by Andrew N Tanen, (513) 702-7081
Sibcy Cline, Inc., (513) 793-2121
Bought with: Comey & Shepherd, (513) 891-4444
Originating MLS: Cincinnati Area Multiple Listing Service
Source: Cincy MLS, MLS#1730478
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 2025, MLS of Greater Cincinnati, Inc. All rights reserved

Price History for 1041 Celestial St

DatePriceEventSource
05/26/2022$1,500,000Sold
Cincy MLS #1730478
03/02/2022$1,995,000PendingCincy MLS #1730478
03/01/2022$1,995,000Listed For SaleCincy MLS #1730478
01/04/2022ListingRemovedSibcy Cline Realtors
11/15/2021$2,299,000PriceChange
Cincy MLS #1717528
10/18/2021$2,499,000PriceChange
Cincy MLS #1717528
10/04/2021$2,700,000Listed For SaleCincy MLS #1717528

Property Taxes and Assessment

Year2023
Tax$28,188
Assessment$1,271,430
Home facts updated by county records

Comparable Sales for 1041 Celestial St

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
337 Oregon St, Cincinnati, OH
0.06
Single-Family Home
$2,150,000
10/31/24
3
5
4,050
355 Oregon St, Cincinnati, OH
0.05
Single-Family Home
$1,099,000
03/21/25
3
4
3,501
943 Monastery St, Cincinnati, OH
0.19
Single-Family Home
$2,743,600
11/04/24
4
5
4,484
1236 Elsinore Ave, Cincinnati, OH
0.28
Single-Family Home
$982,000
07/12/24
3
4
3,530
1126 Fuller St, Cincinnati, OH
0.23
Single-Family Home
$1,295,000
07/29/24
3
3
3,264
975 Hill St, Cincinnati, OH
0.19
Single-Family Home
$755,000
06/04/25
3
3
2,820
1017 Parkside Pl, Cincinnati, OH
0.39
Single-Family Home
$1,000,000
09/09/24
4
3
3,206
1255 Ida St, Cincinnati, OH
0.32
Single-Family Home
$915,000
05/05/25
4
5
2,750
1137 Fort View Pl, Cincinnati, OH
0.29
Single-Family Home
$1,490,000
03/28/25
3
4
2,548

Assigned Schools

These are the assigned schools for 1041 Celestial St.
GreatSchools ratings are based on test scores and additional metrics when available.
Check with the applicable school district prior to making a decision based on these schools. 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%
    It's dog friendly
  • 97%
    There are sidewalks
  • 94%
    It's walkable to restaurants
  • 90%
    People would walk alone at night
  • 79%
    Streets are well-lit
  • 79%
    Car is needed
  • 65%
    Neighbors are friendly
  • 63%
    There's holiday spirit
  • 62%
    Yards are well-kept
  • 58%
    Parking is easy
  • 57%
    There's wildlife
  • 57%
    There are community events
  • 47%
    They plan to stay for at least 5 years
  • 39%
    Kids play outside
  • 34%
    It's quiet
  • 25%
    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 1041 Celestial St

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

Off Market Homes Near 1041 Celestial St

Skip to last item
Skip to first item
1041 Celestial St, Cincinnati, OH 45202 is a 4 bedroom, 5 bathroom, 4,475 sqft single-family home built in 1914. 1041 Celestial St is located in Mt. Adams, Cincinnati. This property is not currently available for sale. 1041 Celestial St was last sold on May 26, 2022 for $1,500,000 (25% lower than the asking price of $1,995,000). The current Trulia Estimate for 1041 Celestial St is $1,782,500.