$2,999,000
NEW CONSTRUCTION

Estimated payment $17,032/month

Total Views 5,069
5 Beds
5 Baths
5,263 Sq Ft
$570 Price per Sq Ft

Highlights

  • Very Popular Property
  • New Construction
  • Marble Flooring
  • Open-Concept Dining Room
  • Wooded Lot
  • Traditional Architecture

About This Home

Unlock the excitement of starting fresh in a new build by Legendary Homes. Over an acre and surrounded by mature trees, this wooded lot is the perfect setting for the incredible 5,263 finished sf build. With 5 bedrooms, 5 baths, & 10ft first floor ceilings. First floor primary ensuite w/ large W.I.C, office, great room w/ fireplace, gourmet eat-in kitchen, private office and expansive covered porch w/ gas fireplace and vews of the creek. On the 2nd level there is a common loft w/ built-ins, 3 bedrooms, an ensuite bath & a jack-n-jill bath and W.I.Cs. In the lower level is full bath, bar, family room & game area. The 3 car garage gives you plenty of storage for cars, bikes, lawn equipment, storage etc. Construction has started. Spring 2027 Completion.

Listing Agent

Patrick Gunning

Coldwell Banker Realty License #2017005645 Listed on: 07/31/2026

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Lot Details

  • 1.23 Acre Lot
  • Wooded Lot

Parking

  • 3 Car Garage

Home Design

  • New Construction
  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Stone

Interior Spaces

  • 5,263 Sq Ft Home
  • 2-Story Property
  • Bookcases
  • Crown Molding
  • Beamed Ceilings
  • Ceiling height of 9 feet or more
  • Chandelier
  • ENERGY STAR Qualified Windows
  • Double Hung Windows
  • Casement Windows
  • Double Door Entry
  • French Doors
  • Panel Doors
  • Great Room with Fireplace
  • Open-Concept Dining Room
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Butlers Pantry
  • Double Oven
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Solid Wood Cabinet

Flooring

  • Wood
  • Marble
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • 5 Full Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub
  • Built-In Shower Bench

Outdoor Features

  • Covered Deck
  • Porch

Utilities

  • 95% Forced Air Zoned Heating and Cooling System
  • Heating System Uses Gas
  • High-Efficiency Water Heater
  • Gas Water Heater
  • Septic Tank

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Lot Details

1.23 Acres

Parking

3

Listing Details

  • Suburb: Indian Hill
  • Degree Complete: Foundation
  • Broker Approved: Yes
  • Cooling: Central Air
  • Heating: Forced Air, Gas, Gas Furn EF Rtd 95%+
  • Suburb S I C: Indian Hill
  • Bathroom 4: Full
  • Bathroom 4 Level: Lower
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Dining Room Feat: French Doors, Chandelier, Open, Walkout, Wood Floor
  • Entry Foyer: Open Foyer, Double Doors, Wood Floor
  • Great Room Feat: Walkout, Fireplace, Wood Floor
  • Living Great Rm Dim: 0 x 0
  • Single Family Desc: Single Family
  • Study Lib Den: 15x15 Level: 1
  • Study Lib Den Dim: 15 x 15
  • Water Heating: Gas, High Efficiency Tank
  • Architecture: Traditional
  • Full Bathrooms: 5
  • Bedrooms: 5
  • Directions: Indian Hill Rd to Miami Rd
  • Lot Measurement: Acres
  • Status: Active
  • On Market Date: 2026-07-31
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • ADU Y/N: No
  • Special Features: NewHome
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Beam Ceiling, Crown Molding, Multi Panel Doors
  • Bedroom 2: 13x14 Level: 2
  • Bedroom 3: 13x14 Level: 2
  • Bedroom 4: 13x13 Level: 2
  • Bedroom 5: 15x15 Level: 1
  • Dining Room: 16x16 Level: 2
  • Recreation Room: 21x40 Level: Lower
  • Property Type: Residential
  • Year Built Exception: New
  • Reciprocal Listing: No
  • Semi Annual Taxes: $0
  • Appliances: Dishwasher, Double Oven, Microwave, Oven/Range, Refrigerator
  • Kitchen Features: Butler's Pantry, Pantry, Quartz Counters, Eat-In, Island, Wood Cabinets, Wood Floor, Marble/Granite/Slate
  • Basement: Full
  • Study Features: Bookcases, Wood Floor, Panel Walls
  • Entry: 8x18 Level: 1
  • Bathrooms: 5.00
  • Great Room: 20x20 Level: 1
  • Kitchen Dim: 15 x 20
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Laundry Room: 8x8 Level: 1
  • Laundryroom Dim: 8 x 8
  • Recreation Room Dim: 21 x 40
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 5263.00
  • Windows: Casement, Double Hung, ENERGY STAR
  • PrimaryBedroomDim: 16 x 16
  • Primary Bathrooms: Built-In Shower Seat, Shower, Tile Floor, Double Vanity, Tub, Marb/Gran/Slate
  • P R I M A R Y B E D R O O M: 16x16 Level: 1

