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 14684 Ingersoll Road, Sterling, NY 13156
IN ESCROW
0
$524,900

14684 Ingersoll RoadSterling, NY, 13156

5 Beds2 Baths2,153 SqFt0.2764 Acres
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!
1 / 47

Est. Monthly

$2,488/mo

$524,900

14684 Ingersoll Road, Sterling, NY

5 Beds2 Baths2,153 SqFt0.2764 Acres

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!

StatusIn Escrow
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built1973
Total Rooms10 rooms
Days on Market44 days

Est. Monthly Payment

$2,488.01

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

14684 Ingersoll Road

Sterling, NY 13156 • Cayuga
5
Beds
2
Baths
2,153
SqFt
0.2764
Acres
Status
In Escrow
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
197353 years ago
Total Rooms
10 rooms
Days on Market
44 days
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $7,777
Property History
  • Listed for sale
    Apr 13, 2026 • NYSAMLS • S1672684
    $524,900
Mortgage Calculator
Estimated monthly payment for this property
$2,488.01
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
    NYSAMLS
  • MLS#
    S1672684
  • Listing Office
    Century 21 Leah's Signature
  • Last Updated
    33 days ago

Appliances

  • Appliances
    • Dryer
    • Electric Oven
    • Electric Range
    • Electric Water Heater
    • Microwave
    • Refrigerator
    • Washer

Climate & Systems

  • Heating
    • Other
    • See Remarks
    • None

Interior Features

  • Flooring
    • Hardwood
    • Tile
    • Varies
  • Interior Features
    • Separate Formal Living Room
    • Country Kitchen
    • Kitchen Island
    • Bedroom On Main Level

Parking

  • Parking Features
    • Attached
    • Garage
  • Garage Spaces
    2

Lot & Grounds

  • Lot Size
    0.2764 acres
  • Lot Features
    • Rectangular
    • Rectangular Lot
    • Residential Lot
  • View
    Water
  • Patio & Porch
    • Balcony
    • Deck
  • Exterior Features
    • Blacktop Driveway
    • Balcony
    • Deck
    • Dock
    • See Remarks

Type

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

Structure

  • Construction
    Wood Siding
  • Foundation
    • Pillar Post Pier
    • Slab

Condition

  • Year Built
    1973
  • Condition
    Resale
  • Days on Market
    44 days
  • Water
    Connected
  • Sewer
    Connected
  • Utilities
    • Sewer Connected
    • Water Connected

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 →
  • 5414 Hamilton Pt, Richmond, NY 14471ACTIVE$474,900

    5414 Hamilton Pt, Richmond, NY 14471

    3 Beds1 Bath820 SqFt0.17 Acres

    LISTING BY HOWARD HANNA

  • 900 Northumberland Street, Morristown, NY 13664ACTIVE$474,900

    900 Northumberland Street, Morristown, NY 13664

    3 Beds2 Baths1,718 SqFt0.55 Acres

    LISTING BY LAKE ONTARIO REALTY, LLC

  • 1707 Pompey Center Road, Fabius, NY 13063ACTIVE$474,900

    1707 Pompey Center Road, Fabius, NY 13063

    9 Beds5.5 Baths2,182 SqFt10.39 Acres

    LISTING BY WEICHERT, REALTORS-TBG

  • 11991 Route 19, Hume, NY 14735ACTIVE$474,900

    11991 Route 19, Hume, NY 14735

    5 Beds2 Baths3,296 SqFt12 Acres

    LISTING BY NEXT HOME BRIXWOOD

  • 143 Pawnee Drive, Webb, NY 13420ACTIVE$474,900

    143 Pawnee Drive, Webb, NY 13420

    2 Beds2 Baths992 SqFt0.39 Acres

    LISTING BY ROCKY POINT PROPERTIES, INC.

  • 4 Wallingford Court, Moreau, NY 12831ACTIVE$474,900

    4 Wallingford Court, Moreau, NY 12831

    4 Beds2.5 Baths1,968 SqFt1.4 Acres

    LISTING BY RED DOOR REALTY NY INC

  • 2797 Gunn Road, Troupsburg, NY 14885ACTIVE$474,900

    2797 Gunn Road, Troupsburg, NY 14885

    4 Beds3 Baths3,380 SqFt36.5 Acres

    LISTING BY HOWARD HANNA

  • 4146 W Lake Road, Chautauqua, NY 14757ACTIVE$474,900

    4146 W Lake Road, Chautauqua, NY 14757

    3 Beds3 Baths1,512 SqFt0.71 Acres

    LISTING BY REAL ESTATE ADVANTAGE

  • 241 Sand Creek Road, Colonie, NY 12205ACTIVE$474,900

    241 Sand Creek Road, Colonie, NY 12205

    3 Beds1.5 Baths1,892 SqFt3.4 Acres

    LISTING BY HOWARD HANNA CAPITAL INC

  • 14452 Stafford Street, Sterling, NY 13156ACTIVE$474,900

    14452 Stafford Street, Sterling, NY 13156

    5 Beds2 Baths1,868 SqFt9.1 Acres

    LISTING BY CENTURY 21 LEAH'S SIGNATURE