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!
Primary Bathrooms: Skylight,Tile Floor,Double Vanity,Tub,Jetted Tub
PrimaryBedFeat: Bath Adjoins,Wood Floor
P R I M A R Y B E D R O O M: 20x19 Level: 2
Exterior Features
View: City, River, Valley
Roof: Tile, Membrane
Construction: Brick, Other
Outside Features: Deck, Fire Pit, Patio
Foundation: Poured
Listing Price: 3974999.00
Acres: 0.2430
New Construction: No
Garage/Parking
Garage Spaces: 3.00
Garage Carport: Front,Garage Attached
Utilities
Gas: Natural
Sewer: Public Sewer
Water Source: Public
Condo/Co-op/Association
HOA Yes/No: No
Association: Cincinnati Area Multiple Listing Service
Schools
District: Cincinnati City SD
Lot Info
Lot Dimensions: 50x203
Lot Size Sq Ft: 10585.00
Total Assessed Value: of record
ResoLotSizeUnits: Acres
Rental Info
Sub Lease: No
Tax Info
Tax Abatement: No
Map
Range of Values:
Collateral Analytics
Collateral Analytics
Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.
Not Available
Collateral Analytics does not have data for the current month. Please view the chart for historical values.
ICE
ICE Mortgage Technology
ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.
Not Available
ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.
First American
First American
First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.
Not Available
First American does not have data for the current month. Please view the chart for historical values.
Quantarium
Quantarium
Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.
Not Available
Quantarium does not have data for the current month. Please view the chart for historical values.
Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Source: Public Records
Average Home Value in this Area
Source: Public Records
Tax History
Year
Tax Paid
Tax AssessmentTax Assessment
Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property.
Coldstream's Legacy Riverview Estates is a rare 100 Acres for a select few private homes. Minutes to Town, Stadiums ,schools, & Golf Club, this is a commanding 12,000 SF presence on 4.5 view acres created by legacy builder for his own home. Primary Suite on first, covered terraces, spa -pool, fitness, 4 Car Garage, Club Bar, Library, 4 Family BR Suites. Live your best life!
Absolutely incredible new construction opportunity in the heart of The Village of Indian Hill. This flat, 3 acre building lot with sewer access is ready for this plan or your custom design with Daley Design & Build. This plan is over 6000 finished sq ft with 5 beds, 5+ baths, with the highest quality finishes and a 4 car garage. Additional features include 1st floor primary bedroom, study,
Sold before sent. This custom built home situated on beautiful Alberly Lane features a thoughtfully designed layout with spacious rooms, high ceilings, wrought-iron railings and hrdwd flrs. The first-floor primary suite features double walk-in closets and a newly remodeled spa-like bath. The kitchen opens to a cozy inviting family room with wood burning fp. Walk out to a private covered patio
This stunning home is designed for entertaining, featuring a grand entry with marble floors, and a gourmet kitchen that flows into the dining and living rooms. The formal great room with a pub style bar walks out to a covered patio overlooking a grand beautifully landscaped lawn. With 10 to 15-foot ceilings throughout the main floor, the spacious primary suite includes a custom wardrobe, and a
Elegant 5 bedroom, 6/2 bath home on 3 serene acres in a quiet, nature surrounded neighborhood. Built in 2013 but recently updated with new flooring, Restoration Hardware/Pottery Barn light fixtures, landscape lighting and beautiful tile work throughout the house. The new gourmet kitchen boasts Wolf/Subzero appliances, a 10-foot island, quartz counters, Miele coffee station, 2 dishwashers and prep
This home is located at 1059 Celestial St, Cincinnati, OH 45202 and is currently priced at $3,974,999, approximately $586 per square foot. This property was built in 2017. 1059 Celestial St is a home located in Hamilton County with nearby schools including Robert A. Taft Information Technology High School, Withrow University High School, and Clark Montessori High School.
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
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 Ten-X 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. Ten-X 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 2025, MLS of Greater Cincinnati, Inc. All rights reserved