An utterly breathtaking 5-bedroom home, complete with a DEEDED BOAT DOCK, a FOUR-CAR GARAGE, and situated in an exclusive cul-de-sac location in the wonderfully sought-after Valleys at Geist subdivision. The property, which spans close to 6,000 square feet, has been subject to extensive refurbishment by the current owners and is presented in beautiful internal order. The property has a host of exciting features, including a primary bedroom on the main level, an expansive office with an additional vault room, and a sprawling basement complete with a gym, wet bar, and wine room. In addition, the property boasts an incredible outdoor living space that includes a fenced yard, a garden area, a covered outdoor fireplace, a deck, and a wonderful heated in-ground pool. The property sits on just over half an acre, on a lot that offers a combination of prime location and incredible privacy. A jaw-dropping home with high levels of interest anticipated.
Est. $3,622 per month, based on comparable rentals
Redfin agents who toured
This house needs a ton of work, specifically around the back yard, pool, and retaining wall. The list price reflects it's amazing location in Geist Woods, just north of 104th st, and off the Geist Reservoir. It's going to take an experienced...
contractor to dig into the home and access it's needs.
4 years ago• May not reflect the current state of the home
Gourmet Kitchen, hearth room with doule sided fireplace, main floor master suite with large walk in closet, outdoor entertaining at its finest including covered area w/fireplace and pool, full finished basement with bar/kitchen, work out room / bedroom, wine room, 4 car garage.
MIBOR as Distributed by MLS Grid #21800904
Oct 9, 2021
Listing Removed
—
Oct 9, 2021
Relisted
—
Sep 8, 2021
Listing Removed
—
Sep 6, 2021
Relisted
—
Aug 21, 2021
Pending
—
Jul 22, 2021
Listed
$999,900
$167/sq ft
MIBOR as Distributed by MLS Grid #21328566
Mar 28, 2015
Sold
$785,000
$131/sq ft
Feb 24, 2015
Contingent
—
Dec 16, 2014
Price Changed
$824,900
$138/sq ft
Dec 15, 2014
Listed
$829,900
$139/sq ft
MIBOR as Distributed by MLS Grid #21319406
Dec 15, 2014
Listing Removed
—
Oct 8, 2014
Listed
$829,900
$139/sq ft
MIBOR as Distributed by MLS Grid #21026121
Sep 15, 2010
Listing Removed
—
May 13, 2010
Listed
$699,900
$117/sq ft
MIBOR as Distributed by MLS Grid #2846798
Aug 10, 2009
Listing Removed
—
Aug 9, 2008
Listed
$749,900
$125/sq ft
MIBOR as Distributed by MLS Grid #2732639
May 18, 2008
Listing Removed
—
May 18, 2007
Listed
$784,900
$131/sq ft
MIBOR as Distributed by MLS Grid #2608139
Feb 4, 2007
Listing Removed
—
Feb 4, 2006
Listed
$784,900
$131/sq ft
MIBOR as Distributed by MLS Grid #2549702
Feb 10, 2006
Listing Removed
—
Aug 10, 2005
Listed
$799,900
$134/sq ft
MIBOR as Distributed by MLS Grid #2459850
Apr 22, 2005
Listing Removed
—
Oct 23, 2004
Listed
$800,000
$134/sq ft
MIBOR as Distributed by MLS Grid #2044718
Nov 15, 2000
Listed
$69,000
$12/sq ft
MIBOR as Distributed by MLS Grid #2006800
Feb 24, 2000
Listed
$79,000
$13/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$11,707 (−45.1%)
$145,200 + $879,900
$1,025,100
2024
$21,327 (+83.5%)
$145,200 + $879,900
$1,025,100
2023
$11,621 (+11.9%)
$145,200 + $836,600
$981,800
2022
$10,384 (+9.5%)
$145,200 + $827,000
$972,200
2021
$9,480 (−0.2%)
$145,200 + $692,800
$838,000
2020
$9,502 (+1.1%)
$129,000 + $630,300
$759,300
2019
$9,402 (+0.1%)
$129,000 + $627,400
$756,400
2018
$9,391 (+15.4%)
$120,800 + $627,500
$748,300
2017
$8,140 (−2.5%)
$120,800 + $536,800
$657,600
2016
$8,351 (+15.4%)
$120,800 + $536,800
$657,600
2015
$7,237 (+2.0%)
$120,800 + $551,900
$672,700
2013
$7,095
$91,900 + $541,100
$633,000
Public record
Public record
Zoning
Beds
—
Baths
5.5
Stories
2
Lot width
—
Lot depth
—
Lot size
0.56 Acres
Year renovated
2002
Sq. Ft.
5,321
Year built
2002
Style
Single Family Residential
County
Hamilton County
APN
291607101006000020
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 20, 2026.
R2
Residential District
The R2 District is intended to be provide for single-family homes in a lower density range of approximately 1.0 to 1.7 dwelling units per acre.
Permitted uses
Include but are not limited to:
Housing-Group
Housing-Single unit
Housing-Other
Infrastructure
Park & open space
Property details
Parking
Parking Information
Garage SqFt: 1131
Garage Parking Other: Finished Garage,Service Door