Skip main navigation
Pending
  • $649,900

    154 Lakeside Drive, Mayfield, NY 12117

    2beds
    728sqft
    Loading
    Single Family Residence, Residential
    Built in 1951
    7,840 Square Feet Lot
    $653,100 Zestimate®
    $893/sqft
    $-- HOA

    What's special

    Finished walkout basementGreen lawnLarge covered deckShaded lower patioPrivate long dockKitchen island
    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.
    33 days
    |
    1,138
    |
    60
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Inglenook Realty Inc 518-843-4663,

    Robert Gordon 518-852-4408

    Source: Global MLS,MLS#: 202619975MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 2
      • Bathrooms: 2
      • Full bathrooms: 1
      • 1/2 bathrooms: 1
      Bedroom
      • Level: First
      Bedroom
      • Level: First
      Full bathroom
      • Level: First
      Half bathroom
      • Level: Basement
      Den
      • Level: Basement
      Kitchen
      • Level: First
      Living room
      • Level: First
      Other
      • Description: Currently Used as Bunk Room
      • Level: Basement
      Other
      • Description: Currently Used as Bedroom
      • Level: Basement
      Heating
      • Forced Air, Propane
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Microwave, Range, Refrigerator
      • Laundry: In Basement, In Bathroom, Washer Hookup
      Features
      • Ceiling Fan(s)
      • Flooring: Tile, Vinyl, Laminate
      • Doors: Sliding Doors
      • Basement: Bath/Stubbed,Exterior Entry,Finished,Full,Heated,Interior Entry,Walk-Out Access
      Interior area
      • Total structure area: 728
      • Total interior livable area: 728 sqft
      • Finished area above ground: 728
      • Finished area below ground: 728
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: Paved, Driveway
      • Has uncovered spaces: Yes
      Features
      • Patio & porch: Composite Deck, Covered, Deck, Patio
      • Exterior features: Outdoor Shower, Dock
      • Has view: Yes
      • On waterfront: Yes
      • Waterfront features: Beach Front, Lake Front, Permit Required
      • Body of water: Great Sacandaga Lake
      Lot
      • Size: 7,840 Square Feet
      • Features: Road Frontage, Sloped, Views, Irregular Lot, Landscaped, Waterfront
      Details
      • Additional structures: Shed(s)
      • Parcel number: 173001 104.1429
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Cottage
      • Property subtype: Single Family Residence, Residential
      Materials
      • Clapboard, Drywall
      • Foundation: Block
      • Roof: Asphalt
      Condition
      • Updated/Remodeled
      • New construction: No
      • Year built: 1951

      Utilities & green energy

      • Electric: 100 Amp Service, Circuit Breakers
      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      HOA
      • Has HOA: No
      Location
      • Region: Mayfield

      Financial & listing details

      • Price per square foot: $893/sqft
      • Tax assessed value: $170,000
      • Annual tax amount: $8,729
      • Date on market: 6/18/2026

        Estimated market value

        $653,100

        $620,000 - $686,000

        $1,524/mo

        Price history

        DateEventPrice
        6/27/2026Pending sale$649,900$893/sqft
        Source: Global MLS #202619975 Report a problem
        6/26/2026Contingent$649,900$893/sqft
        Source: NY State MLS #11847048 Report a problem
        6/18/2026Listed for sale$649,900+76.1%$893/sqft
        Source: Global MLS #202619975 Report a problem
        2/26/2018Listing removed$369,000$507/sqft
        Source: Keller Williams Capital Dist #201720722 Report a problem
        2/26/2018Listed for sale$369,000$507/sqft
        Source: Keller Williams Capital Dist #201720722 Report a problem
        2/22/2018Sold$369,000$507/sqft
        Source: Global MLS #201720722 Report a problem
        11/6/2017Pending sale$369,000$507/sqft
        Source: Keller Williams Capital Dist #201720722 Report a problem
        10/19/2017Listed for sale$369,000+106.1%$507/sqft
        Source: Keller Williams Capital Dist #201720722 Report a problem
        8/26/2011Sold$179,000-5.3%$246/sqft
        Source: Global MLS #201122533 Report a problem
        7/2/2011Listed for sale$189,000+1008.8%$260/sqft
        Source: Thomas J. Real Estate, Inc. #201122533 Report a problem
        6/13/2011Sold$17,046-69%$23/sqft
        Source: Public Record Report a problem
        11/19/1997Sold$55,000$76/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $170,000
        2024-- $170,000
        2023-- $170,000
        2022-- $170,000
        2021-- $170,000
        2020-- $170,000
        2019-- $170,000
        2018-- $170,000 +36%
        2017$4,522 $125,000
        2016-- $125,000
        2015-- $125,000
        2014-- $125,000 +3.5%
        2013-- $120,800
        2012-- $120,800 +4.2%
        2011-- $115,900
        2010-- $115,900
        2009-- $115,900
        2008-- $115,900
        2007-- $115,900
        2006-- $115,900
        2005-- $115,900
        2004-- $115,900 +76.9%
        2003-- $65,500
        2002-- $65,500
        2001-- $65,500
        2000-- $65,500
        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 12117

        Getting around

        7 / 100
        Car-Dependent
        11 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes