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,339,800 Zestimate®
$410/sqft
$31,476 Estimated rent
Home value
$5,339,800
$4.86M - $5.87M
$31,476/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: March 18, 2025 at 01:31pm
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.18 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 & neighborhood
Security
- Security features: Security System
Location
- Region: Cincinnati
HOA & financial
HOA
- Has HOA: No
Other
Other facts
- 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 | ||
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 |
Find assessor info on the county website
Neighborhood: 45243
Nearby schools
GreatSchools rating
- 9/10Indian Hill Elementary SchoolGrades: 3-5Distance: 2.2 mi
- 8/10Indian Hill Middle SchoolGrades: 6-8Distance: 2.4 mi
- 9/10Indian Hill High SchoolGrades: 9-12Distance: 2.5 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,339,800