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
    • Practical Guides
    • 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
Practical Guides
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

Let's Find Your Next Property.

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

About Us

  • Who We are
  • Meet the Team

Resources

  • Latest Blogs
  • Free Vendor List
  • PracticalGuides
  • 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
CLOSED
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.

StatusClosed
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built1883
Total Rooms7 rooms
Days on Market41 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
Closed
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
1883143 years ago
Total Rooms
7 rooms
Days on Market
41 days
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $4,718
Property History
  • Closed
    May 29, 2026 • GLOBAL MLS • 202615357
    $374,500
  • 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
    2 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
    41 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 →
  • 40 Ballston Avenue, Ballston Spa, NY 12020ACTIVE$337,131

    40 Ballston Avenue, Ballston Spa, NY 12020

    4 Beds1.5 Baths1,496 SqFt0.47 Acres

    LISTING BY KW PLATFORM

  • 22 Newgate Road, Amherst, NY 14226ACTIVE$337,500

    22 Newgate Road, Amherst, NY 14226

    3 Beds1.5 Baths1,642 SqFt0.17 Acres

    LISTING BY HOWARD HANNA WNY INC.

  • 519 Nelson Road, Danby, NY 14850ACTIVE$337,500

    519 Nelson Road, Danby, NY 14850

    3 Beds2 Baths1,503 SqFt1.6 Acres

    LISTING BY HOWARD HANNA S TIER INC

  • 41 Gage Hill Drive, Lake Luzerne, NY 12846ACTIVE$337,900

    41 Gage Hill Drive, Lake Luzerne, NY 12846

    2 Beds1 Bath1,212 SqFt0.55 Acres

    LISTING BY REALITY REALTY

  • 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

  • 2650 Patel Drive, Wheatfield, NY 14304ACTIVE$339,000

    2650 Patel Drive, Wheatfield, NY 14304

    3 Beds2 Baths1,404 SqFt0.2755 Acres

    LISTING BY J LAWRENCE REALTY

  • 212 Chemung Street, Corning City, NY 14830ACTIVE$339,000

    212 Chemung Street, Corning City, NY 14830

    4 Beds2.5 Baths2,650 SqFt0.1173 Acres

    LISTING BY KELLER WILLIAMS REALTY SOUTHERN TIER & FINGER LAKES

  • 145 Grant Boulevard, West Seneca, NY 14218ACTIVE$339,000

    145 Grant Boulevard, West Seneca, NY 14218

    3 Beds2 Baths1,308 SqFt0.18 Acres

    LISTING BY HUNT REAL ESTATE CORPORATION

  • 49 Marilyn Drive, West Seneca, NY 14224ACTIVE$339,000

    49 Marilyn Drive, West Seneca, NY 14224

    4 Beds2 Baths1,490 SqFt0.1812 Acres

    LISTING BY WNY METRO ROBERTS REALTY

  • 11806 Wyandale Road, Concord, NY 14141ACTIVE$339,000

    11806 Wyandale Road, Concord, NY 14141

    4 Beds2 Baths1,590 SqFt1 Acres

    LISTING BY WNY METRO ROBERTS REALTY