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

  • 2 Lakeside Circle, Elma, NY 14059ACTIVE$564,900

    2 Lakeside Circle, Elma, NY 14059

    3 Beds3 Baths2,207 SqFt0.19 Acres

    LISTING BY WNY METRO ROBERTS REALTY

  • 3249 Big Ridge Road, Ogden, NY 14559ACTIVE$565,000

    3249 Big Ridge Road, Ogden, NY 14559

    3 Beds2.5 Baths2,884 SqFt2.14 Acres

    LISTING BY KELLER WILLIAMS REALTY GREATER ROCHESTER

  • 104 Burlingame Road, Syracuse, NY 13203ACTIVE$565,000

    104 Burlingame Road, Syracuse, NY 13203

    4 Beds2.5 Baths2,576 SqFt0.3719 Acres

    LISTING BY KELLER WILLIAMS SYRACUSE

  • 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

  • 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

  • #1 Orchard View Trail, Walworth, NY 14568ACTIVE$565,120

    #1 Orchard View Trail, Walworth, NY 14568

    3 Beds2.5 Baths1,796 SqFt1.2 Acres

    LISTING BY GERBER HOMES