Mountain Homes Realty
Enter City, Zip or MLS

196 county highway 123

Mayfield, NY 12117

$625,000

4 BEDS 2.5 BATHS
3,340 SQFT59 AC LOT
Residential - Single Family
Waterfront
Image 1: 196 CR-123-51 c
Image 2: 6526776976670547699
Image 3: 1337242036854774148
Image 4: Lake Access (2)
Bedrooms 4
Total Baths 3
Full Baths 2
Square Feet 3340
Acreage 59
Status Active
MLS # 202613225
County Fulton
More Info
Category Residential - Single Family
Status Active
Square Feet 3340
Acreage 59
MLS # 202613225
County Fulton
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 10' 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 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!!
Location not available

Exterior Features

  • Style Colonial
  • Siding Shingle
  • Exterior Garden, Outdoor Furnace
  • Roof Shingle
  • Garage No
  • Garage Description
  • Sewer Septic Tank

Interior Features

  • Appliances Microwave, Oven, Range
  • Heating Propane, Radiant Floor, Wood
  • Cooling Window Unit(s)
  • Basement Finished, Full, Walk-Out Access
  • Living Area 3,340 SQFT
  • Year Built 2004

Financial Information

  • Parcel ID 173089 73.-1-40.1

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Howard Hanna Capital Inc
©2026 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. Data last updated 03/28/2026.
Listing data is current as of 03/28/2026.

Contact Our Agent

By clicking “Submit”, you agree that Mountain Homes Realty, its affiliates, and real estate professionals may contact you by phone, text, or email to any phone number and email address you provided, including by automated means, even if your number is on a federal, state, or our internal Do Not Call list. You also agree to our Terms of Use and Privacy Policy.