$3,974,999
$25K PRICE DROP

Estimated payment $23,027/month

Total Views 26,902
4 Beds
3.5 Baths
6,778 Sq Ft
$586 Price per Sq Ft

Highlights

  • Eat-In Gourmet Kitchen
  • River View
  • Deck
  • Walnut Hills High School Rated A+
  • 0.24 Acre Lot
  • Contemporary Architecture

About This Home

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!

Listing Agent

Gail Coughlin

Coldwell Banker Realty License #0000228845

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,606

Year Built

  • Built in 2017

Lot Details

  • 10,585 Sq Ft Lot
  • Lot Dimensions are 50x203

Parking

  • 3 Car Garage
  • Garage Door Opener

Property Views

  • River
  • City
  • Valley

Home Design

  • Contemporary Architecture
  • Brick Exterior Construction
  • Tile Roof
  • Membrane Roofing

Interior Spaces

  • 6,778 Sq Ft Home
  • 3-Story Property
  • Ceiling height of 9 feet or more
  • Skylights
  • Gas Fireplace
  • Triple Pane Windows
  • Insulated Windows
  • Picture Window
  • Sliding Windows
  • Great Room with Fireplace

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Double Oven
  • Gas Cooktop
  • Dishwasher
  • Wine Cooler
  • ENERGY STAR Qualified Appliances
  • Quartz Countertops
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms

Basement

  • Walk-Out Basement
  • Partial Basement

Eco-Friendly Details

  • ENERGY STAR Qualified Equipment for Heating
  • Solar Heating System

Outdoor Features

  • Deck
  • Patio
  • Fire Pit

Utilities

  • ENERGY STAR Qualified Air Conditioning
  • Forced Air Zoned Heating and Cooling System
  • Geothermal Heating and Cooling
  • Electric Water Heater

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,606

Year Built

Built in 2017

Lot Details

0

Parking

3

Listing Details

  • Suburb: Mt. Adams
  • Land Description: Less than .5 Acre
  • Access: City Street
  • Broker Approved: Yes
  • Miscellaneous: Busline Near,Cable,Ceiling Fan,CO Detector,Recessed Lights,Smoke Alarm,Tech Wiring
  • Basement Sq Ft: 2211
  • Census Tract Realist: 268.00
  • Cooling: Central Air, ENERGY STAR, Geothermal
  • Heating: ENERGY STAR, Forced Air, Solar, Geothermal, Zoned
  • Lot Area Realist: 10585.00
  • Sub Lease Expiration Date: 1800-01-01T00:00:00-05:00
  • Suburb S I C: Mt. Adams
  • Taxes Annual: 10606
  • Price Per Acre: 16358020.58
  • Zoning: Residential
  • Basement Features: Part Finished,Walkout
  • Bathroom 4: Partial
  • Bathroom 4 Level: 1
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Entry Area: 180
  • Entry Foyer: Marble/Slate,Open Foyer,Tile Floor
  • Great Room Feat: Walkout,Fireplace
  • Living Great Rm Dim: 0 x 0
  • Mechanical Systems: Garage Door Opener
  • Single Family Desc: Single Family
  • Study Lib Den: 15x17 Level: 1
  • Study Lib Den Area: 255
  • Study Lib Den Dim: 15 x 17
  • Study Lib Den Len: 15
  • Water Heating: Electric
  • Year Built: 2017
  • Architecture: Contemporary/Modern
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Bedrooms: 4
  • Directions: Paradrome past Art Museum to Ida to Celestial
  • Lot Measurement: Acres
  • Status: Active
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • Second Floor Area: 2548
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Skylight
  • Bedroom 2: 19x16 Level: 2
  • Bedroom 3: 19x16 Level: 2
  • Bedroom 4: 16x12 Level: Lower
  • Recreation Room: 27x24 Level: Lower
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $5303
  • Appliances: Dishwasher, Double Oven, ENERGY STAR, Garbage Disposal, Gas Cooktop, Refrigerator, Wine Cooler
  • Kitchen Features: Quartz Counters,Counter Bar,Eat-In,Tile Floor,Gourmet,Wood Cabinets,Marble/Granite/Slate
  • Bedroom 2 Area: 304
  • Basement: Partial
  • Bedroom 3 Area: 304
  • Bedroom 4 Area: 192
  • Entry: 30x6 Level: 1
  • Bathrooms: 4.00
  • Great Room: 31x28 Level: 1
  • Kitchen Area: 290
  • Kitchen Dim: 29 x 10
  • Levels: Three
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 2
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Laundry Room: 20x8 Level: 1
  • Laundry Room Area: 160
  • Laundryroom Dim: 20 x 8
  • Recreation Room Area: 648
  • Recreation Room Dim: 27 x 24
  • Fireplace: Gas
  • Fireplaces: 1
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 6778.00
  • Total Rooms: 7
  • Windows: Picture, Slider, Casement, Triple Pane, Insulated
  • PrimaryBedroomArea: 380
  • PrimaryBedroomDim: 20 x 19
  • PrimaryBedroomLen: 20
  • 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 Assessment Tax 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. Land Improvement
