Sharon FronkRealtor® · Howard Hanna
LoadingActive
$80,000 price cut · was $1,175,000
$1,095,000
120 Longview Drive
Mayfield, NY 12078 · Fulton County
3Beds
3Baths
2,629Sq Ft
0.47 acresLot Size
1987Year Built
$417Per Sq Ft
Est. P&I $5,537/moGet pre-qualified
Single Family 100 days on market
MLS# 202617719 Updated 2 weeks ago
Sharon’s Take
This lakefront home on Great Sacandaga Lake features three bedrooms and three full bathrooms across 2,629 square feet, built in 1987 on 0.47 acres. The property includes 100 feet of sandy shoreline and sits on a quiet road in Mayfield, with an attached two-car garage, storage shed, and full basement. The interior showcases vaulted ceilings, hardwood floors, a wood-burning fireplace, and a bright sunroom with flexible space options. Large windows and multiple decks frame lake views and overlook the lawn, with direct lake access just steps away.
Sharon Fronk · Howard Hanna Capital Region
About this property
This spacious 3 bedroom 3 full bath lakefront home offers comfort, privacy, and timeless style, with 100' of sandy shoreline and no road to cross to reach the waters of the Great Sacandaga. Architect designed to blend into the existing neighborhood when viewed from the road, the home reveals its full impact when seen from the lake side.Tucked away on a quiet, low-traffic road, the setting provides a peaceful lakeside experience that's increasingly hard to find. Inside, the home features an expansive open-concept layout, filled with natural light from abundant windows and showcases vaulted ceilings, hardwood floors, and a beautiful wood-burning fireplace as the centerpiece of an inviting gathering space. The living space opens to a large deck overlooking an expansive green lawn and views of the lake. A very short walk brings you to 100' of shoreline with your own sandy beach! The classic style gives the home an elegantce that sets it apart from the common rustic lodge aesthetic. A bright sunroom with it's own deck offers flexible space for year-round enjoyment and could easily serve as a future hot tub room, fitness space, or office. The first floor bedroom is located directly adjacent to a full bath for easy access. The upstairs offers two ensuites, one with a private porch with a lake view! Additional highlights include a second story loft, a full basement, a separate 12 x 16 foot storage shed and an attached two car garage
Is it priced right?
The price signals we can read on this listing today. For a true sense of value against recent Mayfield sales, Sharon will pull the comparable closings and walk you through them.
Price per sq ft
$417
Days on market
100
Price reduced
$80,000
from $1,175,000
Curious whether this home is priced right for the neighborhood?
Ask Sharon for the compsProperty details
22 facts pulled straight from the MLS listing.
Overview
Property TypeSingle Family
Sub-TypeSingle Family Residence
Year Built1987
Days on Market100
StatusActive
MLS Number202617719
ListedMay 21, 2026
Interior
Bedrooms3
Bathrooms3 full
Living Area2,629 sq ft
Interior Features
Finished Unfinished BasementHigh Speed InternetCathedral Ceiling(s)DuctlessBaseboardElectricTileWoodFireplaceWood Burning
Exterior & Lot
Lot Size0.47 acres
Exterior Features
OtherWaterfrontBeach FrontLake FrontTrees/WoodsLakeGarage2 Car GarageAttachedDriveway
Building & Construction
Construction
Vinyl Siding
Financial
List Price$1,095,000
Price per Sq Ft$417
Est. Monthly P&I$5,537/mo
Location
CountyFulton
School DistrictMayfield
Listing Details
Listed ByChristian Klueg of Howard Hanna Capital Inc
Data SourceSpark Platform / Global MLS
Last UpdatedAug 10, 2026
What's nearby
Google Maps view. Pan, zoom, click a pin to read about a business or place.
Commute Planner
Plan a multi-stop route from this address: drop-off the kid, hit the office, head home. Live traffic from Google.
- Start120 Longview Drive, Mayfield, NY 12078
Try a preset
Schools
The district this address is assigned to. Ratings and reviews are hosted on GreatSchools.
Mayfield
Assigned school district
Assigned districts can change and are not guaranteed. Confirm enrollment boundaries with the district directly before relying on them.
About Mayfield, NY
Mayfield is in Fulton County, NY. There are currently 17 active listings here, ranging from $39,900 to $1,345,000. Listings in this address fall under the Mayfield school district. Priced 174% above the Mayfield median of $399,000.
See Sharon's Mayfield community guideYou might also like
Sharon represents buyers for this property. Your tour, offer, and inquiries go through her, not the listing brokerage.
Howard Hanna Capital Inc · Listed by Christian Klueg (21409)
Contact: 518-332-0218
MLS #202617719 · Source: Global MLS, Inc.
IDX information is provided exclusively for consumers' personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Sharon Fronk Real Estate is committed to compliance with the Fair Housing Act and provides equal opportunity in housing.
