Skip main navigation
Closed
  • $640,000

    154 Lakeside Drive, Mayfield, NY 12117

    2beds
    728sqft
    Single Family Residence, Residential
    Built in 1951
    7,840 Square Feet Lot
    $648,700 Zestimate®
    $879/sqft
    $2,293 Estimated rent

    Home value

    $648,700

    $441,000 - $947,000

    $2,293/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $2,293/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

    $2,293/mo

    Rent Zestimate®

    Refinance and save

    $4,684/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

    $4,684/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    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.

    Zillow last checked:

    Listing updated:

    Listed by:

    Robert Gordon 518-852-4408,

    Inglenook Realty Inc

    Bought with:

    Sheila Sperling, 10401315668

    Julie & Co Realty LLC

    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

    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: $879/sqft
    • Tax assessed value: $170,000
    • Annual tax amount: $8,729
    • Date on market: 6/18/2026

    Price history

    DateEventPrice
    8/7/2026Sold$640,000-1.5%$879/sqft
    Source: Global MLS #202619975 Report a problem
    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: Public Record 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

    Neighborhood: 12117

    Nearby schools

    GreatSchools rating