D Todd Ogden
Licensed Associate Real Estate Broker
REALTOR®
Walton, NY
Office: (607) 865-7000 (607) 353-3350

196 County Highway 123, Mayfield, NY 12117


Sold For: 560000

Sold on: Jun 5th, 2026
$ Per Square Foot: Not Available
Beds: 4
Baths: 2 full 1 partial
Days on Market: 85

Comments for 196 County Highway 123, Mayfield, NY 12117

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 enthusiasts 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 propertys 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!!

Appliances: Microwave, Oven, Range Parcel #: 173089 73.-1-40.1
Basement: Finished, Full, Walk-Out Access Parking: Driveway
Basement: Yes Parking Total: 10
Body of Water: Great Sacandaga Lake Parking Total: 10
Body of Water: Great Sacandaga Lake Patio/Porch: Rear Porch, Side Porch, Wrap Around, Deck, Front Porch
Cooling: Window Unit(s) Roof Type: Shingle
Days on Market: 85 Rooms Total: 11
Exterior: Garden, Outdoor Furnace Security: Smoke Detector(s), Carbon Monoxide Detector(s)
Exterior: Vinyl Siding Sewer: Septic Tank
Flooring: Vinyl Special View Info: Mountain(s), Orchard, Skyline
Heating: Propane, Radiant Floor, Wood SQFT Above Grade Finished: 3340
Interior: High Speed Internet, Paddle Fan, Walk-In Closet(s), Built-in Features Taxes: $5,951
Laundry: Main Level Waterfront: Permit Required
Lot Size: 59.00 Acres Year Built: 2004
School District: Mayfield

Listed By

Agency Name: Howard Hanna Capital Inc

Shown By

Agent Name: D Todd Ogden
Agent Phone: (607) 353-3350
Agency Title: Timberland Properties

All information is deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither broker(s), nor agent(s) shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless. Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 06/15/2026. The listing information on this page last changed on 06/15/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Mon 06/15/2026 5:00:14 AM EST) or Global MLS (last updated Mon 06/15/2026 1:22:14 AM EST) or New York State Alliance MLS (last updated Mon 06/15/2026 2:34:51 AM EST) or Hudson Valley Catskill Region MLS (last updated Mon 06/15/2026 12:11:12 AM EST) or OneKey MLS (last updated Mon 06/15/2026 1:45:25 AM EST). Real estate listings held by brokerage firms other than Timberland Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

All information is deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither broker(s), nor agent(s) shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless.

Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel