Located in one of Cincinnati's most desirable areas,this custom-blt deStefano home is perfectly situated on 5.19acres in Indian Hill,showcasing unparalleled quality&craftsmanship.12,880sqft of lux living space,this estate is a masterpiece of custom finishes!The 1stFL features a primary suite as well as a guest suite,an exec office w/a cozy fireplace&built-ins,& stunning gourmet kitchen w/stone&brick accents&high-end appliances opens to the spacious,20ft+ great room w/a wall of windows!The 2ndFL boasts 4 additl bdrms each w/ensuite baths, family/study room, playroom&2nd laundry room.The LL is an entertainer's dream w/media room,family space&fireplace,large wet bar w/a stone wine cellar,exercise room,arcade room,&convenient walk-out!Experience resort-style living outside!Stunning salt-water pool complete w/a hot tub,slide&waterfalls,play area,stable w/5 heated stalls.This estate offers an ideal setting for exceptional living & unprecedented entertaining.Superb location in Indian Hill SD
Sold for $5,275,000
$5,275,000
5900 Park Rd, Cincinnati, OH 45243
6beds
12,880sqft
Single Family Residence
Built in 2009
5.19 Acres Lot
$5,459,500 Zestimate®
$410/sqft
$31,476 Estimated rent
Home value
$5,459,500
$4.91M - $6.06M
$31,476/mo
Zestimate® history
Owner options
List your home for rent
$31,476/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$31,476/mo
Rent Zestimate®
Refinance and save
$34,755/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$34,755/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Exec officeSalt-water poolExercise roomGuest suiteMedia roomPlay areaHot tub
Zillow last checked:
Listing updated:
Listed by:
Andrea DeStefano 513-309-3184,
Sibcy Cline, Inc. 513-793-2700,
Gregory J Tassone 513-607-6400,
Coldwell Banker Realty
Bought with:
Kelly A Meyer, 2015001119
Drake & Madison LLC
Source: Cincy MLS,MLS#: 1813657
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 9
- Full bathrooms: 7
- 1/2 bathrooms: 2
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Walkout, Fireplace, Wood Floor
- Level: First
- Area: 304
- Dimensions: 19 x 16
Bedroom 2
- Level: Second
- Area: 270
- Dimensions: 18 x 15
Bedroom 3
- Level: Second
- Area: 270
- Dimensions: 18 x 15
Bedroom 4
- Level: Second
- Area: 255
- Dimensions: 17 x 15
Bedroom 5
- Level: First
- Area: 221
- Dimensions: 17 x 13
Primary bathroom
- Features: Built-In Shower Seat, Shower, Double Shower, Tile Floor, Double Vanity, Tub, Marb/Gran/Slate
Bathroom 1
- Features: Full
- Level: First
Bathroom 2
- Features: Full
- Level: First
Bathroom 3
- Features: Full
- Level: Second
Bathroom 4
- Features: Full
- Level: Second
Dining room
- Features: Chandelier, Wood Floor
- Level: First
- Area: 270
- Dimensions: 18 x 15
Family room
- Features: Bookcases, Walkout, Fireplace, Wet Bar
- Area: 320
- Dimensions: 20 x 16
Great room
- Features: Bookcases, Fireplace, Wood Floor
- Level: First
- Area: 460
- Dimensions: 23 x 20
Kitchen
- Features: Butler's Pantry, Pantry, Counter Bar, Eat-in Kitchen, Tile Floor, Fireplace, Gourmet, Kitchen Island, Wood Cabinets, Marble/Granite/Slate, Other
- Area: 342
- Dimensions: 19 x 18
Living room
- Features: Fireplace, Wood Floor
- Area: 270
- Dimensions: 18 x 15
Office
- Features: Bookcases, Fireplace, French Doors, Wood Floor, Panel Walls
- Level: First
- Area: 288
- Dimensions: 18 x 16
Heating
- Forced Air, Gas, Zoned
Cooling
- Central Air
Appliances
- Included: Dishwasher, Double Oven, Gas Cooktop, Microwave, Oven/Range, Refrigerator, Warming Drawer, Wine Cooler, Humidifier, Gas Water Heater
Features
- High Ceilings, Beamed Ceilings, Crown Molding, Natural Woodwork, Vaulted Ceiling(s), Other, Ceiling Fan(s), Recessed Lighting
- Doors: French Doors
- Windows: Picture, Casement, Wood Frames, Insulated Windows
- Basement: Full,Finished,Walk-Out Access,Other
- Attic: Storage
- Number of fireplaces: 8
- Fireplace features: Stone, Gas, Wood Burning, Outside, Basement, Family Room, Great Room, Kitchen, Living Room, Master Bedroom, Study
Interior area
- Total structure area: 12,880
- Total interior livable area: 12,880 sqft
Property
Parking
- Total spaces: 5
- Parking features: Driveway, Garage Door Opener
- Attached garage spaces: 5
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered Deck/Patio, Patio
- Exterior features: Barbecue, Fireplace, Yard Lights
- Has private pool: Yes
- Pool features: Gunite, Heated, In Ground, Salt Water, Slide
- Fencing: Wood
- Has view: Yes
- View description: Trees/Woods
Lot
- Size: 5.19 Acres
- Features: Wooded, 5 to 9.9 Acres, Fountain
- Topography: Level,Sloping
- Residential vegetation: Heavily Wooded
Details
- Additional structures: Stable(s)
- Parcel number: 5290020002000
- Zoning description: Residential
- Other equipment: Sump Pump w/Backup
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Italianate,Transitional
- Property subtype: Single Family Residence
Materials
- Brick, Stone
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 2009
Utilities & green energy
- Electric: 220 Volts
- Gas: Propane
- Sewer: Septic Tank
- Water: Public
Community & HOA
Community
- Security: Security System
HOA
- Has HOA: No
Location
- Region: Cincinnati
Financial & listing details
- Price per square foot: $410/sqft
- Tax assessed value: $4,389,400
- Annual tax amount: $55,048
- Date on market: 8/2/2024
- Listing terms: No Special Financing,Cash
Price history
| Date | Event | Price |
|---|---|---|
| 3/17/2025 | Sold | $5,275,000-4.1%$410/sqft |
Source:  Cincy MLS #1813657 Report a problem | ||
| 1/23/2025 | Pending sale | $5,500,000$427/sqft |
Source: Cincy MLS #1813657 Report a problem | ||
| 8/2/2024 | Listed for sale | $5,500,000+10.1%$427/sqft |
Source: Cincy MLS #1813657 Report a problem | ||
| 5/17/2024 | Listing removed | -- |
Source: Cincy MLS #1770218 Report a problem | ||
| 2/20/2024 | Listed for sale | $4,995,000-15.3%$388/sqft |
Source: Cincy MLS #1770218 Report a problem | ||
| 1/29/2024 | Listing removed | -- |
Source: Cincy MLS #1770218 Report a problem | ||
| 6/1/2023 | Listed for sale | $5,899,000+391.6%$458/sqft |
Source: Cincy MLS #1770218 Report a problem | ||
| 2/8/2008 | Sold | $1,200,000$93/sqft |
Source: Cincy MLS #1054553 Report a problem | ||
| 11/17/2005 | Sold | $1,200,000$93/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $54,979 -0.1% | $1,536,290 |
| 2023 | $55,049 +26.6% | $1,536,290 +54% |
| 2022 | $43,469 +17.1% | $997,500 |
| 2021 | $37,116 | $997,500 |
| 2020 | $37,116 -6.4% | $997,500 |
| 2019 | $39,671 -17.6% | $997,500 -21.7% |
| 2018 | $48,126 | $1,273,325 |
| 2017 | $48,126 -2.2% | $1,273,325 -1.5% |
| 2016 | $49,218 | $1,292,456 |
| 2015 | $49,218 +0.8% | $1,292,456 |
| 2014 | $48,845 -4.6% | $1,292,456 -1% |
| 2013 | $51,185 +0.1% | $1,305,511 |
| 2012 | $51,145 +2.1% | $1,305,511 |
| 2011 | $50,092 -12.4% | $1,305,511 -15.2% |
| 2010 | $57,165 +275.6% | $1,540,000 +266.7% |
| 2009 | $15,221 +1.6% | $420,000 |
| 2008 | $14,987 +34.5% | $420,000 +31.4% |
| 2007 | $11,144 +1.1% | $319,620 |
| 2006 | $11,019 -10% | $319,620 -10.7% |
| 2005 | $12,244 +33.2% | $357,770 +39.4% |
| 2003 | $9,190 -1.7% | $256,620 |
| 2002 | $9,351 +7% | $256,620 +5.7% |
| 2001 | $8,744 +4.2% | $242,795 |
| 2000 | $8,390 | $242,795 |
Find assessor info on the county website
Neighborhood: 45243
Nearby homes
- $2,804,6005 bd7 ba8.6k sqft5890 Park Rd, Cincinnati, OH 45243Off Market
- $2,747,3005 bd7 ba6.8k sqft5950 Park Rd, Cincinnati, OH 45243Off Market
- $2,210,1005 bd6 ba5.2k sqft5855 Drewry Farm Ln, Cincinnati, OH 45243Off Market
- $1,487,8005 bd4 ba3.5k sqft5800 Drewry Farm Ln, Cincinnati, OH 45243Off Market
- $2,087,800-- bd-- ba-- sqft5800 Drewry Farm Ln, Cincinnati, OH 45243Off Market
- $2,057,4005 bd6 ba5.6k sqft5805 Park Rd, Cincinnati, OH 45243Off Market
- $1,996,100-- bd3 ba3k sqft6210 Park Rd, Cincinnati, OH 45243Off Market
- $2,011,1003 bd4 ba5.3k sqft9655 Shawnee Run Rd, Cincinnati, OH 45243Off Market
Nearby schools
GreatSchools rating
- 9/10Indian Hill Elementary SchoolGrades: 3-5Distance: 2.2 mi
- 9/10Indian Hill Middle SchoolGrades: 6-8Distance: 2.4 mi
- 9/10Indian Hill High SchoolGrades: 9-12Distance: 2.6 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$5,459,500
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$5,459,500
Nearby cities
Nearby zip codes
Other The Village of Indian Hill Topics
- Apartments for Rent in 45243
- Houses for Sale in 45243
- Houses for Rent in 45243
- 45243 Real Estate
- The Village of Indian Hill Condos
- Houses for Sale in The Village of Indian Hill
- Newest Listings in The Village of Indian Hill
- The Village of Indian Hill Home Values
- The Village of Indian Hill Real Estate Agents
- The Village of Indian Hill Refinance
- The Village of Indian Hill Mortgage Rates
