Lake Homes Realty
Enter City, Zip or MLS
WaterfrontNew Listing

154 lakeside drive

Mayfield, NY 12117

$649,900

2 BEDS 1.5 BATHS
728 SQFT0.18 AC LOT
Residential - Single Family
WaterfrontNew Listing
Image 1: 154-Lakeside-Dr-Mayfield-2
Image 2: 154-Lakeside-Dr-Mayfield-NY-12
Image 3: 154-Lakeside-Dr-Mayfield-NY-64
Image 4: 154-Lakeside-Dr-Mayfield-NY-62
Bedrooms 2
Total Baths 2
Full Baths 1
Square Feet 728
Acreage 0.18
Status Pending
MLS # 202619975
County Fulton
More Info
Category Residential - Single Family
Status Pending
Square Feet 728
Acreage 0.18
MLS # 202619975
County Fulton
OPEN HOUSE FOR 6-28-26 IS CANCELLED...PROPERTY IS UNDER CONTRACT. Imagine pulling into your own quiet retreat where stressful days melt away the moment you arrive. This isn't just a house beside the water; it is a front-row seat to lake life on Great Sacandaga Lake. Step inside to this fully furnished home, and your eyes are instantly drawn through the open living room toward a wall of glass framing wide, beautiful water views. Because there is no road separating the home from the shoreline, the lake is truly your backyard. Picture your mornings starting with a warm cup of coffee on the large, covered deck. You can feel the cool breeze on your face and listen to loons calling across the water. The bright kitchen and living spaces flow together as one, making it easy to chat with family and friends while preparing meals. The lake serves as a constant backdrop to your daily life--whether you are sitting at the kitchen island or relaxing on the couch, the view follows you everywhere. Downstairs, the finished walkout basement feels like a private Adirondack camp. It features a cozy custom bar wrapped in warm knotty pine, perfect for sharing stories after a fun day on the water. Walk straight through the sliding glass doors onto the shaded lower patio, where you can watch loved ones run across the green lawn down to your private, long dock. With 68 feet of direct waterfront lake permit, your summers will be filled with swimming, fishing, and sunset boat rides. After a day in the sun, rinse off the sand in the private, open-air outdoor shower under the sky. This immaculate home was completely remodeled down to the studs, so you can move right in and start relaxing. This is the kind of property where weekends turn into traditions and ordinary days turn into lifelong memories. It is a home you will feel long before you see it. Step inside, stand on the deck, and see why people dream of owning a piece of paradise like this. Sold as-is.
Location not available
Listing
Street
Satellite

Exterior Features

  • Style Cottage
  • Siding Asphalt
  • Exterior Outdoor Shower, Dock
  • Roof Asphalt
  • Garage No
  • Garage Description
  • Water Public
  • Sewer Public Sewer
  • Lot Dimensions 60x96x69.1x112
  • Lot Description Road Frontage, Sloped, Views, Irregular Lot, Landscaped, Waterfront

Interior Features

  • Appliances Dishwasher, Microwave, Range, Refrigerator
  • Heating Forced Air, Propane
  • Cooling Central Air
  • Basement Bath/Stubbed, Exterior Entry, Finished, Full, Heated, Interior Entry, Walk-Out Access
  • Living Area 728 SQFT
  • Year Built 1951

Financial Information

  • Parcel ID 173001 104.14-2-9

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Inglenook Realty Inc
©2026 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. Data last updated 06/29/2026.Source MLS Verified
Listing data is current as of 06/29/2026.

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.