Welcome to your dream waterfront escape on Lebanon Reservoir! This stunning property has over 296 feet of pristine lake frontage offering breathtaking views and unparalleled tranquility. Step inside to discover a beautifully rebuilt home featuring 2 bedrooms and 2 full baths. The vaulted ceiling in the family room creates an airy, open atmosphere perfect for relaxation or entertaining. Enjoy the serene lake views year-round from this inviting waterfront retreat! A 3 season front room with a wall of windows takes in gorgeous waterfront views. Outside, you'll find a spacious patio down by the lake perfect for soaking in that natural peaceful private beauty. Don't miss this rare opportunity to own a piece of paradise on the water! You will rarely find any waterfront property with this much privately owned frontage!! Also 11' x 24' shed on the property is included along with the dock.
Single-familyProperty Type
2002Year Built
0.88 acresLot Size
$453Est. Price/Sq.Ft.
2 car garageParking
Listing by Laurie Omans• Berkshire Hathaway CNY Realty
•315-815-5111 (broker)
•ddecker@bhhscnyrealty.com (broker)
Contact: 315-447-3636
Bought with Laurie Omans• Berkshire Hathaway CNY Realty
Listing by Coldwell Banker Faith Properties, (315) 735-2222
See all
Provided by Redfin
Sale history for 5899 Geer Rd
Date
Event
Price
CNYIS #S1552906
Nov 22, 2024
Sold
$450,000
$399/sq ft
Nov 4, 2024
Pending
—
Oct 27, 2024
Listing Removed
—
Aug 30, 2024
Price Changed
$469,900
$417/sq ft
Jul 20, 2024
Listed
$485,000
$430/sq ft
Public Records
Nov 14, 2002
Sold
$51,795
$46/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$9,541 (+63.7%)
$101,400 + $148,600
$250,000
2024
$5,828 (−3.9%)
$101,400 + $73,600
$175,000
2023
$6,062 (+6.0%)
$101,400 + $73,600
$175,000
2022
$5,721 (−0.1%)
$101,400 + $73,600
$175,000
2021
$5,728 (+35.6%)
$101,400 + $73,600
$175,000
2020
$4,225 (+2.6%)
$86,800 + $53,200
$140,000
2019
$4,119 (+7.3%)
$86,800 + $53,200
$140,000
2018
$3,838 (+0.7%)
$86,800 + $53,200
$140,000
2017
$3,811 (+76.8%)
$86,800 + $53,200
$140,000
2016
$2,155 (−44.6%)
$86,800 + $53,200
$140,000
2015
$3,889 (+16.2%)
$86,800 + $53,200
$140,000
2014
$3,347
$86,800 + $53,200
$140,000
Tax history for 5899 Geer Rd
Year
Property tax
Land + Additions
Assessment*
2025
$9,541 (+63.7%)
$101,400 + $148,600
$250,000
2024
$5,828 (−3.9%)
$101,400 + $73,600
$175,000
2023
$6,062 (+6.0%)
$101,400 + $73,600
$175,000
2022
$5,721 (−0.1%)
$101,400 + $73,600
$175,000
2021
$5,728 (+35.6%)
$101,400 + $73,600
$175,000
2020
$4,225 (+2.6%)
$86,800 + $53,200
$140,000
2019
$4,119 (+7.3%)
$86,800 + $53,200
$140,000
2018
$3,838 (+0.7%)
$86,800 + $53,200
$140,000
2017
$3,811 (+76.8%)
$86,800 + $53,200
$140,000
2016
$2,155 (−44.6%)
$86,800 + $53,200
$140,000
2015
$3,889 (+16.2%)
$86,800 + $53,200
$140,000
2014
$3,347
$86,800 + $53,200
$140,000
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
2
Baths
1
Stories
1
Lot width
—
Lot depth
—
Lot size
0.88 Acres
Year renovated
—
Sq. Ft.
1,128
Year built
1958
Style
Single Family Residential
County
Madison County
APN
253400A18200600010050000000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 19, 2026.
Property details
Parking
Garage/Carport Information
Has Garage
Has Attached Garage
# of Garage Spaces: 2
Parking
Features: Attached, Garage, Storage, Workshop in Garage, Garage Door Opener
Interior
Virtual Tour
Bedroom Information
# of Main Level Bedrooms: 2
Bathroom Information
# of Full Bathrooms: 2
# of Main Level Bathrooms: 2
Room Information
# of Rooms (Total): 7
Room Types: Bedroom, Laundry, Living Room, Porch, Entry Foyer
Basement Information: Crawl Space
Room 1 Information
Level: First
Room 2 Information
Level: First
Room 3 Information
Level: First
Room 4 Information
Level: First
Room 5 Information
Level: First
Room 6 Information
Level: First
Laundry Information
Features: Main Level
Equipment
Appliances: Dryer, Dishwasher, Electric Cooktop, Exhaust Fan, Electric Oven, Electric Range, Electric Water Heater, Free-Standing Range, Microwave, Oven, Refrigerator, Range Hood, Washer, Water Softener Owned
Interior Features
Door Features: Sliding Doors
Flooring: Carpet, Varies, Vinyl
Other Features: Ceiling Fan(s), Cathedral Ceiling(s), Entrance Foyer, Eat-in Kitchen, Separate/Formal Living Room, Kitchen Island, Pull Down Attic Stairs, Sliding Glass Door(s), Natural Woodwork, Bedroom on Main Level, Bath In Primary Bedroom, Main Level Primary, Primary Suite
Exterior
Building Information
Stories: 1
Stories (Total): 1
Year Built Details: Existing
Roof Details: Asphalt
Construction Details: Vinyl Siding, Copper Plumbing
Exterior Features
Exterior Features: Deck, Dock, Gravel Driveway, Patio, See Remarks
Patio And Porch Features: Deck, Enclosed, Patio, Porch
Other Structures: Shed(s), Storage
Lot Information
Lot Size Area: 1.04
Lot Size Acres: 1.04
Lot Size Dimensions: 296X100
Lot Features: Irregular Lot
Is Waterfront
Water Body Name: Lebanon Reservoir
Waterfront Features: Beach Access, Deeded Access, Dock Access, Lake
Frontage Length: 296
Frontage Length Remarks: 296
Property Information
Has View
Foundation Details: Block, Pillar/Post/Pier
Resale
Financial
Assessments and Fees
Assessed Value: $175,000
Tax Information
Annual Tax Amount: $4,912
Utilities
Utility Information
Utilities: Cable Available
Electric: Circuit Breakers
Sewer: Septic Tank
Water Source: Well
Heating & Cooling
Has Cooling
Cooling: Window Unit(s)
Has Heating
Heating: Baseboard, Electric
Public facts
Beds: 2
Baths: 1.0
Sq. Ft.: 1,128
Stories: 1.0
Lot Size: 0.88 acres
Style: Single Family Residential
Year Built: 1958
Year Renovated: —
County: Madison County
APN: 253400A18200600010050000000
Home facts updated by county records on Aug 19, 2026
Around this home
Schools
Hamilton Elementary School
Public PreK-5 • Assigned • 3.5mi
5/10
Hamilton Junior Senior High School
Public 6-12 • Assigned • 3.5mi
7/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
2/10 Heat Factor
7 days above 92° expected this year, 16 days in 30 years
1/10 Wind Factor
1% chance of strong winds in next 30 years
1/10 Air Factor
0 unhealthy days expected this year, 0 days in 30 years
Provided by First Street
Historical weather
Hamilton, NY • 13346
Average low and high temperatures (°F)
27
14
31
14
48
28
58
36
64
45
76
56
81
61
77
53
72
50
60
38
46
31
33
19
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 8.6 hours in
June and 2.5 hours in December, placing it below the
U.S. average for solar exposure.
8.6 hrs
2.5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$486,000 – $588,000
Reach more buyers when you sell with Redfin. Save up to $5,112 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.