Jodie M. DeCosty
Licensed Associate Real Estate Broker
Realtor, Coldwell Banker Chairman's Circle, Coldwell Banker Diamond Society, Coldwell Banker Sterling Society, Equal Housing Opportunity, Coldwell Banker Premier Office
New Hartford, NY
Cell: (315) 723-8554 Office: (315) 768-1680 Fax: (315) 768-1685

154 Lakeside Drive, Mayfield, NY 12117

New - 18 Hours Ago
V-Tour
Virtual Tour View Full Photo Gallery

Property Description

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.

154 Lakeside Drive | MLS# 202619975

This single family home located at 154 Lakeside Drive, Mayfield, NY 12117 is currently listed for sale with an asking price of $649,900. This property was built in 1951 and has 2 bedrooms and 1 full and 1 partial baths with 728 sq. ft. Lakeside Drive is located within the Mayfield school district. Search Mayfield real estate on jodie-decosty.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Residential - Single Family
Basement: Yes
Basement: Bath/Stubbed, Exterior Entry, Finished, Full, Heated, Interior Entry, Walk-Out Access
Cooling: Central Air
Heating: Forced Air, Propane
Home Style: Cottage
Lot Size: 0.18 Acres
Roof Type: Asphalt
Taxes: $8,729
Year Built: 1951

Feature Descriptions

Appliances: Dishwasher, Microwave, Range, Refrigerator
Body of Water: Great Sacandaga Lake
Body of Water: Great Sacandaga Lake
Doors: Sliding Doors
Exterior: Outdoor Shower, Dock
Exterior: Clapboard, Drywall
Flooring: Tile, Vinyl, Laminate
Foundation: Block
Interior: Paddle Fan
Laundry: In Basement, In Bathroom, Washer Hookup
Lot: Road Frontage, Sloped, Views, Irregular Lot, Landscaped, Waterfront
Lot Dimensions: 60x96x69.1x112
Parcel #: 173001 104.14-2-9
Parking: Paved, Driveway
Parking Total: 2
Parking Total: 2
Patio/Porch: Composite Deck, Covered, Deck, Patio
Rooms Total: 9
Sewer: Public Sewer
SQFT Above Grade Finished: 728
SQFT Below Grade Finished: 728
Structures: Shed(s)
Water: Public
Waterfront: Beach Front, Lake Front, Permit Required

Room Sizes

Kitchen: Level - First
Living Room: Level - First
Bedroom: Level - First
Full Bathroom: Level - First
Half Bathroom: Level - Basement
Den: Level - Basement
Other: Level - Basement

Local Schools

School District: Mayfield

Estimate Your Payment

Estimated Payment

$ 2,363.37 per month $1,446.40 Principal & Interest $727.42 Property Tax $189.55 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: Inglenook Realty Inc
Agency Phone: 1 518-843-4663

Shown By

Agent Name: Jodie M. DeCosty
Agent Phone: (315) 723-8554 Primary
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 06/19/2026. The listing information on this page last changed on 06/19/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Fri 06/19/2026 3:52:26 AM EST) or Global MLS (last updated Fri 06/19/2026 1:22:31 AM EST) or New York State Alliance MLS (last updated Fri 06/19/2026 2:34:51 AM EST) or Hudson Valley Catskill Region MLS (last updated Fri 06/19/2026 12:11:26 AM EST) or OneKey MLS (last updated Fri 06/19/2026 1:45:34 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel