Tucked away down a private drive on Grandin Road lies your private retreat at the Sunset Treehouse. This 2006 custom build by Daniels Fine Homes provides four seasons of tranquility and spectacular views of your wooded yard from your private deck and walkout basement. A truly flexible floor plan provides endless possibilities for the house to easily accommodate extra bedrooms, if desired, and a private entrance into a studio/office space. Soaring ceilings and quality finishes are the hallmark of this lovingly maintained home.
Sold for $1,900,000
$1,900,000
2617 Grandin Rd, Cincinnati, OH 45208
3beds
6,664sqft
Single Family Residence
Built in 2006
1.3 Acres Lot
$1,900,600 Zestimate®
$285/sqft
$7,496 Estimated rent
Home value
$1,900,600
$1.81M - $2.00M
$7,496/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: December 15, 2025 at 06:25am
Listed by:
Brett P Stern 513-885-8226,
Keller Williams Advisors 513-766-9200
Bought with:
Monika Deroussel, 2006002985
eXp Realty
Source: Cincy MLS,MLS#: 1860938
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Walkout, Wood Floor, Other
- Level: First
- Area: 384
- Dimensions: 16 x 24
Bedroom 2
- Level: Lower
- Area: 252
- Dimensions: 18 x 14
Bedroom 3
- Level: Lower
- Area: 272
- Dimensions: 17 x 16
Bedroom 4
- Area: 0
- Dimensions: 0 x 0
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Sauna, Built-In Shower Seat, Shower, Double Shower, Double Vanity, Jetted Tub
Bathroom 1
- Features: Full
- Level: First
Bathroom 2
- Features: Full
- Level: Lower
Bathroom 3
- Features: Full
- Level: Lower
Bathroom 4
- Features: Partial
- Level: First
Dining room
- Features: Chandelier, Walkout, Wood Floor
- Level: First
- Area: 195
- Dimensions: 15 x 13
Family room
- Area: 0
- Dimensions: 0 x 0
Great room
- Features: Walkout, Fireplace, Wood Floor, Other
- Level: First
- Area: 528
- Dimensions: 22 x 24
Kitchen
- Features: Butler's Pantry, Pantry, Planning Desk, Counter Bar, Eat-in Kitchen, Gourmet, Kitchen Island, Other
- Area: 625
- Dimensions: 25 x 25
Living room
- Area: 0
- Dimensions: 0 x 0
Office
- Features: Walkout
- Level: Lower
- Area: 216
- Dimensions: 12 x 18
Heating
- Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Double Oven, Gas Cooktop, Oven/Range, Refrigerator, Gas Water Heater
Features
- High Ceilings, Ceiling Fan(s), Recessed Lighting
- Windows: Vinyl, Insulated Windows
- Basement: Full,Finished,Walk-Out Access,WW Carpet
- Number of fireplaces: 1
- Fireplace features: Wood Burning, Great Room
Interior area
- Total structure area: 6,664
- Total interior livable area: 6,664 sqft
Property
Parking
- Total spaces: 3
- Parking features: Driveway, Garage Door Opener
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered Deck/Patio, Deck, Enclosed Porch, Porch
Lot
- Size: 1.30 Acres
- Features: Wooded
Details
- Parcel number: 0300002009100
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Transitional
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 2006
Utilities & green energy
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Location
- Region: Cincinnati
HOA & financial
HOA
- Has HOA: No
Other
Other facts
- Listing terms: No Special Financing,Cash
Price history
| Date | Event | Price |
|---|---|---|
| 12/13/2025 | Sold | $1,900,000+16.9%$285/sqft |
Source:  Cincy MLS #1860938 Report a problem | ||
| 11/16/2025 | Pending sale | $1,625,000$244/sqft |
Source: Cincy MLS #1860938 Report a problem | ||
| 11/14/2025 | Listed for sale | $1,625,000$244/sqft |
Source: Cincy MLS #1860938 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $30,336 -2.2% | $508,330 |
| 2023 | $31,003 +0.4% | $508,330 +11.9% |
| 2022 | $30,889 +24.6% | $454,402 |
Find assessor info on the county website
Neighborhood: Columbia-Tusculum
Nearby schools
GreatSchools rating
- 4/10Riverview East AcademyGrades: PK-12Distance: 0.6 mi
- 6/10Hyde Park SchoolGrades: K-6Distance: 1.1 mi
- 6/10Clark Montessori High SchoolGrades: 7-12Distance: 1.3 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,900,600