Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker King George Realty
Property view
Listing view 2
Listing view 3

196 County Highway 123, 
Mayfield, NY 12117

$649,000


4

Beds


3

Baths


3,340

Sq Ft


Single Family


Virtual Tour

Active

Listed by

Chad J Majewski

Chad Majewski Real Estate

518-774-0437

Last updated:

January 14, 2026, 03:58 PM

MLS#

202525165

Source:

Global MLS

About This Home

196 County Highway 123

Nestled on 59 acres of pristine Adirondack countryside, this extraordinary estate is a rare blend of natural beauty, agricultural charm, and timeless living. A mature 60-tree apple orchard and 250 flourishing blueberry bushes set the stage for a property that feels like your own private retreat. The stately home welcomes you with a sweeping wraparound porch, offering front-row views of rolling fields and endless skies. Step inside to a gracious foyer that opens into a spacious living room, elegant dining room, well-equipped kitchen, and a sun-soaked four-season room. The main floor also features a half bath, laundry, and abundant storage, thoughtfully designed for everyday convenience. Upstairs, a light-filled landing leads to three generous bedrooms and a full bath, while the finished lower level provides even more living space, including a family room, bedroom, utility room, and an additional full bath—perfect for guests or multigenerational living. Outdoor living is equally inviting with a back patio and main-floor deck, both overlooking the expansive property. Whether you're enjoying summer sunsets, crisp autumn mornings, or snowy winter scenes, the views never disappoint. This property also offers incredible potential with an already-approved 10-acre subdivision (10 lots pending ADK Park approval), making it as much an investment opportunity as it is a dream home. A 10-foot beach permit nearby adds even more recreational appeal. Beautifully maintained and ready for its next chapter, this one-of-a-kind estate is waiting to welcome you home.

Home Facts

Single Family

3 Baths

4 Bedrooms

Built in 2004

Price Summary

649,000

$194 per Sq. Ft.

MLS #:

202525165

Last Updated:

January 14, 2026, 03:58 PM

Added:

4 month(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:

$649,000

Price per Sq. Ft:

$194 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.
See this home in person
196 County Highway 123
Attend an upcoming open house
Sun, Jan 18
11:00 AM01:00 PM

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.