Skip main navigation
Off market
  • $3,025,000

    1059 Celestial St, Cincinnati, OH 45202

    4beds
    6,778sqft
    SingleFamily
    Built in 2017
    10,585 Square Feet Lot
    $-- Zestimate®
    $446/sqft
    $4,642 Estimated rent

    What's special

    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!

    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
    Services availability