1014 Celestial Street

Cincinnati, OH 45202

$690,000
Last Sold Price
3
Beds
2,052 Sq. Ft.
$336 / Sq. Ft.
2,052
Sq. Ft.
$336
per Sq. Ft.
Get preapproved with Rocket Mortgage1
Sold 7/1/25Virtual Tour
Sold 7/1/25Virtual Tour

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...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.
  1. Listed by Lauren E Hoeffel • Brokerage DRE #2008002487 • Coldwell Banker Realty
    P: (513)-913-4710 lauren.hoeffel@cbrealty.com

Property Details for 1014 Celestial Street

Architectural Style
Traditional, Historical
View
City
Zoning
Residential
Zoning Details
Residential
LISTING UPDATED: 07/01/2025 07:22 PM

Property Details for 1014 Celestial Street

StatusSold
MLS #1839336
Days on Market16
Taxes-
HOA Fees-
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built1873
Lot Size0.05 AC / 2,004 SF
CountyHamilton County
Get preapproved with Rocket Mortgage1

Location

Listing Courtesy of Coldwell Banker Realty

Sold By Coldwell Banker Realty

Add your commute

Virtual Tour

Building Information for 1014 Celestial Street

Stories-Year Built1873Building Size-Lot Size0.05 AC / 2,004 SF

Payment Calculator

Get preapproved with Rocket Mortgage1

$4,238 per month

30 year fixed, 6.36% Interest

Principal and Interest

$3,438

Property Taxes

$800

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 1014 Celestial Street

Summary
Location and General Information
  • MLS Area Major: Hamilton-E01
  • Access: City Street
  • Area Short Name: E01
  • Directions: Miller Dr. to Hill St. to Celestial St.
  • FIPS Code: 61
  • Topography: Level
  • Topography Details: Level
  • Township: Cincinnati City
  • Census Tract: 268.0
Taxes and HOA
  • Has Association: No
  • Parcel Number: 073-0001-0037-00
  • Semi Annual Taxes: $0
  • Tax Abatement: No
School Information
  • High School District: Cincinnati City SD
Parking
  • Parking Features: On Street
Virtual Tour
Property
Lot Information
  • Land Description: Less than .5 Acre
  • Lot Area: 2004.0
  • Lot Size Acres: 0.046
  • Lot Size Dimensions: 25x95
  • Lot Size Square Feet: 2004.0
  • Lot Size Units: Acres
  • 2nd Floor Area: 1044
Property and Assessments
  • Living Area: 2052.0
  • 3rd Party Approval Required: No
  • Above Grade Sq Ft: 2052
  • Assessment Amount: of record
  • Has Board Loaded: No
  • Complete Renovation: No
  • New Construction: No
  • Single Family Description: Single Family
  • Validated: Yes
  • Year Built: 1873
Building Features
  • Foundation Details: Stone
  • Levels: Two
  • Entry: 0x0 Level: 1
  • Entry Dimensions: 0 x 0
  • Has Additional Dwelling Unit: No
  • Construction Materials: Wood Siding
Utilities
  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public
Interior and Exterior Features
Exterior Features
  • Exterior Features: Patio, Other
  • Fencing: Wood
  • Roof: Membrane
Interior Features
  • Appliances: Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Wine Cooler
  • Basement: Partial
  • Basement Features: Unfinished
  • Bathroom1: Full
  • Bathroom1 Level: 2
  • Bathroom2: Full
  • Bathroom2 Level: 2
  • Bathroom3: Partial
  • Bathroom3 Level: 1
  • Bath Level1 Type: Full
  • Bathroom Level: Yes
  • Bathrooms: 3.0
  • Bathrooms Display: 3 (2 1)
  • Bathrooms Full: 2
  • Bathrooms Half: 1
  • Bedroom Level1: No
  • Bedrooms Total: 3
  • Basement Sq Ft: 340
  • Cooling: Central Air
  • Entry Foyer: Wood Floor
  • Heating: Forced Air, Gas
  • Primary Bathroom: Shower, Tile Floor, Double Vanity, Tub, Marb/Gran/Slate
  • Rooms Total: 7
  • Water Heating: Gas
  • Window Features: Aluminum, Insulated
