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 264 County Highway 154, Mayfield, NY 12078
      CLOSED
      $10,000
      $329,000

      264 County Highway 154Mayfield, NY, 12078

      3 Beds1 Baths1,150 SqFt0.46 Acres
      Welcome home to this beautifully renovated ranch in the Mayfield School District! This 3-bedroom, 1-bath home has been completely transformed with quality craftsmanship and thoughtful upgrades throughout. Every detail has been refreshed-new roof, windows, flooring, furnace, lighting, kitchen cabinets, granite countertops, stainless steel appliances, and fresh paint inside-making this home feel brand new and truly move-in ready. Step inside to an inviting open-concept layout featuring an eat-in kitchen with sleek granite counters and modern fixtures that flows effortlessly into a bright living room accented by crown molding and luxury vinyl plank flooring. All three bedrooms are conveniently located on the main floor, along with an updated full bath. Outside, enjoy a large level lot with a paved driveway, one-car garage, and deck overlooking the peaceful surroundings-perfect for relaxing or entertaining. The full unfinished basement offers potential for added storage or future living space. This low-maintenance home with new siding and energy shield insulation blends comfort, style, and convenience. Nothing to do but move in and enjoy! Schedule your private tour today.
      1 / 41

      Est. Monthly

      $1,559/mo

      $329,000
      $10,000

      264 County Highway 154, Mayfield, NY

      3 Beds1 Bath1,150 SqFt0.46 Acres

      Welcome home to this beautifully renovated ranch in the Mayfield School District! This 3-bedroom, 1-bath home has been completely transformed with quality craftsmanship and thoughtful upgrades throughout. Every detail has been refreshed-new roof, windows, flooring, furnace, lighting, kitchen cabinets, granite countertops, stainless steel appliances, and fresh paint inside-making this home feel brand new and truly move-in ready. Step inside to an inviting open-concept layout featuring an eat-in kitchen with sleek granite counters and modern fixtures that flows effortlessly into a bright living room accented by crown molding and luxury vinyl plank flooring. All three bedrooms are conveniently located on the main floor, along with an updated full bath. Outside, enjoy a large level lot with a paved driveway, one-car garage, and deck overlooking the peaceful surroundings-perfect for relaxing or entertaining. The full unfinished basement offers potential for added storage or future living space. This low-maintenance home with new siding and energy shield insulation blends comfort, style, and convenience. Nothing to do but move in and enjoy! Schedule your private tour today.

      StatusClosed
      Property TypeResidential
      Property SubtypeSingle Family Residence
      Year Built1965
      Total Rooms6 rooms
      Days on Market159 days

      Est. Monthly Payment

      $1,559.45

      %
      %
      yr

      Private Mortgage Insurance

      Not required

      Affordability Checkoptional
      $

      Enter your annual income to check affordability

      Property Details

      Property Information

      264 County Highway 154

      Mayfield, NY 12078 • Fulton
      3
      Beds
      1
      Bath
      1,150
      SqFt
      0.46
      Acres
      Status
      Closed
      Property Type
      Residential
      Property Subtype
      Single Family Residence
      Year Built
      196561 years ago
      Total Rooms
      6 rooms
      Days on Market
      159 days
      Tax History
      Estimated values, may not reflect current amounts.
      • Annual Tax Amount
        $3,500
      Property History
      • Closed
        Mar 25, 2026 • GLOBAL MLS • 202528031
        $329,000
      • Price reduced
        Nov 17, 2025 • GLOBAL MLS • 202528031
        $339,000 → $329,000
      • Listed for sale
        Oct 17, 2025 • GLOBAL MLS • 202528031
        $339,000
      Mortgage Calculator
      Estimated monthly payment for this property
      $1,559.45
      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#
        202528031
      • Listing Office
        Howard Hanna Capital Inc
      • Last Updated
        41 days ago

      Kitchen & Laundry

      • Kitchen
        Eat-in Kitchen

      Appliances

      • Appliances
        • Range
        • Refrigerator
        • Dishwasher
        • Microwave

      Climate & Systems

      • Heating
        • Natural Gas
        • Forced Air

      Interior Features

      • Doors
        Sliding Doors
      • Basement
        • Unfinished
        • Full
      • Interior Features
        • Crown Molding
        • Eat-in Kitchen

      Parking

      • Parking Features
        • Off Street
        • Paved
        • Driveway
        • Garage
      • Parking Spaces
        4
      • Garage Spaces
        1

      Lot & Grounds

      • Lot Size
        0.46 acres
      • Lot Features
        Level
      • View
        Pasture
      • Patio & Porch
        Deck
      • Exterior Features
        Drive-Paved

      Type

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

      Structure

      • Construction
        Vinyl Siding
      • Roof
        • Asphalt
        • Shingle

      Condition

      • Year Built
        1965
      • Condition
        Updated or Remodeled
      • Days on Market
        159 days
      • Water
        Well
      • Sewer
        Septic Tank
      • Electric
        Circuit Breakers
      Also Listed On
      • Global MLS
        1 related listing
        Closed$154,900

      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 →
      • 27 Tioga Street, Spencer, NY 14883ACTIVE$297,000

        27 Tioga Street, Spencer, NY 14883

        3 Beds2 Baths2,396 SqFt2.61 Acres

        LISTING BY REALTY ONE GROUP SUPREME

      • 2507 Shanty Plains Road, Jerusalem, NY 14527ACTIVE$297,000

        2507 Shanty Plains Road, Jerusalem, NY 14527

        1 Bed1 Bath800 SqFt18.331 Acres

        LISTING BY CURBEAU REALTY INC.

      • 1607 Genesee Street, Syracuse, NY 13204ACTIVE$297,000

        1607 Genesee Street, Syracuse, NY 13204

        4 Beds1.5 Baths3,453 SqFt0.2 Acres

        LISTING BY REALTY BOOM

      • 901 Water Street, Elmira, NY 14905ACTIVE$298,000

        901 Water Street, Elmira, NY 14905

        4 Beds3.5 Baths3,412 SqFt1.99 Acres

        LISTING BY HOWARD HANNA CORNING

      • 47 Groff Road, Big Flats, NY 14845ACTIVE$298,000

        47 Groff Road, Big Flats, NY 14845

        3 Beds2 Baths1,720 SqFt0.3444 Acres

        LISTING BY HOWARD HANNA ELMIRA

      • 5764 Rees Road, Granger, NY 14735ACTIVE$298,000

        5764 Rees Road, Granger, NY 14735

        4 Beds2 Baths2,408 SqFt2.1 Acres

        LISTING BY WHITETAIL PROPERTIES REAL ESTATE, LLC

      • 6809 Handsome Brook Road, Franklin, NY 13775ACTIVE$298,000

        6809 Handsome Brook Road, Franklin, NY 13775

        1 Bed1 Bath600 SqFt0.28 Acres

        LISTING BY COOPERSTOWN BROKERS, LLC

      • 302 Keyes Avenue, Watertown City, NY 13601ACTIVE$298,000

        302 Keyes Avenue, Watertown City, NY 13601

        4 Beds2.5 Baths3,238 SqFt0.2278 Acres

        LISTING BY NORTH STAR REAL ESTATE & PROP MGMT LLC-CARTHAGE

      • 115 Arrow Street, Schenectady, NY 12304ACTIVE$299,000

        115 Arrow Street, Schenectady, NY 12304

        2 Beds1 Bath906 SqFt0.21 Acres

        LISTING BY THE PEOPLE'S REAL ESTATE GROUP

      • 42 Kakely Street, Albany, NY 12208ACTIVE$299,000

        42 Kakely Street, Albany, NY 12208

        2 Beds1.5 Baths1,322 SqFt0.12 Acres

        LISTING BY KW PLATFORM