Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$415,000 Just Listed

  • For Sale
  • Active
  • Condo
  • 2 Beds
  • 1 Full Bath
  • 1 Partial Bath
  • 1,500 Sq. Ft.
  • 1 Car Garage
  • Updated 9 hours ago

Next open house:

Open House: 2:00 PM - 4:00 PM

Saturday 2/21 2:00 PM - 4:00 PM

1004 Celestial Street #A,Cincinnati, OH 45202

1004 Celestial Street #ACincinnatiOH45202

Get directions
See This Home
Save This Home
See This Home
Save This Home
Fabulous Mt Adams condo with River and City views!! Neutral colors, sleek style & finishes PLUS 1-car garage & assigned spot. Huge 20x10 recently rebuilt deck. Modern style kitchen & sleek baths adorned w/stainless*granite*emperador marble*cool lighting & fixtures. Office w/walkout to private fenced covered patio & yard, 2 WBFPs, laundry & bonus room perfect for wine cellar, workshop, large storage. Newer Furnace. Low HOA.

Full Property Details for 1004 Celestial St. #A

General

  • Price: $415,000
  • HOA FEE: $177/month
  • Status: Active
  • Type: Condo
  • Source: Cincinnati
  • MLS ID: 1868697
  • Updated: Today (2/20/2026)
  • Added to Site: Today

Interior

  • Number of Rooms: 10
  • Rooms/Areas: Bonus Room, Wine Cellar, Workshop, Other
  • Interior Features: Beam Ceiling, Skylight
  • Fireplace: Yes
  • Number of Fireplaces: 2
  • Fireplace(s): Brick, Wood-Burning
  • Appliances: Dishwasher, Dryer, Electric Cooktop, Garbage Disposal, Microwave, Oven/Range, Refrigerator, Washer

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Primary Bathroom: Shower, Tile Floor, Marb/Gran/Slate
  • Bathroom 1: Full, Level 1
  • Bathroom 2: Partial, Level 2

Bedrooms

  • Total Bedrooms: 2
  • Primary Bedroom: Window Treatment, 15 x 11, Level 1, 165 Sq. Ft.
  • Bedroom 2: 11 x 9, Level 1, 99 Sq. Ft.

Other Rooms

  • Foyer/Entry: Closet, Open Foyer, Tile Floor, Transom/Sidelit, Wood Floor, Level 2
  • Living Room: Walk-Out, Fireplace, Window Treatment, Wood Floor, 15 x 13, Level 2, 195 Sq. Ft.
  • Kitchen: Counter Bar, Eat-In, Tile Floor, Gourmet, Window Treatment, Wood Cabinets, Marble/Granite/Slate, 15 x 8, 15x8, 120 Sq. Ft.
  • Dining Room: Walk-Out, Window Treatment, Fireplace, Wood Floor, 13 x 8, Level 2, 104 Sq. Ft.
  • Breakfast Room: 9 x 9, Level 2, 81 Sq. Ft.
  • Office/Den/Study: 14 x 11, Level 1, 154 Sq. Ft.
  • Office: Walk-Out, Fireplace, Window Treatment
  • Laundry: 11 x 10, Lower, 110 Sq. Ft.

Additional Information

  • Amenities: Dir Ent Garage-Bldg, Pets Allowed, Private Entry, Unit On Top Floor, Laundry-Common Area, Laundry-In Unit
  • Mechanicals: Garage Door Opener
  • Other Features: Bus Line Nearby, Cable, Recessed Lights

Exterior

  • Exterior Features: Covered Deck/Patio, Deck, Patio

Parking

  • Garage: Yes
  • Garage Spaces: 1
  • Parking: 2 Assigned, Driveway
  • Garage Description: Built-In, Oversized

Location

  • Area: Mt. Adams
  • County: Hamilton
  • Township: Cincinnati City
  • Suburb: Mt. Adams
  • Cross Streets: Hill St
  • Driving Directions: Hill St, Ida St or Monastery St to Celestial
  • Transportation: Busline Near

School Information

  • School District: Cincinnati City SD
  • High School District: Cincinnati City SD

Community

  • Association: Yes
  • Home Owners Assn.: True
  • Assoc. Fees Include: Insurance, AssociationDues, LandscapingCommunity, ProfessionalMgt
  • Mgmt. Company: Denali Property Mgmt

