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,921,000 Zestimate®
$285/sqft
$6,127 Estimated rent
Home value
$1,921,000
$1.77M - $2.09M
$6,127/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$6,127/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$6,127/mo
Rent Zestimate®
Refinance and save
$10,328/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$10,328/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
Zillow last checked: 7 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,921,000
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,921,000
- Ohio
- Hamilton County
- Cincinnati
- 45208
- Columbia-Tusculum
- 2617 Grandin Rd