Exterior Features

  • Roof: Shingle
  • Construction: Brick, Stone, Fiber Cement
  • Outside Features: Covered Deck/Patio, Porch, Wooded Lot
  • Foundation: Poured
  • Listing Price: 2999000.00
  • Acres: 1.2340
  • New Construction: Yes

Garage/Parking

  • Garage Spaces: 3.00
  • Garage Carport: Built in, Side

Utilities

  • Gas: Natural
  • Sewer: Septic Tank
  • Water Source: Public

Condo/Co-op/Association

  • HOA Yes/No: No
  • Association: Cincinnati Area Multiple Listing Service

Schools

  • District: Indian Hill Ex Vill

Lot Info

  • Lot Size Sq Ft: 53753.00
  • Total Assessed Value: none

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Map

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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2025 $6,192 $165,470 $165,470
2024 $6,193 $165,470 $165,470
2023 $6,104 $165,470 $165,470 $0
2022 $5,979 $133,651 $133,651 $0
2021 $5,937 $133,651 $133,651 $0
2020 $5,104 $133,651 $133,651 $0
2019 $4,882 $119,333 $119,333 $0
2018 $4,888 $119,333 $119,333 $0
2017 $4,720 $119,333 $119,333 $0
2016 $4,982 $124,149 $124,149 $0
2015 $4,936 $124,149 $124,149 $0
2014 $4,891 $124,149 $124,149 $0
2013 $5,125 $125,402 $125,402 $0
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/31/2026 07/31/26 For Sale $2,999,000 +399.8% $570 / Sq Ft
05/09/2025 05/09/25 Sold $600,000 -6.3% -- View Prior Sale
04/11/2025 04/11/25 Off Market $640,000 -- --
03/08/2025 03/08/25 Pending -- -- --
02/25/2025 02/25/25 For Sale $640,000 -- --
Source: MLS of Greater Cincinnati (CincyMLS)

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Fiduciary Deed $600,000 None Listed On Document
Warranty Deed -- None Listed On Document
Warranty Deed $400,000 Cambridge Land Title Agency
Warranty Deed $387,500 --
Interfamily Deed Transfer -- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Open $1,275,000 Credit Line Revolving
Previous Owner $250,000 Unknown
Previous Owner $273,750 Unknown
Source: Public Records

About the Listing Agent

Patrick Gunning

Coldwell Banker Realty

(513) 450-4428

Section Image

I'm an expert real estate agent with Coldwell Banker West Shell in Cincinnati, OH and the nearby area, providing home-buyers and sellers with professional, responsive and attentive real estate services. Want an agent who'll really listen to what you want in a home? Need an agent who knows how to effectively market your home so it sells? Give me a call! I'm eager to help and would love to talk to you.

