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 197 Lakeside Drive, Mayfield, NY 12117
ACTIVE
0
$270,000

197 Lakeside DriveMayfield, NY, 12117

2 Beds1 Baths1,160 SqFt1.6 Acres
Charming mobile home with attached garage plus oversized 3 car garage and a lake view! Large yard and covered front & rear porches allow you to enjoy the warm summer evenings and the oversized garage provides storage space for all your lake toys! Multiple marinas just a stone's throw away! The interior of the home is bright and well maintained and turn-key ready!
1 / 27

Est. Monthly

$1,280/MO

$270,000

197 Lakeside Drive, Mayfield, NY

2 Beds1 Bath1,160 SqFt1.6 Acres

Charming mobile home with attached garage plus oversized 3 car garage and a lake view! Large yard and covered front & rear porches allow you to enjoy the warm summer evenings and the oversized garage provides storage space for all your lake toys! Multiple marinas just a stone's throw away! The interior of the home is bright and well maintained and turn-key ready!

StatusActive
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built1962
Total Rooms6 rooms

Est. Monthly Payment

$1,279.79

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

197 Lakeside Drive

Mayfield, NY 12117 • Fulton
2
Beds
1
Bath
1,160
SqFt
1.6
Acres
Status
Active
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
196264 years ago
Total Rooms
6 rooms
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $4,000
Property History
  • Listed for sale
    Jun 4, 2026 • GLOBAL MLS • 202618855
    $270,000
Mortgage Calculator
Estimated monthly payment for this property
$1,279.79
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#
    202618855
  • Listing Office
    Howard Hanna Capital Inc
  • Last Updated
    2 hours ago

Appliances

  • Appliances
    • Range
    • Refrigerator
    • Dishwasher
    • Microwave

Climate & Systems

  • Heating
    • Oil
    • Hot Water

Interior Features

  • Basement
    • Unfinished
    • Full
  • Interior Features
    Paddle Fan

Parking

  • Parking Features
    • Attached
    • Detached
    • Driveway
  • Parking Spaces
    10
  • Garage Spaces
    4

Lot & Grounds

  • Lot Size
    1.6 acres
  • View
    Lake
  • Fencing
    None
  • Patio & Porch
    • Front Porch
    • Covered
    • Rear Porch
  • Exterior Features
    Barn

Type

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

Structure

  • Construction
    • Wood Siding
    • Vinyl Siding
  • Roof
    Metal
  • Foundation
    Block

Condition

  • Year Built
    1962
  • Water
    Well
  • Sewer
    Septic Tank
  • Electric
    Circuit Breakers

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 →
  • 11 Airview Terrace, Cheektowaga, NY 14043ACTIVE$243,000OPEN 6/6

    11 Airview Terrace, Cheektowaga, NY 14043

    3 Beds1 Bath1,134 SqFt0.15 Acres

    LISTING BY HUNT REAL ESTATE CORPORATION

  • 1449 Huntersland Road, Middleburgh, NY 12122ACTIVE$243,900

    1449 Huntersland Road, Middleburgh, NY 12122

    3 Beds1 Bath1,900 SqFt0.94 Acres

    LISTING BY COUNTRY BOY REALTY

  • 674 Merchants Road, Rochester, NY 14609ACTIVE$244,900OPEN 6/4

    674 Merchants Road, Rochester, NY 14609

    4 Beds2.5 Baths2,360 SqFt0.5177 Acres

    LISTING BY HOWARD HANNA

  • 878 Turnbull Road, Duanesburg, NY 12053ACTIVE$244,900

    878 Turnbull Road, Duanesburg, NY 12053

    Unit • ---------3 Beds1.5 Baths3,120 SqFt5.87 Acres

    LISTING BY EMPIRE REAL ESTATE MANAGMENT LLC

  • 73 Atwood Drive, Gates, NY 14606ACTIVE$244,900

    73 Atwood Drive, Gates, NY 14606

    2 Beds2.5 Baths1,354 SqFt0.13 Acres

    LISTING BY HUNT REAL ESTATE ERA/COLUMBUS

  • 558 Applewood Drive, Porter, NY 14174ACTIVE$244,900

    558 Applewood Drive, Porter, NY 14174

    3 Beds1 Bath1,120 SqFt0.2663 Acres

    LISTING BY CENTURY 21 NORTH EAST

  • 61 Barlow Avenue, Lackawanna, NY 14218ACTIVE$244,900OPEN 6/6

    61 Barlow Avenue, Lackawanna, NY 14218

    3 Beds1 Bath1,350 SqFt0.1302 Acres

    LISTING BY MJ PETERSON REAL ESTATE INC.

  • 118 Main Street, Kendall, NY 14464ACTIVE$244,900

    118 Main Street, Kendall, NY 14464

    3 Beds2 Baths1,252 SqFt

    LISTING BY HOWARD HANNA

  • 131 Halladay Road, Mexico, NY 13114ACTIVE$244,900

    131 Halladay Road, Mexico, NY 13114

    3 Beds1.5 Baths1,388 SqFt1.22 Acres

    LISTING BY HOWARD HANNA REAL ESTATE

  • 351 N California Avenue, Watertown City, NY 13601ACTIVE$244,900

    351 N California Avenue, Watertown City, NY 13601

    4 Beds1 Bath1,232 SqFt0.21 Acres

    LISTING BY HAPPILY EVER AFTER REALTY CORP