Discover your dream property with this beautifully updated and versatile home, perfectly situated on the serene shores of Hamilton Reservoir. This turn key gem comes fully furnished with stylish furnishings and contemporary updates that create a welcoming atmosphere. Everything you need is ready for you or your future tenants! Ideal for both rental investors and owner-occupants, this property offers a fantastic opportunity to generate income in a sought-after area while enjoying a lakeside lifestyle. Each level has a large living/dining area off the updated kitchen, perfect for entertaining, along with two large bedrooms, a full bath with laundry hookups. The entire front of the house overlooks the beautiful, pristine water. The house is all-electric, using the affordable Onieda-Madison Electric Co-op. The split units provide both Central air and heat, along with the stylish electric fireplaces. Enjoy 210 feet of waterfrontage, perfect for summer days spent floating, fishing or simply relaxing by the water. Two sheds provide storage space. Whether used as a single-family home with a second kitchen or as a duplex, this is a move-in-ready home in an amazing location.
Listing by Coldwell Banker Faith Properties, (315) 735-2222
See all
Provided by Redfin
Sale history for 6186 Reservoir Rd
Date
Event
Price
GBAOR #330773
Sep 5, 2025
Sold
$420,000
$219/sq ft
Jul 23, 2025
Pending
—
Jul 8, 2025
Price Changed
$475,000
$247/sq ft
Jun 16, 2025
Price Changed
$495,000
$258/sq ft
May 29, 2025
Price Changed
$515,000
$268/sq ft
May 9, 2025
Price Changed
$523,000
$272/sq ft
Apr 16, 2025
Listed
$525,000
$273/sq ft
+45
Discover your dream property with this beautifully updated and versatile home, perfectly situated on the serene shores of Hamilton Reservoir. This turn-key gem comes fully furnished with stylish furnishings and contemporary updates that create a welcoming atmosphere. Everything you need is ready for you or your future tenants! Ideal for both rental investors and owner-occupants, this property offers a fantastic opportunity to generate income in a sought-after area while enjoying a lakeside lifestyle. Each level has a large living/dining area off the updated kitchen, perfect for entertaining, along with two large bedrooms, a full bath w/ laundry hookups. The house is all-electric, using the affordable local co-op electric. The split units provide central air and heat. Enjoy 210 feet of lake frontage, perfect for summer days. 2 sheds provide storage space. Whether used as a single-family home with a second kitchen or as a duplex, this is a move-in-ready home in an amazing location.
UNYREIS #R1600104
Sep 5, 2025
Sold
$420,000
$219/sq ft
Aug 6, 2025
Pending
—
Jul 8, 2025
Price Changed
$475,000
$247/sq ft
Jun 16, 2025
Price Changed
$495,000
$258/sq ft
May 29, 2025
Price Changed
$515,000
$268/sq ft
May 9, 2025
Price Changed
$523,000
$272/sq ft
Apr 16, 2025
Listed
$525,000
$273/sq ft
GBAOR #326203
Jun 5, 2024
Sold
$380,000
$198/sq ft
Jan 17, 2024
Listed
$389,900
$203/sq ft
CNYIS #S1517397
Jun 5, 2024
Sold
$380,000
$198/sq ft
Mar 7, 2024
Price Changed
$389,000
$203/sq ft
Feb 8, 2024
Price Changed
$399,000
$208/sq ft
Jan 17, 2024
Listed
$415,000
$216/sq ft
Amazing, fully-updated Lebanon Reservoir year round lakefront home on 1.66 acres, 210’ of waterfront, only 7 minutes from Colgate University and the Village of Hamilton. Designed with flexibility to be used as a single-family home with a second kitchen, or two separate units to Airbnb/rent. Each level has: 2 large bedrooms w/ closets, full bath, laundry hook-ups, and an open kitchen/dining/living room with electric fireplace and A/C, kitchens w/ eat-in countertops, white shaker cabinets and new appliances, combination of full-glass doors & windows across the entire front of the house offering panoramic views of the lake. There is a covered porch upstairs and covered patio down. Easy access to the gently sloping lakefront shoreline, the widest and nicest shoreline on this side of the Reservoir. The home is located on an outward curve, providing a nice vantage point and beautiful views of the lake. Outdoor/boating equipment can be stored in the 6x10 shed. Oneida-Madison Electric Co-op provides cost effective electricity and heat with an average residential rate 53% less than the NYS average rate. Public tax records indicate 960 SF each floor, total of both is 1,920 square feet.
CNYIS #S1517394
Jun 5, 2024
Sold
$380,000
$198/sq ft
Mar 7, 2024
Price Changed
$389,000
$203/sq ft
Feb 8, 2024
Price Changed
$399,000
$208/sq ft
Jan 17, 2024
Listed
$415,000
$216/sq ft
CNYIS #S1481484
Jan 1, 2024
Listing Removed
—
Oct 17, 2023
Price Changed
$419,000
$218/sq ft
Sep 7, 2023
Price Changed
$429,000
$223/sq ft
Aug 29, 2023
Price Changed
$439,000
$229/sq ft
Jul 19, 2023
Price Changed
$449,900
$234/sq ft
Jul 1, 2023
Listed
$469,000
$244/sq ft
CNYIS #S1481480
Jan 1, 2024
Listing Removed
—
Oct 17, 2023
Price Changed
$419,000
$218/sq ft
Sep 7, 2023
Price Changed
$429,000
$223/sq ft
Aug 29, 2023
Price Changed
$439,000
$229/sq ft
Jul 19, 2023
Price Changed
$449,900
$234/sq ft
Jul 1, 2023
Listed
$469,000
$244/sq ft
CNYIS #S1443229
Nov 4, 2022
Sold
$275,000
$143/sq ft
Nov 4, 2022
Listed
$275,000
$143/sq ft
CNYIS #S239250
Jun 30, 2011
Sold
$158,000
$82/sq ft
Aug 4, 2010
Listed
$179,900
$94/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$9,541 (+54.9%)
$91,900 + $158,100
$250,000
2024
$6,161 (−3.9%)
$91,900 + $93,100
$185,000
2023
$6,409 (+6.0%)
$91,900 + $93,100
$185,000
2022
$6,048 (−0.1%)
$91,900 + $93,100
$185,000
2021
$6,056 (−38.6%)
$91,900 + $93,100
$185,000
2020
$9,861 (+65.3%)
$60,000 + $98,500
$158,500
2019
$5,967 (+5.6%)
$60,000 + $98,500
$158,500
2018
$5,648 (+1.0%)
$60,000 + $98,500
$158,500
2017
$5,591 (+129.2%)
$60,000 + $98,500
$158,500
2016
$2,440 (−56.7%)
$60,000 + $98,500
$158,500
2015
$5,630 (+12.8%)
$60,000 + $98,500
$158,500
2014
$4,993
$60,000 + $98,500
$158,500
Tax history for 6186 Reservoir Rd
Year
Property tax
Land + Additions
Assessment*
2025
$9,541 (+54.9%)
$91,900 + $158,100
$250,000
2024
$6,161 (−3.9%)
$91,900 + $93,100
$185,000
2023
$6,409 (+6.0%)
$91,900 + $93,100
$185,000
2022
$6,048 (−0.1%)
$91,900 + $93,100
$185,000
2021
$6,056 (−38.6%)
$91,900 + $93,100
$185,000
2020
$9,861 (+65.3%)
$60,000 + $98,500
$158,500
2019
$5,967 (+5.6%)
$60,000 + $98,500
$158,500
2018
$5,648 (+1.0%)
$60,000 + $98,500
$158,500
2017
$5,591 (+129.2%)
$60,000 + $98,500
$158,500
2016
$2,440 (−56.7%)
$60,000 + $98,500
$158,500
2015
$5,630 (+12.8%)
$60,000 + $98,500
$158,500
2014
$4,993
$60,000 + $98,500
$158,500
*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
1.66 Acres
Year renovated
—
Sq. Ft.
1,920
Year built
1974
Style
Single Family Residential
County
Madison County
APN
253400A18200700010070000000
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
Bedroom Information
# of Main Level Bedrooms: 2
Bathroom Information
# of Full Bathrooms: 2
# of Main Level Bathrooms: 1
Room Information
# of Rooms (Total): 6
Room Types: Bedroom, Great Room, InLaw Suite, Laundry, Living Room
Laundry Information
Features: Main Level, Upper Level
Fireplace Information
Has Fireplace
# of Fireplaces: 2
Equipment
Appliances: Dryer, Electric Water Heater, Refrigerator, Washer
Interior Features
Flooring: Luxury Vinyl
Other Features: Separate/Formal Living Room, Great Room, Living/Dining Room, Quartz Counters, See Remarks, Solid Surface Counters, Bedroom on Main Level, In-Law Floorplan, Programmable Thermostat
Exterior
Building Information
Stories: 2
Stories (Total): 2
Year Built Details: Existing
Roof Details: Architectural, Shingle
Construction Details: Vinyl Siding
Exterior Features
Exterior Features: Blacktop Driveway, Patio
Patio And Porch Features: Open, Patio, Porch
Other Structures: Shed(s), Storage
Lot Information
Lot Size Area: 1.66
Lot Size Acres: 1.66
Lot Size Dimensions: 210X100
Lot Features: Rectangular, Rectangular Lot
Road Frontage Type: Main Thoroughfare
Is Waterfront
Water Body Name: Lebanon Reservoir
Waterfront Features: Beach Access, Reservoir in Community
Frontage Length: 210
Frontage Length Remarks: 210
Property Information
Has View
Foundation Details: Poured
Resale
Financial
Assessments and Fees
Assessed Value: $185,000
Tax Information
Annual Tax Amount: $6,316
Utilities
Utility Information
Utilities: Cable Available, High Speed Internet Available
Sewer: Septic Tank
Water Source: Well
Heating & Cooling
Has Cooling
Cooling: Ductless, Heat Pump, Central Air
Has Heating
Heating: Ductless, Heat Pump, Electric
Public facts
Beds: 2
Baths: 2.0
Sq. Ft.: 1,920
Stories: 1.0
Lot Size: 1.66 acres
Style: Single Family Residential
Year Built: 1974
Year Renovated: —
County: Madison County
APN: 253400A18200700010070000000
Home facts updated by county records on Aug 19, 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
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
$506,000 – $612,000
Reach more buyers when you sell with Redfin. Save up to $5,321 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.