Heating & Cooling

  • Central air: Yes
  • Cooling Type: Central Air Conditioning
  • Heating Type: Forced Air, Gas
  • Heating Fuel: Natural
  • Water Heater: Gas

Utilities

  • Sewer: Public Sewer
  • Water: Public

Structural Information

  • Architectural Style: Two Story Contemporary/Modern
  • Exterior Const.: Brick
  • Basement: Yes
  • Basement Desc.: Full, Unfinished, Walk-Out
  • Foundation: Poured
  • Roof: Membrane
  • Windows: Slider, Vinyl
  • Stories/Levels: Two
  • Square Feet: 1,500
  • Year Built: 1968

Lot Features

  • Property View: City, River, Valley
  • Zoning: Residential
  • Fencing (Description): Privacy

Financial Considerations

  • Association Fee: $177
  • Assoc Fee Freq.: Monthly
  • Semi-Annual Taxes: $3929

Disclosures and Reports

  • APN: 073-0001-0242-00

Listed by Sibcy Cline, Inc. (513) 321-9922, Carl Tuke

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 1004 Celestial St. #A —

  • Carl Tuke

    Sibcy Cline, Inc.

    513-321-9922

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 1004 Celestial St. #A

School District:Cincinnati City School District
NameGradesDistance
Walnut Hills High School
3250 Victory Parkway, Cincinnati, OH 45207
7-122.5 mi
Riverview East Academy
3555 Kellogg Avenue, Cincinnati, OH 45226
9-123 mi
Withrow University High School
2488 Madison Road, Cincinnati, OH 45208
7-123.4 mi
Robert A. Taft Information Technology High School
420 Ezzard Charles Drive, Cincinnati, OH 45214
7-121.4 mi
Hughes STEM High School
2515 Clifton Avenue, Cincinnati, OH 45219
7-122 mi
Clark Montessori High School
3030 Erie Avenue, Cincinnati, OH 45208
7-124.3 mi
Woodward Career Technical High School
7005 Reading Road, Cincinnati, OH 45237
7-126 mi
Mt. Washington Elementary School, Cincinnati, OH
1730 Mears Avenue, Cincinnati, OH 45230
PK-86.2 mi
Shroder Paideia High School
5030 Duck Creek Road, Cincinnati, OH 45227
7-126.3 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 1004 Celestial St. #A Get Price Alerts and Save Property

Date
Details
Price
Change
Source
2/20/2026
Listed
$415,000
33.87%
MLS
8/29/2005
Sold
$310,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 1004 Celestial St. #A

Year
Property Taxes
Change
Tax Assessment
Change
2025
$6,851
3%
$111,356
—
2024
$6,642
-2%
$111,356
—
2023
$6,792
7%
$111,356
19%
2021
$6,320
-1%
$93,783
—
2022
$6,377
1%
$93,783
—
2020
$6,320
1%
$93,783
10%
2019
$6,281
—
$85,257
—
2018
$6,290
5%
$85,257
—
2017
$5,976
-10%
$85,257
-9%
2016
$6,654
11%
$93,626
—
2015
$5,998
40%
$93,626
—
2014
$4,288
5%
$93,625
7%
2013
$4,078
—
$87,500
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 1004 Celestial St. #A

$
Down Payment
%
$
%

$
$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Sibcy Cline, Inc. (513) 321-9922, Carl Tuke

Similar Properties near 1004 Celestial St. #A

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

353 W 4th St, Cincinnati, OH 45202 - Photo 1
$418,000

353 W 4th St  #600  Cincinnati, OH 45202

  • Condo
  • Active
  • 2
    Beds
  • 2
    Total Baths
  • 1,559
    Sq. Ft.
1508 Pleasant St, Cincinnati, OH 45202 - Photo 1
$425,000

1508 Pleasant St  #201  Cincinnati, OH 45202

  • Condo
  • Active
  • Updated 7 days ago
  • 2
    Beds
  • 1
    Total Bath
  • 818
    Sq. Ft.
100 W 14th St, Newport, KY 41071 - Photo 1
$425,000
Open House

