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

$675,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:

September 11, 2025, 02:24 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

675,000

$202 per Sq. Ft.

MLS #:

202525165

Last Updated:

September 11, 2025, 02:24 PM

Added:

16 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:

$675,000

Price per Sq. Ft:

$202 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.  © 2025 Global MLS All rights reserved.

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. 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 from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.