2017 Jose Garcia designed and built architectural tour de force. Panoramic views of Newport, Covington, Downtown, Ohio River, & OTR. Finest materials throughout with no expense spared. Expansive spaces with tons of natural light & walls of windows. Incredible entertaining house while being low maintenance. The FINEST that Mt. Adams has to offer. A piece of art that you can live in. A must see!
Sold for $3,650,000
$3,650,000
1059 Celestial St, Cincinnati, OH 45202
4beds
6,778sqft
SingleFamily
Built in 2017
10,585 Square Feet Lot
$3,779,700 Zestimate®
$539/sqft
$5,810 Estimated rent
Home value
$3,779,700
$3.44M - $4.16M
$5,810/mo
Zestimate® history
Owner options
List your home for rent
$5,810/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,810/mo
Rent Zestimate®
Refinance and save
$19,841/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$19,841/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Heating
- Forced air, Gas, Solar, Geothermal
Cooling
- Central, Geothermal, Solar
Appliances
- Included: Dishwasher, Dryer, Freezer, Garbage disposal, Microwave, Range / Oven, Refrigerator, Washer
Features
- Recessed Lighting, Smart Thermostat, Natural Woodwork, 9Ft + Ceiling, Tech Wiring
- Flooring: Other
- Windows: Double Pane Windows, Insulated Windows, Skylight(s), Slider, Picture
- Basement: Finished
- Has fireplace: Yes
- Fireplace features: Gas, Great Room, Fire Pit
Interior area
- Total interior livable area: 6,778 sqft
- Finished area below ground: 2211
Property
Parking
- Total spaces: 3
- Parking features: Garage - Attached
Features
- Patio & porch: Patio
- Exterior features: Wood, Brick
- Has view: Yes
- View description: Territorial, Water, City
- Has water view: Yes
- Water view: Water
Lot
- Size: 10,585 sqft
Details
- Parcel number: 0730001020900
- Zoning description: Residential
- Other equipment: Dehumidifier
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Conventional
Materials
- masonry
- Roof: Other
Condition
- Year built: 2017
Utilities & green energy
- Gas: Natural
- Water: Public
- Utilities for property: Cable Connected
Community & neighborhood
Security
- Security features: Security System, Smoke Detector(s), Security
Location
- Region: Cincinnati
Other
Other facts
- ViewYN: true
- BuildingFeatures: DSL/Cable Available
- WaterSource: Public
- Roof: Membrane
- Heating: Forced Air, Natural Gas, Zoned
- View: River, Valley, City
- Appliances: Dishwasher, Refrigerator, Disposal, Gas Cooktop, Double Oven, Convection Oven, Dryer, Microwave
- FireplaceYN: true
- GarageYN: true
- AttachedGarageYN: true
- Basement: Partially Finished, Partial, Walk-Out Access
- ZoningDescription: Residential
- HeatingYN: true
- CoolingYN: true
- PatioAndPorchFeatures: Patio
- FireplaceFeatures: Gas, Great Room, Fire Pit
- FireplacesTotal: 1
- RoomsTotal: 7
- ConstructionMaterials: Brick, Cedar
- WindowFeatures: Double Pane Windows, Insulated Windows, Skylight(s), Slider, Picture
- ExteriorFeatures: Balcony, Yard Lights
- ArchitecturalStyle: Contemporary/Modern
- BedroomsPossible: 0
- Utilities: Cable Connected
- FarmLandAreaUnits: Square Feet
- ParkingFeatures: Driveway, Off Street, Garage Door Opener, Oversized, Built In, Garage Faces Front
- CoveredSpaces: 0
- CurrentUse: Residential
- Cooling: Central Air
- OpenParkingYN: true
- InteriorFeatures: Recessed Lighting, Smart Thermostat, Natural Woodwork, 9Ft + Ceiling, Tech Wiring
- SecurityFeatures: Security System, Smoke Detector(s), Security
- FoundationDetails: Poured
- RoomKitchenFeatures: Pantry, Eat-in Kitchen, Galley, Gourmet, Wood Cabinets, Counter Bar, Quartz Counters
- RoomMasterBathroomFeatures: Double Vanity, Whirlpool Tub, Shower, Soaking Tub, Skylight
- BelowGradeFinishedArea: 2211
- WoodedArea: NaN
- RoomMasterBedroomLevel: 2
- RoomBedroom4Level: Lower
- RoomBathroom3Level: Lower
- RoomBathroom2Level: Second
- RoomBathroom1Level: Second
- RoomBathroom4Level: First
- RoomBedroom2Level: 2
- RoomBedroom3Level: 2
- RoomDiningRoomLevel: 1
- RoomKitchenLevel: 1
- OtherEquipment: Dehumidifier
- Gas: Natural
- RoomBathroom1Features: Full
- RoomBathroom3Features: Full
- RoomBathroom4Features: Partial
- RoomMasterBedroomFeatures: Bath Adjoins, Wood Floor
- RoomDiningRoomFeatures: Walkout
- MlsStatus: Active
Price history
| Date | Event | Price |
|---|---|---|
| 7/17/2025 | Sold | $3,650,000-7%$539/sqft |
Source: Public Record Report a problem | ||
| 6/2/2025 | Price change | $3,924,999-0.6%$579/sqft |
Source:  Cincy MLS #1818706 Report a problem | ||
| 5/2/2025 | Price change | $3,949,999-0.6%$583/sqft |
Source: Cincy MLS #1818706 Report a problem | ||
| 4/22/2025 | Price change | $3,974,999-0.6%$586/sqft |
Source: Cincy MLS #1818706 Report a problem | ||
| 9/27/2024 | Listed for sale | $3,999,999+11.1%$590/sqft |
Source: Cincy MLS #1818706 Report a problem | ||
| 9/9/2022 | Listing removed | -- |
Source: Owner Report a problem | ||
| 8/8/2022 | Listed for sale | $3,600,000+19%$531/sqft |
Source: Owner Report a problem | ||
| 6/18/2021 | Sold | $3,025,000-6.9%$446/sqft |
Source: Cincy MLS #1700222 Report a problem | ||
| 1/20/2021 | Listing removed | -- |
Source: Cincy MLS Report a problem | ||
| 5/29/2020 | Listed for sale | $3,249,000+524.8%$479/sqft |
Source: Coldwell Banker West Shell #1662867 Report a problem | ||
| 4/15/2013 | Sold | $520,000$77/sqft |
Source: Cincy MLS #1323742 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $10,356 -2.2% | $1,058,750 |
| 2023 | $10,591 -6.4% | $1,058,750 +9.2% |
| 2022 | $11,313 -6.8% | $969,885 |
| 2021 | $12,133 -80% | $969,885 |
| 2020 | $60,638 +43.1% | $969,885 +83.4% |
| 2019 | $42,381 +159.8% | $528,958 +163.7% |
| 2018 | $16,314 +16.1% | $200,589 |
| 2017 | $14,057 +4.4% | $200,589 +10.2% |
| 2016 | $13,468 +15.5% | $182,001 |
| 2015 | $11,660 -0.7% | $182,001 |
| 2014 | $11,744 -16% | $182,001 -10.3% |
| 2013 | $13,976 +2.3% | $202,829 |
| 2012 | $13,666 +1.5% | $202,829 |
| 2011 | $13,458 +5% | $202,829 -3.4% |
| 2010 | $12,823 +1.7% | $209,906 |
| 2009 | $12,604 +7.7% | $209,906 |
| 2008 | $11,706 +15.7% | $209,906 +1% |
| 2007 | $10,119 +1.1% | $207,830 |
| 2006 | $10,007 -0.9% | $207,830 |
| 2005 | $10,098 0% | $207,830 +9% |
| 2003 | $10,099 +6.7% | $190,645 |
| 2002 | $9,466 +2% | $190,645 +8.6% |
| 2001 | $9,281 +3.4% | $175,560 |
| 2000 | $8,976 | $175,560 |
Find assessor info on the county website
Neighborhood: Mt. Adams
Nearby schools
GreatSchools rating
- 4/10Riverview East AcademyGrades: PK,4,6,9-12Distance: 3.2 mi
- 3/10Robert A. Taft Information Technology High SchoolGrades: 7-12Distance: 1.3 mi
- 3/10Hughes STEM High SchoolGrades: 7-12Distance: 1.9 mi
Schools provided by the listing agent
- District: Cincinnati City SD
Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$3,779,700
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$3,779,700
- Ohio
- Hamilton County
- Cincinnati
- 45202
- Mt. Adams
- 1059 Celestial St
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Cincinnati Topics
