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 191 County Highway 123, Mayfield, NY 12117
      IN ESCROW
      0
      $374,500

      191 County Highway 123Mayfield, NY, 12117

      4 Beds1.5 Baths2,292 SqFt1 Acres
      Set in a picturesque country setting, this stunning circa-1883 farmhouse has been completely reimagined from top to bottom, offering the perfect blend of timeless charm and modern comfort. This home has been thoughtfully remodeled inside and out, allowing you to enjoy the character of a classic farmhouse without sacrificing today's conveniences. Relax and unwind on the fully screened front porch, where sweeping views of open fields and distant mountains create a peaceful, ever-changing backdrop. Inside, the gourmet kitchen is a true centerpiece, featuring high-end Wellborn cabinetry, elegant quartz countertops, a farmhouse sink, and quality finishes throughout, ideal for both everyday living and entertaining. Extensive updates provide peace of mind, including all new Andersen windows, a new roof, chimneys, oil tank, furnace, and energy-efficient mini-split system. The property is further enhanced by a charming stone wall along the rear, adding to the home's classic country appeal. Located just half a mile from Great Sacandaga Lake, this property offers easy access to multiple marinas and is only 2 minutes to the town beach, making it a perfect year-round residence or weekend retreat. Enjoy the best of country living with modern upgrades in a truly beautiful setting. 40 minutes to Saratoga Springs and an hour to Albany.
      1 / 58

      Est. Monthly

      $1,775/mo

      $374,500

      191 County Highway 123, Mayfield, NY

      4 Beds1.5 Baths2,292 SqFt1 Acre

      Set in a picturesque country setting, this stunning circa-1883 farmhouse has been completely reimagined from top to bottom, offering the perfect blend of timeless charm and modern comfort. This home has been thoughtfully remodeled inside and out, allowing you to enjoy the character of a classic farmhouse without sacrificing today's conveniences. Relax and unwind on the fully screened front porch, where sweeping views of open fields and distant mountains create a peaceful, ever-changing backdrop. Inside, the gourmet kitchen is a true centerpiece, featuring high-end Wellborn cabinetry, elegant quartz countertops, a farmhouse sink, and quality finishes throughout, ideal for both everyday living and entertaining. Extensive updates provide peace of mind, including all new Andersen windows, a new roof, chimneys, oil tank, furnace, and energy-efficient mini-split system. The property is further enhanced by a charming stone wall along the rear, adding to the home's classic country appeal. Located just half a mile from Great Sacandaga Lake, this property offers easy access to multiple marinas and is only 2 minutes to the town beach, making it a perfect year-round residence or weekend retreat. Enjoy the best of country living with modern upgrades in a truly beautiful setting. 40 minutes to Saratoga Springs and an hour to Albany.

      StatusIn Escrow
      Property TypeResidential
      Property SubtypeSingle Family Residence
      Year Built1883
      Total Rooms7 rooms
      Days on Market2 days

      Est. Monthly Payment

      $1,775.12

      %
      %
      yr

      Private Mortgage Insurance

      Not required

      Affordability Checkoptional
      $

      Enter your annual income to check affordability

      Property Details

      Property Information

      191 County Highway 123

      Mayfield, NY 12117 • Fulton
      4
      Beds
      1.5
      Baths
      2,292
      SqFt
      1
      Acre
      Status
      In Escrow
      Property Type
      Residential
      Property Subtype
      Single Family Residence
      Year Built
      1883143 years ago
      Total Rooms
      7 rooms
      Days on Market
      2 days
      Tax History
      Estimated values, may not reflect current amounts.
      • Annual Tax Amount
        $4,718
      Property History
      • Listed for sale
        Apr 18, 2026 • GLOBAL MLS • 202615357
        $374,500
      Mortgage Calculator
      Estimated monthly payment for this property
      $1,775.12
      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#
        202615357
      • Listing Office
        Howard Hanna Capital Inc
      • Last Updated
        9 days ago

      Kitchen & Laundry

      • Kitchen
        Gourmet Kitchen

      Appliances

      • Appliances
        • Range
        • Refrigerator
        • Dishwasher
        • Washer or Dryer
        • Oven

      Climate & Systems

      • Heating
        • Oil
        • Forced Air

      Interior Features

      • Flooring
        Wood
      • Basement
        Full
      • Interior Features
        Ceramic Tile Bath

      Parking

      • Parking Features
        • Attached
        • Garage Door Opener
        • Driveway
        • Garage
      • Parking Spaces
        8
      • Garage Spaces
        2

      Lot & Grounds

      • Lot Size
        1 acres
      • Lot Features
        • Cleared
        • Landscaped
        • Level
        • Private
        • Wooded
      • View
        • Forest
        • Meadow
        • Orchard
      • Patio & Porch
        • Screened
        • Front Porch
      • Exterior Features
        Garden

      Type

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

      Structure

      • Construction
        • Wood Siding
        • Stone
      • Roof
        Asphalt

      Condition

      • Year Built
        1883
      • Days on Market
        2 days
      • Water
        Well
      • Sewer
        Septic Tank
      • Electric
        200+ Amp Service

      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 →
      • 8883 US Route 11, Ellisburg, NY 13605ACTIVE$338,000

        8883 US Route 11, Ellisburg, NY 13605

        3 Beds2.5 Baths5,400 SqFt14.4 Acres

        LISTING BY BERKSHIRE HATHAWAY HOME SERVICES CNY REALTY WATN

      • 1335 Park Road, Grand Island, NY 14072ACTIVE$339,000OPEN 5/16

        1335 Park Road, Grand Island, NY 14072

        3 Beds2 Baths1,200 SqFt0.1978 Acres

        LISTING BY HOWARD HANNA WNY INC.

      • 133 Hilgert Parkway, Schoharie, NY 12157ACTIVE$339,000

        133 Hilgert Parkway, Schoharie, NY 12157

        3 Beds1.5 Baths1,992 SqFt0.8 Acres

        LISTING BY CENTURY 21 NORTH EAST

      • 15 HOCKEBORNE, Auburn, NY 13021ACTIVE$339,000OPEN 5/10

        15 HOCKEBORNE, Auburn, NY 13021

        4 Beds2 Baths1,947 SqFt0.49 Acres

        LISTING BY POST REALTY

      • 4 Linden Drive, Hudson Falls, NY 12839ACTIVE$339,000

        4 Linden Drive, Hudson Falls, NY 12839

        4 Beds2 Baths2,400 SqFt0.53 Acres

        LISTING BY HOWARD HANNA

      • 1196 State Route 143, Coeymans, NY 12046ACTIVE$339,000

        1196 State Route 143, Coeymans, NY 12046

        3 Beds1 Bath1,100 SqFt0.87 Acres

        LISTING BY KELLER WILLIAMS REALTY HUDSON VALLEY UNITED

      • 14 Crescent Avenue, Amsterdam, NY 12010ACTIVE$339,000

        14 Crescent Avenue, Amsterdam, NY 12010

        4 Beds2 Baths1,368 SqFt0.07 Acres

        LISTING BY SANICHAR & ASSOCIATES REALTY

      • 143 Burdick Medbury Road, Norwich, NY 13815ACTIVE$339,000

        143 Burdick Medbury Road, Norwich, NY 13815

        4 Beds2 Baths2,761 SqFt1.6 Acres

        LISTING BY HOWARD HANNA

      • 464 Curtis Lane, Hamden, NY 13782ACTIVE$339,000

        464 Curtis Lane, Hamden, NY 13782

        3 Beds2 Baths1,352 SqFt6.11 Acres

        LISTING BY KELLER WILLIAMS UPSTATE NY PROPERTIES

      • 4059 Brick Schoolhouse Road, Hamlin, NY 14464ACTIVE$339,000

        4059 Brick Schoolhouse Road, Hamlin, NY 14464

        4 Beds3.5 Baths1,800 SqFt0.75 Acres

        LISTING BY RE/MAX PLUS