HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

Layout spacer

    Layout spacer

      About Us

      • Who We are
      • Meet the Team

      Resources

      • Latest Blogs
      • Free Vendor List
      • PracticalGuides
      • Need Funding?
      • Property Inspector
      • Down Payment Eligibility

      Communities

      • Otsego County
      • Schoharie County
      • Chenango County
      • Delaware County
      • Greene County
      • Broome County
      • Oneida County
      • Montgomery County
      • Ulster County

      Disclosures

      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution

      © 2026 Homes, Farms & Land. All rights reserved.

      Property at 152 Frank Road, Madison, NY 13346
      CLOSED
      0
      $549,000

      152 Frank RoadMadison, NY, 13346

      3 Beds2 Baths1,008 SqFt0.31 Acres
      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!

      Est. Monthly

      $2,602/mo

      $549,000

      152 Frank Road, Madison, NY

      3 Beds2 Baths1,008 SqFt0.31 Acres

      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!

      StatusClosed
      Property TypeResidential
      Property SubtypeSingle Family Residence
      Year Built1954
      Total Rooms5 rooms
      Days on Market59 days

      Est. Monthly Payment

      $2,602.25

      %
      %
      yr

      Private Mortgage Insurance

      Not required

      Affordability Checkoptional
      $

      Enter your annual income to check affordability

      Property Details

      Property Information

      152 Frank Road

      Madison, NY 13346 • Madison
      3
      Beds
      2
      Baths
      1,008
      SqFt
      0.31
      Acres
      Status
      Closed
      Property Type
      Residential
      Property Subtype
      Single Family Residence
      Year Built
      195472 years ago
      Total Rooms
      5 rooms
      Days on Market
      59 days
      Tax History
      Estimated values, may not reflect current amounts.
      • Annual Tax Amount
        $7,710
      Property History
      • Closed
        Aug 15, 2025 • NYSAMLS • S1615470
        $549,000
      • Listed for sale
        Jun 17, 2025 • NYSAMLS • S1615470
        $549,000
      Mortgage Calculator
      Estimated monthly payment for this property
      $2,602.25
      Down Payment
      Interest Rate
      Loan Term
      %
      %
      yearsyrs.
      Affordability Checkoptional
      $

      Enter your annual income to see if this home fits your budget

      Private Mortgage Insurance

      Not required — down payment above 20%
      MLS Information
      • Source
        NYSAMLS
      • MLS#
        S1615470
      • Listing Office
        Suzanne L. Martin R.E., LLC
      • Last Updated
        33 days ago

      Appliances

      • Appliances
        • Dryer
        • Dishwasher
        • Electric Oven
        • Electric Range
        • Microwave
        • Propane Water Heater
        • Refrigerator
        • Wine Cooler
        • Washer

      Climate & Systems

      • Heating
        • Propane
        • Forced Air

      Interior Features

      • Flooring
        • Hardwood
        • Laminate
        • Tile
        • Varies
      • Doors
        Sliding Doors
      • Basement
        • Crawl Space
        • Partially Finished
        • Walk Out Access
      • Interior Features
        • Breakfast Bar
        • Entrance Foyer
        • Granite Counters
        • Great Room
        • Kitchen Family Room Combo
        • Living Dining Room
        • Quartz Counters
        • Sliding Glass Doors
        • Bedroom On Main Level

      Parking

      • Parking Features
        • Detached
        • Electricity
        • Garage
        • Garage Door Opener
      • Garage Spaces
        2

      Lot & Grounds

      • Lot Size
        0.31 acres
      • Lot Features
        Irregular Lot
      • View
        Water
      • Patio & Porch
        Deck
      • Exterior Features
        • Deck
        • Dock
        • Gravel Driveway
        • See Remarks
        • Propane Tank Leased

      Type

      • Property Type
        Residential
      • Property Subtype
        Single Family Residence
      • Architectural Style
        • Cape Cod
        • Cottage

      Structure

      • Construction
        • Frame
        • Vinyl Siding
      • Roof
        Shingle
      • Foundation
        Block

      Condition

      • Year Built
        1954
      • Condition
        Resale
      • Days on Market
        59 days
      • Water
        Well
      • Sewer
        Septic Tank
      • Electric
        Circuit Breakers
      • Utilities
        • Cable Available
        • Electricity Connected
        • High Speed Internet Available

      607-282-6242, (607) 282-6242, or +1 607 282 6242

      Kevin Lucero

      Kevin Lucero

      Lic. Real Estate Salesperson

      CallEmail
      Picked for you

      Similar Properties

      Handpicked listings that match what you're looking at

      View all →
      • 3006 Mohawk Drive, Forestport, NY 13338ACTIVE$495,000

        3006 Mohawk Drive, Forestport, NY 13338

        3 Beds1.5 Baths1,400 SqFt4 Acres

        LISTING BY HERRON REALTY

      • 35799 State Highway 10, Hamden, NY 13782ACTIVE$495,000

        35799 State Highway 10, Hamden, NY 13782

        5 Beds4.5 Baths1,828 SqFt1 Acres

        LISTING BY COMPASS GREATER NY LLC

      • 216 Treehaven Drive, Aurora, NY 14052ACTIVE$495,000

        216 Treehaven Drive, Aurora, NY 14052

        3 Beds1.5 Baths1,796 SqFt0.5073 Acres

        LISTING BY MAYWALT REALTY GROUP

      • 720 Kennedy Road, Romulus, NY 14541ACTIVE$495,000OPEN 5/20

        720 Kennedy Road, Romulus, NY 14541

        3 Beds2 Baths1,693 SqFt3.17 Acres

        LISTING BY HOMECOIN.COM

      • 9333 Woodcrest Drive, Erwin, NY 14870ACTIVE$495,000

        9333 Woodcrest Drive, Erwin, NY 14870

        3 Beds3.5 Baths3,362 SqFt0.54 Acres

        LISTING BY SIGNATURE PROPERTIES

      • 3942 Pine Hill Road, Hornby, NY 14830ACTIVE$495,000

        3942 Pine Hill Road, Hornby, NY 14830

        4 Beds4 Baths3,200 SqFt8.25 Acres

        LISTING BY HOWARD HANNA CORNING

      • 10094 Powell Rd, Trenton, NY 13354ACTIVE$495,000

        10094 Powell Rd, Trenton, NY 13354

        5 Beds1.5 Baths3,450 SqFt1.51 Acres

        LISTING BY HOWARD HANNA CNY INC

      • 1336 Wemple Lane, Niskayuna, NY 12309ACTIVE$495,000

        1336 Wemple Lane, Niskayuna, NY 12309

        4 Beds3 Baths2,252 SqFt0.34 Acres

        LISTING BY BERKSHIRE HATHAWAY HOME SERVICES BLAKE

      • 4014 Belknap Hill Road, Jerusalem, NY 14418ACTIVE$495,000

        4014 Belknap Hill Road, Jerusalem, NY 14418

        5 Beds3.5 Baths4,377 SqFt5.63 Acres

        LISTING BY KEUKA LAKE & LAND REALTY

      • 382 Old Road, Grafton, NY 12052ACTIVE$495,000

        382 Old Road, Grafton, NY 12052

        2 Beds2 Baths2,064 SqFt3.59 Acres

        LISTING BY NEUDECKER REALTY