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

Let's Find Your Next Property.

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

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
    74 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 →
  • 10149 Bailey Lake Road, Brookfield, NY 13480ACTIVE$494,900

    10149 Bailey Lake Road, Brookfield, NY 13480

    4 Beds3 Baths1,716 SqFt96.5 Acres

    LISTING BY MOHAWK VALLEY 1ST CHOICE REALTY LLC

  • 1835 Call Street, Lake Luzerne, NY 12846ACTIVE$494,900

    1835 Call Street, Lake Luzerne, NY 12846

    4 Beds4 Baths2,240 SqFt2.33 Acres

    LISTING BY VENTURE FOX REALTY GROUP LLC

  • 287 Thais Road, Sand Lake, NY 12018ACTIVE$495,000

    287 Thais Road, Sand Lake, NY 12018

    4 Beds2 Baths2,729 SqFt3.57 Acres

    LISTING BY HOWARD HANNA CAPITAL INC

  • 4 Woodlake Drive, Wilton, NY 12831ACTIVE$495,000OPEN 7/5

    4 Woodlake Drive, Wilton, NY 12831

    4 Beds2.5 Baths2,256 SqFt0.64 Acres

    LISTING BY OWNER ENTRY.COM

  • 14 Thoroughbred Way, Clifton Park, NY 12065ACTIVE$495,000

    14 Thoroughbred Way, Clifton Park, NY 12065

    4 Beds2.5 Baths2,137 SqFt0.47 Acres

    LISTING BY KW PLATFORM

  • 99 Gunderman Road, Danby, NY 14850ACTIVE$495,000

    99 Gunderman Road, Danby, NY 14850

    4 Beds2 Baths2,484 SqFt1.65 Acres

    LISTING BY THE GREENE REALTY GROUP

  • 1298 Como Park Boulevard, Cheektowaga, NY 14043ACTIVE$495,000

    1298 Como Park Boulevard, Cheektowaga, NY 14043

    3 Beds2 Baths2,200 SqFt1.75 Acres

    LISTING BY HOWARD HANNA WNY INC.

  • 9001 Fairways Circle, Clarence, NY 14031ACTIVE$495,000

    9001 Fairways Circle, Clarence, NY 14031

    4 Beds3 Baths2,201 SqFt0.64 Acres

    LISTING BY HUNT REAL ESTATE CORPORATION

  • 28 Covenant Circle, New Lebanon, NY 12062ACTIVE$495,000

    28 Covenant Circle, New Lebanon, NY 12062

    4 Beds2.5 Baths2,240 SqFt5 Acres

    LISTING BY VERA COHEN REALTY, LLC

  • 364 Smith Road, Worcester, NY 12197ACTIVE$495,000

    364 Smith Road, Worcester, NY 12197

    4 Beds1.5 Baths1,770 SqFt47.74 Acres

    LISTING BY COUNTRY BOY REALTY