Loretta Weldner
Licensed Associate Real Estate Broker
REALTOR®
Johnstown, NY
social icon 

14826 S Hadcock Drive , Sterling, NY 13156

View Full Photo Gallery

Property Description

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/HPNIl7w

14826 S Hadcock Drive | MLS# S1644852

This property located at 14826 S Hadcock Drive , Sterling, NY 13156 is currently listed for rent with an asking price of $5,000 / Monthly. S Hadcock Drive is located within the Red Creek school district. Search Sterling real estate on loretta-weldner.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Rental - Single Family
Basement: Full, Finished, Walk-Out Access
Cooling: Central Air
Heating: Forced Air
Home Style: Contemporary
Lot Size: 0.27 Acres
Taxes: $0
Year Built: 2025

Amenities

Den
Separate/Formal Living Room
Home Office
Bedroom on Main Level
Loft
Main Level Primary
Gravel Driveway

Feature Descriptions

Accessibility: Accessible Entrance
Body of Water: Little Sodus Bay
Days on Site: 158
Laundry: In Basement
Lot Dimensions: 50X236
Parcel#: 055601-008-011-0001-024-000-0000
Parking: Off Street
Parking Notes: Off Street
Patio/Porch: Open, Porch
Water Features: Lake

Local Schools

School District: Red Creek

Demographics

Listed By / Shown By

Listing By

Agency Name: Century 21 Leah's Signature
Agency Phone: 315-598-1165

Shown By

Agent Name: Loretta Weldner
Agent Phone: (518) 762-3808 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 03/23/2026. The listing information on this page last changed on 03/23/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Mon 03/23/2026 12:00:30 AM EST) or Global MLS (last updated Sun 03/22/2026 11:51:55 PM EST) or New York State Alliance MLS (last updated Sun 03/22/2026 11:58:34 PM EST) or Hudson Valley Catskill Region MLS (last updated Sun 03/22/2026 11:51:13 PM EST) or OneKey MLS (last updated Sun 03/22/2026 11:53:08 PM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel