Nestled in a tranquil setting, this comfortable 1456 sq. ft. lakefront home offers 100 feet of pristine waterfront, perfect for picturesque sunrises and gorgeous sunsets. With two plus bedrooms and two full baths, it provides comfort and functionality for year-round living or a relaxing getaway just 6.5 miles from Hamilton. The open design flows seamlessly onto a large deck overlooking the lake. Lots of flat lawn space from road to the water on this 3/4 acre lot. This peaceful retreat offers the ultimate in waterfront living, where you can unwind, fish, kayak, ski or simply enjoy the gentle lapping of the waves from your private oasis. Currently used as an office, this could have potential for a 3rd bedroom. Laundry/utility room leads to side walkout small deck with stairway to side yard. 19 miles from Cazenovia and only 6.5 miles to Hamilton. For those not familiar with Lebanon Reservoir, Physical Features Elevation: 1300 feet , Area: 96 acres, Shoreline Length: 2.2 miles, Maximum Depth: 45 feet Town. This is a manufactured home with a walk up attic for potential further expansion.
Single-familyProperty Type
2006Year Built
0.69 acresLot Size
$269Est. Price/Sq.Ft.
1 spaceParking
Listing by Laurie Omans• Berkshire Hathaway CNY Realty
•315-815-5111 (broker)
•ddecker@bhhscnyrealty.com (broker)
Contact: 315-447-3636
Bought with Gretchen Loomis• Coldwell Banker Prime Prop. Inc.
Listing by Coldwell Banker Faith Properties, (315) 735-2222
See all
Provided by Redfin
Sale history for 5895 Geer Rd
Date
Event
Price
CNYIS #S1684311
Aug 18, 2026
Listing Removed
—
May 27, 2026
Listed
$389,000
$267/sq ft
Public Records
Jul 3, 2025
Sold
$550,000
$378/sq ft
CNYIS #S1596860
Jun 27, 2025
Sold
$275,000
$189/sq ft
May 18, 2025
Pending
—
May 15, 2025
Price Changed
$285,000
$196/sq ft
Apr 24, 2025
Price Changed
$298,500
$205/sq ft
Apr 2, 2025
Listed
$319,900
$220/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$6,403 (+15.0%)
$53,000 + $117,000
$170,000
2024
$5,569 (−3.9%)
$53,000 + $117,000
$170,000
2023
$5,794 (+6.2%)
$53,000 + $117,000
$170,000
2022
$5,456 (−2.0%)
$53,000 + $117,000
$170,000
2021
$5,565 (+37.5%)
$53,000 + $117,000
$170,000
2020
$4,047 (+2.5%)
$45,800 + $92,200
$138,000
2019
$3,947 (+7.5%)
$45,800 + $92,200
$138,000
2018
$3,670 (+0.7%)
$45,800 + $92,200
$138,000
2017
$3,643 (+79.7%)
$45,800 + $92,200
$138,000
2016
$2,028 (−45.4%)
$45,800 + $92,200
$138,000
2015
$3,712 (+16.4%)
$45,800 + $92,200
$138,000
2014
$3,190
$45,800 + $92,200
$138,000
Tax history for 5895 Geer Rd
Year
Property tax
Land + Additions
Assessment*
2025
$6,403 (+15.0%)
$53,000 + $117,000
$170,000
2024
$5,569 (−3.9%)
$53,000 + $117,000
$170,000
2023
$5,794 (+6.2%)
$53,000 + $117,000
$170,000
2022
$5,456 (−2.0%)
$53,000 + $117,000
$170,000
2021
$5,565 (+37.5%)
$53,000 + $117,000
$170,000
2020
$4,047 (+2.5%)
$45,800 + $92,200
$138,000
2019
$3,947 (+7.5%)
$45,800 + $92,200
$138,000
2018
$3,670 (+0.7%)
$45,800 + $92,200
$138,000
2017
$3,643 (+79.7%)
$45,800 + $92,200
$138,000
2016
$2,028 (−45.4%)
$45,800 + $92,200
$138,000
2015
$3,712 (+16.4%)
$45,800 + $92,200
$138,000
2014
$3,190
$45,800 + $92,200
$138,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
2
Stories
1
Lot width
—
Lot depth
—
Lot size
0.53 Acres
Year renovated
—
Sq. Ft.
1,456
Year built
2006
Style
Single Family Residential
County
Madison County
APN
253400A18200600020220060000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 19, 2026.
Property details
Parking
Parking
Features: No Garage, Circular Driveway
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, Office
Room 1 Information
Other
Level: First
Room 2 Information
Living Room
Level: First
Room 3 Information
Bedroom 2
Level: First
Room 4 Information
Other
Level: First
Room 5 Information
Bedroom 1
Level: First
Room 6 Information
Kitchen
Level: First
Room 7 Information
Dining Room
Level: First
Laundry Information
Features: Main Level
Equipment
Appliances: Dryer, Electric Water Heater, Free-Standing Range, Gas Cooktop, Gas Oven, Gas Range, Microwave, Oven, Refrigerator, Trash Compactor, Washer
Interior Features
Window Features: Drapes
Door Features: Sliding Doors
Accessibility Features: Accessibility Features, Accessible Bedroom, No Stairs
Flooring: Carpet, Resilient, Varies
Other Features: Breakfast Bar, Eat-in Kitchen, French Door(s)/Atrium Door(s), Separate/Formal Living Room, Home Office, Kitchen Island, Living/Dining Room, Sliding Glass Door(s), Window Treatments, Bedroom on Main Level, Main Level Primary, Primary Suite
Exterior
Building Information
Stories: 1
Stories (Total): 1
Year Built Details: Existing
Roof Details: Asphalt, Shingle
Construction Details: Vinyl Siding
Exterior Features
Exterior Features: Awning(s), Deck, Gravel Driveway, Propane Tank - Leased
Patio And Porch Features: Deck
Other Structures: Shed(s), Storage
Mobile Home Information
Make: Titan Home Champion
Lot Information
Lot Size Area: 0.72
Lot Size Acres: 0.72
Lot Size Dimensions: 100X335
Lot Features: Irregular Lot
Is Waterfront
Water Body Name: Lebanon Reservoir
Waterfront Features: Beach Access, Deeded Access, Lake
Frontage Length: 100
Frontage Length Remarks: 100
Property Information
Has View
Foundation Details: Slab
Resale
Financial
Assessments and Fees
Assessed Value: $170,000
Tax Information
Annual Tax Amount: $5,624
Utilities
Utility Information
Utilities: Cable Available, Electricity Available, Electricity Connected, High Speed Internet Available
Electric: Circuit Breakers
Sewer: Septic Tank
Water Source: Well
Heating & Cooling
Has Heating
Heating: Propane, Forced Air, Wall Furnace
Public facts
Beds: 2
Baths: 2.0
Sq. Ft.: 1,456
Stories: 1.0
Lot Size: 0.53 acres
Style: Single Family Residential
Year Built: 2006
Year Renovated: —
County: Madison County
APN: 253400A18200600020220060000
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
2/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
92/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.9 hrs
5.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$373,000 – $451,000
Reach more buyers when you sell with Redfin. Save up to $3,919 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.