Sharon FronkRealtor® · Howard Hanna
LoadingActive
New Listing
$975,000
122 Bertrand Road
Mayfield, NY 12078 · Fulton County
3Beds
2.5Baths
2,404Sq Ft
0.28 acresLot Size
2004Year Built
$406Per Sq Ft
Est. P&I $4,930/moGet pre-qualified
Single Family 3 days on market
MLS# 202624751 Updated 2 days ago
Sharon’s Take
This lakefront property on Great Sacandaga Lake offers 80 feet of direct waterfront with a sandy beach and calm bay ideal for swimming and boating. The 2,404-square-foot home built in 2004 features three bedrooms, a flex space, vaulted ceilings, and expansive windows overlooking the water. A detached three-car garage with additional flex space, a lakeside deck, and level grounds on a private road complete the offering. Located in Mayfield, the home is in the Mayfield Central school district with no HOA fees.
Sharon Fronk · Howard Hanna Capital Region
About this property
Welcome to your lakefront escape! Set along 80 feet of direct, level lakefront on the Great Sacandaga Lake in Mayfield, this beautifully updated property offers the perfect blend of comfort, recreation, and relaxed waterfront living. The sprawling lawn provides plenty of room for games, or simply soaking up the sunshine, while the sandy beach and calm bay create an ideal setting for swimming, boating, and watersports. With just over 2,400 square feet of living space, the home has been thoughtfully updated with custom finishing touches throughout. The open floor plan features vaulted ceilings and a wall of windows that fills the space with natural light, creating a warm and inviting atmosphere with beautiful views of the water. Three bedrooms plus an office/flex space provide plenty of room for family and guests, with the flexibility to use the additional space as a fourth bedroom. Enjoy your morning coffee from the expansive lakeside deck as the sun rises over the horizon, or gather with friends and family for unforgettable summer evenings by the lake. Tucked away on a quiet, dead-end private road, this property offers the tranquility you've been looking for. The oversized detached garage adds incredible versatility with three bays, a large carport, and additional flex space above, perfect for a rec room, home gym, game room, or the ultimate lake-house hangout. With its level waterfront, sandy beach, spacious grounds, generous living space, and peaceful setting, this is the kind of lake property where memories are made and summers seem to last forever.
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
$406
Days on market
3
Fresh listing
Year built
2004
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 Built2004
Days on Market3
StatusActive
MLS Number202624751
ListedAugust 25, 2026
Interior
Bedrooms3
Bathrooms2 full, 1 half
Living Area2,404 sq ft
Interior Features
Finished BasementCathedral Ceiling(s)Central AirForced AirPropanePropane Tank OwnedRadiant FloorVinylHardwood
Exterior & Lot
Lot Size0.28 acres
Exterior Features
Drive-PavedDockWaterfrontLake FrontLakeGarage3 Car GarageDetachedDriveway
Building & Construction
Construction
Vinyl Siding
Financial
List Price$975,000
Price per Sq Ft$406
Est. Monthly P&I$4,930/mo
Location
CountyFulton
School DistrictMayfield
Listing Details
Listed ByKatrina F Ruberti of Howard Hanna Capital Inc
Data SourceSpark Platform / Global MLS
Last UpdatedAug 26, 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.
- Start122 Bertrand Road, 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 144% 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 Katrina F Ruberti (20720)
Contact: 518-423-2502
MLS #202624751 · 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.
