Skip main navigation
Closed
  • $560,000

    152 Frank Rd, Hamilton, NY 13346

    3beds
    1,008sqft
    Single Family Residence
    Built in 1954
    0.31 Acres Lot
    $580,400 Zestimate®
    $556/sqft
    $1,951 Estimated rent

    Owner options

    List your home for rent

    $1,951/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $1,951/mo

    Rent Zestimate®

    Refinance and save

    $3,892/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $3,892/mo

    Est. payment

    What's special

    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!

    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#: S1615470MLS LogoOriginating MLS: Syracuse

    Facts & 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