Skip main navigation
For sale
    • Price cut: $25K (6/2)
    $3,924,999

    1059 Celestial St, Cincinnati, OH 45202

    4beds
    6,778sqft
    : 
    Single Family Residence
    Built in 2017
    10,585.08 Square Feet Lot
    $-- Zestimate®
    $579/sqft
    $-- HOA

    What's special

    Majestic panoramasFisher and paykel appliancesAutomated shades
    Sealed Bid 6.25! Witness the Legacy Architecture of Jose Garcia in expansive Cubic Spaces & Glass Walls capturing majestic panoramas living Art. Superlatives include: LEED Platinum Tax Abatement, Geothermal-Solar HVAC EBP $320/mo, Interior Live tree Glass Atriums, State of the Art Lighting, Automated Shades, Chef's Kitchen w Fisher & Paykel Appliances, 1,600 sf Roof Top Terrace, Select Douglas Fir & Tennessee Quartzite finishes. Important Blueprints/Specs included. An irreplaceable 6778 SF work of art in the Heart of Mount Adams. Entertaindd and Live the Good Life!
    273 days
    on Zillow
    |
    3,255
    |
    172
    |

    Zillow last checked: 7 hours ago

    Listing updated: June 18, 2025 at 10:24am

    Listed by:

    Gail Coughlin 513-604-1731,

    Coldwell Banker Realty 513-891-8500

    Source: Cincy MLS,MLS#: 1818706MLS LogoOriginating MLS: Cincinnati Area Multiple Listing Service

    Travel times

    Tour with a buyer’s agent

    We’ll find a local expert to take you on a private tour of 1059 Celestial St.

    Next available tour time:Tomorrow at 9am

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Primary bedroom
    • Features: Bath Adjoins, Wood Floor
    • Level: Second
    • Area: 380
    • Dimensions: 20 x 19
    Bedroom 2
    • Level: Second
    • Area: 304
    • Dimensions: 19 x 16
    Bedroom 3
    • Level: Second
    • Area: 304
    • Dimensions: 19 x 16
    Bedroom 4
    • Level: Lower
    • Area: 192
    • Dimensions: 16 x 12
    Bedroom 5
    • Area: 0
    • Dimensions: 0 x 0
    Primary bathroom
    • Features: Skylight, Tile Floor, Double Vanity, Tub, Jetted Tub
    Bathroom 1
    • Features: Full
    • Level: Second
    Bathroom 2
    • Features: Full
    • Level: Second
    Bathroom 3
    • Features: Full
    • Level: Second
    Bathroom 4
    • Features: Partial
    • Level: First
    Dining room
    • Area: 0
    • Dimensions: 0 x 0
    Family room
    • Area: 0
    • Dimensions: 0 x 0
    Great room
    • Features: Walkout, Fireplace
    • Level: First
    • Area: 868
    • Dimensions: 31 x 28
    Kitchen
    • Features: Quartz Counters, Counter Bar, Eat-in Kitchen, Tile Floor, Gourmet, Wood Cabinets, Marble/Granite/Slate
    • Area: 290
    • Dimensions: 29 x 10
    Living room
    • Area: 0
    • Dimensions: 0 x 0
    Office
    • Level: First
    • Area: 255
    • Dimensions: 15 x 17
    Heating
    • ENERGY STAR Qualified Equipment, Forced Air, Solar, Geothermal, Zoned
    Cooling
    • Central Air, ENERGY STAR Qualified Equipment, Geothermal
    Appliances
    • Included: Dishwasher, Double Oven, ENERGY STAR Qualified Appliances, Disposal, Gas Cooktop, Refrigerator, Wine Cooler, Electric Water Heater
    Features
    • High Ceilings, Ceiling Fan(s), Recessed Lighting, Tech Wiring
    • Windows: Picture, Slider, Casement, Triple Pane Windows, Insulated Windows, Skylight(s)
    • Basement: Partial,Partially Finished,Walk-Out Access
    • Number of fireplaces: 1
    • Fireplace features: Gas, Great Room
    Interior area
    • Total structure area: 6,778
    • Total interior livable area: 6,778 sqft
    Video & virtual tour

    Property

    Parking
    • Total spaces: 3
    • Parking features: Garage Door Opener
    • Attached garage spaces: 3
    Features
    • Stories: 3
    • Patio & porch: Deck, Patio
    • Exterior features: Fire Pit
    • Has view: Yes
    • View description: City, River, Valley
    • Has water view: Yes
    • Water view: River
    Lot
    • Size: 10,585.08 Square Feet
    • Dimensions: 50 x 203
    • Features: Less than .5 Acre, Busline Near
    Details
    • Parcel number: 0730001020900
    • Zoning description: Residential

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary/Modern
    • Property subtype: Single Family Residence
    Materials
    • Brick, Other
    • Foundation: Concrete Perimeter
    • Roof: Tile,Membrane
    Condition
    • New construction: No
    • Year built: 2017

    Utilities & green energy

    • Gas: Natural
    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Cable Connected

    Community & HOA

    Community
    • Security: Carbon Monoxide Detector(s), Smoke Alarm
    HOA
    • Has HOA: No
    Location
    • Region: Cincinnati

    Financial & listing details

    • Price per square foot: $579/sqft
    • Tax assessed value: $3,025,000
    • Annual tax amount: $10,606
    • Date on market: 9/27/2024
    • Listing terms: No Special Financing
    • Loading
    • Loading

    Nearby cities