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 194 Sunrise Drive, Mayfield, NY 12078
ACTIVE
0
$825,000

194 Sunrise DriveMayfield, NY, 12078

5 Beds3 Baths3,288 SqFt3.7 Acres
Welcome to your dream lakeside escape! This exceptional 3,200 square foot custom Colonial seamlessly blends timeless elegance with modern comfort; all set on a secluded 3.7 acre corner lot with 800 feet of beach access to the sought after Great Sacandaga Lake. Boasting 5 spacious bedrooms and 3 full bathrooms, this thoughtfully designed home offers the perfect balance of everyday functionality and refined living. The open concept floor plan invites you in with beautiful hardwood floors and exquisite custom wood accents that add warmth and character throughout. At the heart of the home is a show stopping chef's kitchen. Featuring a 36-inch double oven, expansive workspace, walk in pantry, and a convenient beverage refrigerator, this kitchen is as functional as it is beautiful. Ideal for entertaining and everyday living. The main level includes two bedrooms, including a larger bedroom with an adjoining bathroom. Perfect for guests, extended family, or flexible single level living. Additional interior highlights include a home office space and a fully equipped home gym space, offering versatility for today's lifestyle needs. As part of a neighborhood community, you'll enjoy 800 feet of shared sandy beach access along the shores of the Great Sacandaga Lake, perfect for swimming, relaxing, or soaking in breathtaking views. This property also includes a 26' boat slip, with docks maintained by the neighborhood dock association ($300 Annual Fee), making lake life effortless and enjoyable. Outdoors you will enjoy a stamped concrete front walkway leading to a large front porch and a backyard concrete patio that leads to a dedicated firepit area. Completing the home is a two-car garage and ample outdoor space across the expansive 3-acre lot, a 1900 square foot basement with walk out access ready to be finished for even more living space. Whether you're looking for a year-round residence or a vacation retreat, this extraordinary property offers it all. Agent is owner
1 / 59

Est. Monthly

$3,910/MO

$825,000

194 Sunrise Drive, Mayfield, NY

5 Beds3 Baths3,288 SqFt3.7 Acres

Welcome to your dream lakeside escape! This exceptional 3,200 square foot custom Colonial seamlessly blends timeless elegance with modern comfort; all set on a secluded 3.7 acre corner lot with 800 feet of beach access to the sought after Great Sacandaga Lake. Boasting 5 spacious bedrooms and 3 full bathrooms, this thoughtfully designed home offers the perfect balance of everyday functionality and refined living. The open concept floor plan invites you in with beautiful hardwood floors and exquisite custom wood accents that add warmth and character throughout. At the heart of the home is a show stopping chef's kitchen. Featuring a 36-inch double oven, expansive workspace, walk in pantry, and a convenient beverage refrigerator, this kitchen is as functional as it is beautiful. Ideal for entertaining and everyday living. The main level includes two bedrooms, including a larger bedroom with an adjoining bathroom. Perfect for guests, extended family, or flexible single level living. Additional interior highlights include a home office space and a fully equipped home gym space, offering versatility for today's lifestyle needs. As part of a neighborhood community, you'll enjoy 800 feet of shared sandy beach access along the shores of the Great Sacandaga Lake, perfect for swimming, relaxing, or soaking in breathtaking views. This property also includes a 26' boat slip, with docks maintained by the neighborhood dock association ($300 Annual Fee), making lake life effortless and enjoyable. Outdoors you will enjoy a stamped concrete front walkway leading to a large front porch and a backyard concrete patio that leads to a dedicated firepit area. Completing the home is a two-car garage and ample outdoor space across the expansive 3-acre lot, a 1900 square foot basement with walk out access ready to be finished for even more living space. Whether you're looking for a year-round residence or a vacation retreat, this extraordinary property offers it all. Agent is owner

StatusActive
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built2022
Total Rooms15 rooms
Days on Market4 days

Est. Monthly Payment

$3,910.48

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

194 Sunrise Drive

Mayfield, NY 12078 • Fulton
5
Beds
3
Baths
3,288
SqFt
3.7
Acres
Status
Active
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
20224 years ago
Total Rooms
15 rooms
Days on Market
4 days
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $11,000
  • School Taxes
    $6,780
  • Town/County Taxes
    $4,368
Property History
  • Listed for sale
    May 28, 2026 • GLOBAL MLS • 202618303
    $825,000
Mortgage Calculator
Estimated monthly payment for this property
$3,910.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#
    202618303
  • Listing Office
    Howard Hanna Capital Inc
  • Last Updated
    2 days ago

Kitchen & Laundry

  • Kitchen
    • Gourmet Kitchen
    • Kitchen Island

Appliances

  • Appliances
    • Refrigerator
    • Dishwasher
    • Freezer
    • Microwave
    • Double Oven
    • Range Hood
    • Ice Maker
    • Electric Oven
    • Water Purifier
    • Humidifier
    • Water Softener
    • Electric Water Heater
    • ENERGY STAR Qualified Appliances

