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

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
      • 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 14826 Hadcock Drive, Sterling, NY 13156
      ACTIVE
      FOR RENT
      0
      $5,000

      14826 Hadcock DriveSterling, NY, 13156

      3 Beds2 Baths1,900 SqFt0.2716 Acres
      EXPERIENCE THE ULTIMATE IN LAKESIDE LUXURY WITH THIS NEWLY CONSTRUCTED WATERFRONT HOME NESTLED ALONG 50 FEET OF PRISTINE PEBBLE BEACH SHORELINE ON LITTLE SODUS BAY. DESIGNED FOR COMFORT, STYLE AND UNFORGETTABLE LAKEFRONT LIVING, THIS BEAUTIFULLY CRAFTED 1900 SQFT RESIDENCE FEATURES THREE SPACIOUS BEDROOMS WITH SERENE, MODERN FINISHES AND AMPLE NATURAL LIGHT, A SPA-INSPIRED PRIMARY BATH WITH A CUSTOM TILE SHOWER, FEATURING BOTH WATERFALL AND WALL-MOUNTED SHOWER HEADS, A SECOND BATHROOM WITH A TUB/SHOWER COMBO IS IDEAL FOR FAMILIES OR GUESTS, A FLEXIBLE LOFT SPACE, PERFECT FOR A LIVING ROOM OR PRIVATE OFFICE AND A GOURMET KITCHEN WITH STUNNING BAY VIEWS SURROUNDED BY LARGE PICTURESQUE CUSTOM WINDOWS, STAINLESS STEEL APPLIANCES AND A LARGE QUARTZ ISLAND IDEAL FOR ENTERTAINING AND CASUAL DINING. AN OPEN-CONCEPT LAYOUT WITH CLEAN LINES, HIGH CEILINGS, AND EXPANSIVE WINDOWS, EVERY DETAIL HAS BEEN THOUGHTFULLY CONSIDERED TO CREATE A SEAMLESS BLEND OF MODERN ELEGANCE AND NATURAL BEAUTY. THE DESIRED OUTDOOR FEATURES INCLUDE THE 50 FEET OF PRIVATE PEBBLE BEACH WATERFRONT, A PRIVATE DOCK AND BOAT LIFT, SMALL BOAT OR KAYAK LAUNCH, AN OUTDOOR FIREPIT, A COVERED DECK COMPLETE WITH SPACE FOR LOUNGE SEATING AND BUILT IN GRILLING AREA, ALL OVERLOOKING THE GLISTENING BAY FRONT. WHETHER YOU ARE ENJOYING SUNRISE VIEWS FROM YOUR KITCHEN OR SUNSET VIEWS FROM YOUR DECK, SPENDING THE DAY ON THE WATER OR RELAXING BY THE FIRE AFTER DINNER, THIS HOME DELIVERS THE PERFECT LAKEFRONT LIFESTYLE WITH LUXURY AMENTITIES AND MODERN COMFORT. LOCATED MINUTES FROM FAIR HAVEN VILLAGE, MARINAS, DINING, WINERIES AND SCENIC TRAILS. **BUILDING IS SET TO BE COMPLETE BETWEEN 11/1-12/1. PHOTOS ARE ARCHITECTURAL, NOT ACTUAL AND WILL BE UPDATED AS COMPLETED. FLEXIBLE LEASE TERMS ARE AVAILABLE. WHILE A LONG TERM LEASE IS PREFERRED, SHORTER-TERM OPTIONS MAY BE CONSIDERED. RENT IS $5000/MONTH AND INCLUDES WATER/SEWER, TRASH, LAWN MAINTENANCE AND SNOW REMOVAL. APPLICATIONS ARE REQUIRED PRIOR TO VIEWING VIA RENTSPREE. QUALIFICATIONS INCLUDE VERIFIABLE INCOME AND CREDIT CHECK. https://apply.link/HPN Il7w

      $5,000/mo

      Fees may apply

      Price may not include required fees and charges.

      14826 Hadcock Drive, Sterling, NY

      3 Beds2 Baths1,900 SqFt0.2716 Acres

      EXPERIENCE THE ULTIMATE IN LAKESIDE LUXURY WITH THIS NEWLY CONSTRUCTED WATERFRONT HOME NESTLED ALONG 50 FEET OF PRISTINE PEBBLE BEACH SHORELINE ON LITTLE SODUS BAY. DESIGNED FOR COMFORT, STYLE AND UNFORGETTABLE LAKEFRONT LIVING, THIS BEAUTIFULLY CRAFTED 1900 SQFT RESIDENCE FEATURES THREE SPACIOUS BEDROOMS WITH SERENE, MODERN FINISHES AND AMPLE NATURAL LIGHT, A SPA-INSPIRED PRIMARY BATH WITH A CUSTOM TILE SHOWER, FEATURING BOTH WATERFALL AND WALL-MOUNTED SHOWER HEADS, A SECOND BATHROOM WITH A TUB/SHOWER COMBO IS IDEAL FOR FAMILIES OR GUESTS, A FLEXIBLE LOFT SPACE, PERFECT FOR A LIVING ROOM OR PRIVATE OFFICE AND A GOURMET KITCHEN WITH STUNNING BAY VIEWS SURROUNDED BY LARGE PICTURESQUE CUSTOM WINDOWS, STAINLESS STEEL APPLIANCES AND A LARGE QUARTZ ISLAND IDEAL FOR ENTERTAINING AND CASUAL DINING. AN OPEN-CONCEPT LAYOUT WITH CLEAN LINES, HIGH CEILINGS, AND EXPANSIVE WINDOWS, EVERY DETAIL HAS BEEN THOUGHTFULLY CONSIDERED TO CREATE A SEAMLESS BLEND OF MODERN ELEGANCE AND NATURAL BEAUTY. THE DESIRED OUTDOOR FEATURES INCLUDE THE 50 FEET OF PRIVATE PEBBLE BEACH WATERFRONT, A PRIVATE DOCK AND BOAT LIFT, SMALL BOAT OR KAYAK LAUNCH, AN OUTDOOR FIREPIT, A COVERED DECK COMPLETE WITH SPACE FOR LOUNGE SEATING AND BUILT IN GRILLING AREA, ALL OVERLOOKING THE GLISTENING BAY FRONT. WHETHER YOU ARE ENJOYING SUNRISE VIEWS FROM YOUR KITCHEN OR SUNSET VIEWS FROM YOUR DECK, SPENDING THE DAY ON THE WATER OR RELAXING BY THE FIRE AFTER DINNER, THIS HOME DELIVERS THE PERFECT LAKEFRONT LIFESTYLE WITH LUXURY AMENTITIES AND MODERN COMFORT. LOCATED MINUTES FROM FAIR HAVEN VILLAGE, MARINAS, DINING, WINERIES AND SCENIC TRAILS. **BUILDING IS SET TO BE COMPLETE BETWEEN 11/1-12/1. PHOTOS ARE ARCHITECTURAL, NOT ACTUAL AND WILL BE UPDATED AS COMPLETED. FLEXIBLE LEASE TERMS ARE AVAILABLE. WHILE A LONG TERM LEASE IS PREFERRED, SHORTER-TERM OPTIONS MAY BE CONSIDERED. RENT IS $5000/MONTH AND INCLUDES WATER/SEWER, TRASH, LAWN MAINTENANCE AND SNOW REMOVAL. APPLICATIONS ARE REQUIRED PRIOR TO VIEWING VIA RENTSPREE. QUALIFICATIONS INCLUDE VERIFIABLE INCOME AND CREDIT CHECK. https://apply.link/HPN Il7w

      StatusActive
      Property TypeResidential Lease
      Property SubtypeSingle Family Residence
      Year Built2025
      Total Rooms8 rooms
      Days on Market217 days

      Property Details

      Property Information

      14826 Hadcock Drive

      Sterling, NY 13156 • Cayuga
      3
      Beds
      2
      Baths
      1,900
      SqFt
      0.2716
      Acres
      Status
      ActiveRENTAL
      Property Type
      Residential Lease
      Property Subtype
      Single Family Residence
      Year Built
      20251 year ago
      Total Rooms
      8 rooms
      Days on Market
      217 days
      Property History
      • Listed for sale
        Oct 14, 2025 • NYSAMLS • S1644852
        $5,000
      MLS Information
      • Source
        NYSAMLS
      • MLS#
        S1644852
      • Listing Office
        Century 21 Leah's Signature
      • Last Updated
        216 days ago

      Climate & Systems

      • Heating
        Forced Air

      Interior Features

      • Basement
        • Full
        • Finished
        • Walk Out Access
      • Interior Features
        • Den
        • Separate Formal Living Room
        • Home Office
        • Bedroom On Main Level
        • Loft
        • Main Level Primary

      Parking

      • Parking Features
        Off Street

      Lot & Grounds

      • Lot Size
        0.2716 acres
      • Patio & Porch
        • Open
        • Porch
      • Exterior Features
        Gravel Driveway

      Type

      • Property Type
        Residential Lease
      • Property Subtype
        Single Family Residence
      • Architectural Style
        Contemporary

      Condition

      • Year Built
        2025
      • Condition
        Resale
      • Days on Market
        217 days
      • Water
        None
      • Sewer
        None

      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 →
      • 5458 Center Pine Lane, Clarence, NY 14221ACTIVE$4,500

        5458 Center Pine Lane, Clarence, NY 14221

        4 Beds2.5 Baths2,896 SqFt0.66 Acres

        LISTING BY HUNT REAL ESTATE CORPORATION

      • 1919 Lake Road, Skaneateles, NY 13152ACTIVE$4,500

        1919 Lake Road, Skaneateles, NY 13152

        3 Beds1.5 Baths1,248 SqFt12.28 Acres

        LISTING BY LAKE LIFE REAL ESTATE AGENCY

      • 340 Poplar Beach, Owasco, NY 13021ACTIVE$4,500

        340 Poplar Beach, Owasco, NY 13021

        3 Beds1 Bath1,484 SqFt0.2014 Acres

        LISTING BY THE REAL ESTATE AGENCY

      • 399 French Road, Pittsford, NY 14618ACTIVE$4,500

        399 French Road, Pittsford, NY 14618

        4 Beds2.5 Baths2,784 SqFt0.75 Acres

        LISTING BY KELLER WILLIAMS REALTY GATEWAY

      • 15 McCormicks Lane, Ballston, NY 12019ACTIVE$4,500

        15 McCormicks Lane, Ballston, NY 12019

        5 Beds2.5 Baths3,032 SqFt1.88 Acres

        LISTING BY ROMEO TEAM REALTY

      • 10 Marion Place, Saratoga Springs, NY 12866ACTIVE$4,500

        10 Marion Place, Saratoga Springs, NY 12866

        4 Beds2 Baths1,800 SqFt0.08 Acres

        LISTING BY TAILORED REAL ESTATE GROUP

      • 911 Main Street, Horseheads, NY 14845ACTIVE$4,500

        911 Main Street, Horseheads, NY 14845

        4 Beds3 Baths2,945 SqFt1.1 Acres

        LISTING BY LOCEY REALTY GROUP

      • 11833 Overlook Drive, Corning, NY 14830ACTIVE$4,500

        11833 Overlook Drive, Corning, NY 14830

        5 Beds3 Baths3,840 SqFt3.34 Acres

        LISTING BY LOCEY REALTY GROUP

      • 836 Richmond Avenue, Buffalo, NY 14222ACTIVE$4,500

        836 Richmond Avenue, Buffalo, NY 14222

        4 Beds3.5 Baths1,982 SqFt0.0585 Acres

        LISTING BY INTEGRA REALTY LLC

      • 12 Glennon Road, Colonie, NY 12110ACTIVE$4,700

        12 Glennon Road, Colonie, NY 12110

        4 Beds2.5 Baths2,732 SqFt0.89 Acres

        LISTING BY REALTY ONE GROUP KEY