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 120 Longview Drive, Mayfield, NY 12078
ACTIVE
$75,000
$1,175,000

120 Longview DriveMayfield, NY, 12078

3 Beds3 Baths2,629 SqFt0.47 Acres
This spacious 3 bedroom 3 full bath lakefront home offers comfort, privacy, and timeless style, with 100' of sandy shoreline and no road to cross to reach the waters of the Great Sacandaga. Architect designed to blend into the existing neighborhood when viewed from the road, the home reveals its full impact when seen from the lake side.Tucked away on a quiet, low-traffic road, the setting provides a peaceful lakeside experience that's increasingly hard to find. Inside, the home features an expansive open-concept layout, filled with natural light from abundant windows and showcases vaulted ceilings, hardwood floors, and a beautiful wood-burning fireplace as the centerpiece of an inviting gathering space. The living space opens to a large deck overlooking an expansive green lawn and views of the lake. A very short walk brings you to 100' of shoreline with your own sandy beach! The classic style gives the home an elegantce that sets it apart from the common rustic lodge aesthetic. A bright sunroom with it's own deck offers flexible space for year-round enjoyment and could easily serve as a future hot tub room, fitness space, or office. The first floor bedroom is located directly adjacent to a full bath for easy access. The upstairs offers two ensuites, one with a private porch with a lake view! Additional highlights include a second story loft, a full basement, a separate 12 x 16 foot storage shed and an attached two car garage
1 / 48

Est. Monthly

$5,569/MO

$1,175,000
$75,000

120 Longview Drive, Mayfield, NY

3 Beds3 Baths2,629 SqFt0.47 Acres

This spacious 3 bedroom 3 full bath lakefront home offers comfort, privacy, and timeless style, with 100' of sandy shoreline and no road to cross to reach the waters of the Great Sacandaga. Architect designed to blend into the existing neighborhood when viewed from the road, the home reveals its full impact when seen from the lake side.Tucked away on a quiet, low-traffic road, the setting provides a peaceful lakeside experience that's increasingly hard to find. Inside, the home features an expansive open-concept layout, filled with natural light from abundant windows and showcases vaulted ceilings, hardwood floors, and a beautiful wood-burning fireplace as the centerpiece of an inviting gathering space. The living space opens to a large deck overlooking an expansive green lawn and views of the lake. A very short walk brings you to 100' of shoreline with your own sandy beach! The classic style gives the home an elegantce that sets it apart from the common rustic lodge aesthetic. A bright sunroom with it's own deck offers flexible space for year-round enjoyment and could easily serve as a future hot tub room, fitness space, or office. The first floor bedroom is located directly adjacent to a full bath for easy access. The upstairs offers two ensuites, one with a private porch with a lake view! Additional highlights include a second story loft, a full basement, a separate 12 x 16 foot storage shed and an attached two car garage

StatusActive
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built1987
Total Rooms12 rooms
Days on Market31 days

Est. Monthly Payment

$5,569.47

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

120 Longview Drive

Mayfield, NY 12078 • Fulton
3
Beds
3
Baths
2,629
SqFt
0.47
Acres
Status
Active
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
198739 years ago
Total Rooms
12 rooms
Days on Market
31 days
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $13,697
Property History
  • Price reduced
    Jun 18, 2026 • GLOBAL MLS • 202617719
    $1,250,000 → $1,175,000
  • Listed for sale
    May 21, 2026 • GLOBAL MLS • 202617719
    $1,250,000
Mortgage Calculator
Estimated monthly payment for this property
$5,569.47
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#
    202617719
  • Listing Office
    Howard Hanna Capital Inc
  • Last Updated
    3 days ago

Appliances

  • Appliances
    • Refrigerator
    • Washer
    • Dishwasher
    • Dryer
    • Microwave
    • Double Oven
    • Electric Water Heater

Climate & Systems

  • Heating
    • Electric
    • Baseboard
  • Fireplace
    Wood Burning

Interior Features

  • Flooring
    • Wood
    • Tile
  • Basement
    • Unfinished
    • Finished
  • Interior Features
    • Cathedral Ceiling(s)
    • High Speed Internet

Parking

  • Parking Features
    • Attached
    • Driveway
    • Garage
  • Parking Spaces
    6
  • Garage Spaces
    2

Lot & Grounds

  • Lot Size
    0.47 acres
  • Lot Features
    • Landscaped
    • Rolling Slope
    • Views
    • Waterfront
  • View
    • Lake
    • Trees or Woods
  • Fencing
    None
  • Patio & Porch
    Composite Deck
  • Exterior Features
    Other

Type

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

Structure

  • Construction
    Vinyl Siding
  • Roof
    Shingle
  • Foundation
    Concrete Perimeter

Condition

  • Year Built
    1987
  • Days on Market
    31 days
  • Water
    Well
  • Sewer
    Septic Tank
  • Electric
    • 200+ Amp Service
    • 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 →
  • 1585 Davis Road, Chili, NY 14428ACTIVE$1,075,000

    1585 Davis Road, Chili, NY 14428

    4 Beds2.5 Baths2,749 SqFt10.41 Acres

    LISTING BY RE/MAX PLUS

  • 8154 Golden Oak Circle, Clarence, NY 14221ACTIVE$1,079,900

    8154 Golden Oak Circle, Clarence, NY 14221

    4 Beds5.5 Baths3,889 SqFt1.04 Acres

    LISTING BY SUPERLATIVE REAL ESTATE, INC.

  • 4320 Trout Lilly Lane, Manlius, NY 13104ACTIVE$1,085,000

    4320 Trout Lilly Lane, Manlius, NY 13104

    5 Beds7 Baths5,738 SqFt0.9727 Acres

    LISTING BY HOWARD HANNA REAL ESTATE

  • 352 Columbia Street, Hudson, NY 12534ACTIVE$1,085,000

    352 Columbia Street, Hudson, NY 12534

    4 Beds2.5 Baths3,074 SqFt0.07 Acres

    LISTING BY HOULIHAN LAWRENCE

  • 2 Arlington Circle, Milton, NY 12020ACTIVE$1,087,700

    2 Arlington Circle, Milton, NY 12020

    3 Beds3.5 Baths2,972 SqFt1.05 Acres

    LISTING BY STERLING REAL ESTATE GROUP

  • 121 Lang Road, Spencer, NY 14883ACTIVE$1,090,000

    121 Lang Road, Spencer, NY 14883

    4 Beds2 Baths2,280 SqFt29.34 Acres

    LISTING BY FOUR SEASONS SOTHEBY'S INT'L

  • 5135 Peck Hill Road, DeWitt, NY 13078ACTIVE$1,090,000

    5135 Peck Hill Road, DeWitt, NY 13078

    5 Beds5 Baths5,322 SqFt1.87 Acres

    LISTING BY THE O'HARA GROUP

  • 766 Waite Road, Clifton Park, NY 12065ACTIVE$1,095,000

    766 Waite Road, Clifton Park, NY 12065

    5 Beds4 Baths3,176 SqFt6.39 Acres

    LISTING BY MONTICELLO

  • 2501 Lake Road, Ontario, NY 14519ACTIVE$1,095,000

    2501 Lake Road, Ontario, NY 14519

    5 Beds3.5 Baths4,200 SqFt1.1 Acres

    LISTING BY HOWARD HANNA

  • 100 Southard Road, Saratoga, NY 12866ACTIVE$1,095,000

    100 Southard Road, Saratoga, NY 12866

    3 Beds3.5 Baths1,827 SqFt3.6 Acres

    LISTING BY EXP REALTY