Coldwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker King George Realty

Property view
Listing view 2
Listing view 3

122 Bertrand Road, 
Mayfield, NY 12078

$975,000


3

Beds


3

Baths


2,404

Sq Ft


Single Family


Virtual Tour

Pending

Listed by

Katrina F Ruberti

Howard Hanna Capital Inc

1 518-883-8904

Last updated:

September 21, 2026, 07:58 AM

MLS#

202624751

Source:

Global MLS

About This Home

122 Bertrand Road

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.

Home Facts

Single Family

3 Baths

3 Bedrooms

Built in 2004

Price Summary

975,000

$405 per Sq. Ft.

MLS #:

202624751

Last Updated:

September 21, 2026, 07:58 AM

Added:

a month ago


Rooms & Interior

Bedrooms

Total Bedrooms:

3

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

2

Interior

Living Area:

2,404 Sq. Ft.


Structure

Structure

Architectural Style:

Contemporary

Building Area:

2,404 Sq. Ft.

Year Built:

2004


Lot

Lot Size (Sq. Ft):

12,196


Finances & Disclosures

Finances

Price:

$975,000

Price per Sq. Ft:

$405 per Sq. Ft.

Source:Global MLS
The information being provided by Global MLS is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified.  © 2026 Global MLS All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.