HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

Layout spacer

    Layout spacer

      About Us

      • Who We are
      • Meet the Team

      Resources

      • Latest Blogs
      • Free Vendor List
      • Need Funding?
      • Property Inspector
      • Down Payment Eligibility

      Communities

      • Otsego County
      • Schoharie County
      • Chenango County
      • Delaware County
      • Greene County
      • Broome County
      • Oneida County
      • Montgomery County
      • Ulster County

      Disclosures

      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution

      © 2026 Homes, Farms & Land. All rights reserved.

      Property at 196 County Highway 123, Mayfield, NY 12117
      IN ESCROW
      0
      $625,000

      196 County Highway 123Mayfield, NY, 12117

      4 Beds2.5 Baths3,340 SqFt59 Acres
      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!!
      1 / 62

      Est. Monthly

      $2,962/mo

      $625,000

      196 County Highway 123, Mayfield, NY

      4 Beds2.5 Baths3,340 SqFt59 Acres

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

      StatusIn Escrow
      Property TypeResidential
      Property SubtypeSingle Family Residence
      Year Built2004
      Total Rooms11 rooms
      Days on Market16 days

      Est. Monthly Payment

      $2,962.48

      %
      %
      yr

      Private Mortgage Insurance

      Not required

      Affordability Checkoptional
      $

      Enter your annual income to check affordability

      Property Details

      Property Information

      196 County Highway 123

      Mayfield, NY 12117 • Fulton
      4
      Beds
      2.5
      Baths
      3,340
      SqFt
      59
      Acres
      Status
      In Escrow
      Property Type
      Residential
      Property Subtype
      Single Family Residence
      Year Built
      200422 years ago
      Total Rooms
      11 rooms
      Days on Market
      16 days
      Tax History
      Estimated values, may not reflect current amounts.
      • Annual Tax Amount
        $5,951
      Property History
      • Listed for sale
        Mar 12, 2026 • GLOBAL MLS • 202613225
        $625,000
      Mortgage Calculator
      Estimated monthly payment for this property
      $2,962.48
      Down Payment
      Interest Rate
      Loan Term
      %
      %
      yearsyrs.
      Affordability Checkoptional
      $

      Enter your annual income to see if this home fits your budget

      Private Mortgage Insurance

      Not required — down payment above 20%
      MLS Information
      • Source
        Global MLS
      • MLS#
        202613225
      • Listing Office
        Howard Hanna Capital Inc
      • Last Updated
        40 days ago

      Kitchen & Laundry

      • Kitchen
        Built-in Features

      Appliances

      • Appliances
        • Range
        • Microwave
        • Oven

      Climate & Systems

      • Heating
        • Propane
        • Radiant Floor
        • Wood

      Interior Features

      • Flooring
        Vinyl
      • Basement
        • Walk-Out Access
        • Full
        • Finished
      • Interior Features
        • Walk-In Closet(s)
        • High Speed Internet
        • Paddle Fan
        • Built-in Features

      Parking

      • Parking Features
        Driveway
      • Parking Spaces
        10

      Lot & Grounds

      • Lot Size
        59 acres
      • View
        • Mountain(s)
        • Orchard
        • Skyline
      • Patio & Porch
        • Deck
        • Front Porch
        • Rear Porch
        • Side Porch
        • Wrap Around
      • Exterior Features
        • Outdoor Furnace
        • Garden

      Type

      • Property Type
        Residential
      • Property Subtype
        Single Family Residence
      • Architectural Style
        Colonial

      Structure

      • Construction
        Vinyl Siding
      • Roof
        Shingle

      Condition

      • Year Built
        2004
      • Days on Market
        16 days
      • Water
        Well
      • Sewer
        Septic Tank

      607-282-6242, (607) 282-6242, or +1 607 282 6242

      Kevin Lucero

      Kevin Lucero

      Lic. Real Estate Salesperson

      CallEmail
      Picked for you

      Similar Properties

      Handpicked listings that match what you're looking at

      View all →
      • 8835fr FRONT GASKIN RD, Clay, NY 13135ACTIVE$562,900

        8835fr FRONT GASKIN RD, Clay, NY 13135

        3 Beds2 Baths0.56 Acres

        LISTING BY COLDWELL BANKER PRIME PROP,INC

      • 31 Harbor Lane, Colonie, NY 12047ACTIVE$564,270

        31 Harbor Lane, Colonie, NY 12047

        3 Beds2 Baths1,500 SqFt0.15 Acres

        LISTING BY COLDWELL BANKER PRIME PROPERTIES

      • 219 Aviation Road, Queensbury, NY 12804ACTIVE$564,900OPEN 5/17

        219 Aviation Road, Queensbury, NY 12804

        3 Beds2.5 Baths1,596 SqFt0.4 Acres

        LISTING BY HOWARD HANNA CAPITAL INC

      • 7724 Newco Drive, Hamlin, NY 14464ACTIVE$564,900

        7724 Newco Drive, Hamlin, NY 14464

        3 Beds2.5 Baths1,782 SqFt1.2 Acres

        LISTING BY BERKSHIRE HATHAWAY HOME SERVICES DISCOVER REAL ESTATE

      • 2359 Sessions Hill Road, Homer, NY 13077ACTIVE$564,900

        2359 Sessions Hill Road, Homer, NY 13077

        4 Beds3 Baths3,808 SqFt26.63 Acres

        LISTING BY BERKSHIRE HATHAWAY HOME SERVICES HERITAGE REALTY

      • 475 Bugbee Drive, Watertown City, NY 13601ACTIVE$565,000

        475 Bugbee Drive, Watertown City, NY 13601

        4 Beds2 Baths2,500 SqFt0.4798 Acres

        LISTING BY BERKSHIRE HATHAWAY HOME SERVICES CNY REALTY WATN

      • 9549 Graphite Mountain Road, Hague, NY 12836ACTIVE$565,000

        9549 Graphite Mountain Road, Hague, NY 12836

        4 Beds3 Baths2,050 SqFt2.99 Acres

        LISTING BY SHERWOOD GROUP, LLC

      • 105 McNamee Road, Canaan, NY 12029ACTIVE$565,000

        105 McNamee Road, Canaan, NY 12029

        5 Beds2 Baths3,200 SqFt0.39 Acres

        LISTING BY HOWARD HANNA CAPITAL INC

      • 84 Oak Hill Road, Horseheads, NY 14845ACTIVE$565,000

        84 Oak Hill Road, Horseheads, NY 14845

        4 Beds2.5 Baths2,738 SqFt3.21 Acres

        LISTING BY SIGNATURE PROPERTIES

      • 1957 North Ridge Drive, Sullivan, NY 13037ACTIVE$565,900

        1957 North Ridge Drive, Sullivan, NY 13037

        4 Beds2.5 Baths2,268 SqFt0.23 Acres

        LISTING BY HUNT REAL ESTATE ERA