Exquisite year-round home on Lake Moraine, 3 miles from village of Hamilton, home of Colgate University. New in 2006, the focus of this home is the lake! Views everywhere! Enter into a Great Room w/ cathedral wooden ceiling, flr. to ceiling stone fp flanked by large windows/drs looking west onto the lake. From the balcony deck, cast your view upon the putting green lawn w/ slight slope to water's edge where you'll find a platform dock/deck (includes boat lift & bubbler). Wood flrs, granite counters, state of the art kitchen w/ high-end appl. , walkout FR w/ 2nd kitchen & fp. Many details-must see!
Single-familyProperty Type
2006Year Built
9,147 sq ftLot Size
$233Est. Price/Sq.Ft.
Listing by Suzanne Martin• Suzanne L. Martin R.E., LLC
•315-824-2203 (broker)
•suzanne@martinre.com (broker)
Bought with Suzanne Martin• Suzanne L. Martin R.E., LLC
•315-824-2203 (broker)
•suzanne@martinre.com (broker)
Bought with Suzanne Martin• Suzanne L. Martin Real Estate, LLC
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
4
Baths
2.5
Stories
1.5
Lot width
—
Lot depth
—
Lot size
9,583 Sq. Ft.
Year renovated
—
Sq. Ft.
2,178
Year built
2006
Style
Single Family Residential
County
Madison County
APN
254089A13801500010170000000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 19, 2026.
Property details
Parking
Parking
Features: No Garage
Interior
Virtual Tour
Bedroom Information
# of Main Level Bedrooms: 2
Bathroom Information
# of Full Bathrooms: 3
# of Main Level Bathrooms: 2
Room Information
# of Rooms (Total): 7
Room Types: Bedroom, Great Room, Laundry, Loft, Recreation, Basement, Entry Foyer, Family Room
Has Basement
Basement Information: Finished, Walk-Out Access
Laundry Information
Features: Main Level
Fireplace Information
Has Fireplace
# of Fireplaces: 2
Equipment
Generator
Appliances: Built-In Range, Built-In Oven, Built-In Refrigerator, Dryer, Dishwasher, Electric Cooktop, Microwave, Propane Water Heater, Refrigerator, Wine Cooler, Washer
Interior Features
Window Features: Skylight(s)
Door Features: Sliding Doors
Flooring: Carpet, Hardwood, Tile, Varies
Other Features: Wet Bar, Cathedral Ceiling(s), Entrance Foyer, Granite Counters, Great Room, Kitchen Island, Living/Dining Room, Sliding Glass Door(s), Second Kitchen, Skylights, Bedroom on Main Level, Loft, Bath In Primary Bedroom, Main Level Primary
Exterior
Building Information
Stories (Total): 1
Year Built Details: Existing
Construction Details: Cedar, Frame
Exterior Features
Exterior Features: Blacktop Driveway, Balcony, Deck, Dock, See Remarks, Propane Tank - Owned
Patio And Porch Features: Balcony, Deck, Open, Porch
Other Structures: Shed(s), Storage
Security Features: Security System Owned
Green Features
Green Energy Efficient: Appliances
Lot Information
Lot Size Area: 0.21
Lot Size Acres: 0.21
Lot Size Dimensions: 66X169
Lot Features: Views
Is Waterfront
Water Body Name: Lake Moraine
Waterfront Features: Lake
Frontage Length: 66
Frontage Length Remarks: 66
Property Information
Has View
Foundation Details: Poured
Resale
Financial
Assessments and Fees
Assessed Value: $357,000
Tax Information
Annual Tax Amount: $13,979
Utilities
Utility Information
Utilities: Cable Available
Electric: Circuit Breakers
Sewer: Septic Tank
Water Source: Well
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Propane, Forced Air
Public facts
Beds: 4
Baths: 2.5
Sq. Ft.: 2,178
Stories: 1.5
Lot Size: 9,583 square feet
Style: Single Family Residential
Year Built: 2006
Year Renovated: —
County: Madison County
APN: 254089A13801500010170000000
Home facts updated by county records on Aug 19, 2026
Around this home
Schools
Hamilton Elementary School
Public PreK-5 • Assigned • 3.0mi
5/10
Hamilton Junior Senior High School
Public 6-12 • Assigned • 3.0mi
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
3/10 Fire Factor
0.31% chance of being 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
In this area, properties receive around 8.6 hours in
June and 2.4 hours in December, placing it below the
U.S. average for solar exposure.
8.6 hrs
2.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$776,000 – $939,000
Reach more buyers when you sell with Redfin. Save up to $8,162 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.