STUNNING WATERFRONT OPPORTUNITY ON LITTLE SODUS BAY WITH BREATHTAKING VIEWS!
THIS SPACIOUS 5-BEDROOM, 2 FULL BATH HOME OFFERS INCREDIBLE POTENTIAL AND UNBEATABLE LOCATION. FEATURING A UNIQUE SUNKEN LIVING ROOM, A FUNCTIONAL KITCHEN, AND A SPACIOUS DECK OVERLOOKING THE WATER- PERFECT FOR ENTERTAINING OR RELAXING WHILE TAKING IN THE SCENERY.
THE PROPERTY INCLUDES AN ATTACHED 2-CAR GARAGE, PLUS EXCEPTIONAL OUTDOOR AMENITIES INCLUDING A BAR SHED, SMOKEHOUSE, AND YOUR OWN PRIVATE DOCK- IDEAL FOR BOATING, FISHING, AND ENJOYING BAY LIFE TO THE FULLEST. THIS BAY FRONT PROPERTY IS ONLY STEPS AWAY FROM A LOCAL WINERY AND MINUTES TO THE AREAS RESTAURANTS, SHOPS AND MARINAS IN DOWNTOWN FAIR HAVEN.
WITH 80' OF BAY FRONTAGE, GREAT BONES AND A SOLID FOUNDATION, THIS UNIQUE PROPERTY IS A FANTASTIC OPPORTUNITY TO CUSTOMIZE AND CREATE YOUR DREAM WATERFRONT RETREAT. DON’T MISS YOUR CHANCE TO OWN A SLICE OF PARADISE WITH ENDLESS POTENTIAL!
***OFFERS RECEIVED, HIGHEST & BEST OFFER DEADLINE 4/22 AT 3PM***
Pending
$524,900
14684 Ingersoll Rd, Sterling, NY 13156
5beds
2,153sqft
Single Family Residence
Built in 1973
0.28 Acres Lot
$-- Zestimate®
$244/sqft
$-- HOA
What's special
Private dockBreathtaking viewsBar shedFunctional kitchen
- 73 days |
- 38 |
- 0 |
Zillow last checked:
Listing updated:
Listed by:
Century 21 Leah's Signature 315-598-1165,
Victoria Grutzik 315-806-1322
Source: NYSAMLSs,MLS#: S1672684
Originating MLS: Syracuse
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 1
- Main level bedrooms: 1
Heating
- Other, See Remarks, None
Cooling
- Other, See Remarks
Appliances
- Included: Dryer, Electric Oven, Electric Range, Electric Water Heater, Microwave, Refrigerator, Washer
- Laundry: Main Level
Features
- Separate/Formal Living Room, Country Kitchen, Kitchen Island, Bedroom on Main Level
- Flooring: Hardwood, Tile, Varies
- Number of fireplaces: 1
Interior area
- Total structure area: 2,153
- Total interior livable area: 2,153 sqft
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Attached, Garage
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Balcony, Deck
- Exterior features: Blacktop Driveway, Balcony, Deck, Dock, See Remarks
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Beach Access, Bayfront, Dock Access
- Body of water: Little Sodus Bay
- Frontage length: 80
Lot
- Size: 0.28 Acres
- Dimensions: 70 x 172
- Features: Rectangular, Rectangular Lot, Residential Lot
Details
- Additional structures: Shed(s), Storage
- Parcel number: 05560100801100010550000000
- Special conditions: Estate,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Wood Siding
- Foundation: Pillar/Post/Pier, Slab
Condition
- Resale
- Year built: 1973
Utilities & green energy
- Sewer: Connected
- Water: Connected, Public
- Utilities for property: Sewer Connected, Water Connected
Community & HOA
Community
- Subdivision: Robert G Ingersoll Cottag
Location
- Region: Sterling
Financial & listing details
- Price per square foot: $244/sqft
- Tax assessed value: $239,500
- Annual tax amount: $7,777
- Date on market: 4/13/2026
- Cumulative days on market: 73 days
- Listing terms: Cash,Conventional
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 4/23/2026 | Pending sale | $524,900$244/sqft |
Source: | ||
| 4/13/2026 | Listed for sale | $524,900$244/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2018 | $3,337 | $239,500 |
| 2017 | $3,337 | $239,500 |
| 2016 | -- | $239,500 +7.5% |
| 2015 | -- | $222,800 |
| 2014 | -- | $222,800 |
Find assessor info on the county website
Monthly payment
Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: Fair Haven
Nearby schools
GreatSchools rating
- 5/10Margaret W Cuyler Elementary SchoolGrades: PK-5Distance: 6.1 mi
- 6/10Red Creek Middle SchoolGrades: 6-8Distance: 6.1 mi
- 4/10Red Creek High SchoolGrades: 9-12Distance: 6.1 mi
Schools provided by the listing agent
- District: Red Creek
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
- New York
- Cayuga County
- Sterling
- 13156
- Fair Haven
- 14684 Ingersoll Rd




