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 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
    66 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 →
  • 2492 Lakeville Road, Avon, NY 14414ACTIVE$297,000

    2492 Lakeville Road, Avon, NY 14414

    3 Beds3 Baths2,327 SqFt0.8494 Acres

    LISTING BY ROWE REALTY & APPRAISAL, INC.

  • 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 W Genesee Street, Syracuse, NY 13204ACTIVE$297,000

    1607 W Genesee Street, Syracuse, NY 13204

    4 Beds1.5 Baths3,453 SqFt0.2 Acres

    LISTING BY REALTY BOOM

  • 3595 Owasco Drive, Owasco, NY 13021ACTIVE$297,500

    3595 Owasco Drive, Owasco, NY 13021

    2 Beds1 Bath915 SqFt0.2942 Acres

    LISTING BY THE REAL ESTATE AGENCY

  • 123 N Broad Street, Norwich, NY 13815ACTIVE$297,500

    123 N Broad Street, Norwich, NY 13815

    7 Beds5.5 Baths4,342 SqFt0.95 Acres

    LISTING BY KELLER WILLIAMS UPSTATE NY PROPERTIES

  • 218 Kusak Road, Henrietta, NY 14467ACTIVE$298,000

    218 Kusak Road, Henrietta, NY 14467

    4 Beds2.5 Baths1,712 SqFt0.33 Acres

    LISTING BY HUNT REAL ESTATE ERA/COLUMBUS

  • 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

  • 1900 7th Street, Rensselaer, NY 12144ACTIVE$298,000

    1900 7th Street, Rensselaer, NY 12144

    4 Beds2 Baths1,316 SqFt0.17 Acres

    LISTING BY HOWARD HANNA CAPITAL INC

  • 549 15th Street, Niagara Falls, NY 14301ACTIVE$298,000

    549 15th Street, Niagara Falls, NY 14301

    4 Beds2 Baths1,376 SqFt0.1212 Acres

    LISTING BY RED DOOR REAL ESTATE WNY LLC

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

    901 W Water Street, Elmira, NY 14905

    4 Beds3.5 Baths3,412 SqFt1.99 Acres

    LISTING BY HOWARD HANNA CORNING