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
$582,600 Zestimate®
$556/sqft
$2,279 Estimated rent
Home value
$582,600
$350,000 - $973,000
$2,279/mo
Zestimate® history
Owner options
List your home for rent
$2,279/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,279/mo
Rent Zestimate®
Refinance and save
$4,148/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,148/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Waterfront homeBig windowsSpacious deckCorner stone gas fireplaceThoughtful kitchen designLarge breakfast barWood floors
Zillow last checked:
Listing updated:
Listed by:
Suzanne Martin 315-824-2203,
Suzanne L. Martin R.E., LLC
Bought with:
John Sageer, 10301224298
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 & HOA
Location
- Region: Hamilton
Financial & listing details
- Price per square foot: $556/sqft
- Tax assessed value: $155,000
- Annual tax amount: $7,710
- Date on market: 6/17/2025
- Cumulative days on market: 3 days
- 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 |
|---|---|---|
| 2025 | -- | $155,000 |
| 2024 | -- | $155,000 |
| 2023 | -- | $155,000 |
| 2022 | -- | $155,000 |
| 2021 | -- | $155,000 |
| 2020 | -- | $155,000 |
| 2019 | -- | $155,000 +6.9% |
| 2018 | -- | $145,000 |
| 2017 | $5,930 | $145,000 |
| 2016 | -- | $145,000 |
| 2015 | -- | $145,000 |
| 2014 | -- | $145,000 |
| 2013 | -- | $145,000 |
| 2012 | -- | $145,000 |
| 2011 | -- | $145,000 |
| 2010 | -- | $145,000 |
| 2009 | -- | $145,000 +4.4% |
| 2008 | -- | $138,900 |
| 2007 | -- | $138,900 |
| 2006 | -- | $138,900 |
| 2005 | -- | $138,900 +16.2% |
| 2004 | -- | $119,500 +14.9% |
| 2003 | -- | $104,000 +13% |
| 2002 | -- | $92,000 |
| 2001 | -- | $92,000 |
| 2000 | -- | $92,000 |
Find assessor info on the county website
Neighborhood: 13346
Nearby homes
- $19,960-- bd-- ba-- sqft152 Frank Rd, Hamilton, NY 13346Off Market
- $320,0002 bd2 ba864 sqft156 Frank Rd, Hamilton, NY 13346Sold
- $448,7002 bd1 ba936 sqft148 Frank Rd, Hamilton, NY 13346Off Market
- $290,5002 bd1 ba778 sqft160 Frank Rd, Hamilton, NY 13346Off Market
- $378,3003 bd2 ba2k sqft159 Frank Rd, Hamilton, NY 13346Off Market
- $348,5002 bd1 ba548 sqft144 Frank Rd, Hamilton, NY 13346Off Market
- $198,1001 bd1 ba437 sqft140 Frank Rd, Hamilton, NY 13346Off Market
- $460,7003 bd2 ba1.6k sqft136 Frank Rd, Hamilton, NY 13346Off Market
Nearby schools
GreatSchools rating
- 5/10Hamilton Elementary SchoolGrades: PK-5Distance: 2.3 mi
- 7/10Hamilton Junior Senior High SchoolGrades: 6-12Distance: 2.3 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.
- New York
- Madison County
- Hamilton
- 13346
- 152 Frank Rd
Nearby cities
Nearby zip codes
Other Hamilton Topics
