You've been waiting for this one! Magnificent GEIST WATERFRONT custom ranch on full WALKOUT BASEMENT! Nestled on a quiet cove in popular lake neighborhood, Cambridge! Gorgeous water views from both levels! In-ground SWIMMING POOL & like new PRIVATE BOAT DOCK w/metal roof & hydraulic lift! HOME IS BEYOND UPDATED! Spectacular main level features a stunning office w/built-ins, elegant dining rm, spacious great rm w/fireplace, soaring ceiling & wall of windows, hearth rm w/fireplace open to gourmet kitchen w/center island, pantry & nook w/access to a quaint screened porch. The gorgeous main level owners suite boasts stunning water views+luxurious spa bath! HUGE walkout basement offers 3 bedrooms, 2 full baths, family rm, bar/rec rm & flex space
Geist waterfront in the popular neighborhood of Cambridge. Located on a quiet cove, you can enjoy sunsets out by the pool or from the hot tub. The water and the woods across the cove create a nature lover's paradise. Also, the screened in patio is the perfect place to relax and enjoy the scenery. Views of the water from every bedroom! Walkout lower level with theater area, bar, 2 bedrooms, 2 full baths, exercise area, and plenty of storage. Pool and retaining wall installed in 2010, new liner in 2018. All windows but 2 were replaced in 2015. New boat dock with metal roof & hydraulic lift installed in 2016. New concrete driveway in 2018. Garage w/ epoxy flooring and workbench. Newly repainted interior.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
4
Baths
3.5
Stories
1
Lot width
—
Lot depth
—
Lot size
0.4 Acres
Year renovated
1999
Sq. Ft.
4,629
Year built
1999
Style
Single Family Residential
County
Hamilton County
APN
291511005010000020
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 16, 2026.
R2
AIRSPACE SECONDARY ZONING DISTRICT
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.
Zone overlays
Airspace Secondary Zoning District
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: 1522
Parking Features: Attached
Garage Spaces: 3
Has Garage
Interior
Interior Sq. Ft. Information
Building Area Total: 5290
Living Area: 4959
Main Level Sq. Ft.: 2645
Upper Level Sq. Ft.: 0
Lower/Basement Level Sq. Ft (Finished): 2314
Bedroom Information
Primary Bedroom Description: Closet Walk in,Shower Stall Full,Sinks Double,Tub Garden
# of Basement Bedrooms: 3
# of Bedrooms Main: 1
Beds MU: 1
Bedrooms MU: 1
Bathroom Information
# of Full Baths (Total): 3
# of Half Baths (Total): 1
# of Full Baths (Main): 1
# of Full Baths (Basement): 2
# of Half Baths (Main): 1
Half Baths MU: 1
Half Bathrooms MU: 1
Full Baths MU: 1
Full Bathrooms MU: 1
Room 1 Information
Room Type: Dining Room
Room Features: Hardwood
Room Dimensions: 13x13
Room Level: Main
Room 2 Information
Room Type: Office
Room Features: Hardwood
Room Dimensions: 13x13
Room Level: Main
Room 3 Information
Room Type: Great Room
Room Features: Hardwood
Room Dimensions: 18x23
Room Level: Main
Room 4 Information
Room Type: Kitchen
Room Dimensions: 19x13
Room Level: Main
Room 5 Information
Room Type: Breakfast Room
Room Dimensions: 13x9
Room Level: Main
Room 6 Information
Room Type: Hearth Room
Room Dimensions: 13x8
Room Level: Main
Room 7 Information
Room Features: Hardwood
Room Dimensions: 17x16
Room Level: Main
Room 8 Information
Room Type: Family Room
Room Features: Carpet
Room Dimensions: 19x15
Room Level: Basement
Room 9 Information
Room Type: Play Room
Room Features: Carpet
Room Dimensions: 18x12
Room Level: Basement
Room 10 Information
Room Type: Bedroom 2
Room Features: Carpet
Room Dimensions: 17x12
Room Level: Basement
Room 11 Information
Room Type: Bedroom 3
Room Features: Carpet
Room Dimensions: 13x13
Room Level: Basement
Room 12 Information
Room Type: Bedroom 4
Room Features: Carpet
Room Dimensions: 13x11
Room Level: Basement
Other Rooms Information
Rooms Upper: 0
Rooms Main: 8
Rooms Basement: 5
# of Rooms: 13
Laundry Room Information
Laundry Features: Main Level
Basement Information
Has Basement
Basement Features: Ceiling - 9+ feet, Daylight/Lookout Windows, Egress Window(s), Finished, Walk Out
Fireplace Information
# of Fireplaces: 1
Fireplace Features: Two Sided, Great Room, Hearth Room
Heating & Cooling
Heating Information: Forced Air, Gas
Cooling Information: Central Electric
Interior Features
Interior Features: Attic Access, Breakfast Bar, Built In Book Shelves, Raised Ceiling(s), Tray Ceiling(s), Walk-in Closet(s), Wet Bar, Wood Work Painted
Appliances: Dishwasher, Dryer, Disposal, Gas Water Heater, Microwave, Gas Oven, Refrigerator, Washer
Areas Interior: Great Room - 2 Story
Exterior
Building Information
Percent Optional Level Finished: 75+%
Exterior Features
Patio And Porch Features: Deck Main Level, Open Patio, Screened
Exterior Features: Sprinkler System
Pool Information
Pool Features: In Ground
Waterfront Information
On Waterfront
Waterfront Features: Lake Front, Waterfront, Dock
Property Information
Ownership Interest Types: Mandatory Fee
Other Equipment: Smoke Alarm, Sump Pump w/Backup
Property Type: Residential
Has View
Property Sub Type: Single Family Residence
Land Information
Acres: 1/4-1/2 Acre
Lot Information
Lot Size Acres: 0.4
Lot Features: Mature Trees
Utilities
Utility Information
Utility Prim Sewage Disp: Municipal Sewer Connected
Water Source: Municipal/City
Utilities: Gas
Solid Waste Information: No
Location
HOA Information
Has HOA
HOA Disclosures: Covenants & Restrictions
Association Fee: $700
Association Fee Frequency: Annually
Association Fee Includes: Association Home Owners, Entrance Common, Maintenance, ParkPlayground, Management, Security, Snow Removal
School Information
High School District: Hamilton Southeastern Schools
Location Information
Directions: East on 96th St., Left on Fall Creek, Left on Springstone Rd, Left on Water Ridge Dr. to home on Left.
Tax Legal Description: Acreage .40, Section 11, Township 17, Range 5, Springs Of Cambridge, Section 5, Lot 192
Community Information
Community Features: Playground
Public facts
Beds: 4
Baths: 3.5
Sq. Ft.: 4,629
Stories: 1.0
Lot Size: 0.4 acres
Style: Single Family Residential
Year Built: 1999
Year Renovated: 1999
County: Hamilton County
APN: 291511005010000020
Home facts updated by county records on Sep 16, 2026
Other
Listing Information
Attribution Contact: awilliams@bhhsin.com
Green Information
Green Certification YN: No
Home Information
Foundation Details: Concrete Perimeter
Construction Materials: Brick
Levels: One
Around this home
Schools
Geist Elementary School
Public PreK-4 • Assigned • 1.1mi
9/10
Fall Creek Junior High
Public 7-8 • Assigned • 2.3mi
8/10
Hamilton Southeastern High School
Public 9-12 • Assigned • 2.9mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 101° expected this year, 17 days in 30 years
2/10 Wind Factor
1% chance of strong winds in next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Fishers, IN • 46055
Average low and high temperatures (°F)
31
16
41
24
60
38
68
47
71
52
82
65
86
69
81
62
81
56
69
46
53
38
40
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.8 hours in
June and 3.3 hours in December, placing it below the
U.S. average for solar exposure.
9.8 hrs
3.3 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.61M – $1.95M
Reach more buyers when you sell with Redfin. Save up to $16,955 in fees.3 minutes to get started.