100 W 14th St  #B  Newport, KY 41071

  • Condo
  • Active
  • 2
    Beds
  • 3
    Total Baths
  • 1,550
    Sq. Ft.
Listed by Oyler Hines (513) 623-1351
100 W 14th St, Newport, KY 41071 - Photo 1
$425,000
Open House

100 W 14th St  #C  Newport, KY 41071

  • Condo
  • Active
  • 2
    Beds
  • 3
    Total Baths
  • 1,550
    Sq. Ft.
Listed by Oyler Hines (513) 623-1351

Just Listed near 1004 Celestial St. #A

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

100 W 13th St, Newport, KY 41071 - Photo 1 Just Listed
$762,900
Open House

100 W 13th St  Newport, KY 41071

  • Townhouse
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 4
    Total Baths
Listed by Oyler Hines (513) 623-1351
1019 Monmouth St, Newport, KY 41071 - Photo 1 Just Listed
$5,300

1019 Monmouth St  Newport, KY 41071

  • Commercial Lease
  • Active
  • Updated 1 day ago
31 E 13th St, Newport, KY 41071 - Photo 1 Just Listed
$379,900

31 E 13th St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 4 hours ago
  • 4
    Beds
  • 2
    Total Baths
  • 1,678
    Sq. Ft.
101 Watch Hill Ln, Newport, KY 41071 - Photo 1 Just Listed
$1,650,000
Open House

101 Watch Hill Ln  Newport, KY 41071

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 5
    Total Baths
  • 3,688
    Sq. Ft.

Price Reduced near 1004 Celestial St. #A

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

116 Dogwood Dr, Newport, KY 41076 - Photo 1 Price Reduced
-$5,000 (-2.86%)
$169,900

116 Dogwood Dr  Newport, KY 41076

  • Condo
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,378
    Sq. Ft.
310 W 10th St, Newport, KY 41071 - Photo 1 Price Reduced
-$10,000 (-2.3%)
$425,000

310 W 10th St  #308  Newport, KY 41071

  • Multi-Family
  • Active
  • Updated 3 days ago
  • 4
    Total Beds
120 Main St, Newport, KY 41071 - Photo 1 Price Reduced
-$9,900 (-3.25%)
$295,000

120 Main St  #205  Newport, KY 41071

  • Condo
  • Active
  • Updated 2 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 960
    Sq. Ft.
64 Parkview Ave, Newport, KY 41071 - Photo 1 Price Reduced
-$24,900 (-12.46%)
$175,000

64 Parkview Ave  Newport, KY 41071

  • Single Family
  • Active
  • Updated 3 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,620
    Sq. Ft.

Recent Sales near 1004 Celestial St. #A

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

960 Paradrome St, Cincinnati, OH 45202 - Photo 1 Sold
$414,900

960 Paradrome St  Cincinnati, OH 45202

  • Duplex
  • Closed
  • 1,952
    Sq. Ft.
1052 Hatch St, Cincinnati, OH 45202 - Photo 1 Sold
$400,000

1052 Hatch St  Cincinnati, OH 45202

  • Condo
  • Closed
  • 2
    Beds
  • 3
    Total Baths
  • 1,794
    Sq. Ft.
Listed and Sold by Hinckley Group
1026 Hatch St, Cincinnati, OH 45202 - Photo 1 Sold
$370,000

1026 Hatch St  Cincinnati, OH 45202

  • Condo
  • Closed
  • 2
    Beds
  • 2
    Total Baths
  • 1,615
    Sq. Ft.
400 Riverboat Row, Newport, KY 41071 - Photo 1 Sold
$442,000

400 Riverboat Row  #705  Newport, KY 41071

  • Condo
  • Closed
  • 1
    Bed
  • 2
    Total Baths
  • 1,153
    Sq. Ft.
Listed by Oyler Hines

1004 Celestial Street #A, Cincinnati, OH 45202 (MLS# 1868697) is a Condo property with 2 bedrooms, 1 full bathroom and 1 partial bathroom. 1004 Celestial Street #A is currently listed for $415,000 and was received on February 20, 2026. Want to learn more about 1004 Celestial Street #A? Do you have questions about finding other Condo real estate for sale in Mount Adams? You can browse all Mount Adams real estate or contact a Coldwell Banker agent to request more information.

Tour this property