Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Village Green Realty
Property view
Listing view 2
Listing view 3

196 County Highway 123, 
Mayfield, NY 12117

$625,000


4

Beds


3

Baths


3,340

Sq Ft


Single Family


Virtual Tour

Active

Listed by

Katrina F Ruberti

Howard Hanna Capital Inc

1 518-883-8904

Last updated:

March 12, 2026, 10:02 PM

MLS#

202613225

Source:

Global MLS

About This Home

196 County Highway 123

This exceptional property truly has it all; offering the perfect blend of LAKE LIFE, country living and investment potential!! Situated on 59 acres of scenic countryside, this spacious 4 bed, 2.5 bath home is an outdoor enthusiast's dream!! There is a beautiful SANDY beach providing access to endless lake activities including kayaking, boating, swimming, and relaxing by the water. The acreage allows for hiking, snowmobiling, cross country skiing and endless trails for ATVs! The home welcomes you with a beautiful wraparound covered porch, the perfect place to enjoy morning coffee while watching the sunrise over the peaceful landscape. Inside, an inviting entry foyer opens to a spacious, open floor plan designed for comfortable living and entertaining. The large living and dining rooms capture sweeping views of the surrounding fields and countryside, while the well appointed kitchen offers ample workspace and a convenient breakfast bar. A bright sunroom surrounded by windows fills the space with natural light and provides serene views of the property. Upstairs you will find three generously sized bedrooms and full bath. The finished walk-out lower level offers excellent flexibility with a family room featuring French doors leading to a stone patio, a large fourth bedroom and full bath, making it ideal as an in-law suite or private guest quarters. Designed with entertaining in mind, the home features seamless indoor-outdoor living with French doors from the kitchen and dining area leading to a deck, a spacious patio overlooking the grounds, and additional shaded outdoor seating areas. Adding to the property's charm and agricultural appeal is a mature 60-tree apple orchard and approximately 250 blueberry bushes. Investment potential with approved 10-acre subdivision (pending APA). A rare opportunity to own a private countryside retreat with lake access, abundant acreage, and future development potential....all in one remarkable property!!

Home Facts

Single Family

3 Baths

4 Bedrooms

Built in 2004

Price Summary

625,000

$187 per Sq. Ft.

MLS #:

202613225

Last Updated:

March 12, 2026, 10:02 PM

Added:

2 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

4

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

2

Interior

Living Area:

3,340 Sq. Ft.


Structure

Structure

Architectural Style:

Colonial

Building Area:

3,340 Sq. Ft.

Year Built:

2004


Lot

Lot Size (Sq. Ft):

2,570,040


Finances & Disclosures

Finances

Price:

$625,000

Price per Sq. Ft:

$187 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.