Room Information
Bedroom
  • Bedroom Width: 13
  • Primary Bed Feature: Bath Adjoins, Wood Floor
  • Primary Bedroom: 16x13 Level: 2
  • Primary Bedroom Area: 208
  • Primary Bedroom Dimensions: 16 x 13
  • Primary Bedroom Length: 16
  • Primary Bedroom Width: 13
  • Bedroom 2: 14x13 Level: 2
  • Bedroom 2 Area: 182
  • Bedroom 2 Dimensions: 14 x 13
  • Bedroom 2 Length: 14
  • Bedroom 3: 15x12 Level: 2
  • Bedroom 3 Area: 180
  • Bedroom 3 Dimensions: 15 x 12
  • Bedroom 3 Length: 15
  • Bedroom 3 Width: 12
  • Bedroom 4 Dimensions: 0 x 0
  • Bedroom 5 Dimensions: 0 x 0
Breakfast Room
  • Breakfast Room Dimensions: 0 x 0
Dining Room
  • Dining Room: 15x14 Level: 1
  • Dining Room Area: 210
  • Dining Room Dimensions: 15 x 14
  • Dining Room Feat: Fireplace, Wood Floor
  • Dining Room Length: 15
  • Dining Room Width: 14
Family Room
  • Family Room: 12x11 Level: 1
  • Family Room Area: 132
  • Family Room Dimensions: 12 x 11
  • Family Room Feat: Dry Bar, Wood Floor, Other
  • Family Room Length: 12
  • Family Room Width: 11
Kitchen
  • Kitchen Area: 221
  • Kitchen Dimensions: 17 x 13
  • Kitchen Features: Pantry, Quartz Counters, Counter Bar, Walkout, Island, Wood Cabinets, Wood Floor
  • Kitchen Length: 17
  • Kitchen Width: 13
Laundry Room
  • Laundry Room: 7x4 Level: 2
  • Laundry Room Area: 28
  • Laundry Room Dimensions: 7 x 4
  • Laundry Room Length: 7
  • Laundry Room Width: 4
Living Room
  • Living Great Room Area: 238
  • Living Great Room Dimensions: 17 x 14
  • Living Great Room Length: 17
  • Living Great Room Width: 14
  • Living Room: 17x14 Level: 1
  • Living Room Feat: Fireplace, Wood Floor
Additional Room Information
  • Recreation Room Dimensions: 0 x 0
  • Study/Library Den Dimensions: 0 x 0
Rental
Rent Information
  • Occupancy: At Closing
  • Has Lease Considered: No
  • Sub Lease: No

Property History for 1014 Celestial Street

DateEvent & SourcePriceAppreciation
Jul 1, 2025

Sold

MLS of Greater Cincinnati #1839336

$690,000—
May 1, 2025

Listed (Active)

MLS of Greater Cincinnati #1839336

$729,000—
Jun 29, 2024

Permanently Off Market

MLS of Greater Cincinnati #1804780

$719,000—
DateEvent & SourcePrice
07/01/2025

Sold

MLS of Greater Cincinnati #1839336

$690,000
05/01/2025

Listed (Active)

MLS of Greater Cincinnati #1839336

$729,000
06/29/2024

Permanently Off Market

MLS of Greater Cincinnati #1804780

$719,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 1014 Celestial Street

Taxable ValueLand$54,537Additions$87,913Total$142,450
Tax Record2021$9,597 ($800 / month)
Home Facts
Beds2Baths2.5Total Finished SqFt1,896 SqFtAbove Grade Finished SqFt1,896 SqFtUnfinished Basement SqFt340 SqFtStories2Lot Size2,004 SqFtStyleSingle Family ResidenceYear Built1873CountyHAMILTONAPN073-0001-0037-00Fireplace TypeHas Fireplace

Schools near 1014 Celestial Street

This home is within Cincinnati Public Schools.
Rating
School
Type
Grades
Distance
Riverview East Academy
Public - 4 to 12
Gilbert A. Dater High School
Public - 5 to 12
Hughes STEM High School
Public - 7 to 12
Walnut Hills High School
Public - 7 to 12
Rating
School
Distance
Riverview East Academy
Public4 to 12

Gilbert A. Dater High School
Public5 to 12

Hughes STEM High School
Public7 to 12

Walnut Hills High School
Public7 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Explore Nearby Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Coldwell Banker Realty

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 Compass and its related brokerages, 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. Compass and its related brokerages, 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