Climate & Systems

  • Heating
    • Oil
    • Forced Air
  • Fireplace
    • Gas
    • Family Room

Interior Features

  • Flooring
    • Carpet
    • Ceramic Tile
    • Hardwood
    • Vinyl
  • Doors
    • Sliding Doors
    • ENERGY STAR Qualified Doors
  • Basement
    • Walk-Out Access
    • Full
    • Exterior Entry
    • Heated
    • Interior Entry
  • Windows
    • Blinds
    • Curtain Rods
    • ENERGY STAR Qualified Windows
    • Double Pane Windows
    • Screens
    • Shutters
    • Wood Frames
  • Interior Features
    • Cathedral Ceiling(s)
    • Ceramic Tile Bath
    • High Speed Internet
    • Paddle Fan
    • Built-in Features
    • Solid Surface Counters
    • Kitchen Island

Parking

  • Parking Features
    • Attached
    • Garage Door Opener
    • Paved
    • Driveway
    • Garage
  • Parking Spaces
    11
  • Garage Spaces
    2

Lot & Grounds

  • Lot Size
    3.7 acres
  • Lot Features
    • Corner Lot
    • Cleared
    • Landscaped
    • Level
    • Road Frontage
    • Wooded
  • Fencing
    None
  • Patio & Porch
    • Patio
    • Front Porch
  • Exterior Features
    • Drive-Paved
    • Lighting
    • Other

Type

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

Structure

  • Construction
    Vinyl Siding
  • Roof
    Asphalt
  • Foundation
    Concrete Perimeter

Condition

  • Year Built
    2022
  • Days on Market
    4 days
  • Water
    Well
  • Sewer
    Septic Tank
  • Electric
    • 200+ Amp Service
    • Circuit Breakers
  • Utilities
    Underground Utilities

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 →
  • 3 Saint Andrews Drive, Queensbury, NY 12804ACTIVE$743,000

    3 Saint Andrews Drive, Queensbury, NY 12804

    4 Beds2.5 Baths2,120 SqFt0.68 Acres

    LISTING BY LEVACK REAL ESTATE INC

  • 7a Wyatt's Way, Clifton Park, NY 12065ACTIVE$743,000

    7a Wyatt's Way, Clifton Park, NY 12065

    4 Beds2.5 Baths2,516 SqFt0.38 Acres

    LISTING BY COLDWELL BANKER PRIME PROPERTIES

  • 903 DIMMICK MTN ROAD, Middletown, NY 12421ACTIVE$745,000

    903 DIMMICK MTN ROAD, Middletown, NY 12421

    4 Beds2 Baths1,395 SqFt5.38 Acres

    LISTING BY JEWETT AND JEWETT LLC

  • 3 Moreland Drive, Halfmoon, NY 12118ACTIVE$745,000

    3 Moreland Drive, Halfmoon, NY 12118

    5 Beds2.5 Baths2,632 SqFt0.57 Acres

    LISTING BY COLDWELL BANKER PRIME PROPERTIES

  • 199 Ashdown Road, Clifton Park, NY 12019ACTIVE$745,000

    199 Ashdown Road, Clifton Park, NY 12019

    4 Beds3.5 Baths2,814 SqFt7.09 Acres

    LISTING BY COLDWELL BANKER PRIME PROPERTIES

  • Lot 24 Windrow Way, Halfmoon, NY 12118ACTIVE$746,300

    Lot 24 Windrow Way, Halfmoon, NY 12118

    4 Beds3 Baths2,786 SqFt0.39 Acres

    LISTING BY ROB MAR REALTY INC

  • 4 Brookhaven Court, Wilton, NY 12866ACTIVE$746,500

    4 Brookhaven Court, Wilton, NY 12866

    4 Beds2.5 Baths2,442 SqFt0.92 Acres

    LISTING BY STERLING REAL ESTATE GROUP

  • 463 Cairo Junction Road, Catskill, NY 12414ACTIVE$747,000

    463 Cairo Junction Road, Catskill, NY 12414

    5 Beds3 Baths3,970 SqFt2 Acres

    LISTING BY 4 SEASONS REALTY GROUP

  • 639 County Line Road, Darien, NY 14004ACTIVE$749,000OPEN 6/7

    639 County Line Road, Darien, NY 14004

    5 Beds2.5 Baths3,342 SqFt8.83 Acres

    LISTING BY HOWARD HANNA WNY INC.

  • 2 Sheffield Road, Wilton, NY 12831ACTIVE$749,000

    2 Sheffield Road, Wilton, NY 12831

    4 Beds2.5 Baths2,537 SqFt0.71 Acres

    LISTING BY STERLING REAL ESTATE GROUP