Custom-built 5BR, 5.5BA home blends timeless craftsmanship w/ modern comfort across over 8,400 sq ft. Brazilian cherry floors, solid cherry cabinetry, & extensive woodwork add warmth throughout. The sunlit solarium features a fountain-ready tile floor, while a bonus artist's studio above the 3-car garage offers creative bonus space. The finished lower level includes a full party kitchen, bar, wine cooler, TV with surround sound, and bedroom with soundproofing which could serve as a music room. This lower level is ideal as a private guest suite. The primary suite features a cedar closet off the walk-in closet, a bonus room currently used as a yoga studio and two convenient home offices nearby. The garage includes a 240V EV outlet. New roof (2023), dual high-efficiency HVACs (2022 & 2023), HWH (2024 & 2015) Professionally landscaped w/native plantings, perennials, fountain & tranquil recirculating waterfall. Experience the quality & comfort of 5788 Brookstone!
Sold for $1,000,000
Street View
$1,000,000
5788 Brookstone Dr, Cincinnati, OH 45230
5beds
8,285sqft
Single Family Residence
Built in 1994
1.17 Acres Lot
$1,072,900 Zestimate®
$121/sqft
$6,708 Estimated rent
Home value
$1,072,900
$1.02M - $1.13M
$6,708/mo
Zestimate® history
Owner options
List your home for rent
$6,708/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$6,708/mo
Rent Zestimate®
Refinance and save
$5,836/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$5,836/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
Private guest suiteSunlit solariumFinished lower levelPrimary suiteTv with surround soundExtensive woodworkWine cooler
Zillow last checked:
Listing updated:
Listed by:
David D Browning 513-300-1016,
Coldwell Banker Realty 513-474-5000,
Barbara J. Browning 513-300-7990,
Coldwell Banker Realty
Bought with:
K Lynne Engel, 2011001848
Plum Tree Realty
David D Browning, 2016004486
Coldwell Banker Realty
Source: Cincy MLS,MLS#: 1837936
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 5
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Wall-to-Wall Carpet, Window Treatment, Sitting Room
- Level: Second
- Area: 460
- Dimensions: 23 x 20
Bedroom 2
- Level: Second
- Area: 210
- Dimensions: 15 x 14
Bedroom 3
- Level: Second
- Area: 224
- Dimensions: 16 x 14
Bedroom 4
- Level: Second
- Area: 169
- Dimensions: 13 x 13
Bedroom 5
- Level: Lower
- Area: 196
- Dimensions: 14 x 14
Primary bathroom
- Features: Shower, Tile Floor, Double Vanity, Jetted Tub
Bathroom 1
- Features: Full
- Level: Second
Bathroom 2
- Features: Full
- Level: First
Bathroom 3
- Features: Partial
- Level: First
Bathroom 4
- Features: Full
- Level: Second
Dining room
- Features: Chandelier, Window Treatment, Wood Floor, Formal
- Level: First
- Area: 304
- Dimensions: 19 x 16
Family room
- Features: Bookcases, Walkout, Wall-to-Wall Carpet, Fireplace
- Area: 324
- Dimensions: 18 x 18
Kitchen
- Features: Pantry, Planning Desk, Counter Bar, Eat-in Kitchen, Gourmet, Kitchen Island, Wood Cabinets, Wood Floor
- Area: 270
- Dimensions: 18 x 15
Living room
- Features: Fireplace, Window Treatment, Wood Floor
- Area: 336
- Dimensions: 21 x 16
Office
- Features: Wall-to-Wall Carpet
- Level: Second
- Area: 169
- Dimensions: 13 x 13
Heating
- Forced Air, Gas, Zoned
Cooling
- Central Air
Appliances
- Included: Dishwasher, Double Oven, Dryer, Gas Cooktop, Microwave, Refrigerator, Washer, Wine Cooler, Water Softener, Gas Water Heater
- Laundry: Laundry Chute
Features
- High Ceilings, Crown Molding
- Doors: French Doors, Multi Panel Doors
- Windows: Casement, Wood Frames, Skylight(s)
- Basement: Full,Finished,Walk-Out Access,WW Carpet
- Number of fireplaces: 3
- Fireplace features: Gas, Basement, Family Room, Living Room
Interior area
- Total structure area: 8,285
- Total interior livable area: 8,285 sqft
Property
Parking
- Total spaces: 3
- Parking features: Driveway, Garage Door Opener
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Patio
- Has view: Yes
- View description: Trees/Woods
Lot
- Size: 1.17 Acres
- Features: Wooded, 1 to 4.9 Acres, Fountain
Details
- Parcel number: 5000470025100
- Zoning description: Residential
- Other equipment: Intercom
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Transitional
- Property subtype: Single Family Residence
Materials
- Stone, Stucco
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 1994
Utilities & green energy
- Electric: 220 Volts
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Security: Heat Detector, Security System, Carbon Monoxide Detector(s)
- Subdivision: River Hills
HOA
- Has HOA: Yes
- Services included: Community Landscaping
- HOA fee: $400 annually
Location
- Region: Cincinnati
Financial & listing details
- Price per square foot: $121/sqft
- Tax assessed value: $1,094,650
- Annual tax amount: $24,270
- Date on market: 11/6/2025
- Listing terms: No Special Financing,Other
Price history
| Date | Event | Price |
|---|---|---|
| 2/13/2026 | Sold | $1,000,000-13%$121/sqft |
Source:  Cincy MLS #1837936 Report a problem | ||
| 1/16/2026 | Pending sale | $1,150,000$139/sqft |
Source: Cincy MLS #1837936 Report a problem | ||
| 1/4/2026 | Price change | $1,150,000-8%$139/sqft |
Source: Cincy MLS #1837936 Report a problem | ||
| 12/11/2025 | Price change | $1,250,000-7.4%$151/sqft |
Source: Cincy MLS #1837936 Report a problem | ||
| 11/18/2025 | Price change | $1,350,000-10%$163/sqft |
Source: Cincy MLS #1837936 Report a problem | ||
| 11/6/2025 | Listed for sale | $1,500,000$181/sqft |
Source: Cincy MLS #1837936 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $24,270 +6.6% | $383,128 |
| 2023 | $22,777 +14.2% | $383,128 +28.3% |
| 2022 | $19,948 +1.7% | $298,505 |
| 2021 | $19,613 | $298,505 +0% |
| 2020 | $19,613 +8.9% | $298,504 +13% |
| 2019 | $18,009 +4.6% | $264,162 0% |
| 2018 | $17,209 | $264,163 |
| 2017 | $17,209 +2.8% | $264,163 +2.3% |
| 2016 | $16,747 | $258,332 |
| 2015 | $16,747 +4.6% | $258,332 |
| 2014 | $16,010 +11% | $258,332 +5% |
| 2013 | $14,419 -0.3% | $246,030 |
| 2012 | $14,461 +7.9% | $246,030 |
| 2011 | $13,396 -7.8% | $246,030 -11.1% |
| 2010 | $14,522 +2.3% | $276,742 |
| 2009 | $14,189 +2.3% | $276,742 |
| 2008 | $13,872 -1.5% | $276,742 -5% |
| 2007 | $14,089 +0.7% | $291,305 |
| 2006 | $13,993 +11.3% | $291,305 |
| 2005 | $12,573 +5.5% | $291,305 +16.7% |
| 2003 | $11,917 +445.6% | $249,585 +448.5% |
| 2002 | $2,184 +1.7% | $45,500 |
| 2001 | $2,148 +3.3% | $45,500 |
| 2000 | $2,080 | $45,500 |
Find assessor info on the county website
Neighborhood: 45230
Nearby homes
- $1,138,1005 bd3 ba3.7k sqft5792 Brookstone Dr, Cincinnati, OH 45230Off Market
- $1,808,0005 bd7 ba7.3k sqft5786 Brookstone Dr, Cincinnati, OH 45230Off Market
- $1,580,7005 bd7 ba7.3k sqft5786 Brookstone Dr, Anderson Twp, OH 45230Off Market
- $1,430,8004 bd4 ba3.1k sqft5794 Brookstone Dr, Cincinnati, OH 45230Off Market
- $1,396,7004 bd4 ba-- sqft5794 Brookstone Dr, Anderson Twp, OH 45230Off Market
- $801,0003 bd4 ba2.8k sqft535 Fairway Ln, Cincinnati, OH 45230Off Market
- $814,8004 bd4 ba3.4k sqft5689 Brookstone Dr, Cincinnati, OH 45230Off Market
- $759,6004 bd4 ba-- sqft5689 Brookstone Dr, Anderson Twp, OH 45230Off Market
Nearby schools
GreatSchools rating
- 9/10Sherwood Elementary SchoolGrades: PK-6Distance: 2.9 mi
- 9/10Nagel Middle SchoolGrades: 7-8Distance: 4.3 mi
- 8/10Anderson High SchoolGrades: 9-12Distance: 3.2 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
$1,072,900
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
$1,072,900
- Ohio
- Hamilton County
- Cincinnati
- 45230
- 5788 Brookstone Dr
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Cincinnati Topics
