Residential For Sale - 7 Rooms - 4 Bedrooms - 4 Bathrooms - Price $3,949,999

Properties

A Futuristic Exterior Elevation featuring Natural Douglas Fir & Stone understates the magnificence to follow...the Wow factor.
Click the Gas Fireplace & Check the Glass Perimeter Walls
Wide Open Spaces capture views encapsulated by warm natural wood & cross section wood ceramics
Wide Open Spaces capture views encapsulated by warm natural wood & cross section wood ceramics
Streamlined Dream Kitchen featuring the ultimate Paykel & Fisher Appliance package to include twin dishwashers, wine cooler, Subzero, Gas Cooktop/over wrapped in hard surfaces and light
Streamlined Dream Kitchen featuring the ultimate Paykel & Fisher Appliance package to include twin dishwashers, wine cooler, Subzero, Gas Cooktop/over wrapped in hard surfaces and light
Entry Twin Atriums feature Trees Growing to the Sky and 20’x 30’’x 6’ Cubic Experience
Entry Twin Atriums feature Trees Growing to the Sky and 20’x 30’’x 6’ Cubic Experience
Fully Automated Fitness Room opening to nature
Primary Bedroom Suite features remote control shades & bedside lighting controls, atrium and rooftop views. An adjoining Dressing Room & incomparable Skylit
Primary Bedroom Suite features remote control shades & bedside lighting controls, atrium and rooftop views. An adjoining Dressing Room & incomparable Skylight
Entry Twin Atriums feature Trees Growing to the Sky and 20’x 30’’x 6’ Cubic Experience
180 Degree Daytime Panoramic Views
180 Degree Daytime Panoramic Views
1600 Square Foot Roof Top Terrace like no other! The Ultimate View Experience
Oh! The City Lights at Night Fall

Active

Property Description

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!

Features

Rooms : 7

Heating System : Forced Air, Zoned, Geothermal, Solar, ENERGY STAR

Cooling System : Central Air, Geothermal, ENERGY STAR

Basement : Partial

Window Features : Picture, Insulated, Casement, Slider, Triple Pane

Sewer : Public Sewer

Interior Features : 9Ft + Ceiling, Skylight

Fireplaces Total : 1

Exterior Features : Patio, Fire Pit, Deck

Architectural Style : Contemporary/Modern

Additional Information

Construction Materials : Brick, Other

Foundation Details : Poured

Garage : 3.0

Levels : Three

Lot Size Dimensions : 50x203

Virtual Tour : https://www.youtube.com/watch?v=Oxw Jm YQZV3I

Water Source : Public

Appliances

Appliances : Dishwasher, Refrigerator, Gas Cooktop, Double Oven, Garbage Disposal, Wine Cooler, ENERGY STAR

Location

USOHHamiltonCincinnati45202StreetCelestial

Street : Celestial

Street Suffix : Street

Latitude : N39° 6' 23.7''

Neighborhood

High School District : Cincinnati City SD

Listing Information

Office Name : Coldwell Banker Realty

Listing courtesy of : Gail

List Agent Mls Id : 228845

List Office Mls Id : SHEL02

Mls Status : Active

Modification Timestamp : 2025-05-02T18:21:46Z

Originating System Name : Cincy

Address Map

Directions : Paradrome past Art Museum to Ida to Celestial

Mls Area Major : Hamilton-E01

Google Map

This listing courtesy of:

Coldwell Banker Realty Office:

Phone:

1059 Celestial Street, Cincinnati, Ohio 45202

4 Bedrooms

6,778

List Price:

$3,949,999

MLS ID #1818706

Basic Details

Property Type : Residential

Listing Type : For Sale

MLS ID : 1818706

View : City, River, Valley

Bedrooms : 4

Total Bathrooms : 4

Half Bathrooms : 1

Square Footage : 6,778

Year Built : 2017

Lot Area : 0.24 Acre

Status : 1

Full Bathrooms : 3

Property Sub Type : Single Family Residence

Roof : Membrane, Tile

Listing Status : Active

ClosePrice : $0

Share on Facebook
Share on Twitter
Share on Pinterest
Share on Linkedin
PDF
Add to favorites

Remove from favorites
Send Request for a new Property

Agent info

Arlen Rissover
513.886.7840
513.886.7840
info@cincinnatimodern.com

Contact Agent

Mortgage Calculator

Total Price: $

Down Payment: %

Loan Term: years

Interest Rate: %

Tax: %per year

Insurance: %per year

Monthly Payment: $

Properties

A Futuristic Exterior Elevation featuring Natural Douglas Fir & Stone understates the magnificence to follow...the Wow factor.

Click the Gas Fireplace & Check the Glass Perimeter Walls

Wide Open Spaces capture views encapsulated by warm natural wood & cross section wood ceramics

Wide Open Spaces capture views encapsulated by warm natural wood & cross section wood ceramics

Streamlined Dream Kitchen featuring the ultimate Paykel & Fisher Appliance package to include twin dishwashers, wine cooler, Subzero, Gas Cooktop/over wrapped in hard surfaces and light

Streamlined Dream Kitchen featuring the ultimate Paykel & Fisher Appliance package to include twin dishwashers, wine cooler, Subzero, Gas Cooktop/over wrapped in hard surfaces and light

Entry Twin Atriums feature Trees Growing to the Sky and 20’x 30’’x 6’ Cubic Experience

Entry Twin Atriums feature Trees Growing to the Sky and 20’x 30’’x 6’ Cubic Experience

Fully Automated Fitness Room opening to nature

Primary Bedroom Suite features remote control shades & bedside lighting controls, atrium and rooftop views. An adjoining Dressing Room & incomparable Skylit

Primary Bedroom Suite features remote control shades & bedside lighting controls, atrium and rooftop views. An adjoining Dressing Room & incomparable Skylight

Entry Twin Atriums feature Trees Growing to the Sky and 20’x 30’’x 6’ Cubic Experience

180 Degree Daytime Panoramic Views

180 Degree Daytime Panoramic Views

1600 Square Foot Roof Top Terrace like no other! The Ultimate View Experience

Oh! The City Lights at Night Fall

This listing courtesy of:

1059 Celestial Street, Cincinnati, Ohio 45202

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel