WATERFRONT home on beautiful Lake Moraine, town of Madison, Hamilton School, minutes from village of Hamilton and college town of Colgate University. Once a summer cottage, this sweet lake house was remodeled six years ago and now offers YEAR ROUND living at its finest. First impression will be - WOW! - what a view!! Bank of windows in the GREAT ROOM overlook the lake, deck and "front" yard. Thoughtful kitchen design with large breakfast bar, stunning cabinetry/good storage opens up to living room-dining room combo, corner stone gas fireplace, wood floors, vaulted ceiling, big windows! In addition, first floor offers two bedrooms, nicely tiled full bath, entry foyer/laundry room. Step downstairs into the 3rd bedroom with full bath or make this your comfortable home office-exercise room with a sliding door to the lakefront. Spacious deck overlooks the lake. Includes dock, kayak rack. 2 car garage. This gorgeous home is in MOVE-IN CONDITION!
Closed
$560,000
152 Frank Rd, Hamilton, NY 13346
3beds
1,008sqft
Single Family Residence
Built in 1954
0.31 Acres Lot
$-- Zestimate®
$556/sqft
$1,804 Estimated rent
Home value
Not available
Estimated sales range
Not available
$1,804/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: August 18, 2025 at 10:52am
Listed by:
Suzanne Martin 315-824-2203,
Suzanne L. Martin R.E., LLC
Bought with:
John Sageer, 10401358042
River Hills Properties LLC Ut
Source: NYSAMLSs,MLS#: S1615470
Originating MLS: Syracuse
Originating MLS: SyracuseFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 1
- Main level bedrooms: 2
Heating
- Propane, Forced Air
Cooling
- Central Air
Appliances
- Included: Dryer, Dishwasher, Electric Oven, Electric Range, Microwave, Propane Water Heater, Refrigerator, Wine Cooler, Washer
- Laundry: Main Level
Features
- Breakfast Bar, Entrance Foyer, Granite Counters, Great Room, Kitchen/Family Room Combo, Living/Dining Room, Quartz Counters, Sliding Glass Door(s), Bedroom on Main Level
- Flooring: Hardwood, Laminate, Tile, Varies
- Doors: Sliding Doors
- Basement: Crawl Space,Partially Finished,Walk-Out Access
- Number of fireplaces: 1
Interior area
- Total structure area: 1,008
- Total interior livable area: 1,008 sqft
Property
Parking
- Total spaces: 2
- Parking features: Detached, Electricity, Garage, Garage Door Opener
- Garage spaces: 2
Features
- Levels: One
- Stories: 1
- Patio & porch: Deck
- Exterior features: Deck, Dock, Gravel Driveway, See Remarks, Propane Tank - Leased
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Beach Access, Dock Access, Lake
- Body of water: Lake Moraine
- Frontage length: 60
Lot
- Size: 0.31 Acres
- Dimensions: 60 x 245
- Features: Irregular Lot
Details
- Parcel number: 25408913801800010500000000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cape Cod,Cottage
- Property subtype: Single Family Residence
Materials
- Frame, Vinyl Siding
- Foundation: Block
- Roof: Shingle
Condition
- Resale
- Year built: 1954
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Septic Tank
- Water: Well
- Utilities for property: Cable Available, Electricity Connected, High Speed Internet Available
Community & neighborhood
Location
- Region: Hamilton
Other
Other facts
- Listing terms: Cash,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 8/15/2025 | Sold | $560,000+2%$556/sqft |
Source:  NYSAMLSs #S1615470 Report a problem | ||
| 6/20/2025 | Pending sale | $549,000$545/sqft |
Source: NYSAMLSs #S1615470 Report a problem | ||
| 6/18/2025 | Listed for sale | $549,000+119.6%$545/sqft |
Source: NYSAMLSs #S1615470 Report a problem | ||
| 9/2/2015 | Sold | $250,000+85.2%$248/sqft |
Source: Public Record Report a problem | ||
| 12/17/2003 | Sold | $135,000$134/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $155,000 |
| 2023 | -- | $155,000 |
| 2022 | -- | $155,000 |
Find assessor info on the county website
Neighborhood: 13346
Nearby schools
GreatSchools rating
- 8/10Hamilton Elementary SchoolGrades: PK-5Distance: 2.4 mi
- 8/10Hamilton Junior Senior High SchoolGrades: 6-12Distance: 2.4 mi
Schools provided by the listing agent
- District: Hamilton
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.