2024 $10,356 $1,058,750 $157,227 $901,523
2023 $10,591 $1,058,750 $157,227 $901,523
2022 $11,313 $969,885 $151,508 $818,377
2021 $11,522 $969,885 $151,508 $818,377
2020 $60,638 $969,885 $151,508 $818,377
2019 $40,331 $528,959 $142,933 $386,026
2018 $40,363 $200,589 $142,933 $57,656
2017 $14,057 $200,589 $142,933 $57,656
2016 $12,936 $182,001 $138,646 $43,355
2015 $11,660 $182,001 $138,646 $43,355
2014 $11,744 $182,001 $138,646 $43,355
2013 $13,976 $202,829 $142,933 $59,896
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/22/2025 04/22/25 Price Changed $3,974,999 0.0% $586 / Sq Ft
04/22/2025 04/22/25 For Sale $3,974,999 -0.6% $586 / Sq Ft
04/19/2025 04/19/25 Off Market $3,999,999 -- --
04/18/2025 04/18/25 For Sale $3,999,999 0.0% $590 / Sq Ft
04/06/2025 04/06/25 Off Market $3,999,999 -- --
09/27/2024 09/27/24 For Sale $3,999,999 +32.2% $590 / Sq Ft
06/18/2021 06/18/21 Sold $3,025,000 -6.9% $446 / Sq Ft
05/24/2021 05/24/21 Pending -- -- --
05/14/2021 05/14/21 For Sale $3,249,000 +524.8% $479 / Sq Ft
07/15/2013 07/15/13 Off Market $520,000 -- --
04/15/2013 04/15/13 Sold $520,000 -35.0% $233 / Sq Ft
03/11/2013 03/11/13 Pending -- -- --
08/06/2012 08/06/12 For Sale $800,000 -- $358 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Deed History

Date Type Sale Price Title Company
Warranty Deed $3,025,000 Northwest Ttl Fam Of Compani
Warranty Deed $520,000 Attorney
Interfamily Deed Transfer -- None Available
Warranty Deed -- --
Source: Public Records

Similar Homes in Cincinnati, OH

  • 7951 Ayers Rd, Cincinnati, OH 45255

    $4,000,000

    • 5 Beds
    • 12 Baths
    • 12,784 Sq Ft
    • 7951 Ayers Rd
    • Cincinnati, OH

    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!

    Gail Coughlin Coldwell Banker Realty

    Section Image
  • 7800 Calderwood Ln, Cincinnati, OH 45243

    $4,632,500

    • 5 Beds
    • 6 Baths
    • 7800 Calderwood Ln
    • Cincinnati, OH

    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,

    Luke Luther Coldwell Banker Realty

    Section Image
  • 6755 Alberly Ln, Cincinnati, OH 45243

    $3,500,000

    • 6 Beds
    • 8 Baths
    • 10,929 Sq Ft
    • 6755 Alberly Ln
    • Cincinnati, OH

    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

    Allison Thornton Sibcy Cline, Inc.

    Section Image
  • 9170 Given Rd, Cincinnati, OH 45243

    $3,299,000

    • 6 Beds
    • 9 Baths
    • 10,760 Sq Ft
    • 9170 Given Rd
    • Cincinnati, OH

    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

    Allison Thornton Sibcy Cline, Inc.

    Section Image
  • 6 Abbington Ridge, Cincinnati, OH 45242

    $3,595,000

    • 5 Beds
    • 8 Baths
    • 8,417 Sq Ft
    • 6 Abbington Ridge
    • Cincinnati, OH

    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

    Kim Vincent Sibcy Cline, Inc.

    Section Image

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1818706

MLS of Greater Cincinnati (CincyMLS)

APN: 073-0001-0209