Patrick's Other Listings

  • 6041 Johnson St, Cincinnati, OH 45243

    $1,595,000 New Construction

    • 5 Beds
    • 5 Baths
    • 3,237 Sq Ft
    • 6041 Johnson St
    • Cincinnati, OH

    New Construction from Legendary Homes. Starting construction soon in Madeira! This incredible home features approx. 3,237sf, 9' ceilings, first floor primary, 2-story great room with gas fireplace, gourmet eat-in kitchen, 1st floor study & flex room, sizable primary suite, oversized 2 car garage with side entry garage door for golf cart storage, covered rear patio with gas fireplace, finished

    Patrick Gunning Coldwell Banker Realty

    Section Image
  • 7845 Euclid Ave, Cincinnati, OH 45243

    $1,050,000 New Construction

    • 3 Beds
    • 3 Baths
    • 2,926 Sq Ft
    • 7845 Euclid Ave
    • Cincinnati, OH

    To be Built. Welcome to Laurel Crossing! This unique development includes 5 new detached ranches and 5 new detached homes all within short walking distance to downtown Madeira. The new Ranches are 2,946 sq/ft, include 3bdrs, 3 baths, 2 car garage, all custom finishes incl large kitchen island w Thermador, finished LL & abundant landscaping. Madeira-always rated Top 3 Burbs in Cincinnati in Cincy

    Patrick Gunning Coldwell Banker Realty

    Section Image
  • 3410 Brotherton Rd, Cincinnati, OH 45209

    $765,000 New Construction

    • 3 Beds
    • 2.5 Baths
    • 1,783 Sq Ft
    • 3410 Brotherton Rd
    • Cincinnati, OH

    Brand new home just seconds from everything in Oakley! You can have it all: 1,783 finished sqft (w/ option to finish LL), hardwood flrs, great rm w/ fireplace, gourmet kitchen, primary suite w/ walk-in clst, high end finishes, 2 car garage, rear patio & rooftop deck! Large ready to finish basement with full rough-in and plenty of storage. Mins from Oakley Sq, walkable to MadTree Brewing,

    Patrick Gunning Coldwell Banker Realty

    Section Image
  • 3259 Berwyn Place, Cincinnati, OH 45209

    $815,000 New Construction

    • 3 Beds
    • 2.5 Baths
    • 2,590 Sq Ft
    • 3259 Berwyn Place
    • Cincinnati, OH

    15 yr LEED Gold tax abatement eligible! The last of the 15year abatement - new starts are now only 5 years in Oakley. Saves $12k/year in prop taxes. Brand new home just seconds from everything in Oakley! 2,590 finished sqft, hardwood flrs, great rm w/ fireplace, gourmet kitchen, primary suite w/ oversized walk-in clst, high end finishes, 2 car garage, rear patio & wooded valley view! By Five

    Patrick Gunning Coldwell Banker Realty

    Section Image
  • 3309 Bach Ave, Cincinnati, OH 45209

    $765,000 New Construction

    • 3 Beds
    • 2.5 Baths
    • 1,783 Sq Ft
    • 3309 Bach Ave
    • Cincinnati, OH

    Brand new home just seconds from everything in Oakley! You can have it all: 1,783 finished sqft (w/ option to finish LL & full bath), walk out great rm w/ fireplace, gourmet kitchen, primary suite w/ walk-in clst, high end finishes, 2 car garage, rear deck & rooftop deck! Mins from Oakley Sq, walkable to MadTree Brewing, dining-shopping, new 3.5M Rec Center, & more!

    Patrick Gunning Coldwell Banker Realty

    Section Image
  • 2121 Clough Chase Dr, Cincinnati, OH 45244

    $1,050,000 New Construction

    • 4 Beds
    • 4.5 Baths
    • 4,081 Sq Ft
    • 2121 Clough Chase Dr
    • Cincinnati, OH

    So many features in this beautiful new build from Five Daughters Construction. Over 4,100 finished sqft of open concept living. Soaring 18' Great Room ceilings & massive windows overlooking private wooded view. 9' ceilings in basement and 1st floor. The walkout finished basement is perfect for entertaining and accompanies a full bath. Spacious composite deck overlooks yard. Also spacious &

    Patrick Gunning Coldwell Banker Realty

    Section Image
  • 1906 Pogue Ave, Cincinnati, OH 45208

    $649,000 New Construction

    • 3 Beds
    • 2.5 Baths
    • 1,759 Sq Ft
    • 1906 Pogue Ave
    • Cincinnati, OH

    Brand new in O'bryonville! 1,759 sq ft open concept floor plan. LEED Gold tax Abatement eligible. Save estimated $12k/yr in prop tax. Walkable to all that O'bryonville has to offer - Bon Bonerie, O'bryons, Bean & Barley, Pampa's, Ripple Wine Bar. Kitchen with island, 42 wall cabinets, quartz counters, stainless appliances. Master ensuite & walk-in closet. 9ft ceilings on the first floor. Rear

    Patrick Gunning Coldwell Banker Realty

    Section Image
  • 3119 Hackberry St, Cincinnati, OH 45207

    $595,000 New Construction

    • 3 Beds
    • 2.5 Baths
    • 1,960 Sq Ft
    • 3119 Hackberry St
    • Cincinnati, OH

    Ready now! LEED Gold Tax Abatement Eligible - Save $12,000/yr in prop tax. Open concept with huge windows, Granite counters, 42 wood cabs, eat-in kitchen island. The patio adjoins the great room for entertaining. Very spacious back yard in an urban living environment. 2-car garage. 9ft ceiling on 1st floor. Full basement ready to finish and w egress window & bathroom already plumbed. Master bed w

    Patrick Gunning Coldwell Banker Realty

    Section Image
  • 105 W 13th St Unit 10, Newport, KY 41071

    $645,000 New Construction

    • 3 Beds
    • 3.5 Baths
    • 2,384 Sq Ft
    • 105 W 13th St
    • Unit 10
    • Newport, KY

    New finance promotion for a limited time! 2/1 temporary buydown with rates as low as 3.99 percent!* Move in Ready! The Breckenridge by Ashford Homes. Now under construction in an exclusive new community - Martin's Gate - the site of Homerama 2023. Featuring high end finishes, open concept living, and unprecedented views of Downtown. An expansive deck & large windows to enjoy the views. Easily

    Patrick Gunning Coldwell Banker Realty

    Section Image

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1888974

MLS of Greater Cincinnati (CincyMLS)

APN: 529-0140-0008

Your Personal Tour Guide

Ask me questions while you tour the home.