This property checks all the boxes for a reasonably priced recreational property, second home or retirement home. Unique 38 plus acre parcel with direct deep water LAKEFRONT on Lebanon Reservoir. The property includes a two bedroom two bathroom singlewide mobile home for a turnkey waterfront starter camp. Start with the mobile home and build a new cabin or retirement home. Over 38 acres of beautiful mostly wooded land with expansive views of the lake for hunting, hiking and other recreational pursuits. The land features apple and other fruit bearing trees and shrubs, mature hardwood including maple, ash and black cherry. Long distance views from an elevated field and completely accessible with trails throughout. The lake has excellent fishing for bass and trout. State Boat Launch just down the road. The lake is a clean deep water reservoir perfect for motorboats and small enough for canoes and kayaks. Located just 10 minutes to Hamilton and Colgate University for hospital and health care, shopping restaurants and more! Enjoy life at the LAKE and don't miss out on this rare opportunity to own a large lakefront property!
ManufacturedProperty Type
2002Year Built
38.26 acresLot Size
$255Est. Price/Sq.Ft.
Listing by Justin Rogers• New York Trophy Properties
Bought with Non-Member Reciprocal• Non Member Office
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
38.26 Acres
Year renovated
—
Sq. Ft.
952
Year built
2000
Style
Mobile/Manufactured Home
County
Madison County
APN
253400A18200000010252120000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 8, 2026.
Property details
Interior
Bathroom Information
# of Full Bathrooms: 2
Heating & Cooling
Heating: Forced Air, Propane
Interior Features
Appliances: Dryer, Range, Refrigerator, Washer, Electric Water Heater
Flooring: Carpet, Vinyl
Exterior
Exterior Features
Patio And Porch Features: Deck
Roof: Asphalt
Building Information
Foundation Details: Slab
Property Features
On Waterfront
Property Information
Property Type: Residential
Property Sub Type: Mobile Home
Raw Mls Property Sub Type: Mobile Home
Lot Information
Lot Features: Waterfront
Lot Size Acres: 38.26
Utilities
Utility Information
Water Source: Well
Sewer: Septic Tank
Location
Schools Information
School District: Hamilton
Location Information
Directions: Hamilton onto Lebanon Street heading South to right onto Armstrong Road. Straight across County 73 onto Reservoir Rd. Go across dam and property is on the left approx. half way down.
Public facts
Beds: —
Baths: —
Sq. Ft.: 952
Stories: —
Lot Size: 38.26 acres
Style: Mobile/Manufactured Home
Year Built: 2000
Year Renovated: —
County: Madison County
APN: 253400A18200000010252120000
Home facts updated by county records on Oct 8, 2026
Around this home
Schools
Hamilton Elementary School
Public PreK-5 • Assigned • 3.3mi
5/10
Hamilton Junior Senior High School
Public 6-12 • Assigned • 3.3mi
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
1/10 Heat Factor
6 days above 92° expected this year, 13 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
49
60
38
46
31
33
19
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
Try the sun simulator tool to see how light moves across the property at different times of day and year.