Schenectady, NY 12305 · Schenectady County

This 1900 duplex in Schenectady's historic Stockade District offers six bedrooms and two bathrooms across 2,422 square feet, with each unit holding three bedrooms, a full bath, formal living and dining areas, pantry, and walk-in closets. Original architectural details including stained glass, crown molding, and built-ins are preserved throughout, while the walk-up attic and unfinished basement provide storage and development potential. The detached three-car garage and substantial driveway are notable amenities in this walkable neighborhood steps from the Mohawk River waterfront, parks, restaurants, and downtown. Separate utilities on each unit and no HOA fees add flexibility for owner-occupancy or investment purposes.
Rare opportunity to own a well-maintained two-family home in Schenectady's historic Stockade District. Properties in this neighborhood are always in demand, but finding one with a detached 3-car garage, extensive off-street parking, and a generous driveway is exceptionally uncommon. Just a short stroll to the Mohawk River waterfront, scenic parks, restaurants, and downtown amenities, this home offers the perfect blend of historic charm and everyday convenience. Each spacious apartment features 3 bedrooms, a full bath, formal living and dining rooms, a pantry, walk-in closets, and separate utilities, making it ideal for owner-occupants or investors alike. Original character shines through with details like stained glass, crown molding, and built-in features, while the walk-up attic and basement provide abundant storage and future possibilities. Whether you're looking to build your investment portfolio or enjoy life in one of the Capital Region's most distinctive neighborhoods, 5 Ingersoll Avenue offers an exceptional opportunity in a truly special location.
The price signals we can read on this listing today. For a true sense of value against recent Schenectady sales, Sharon will pull the comparable closings and walk you through them.
Curious whether this home is priced right for the neighborhood?
Ask Sharon for the comps22 facts pulled straight from the MLS listing.
Google Maps view. Pan, zoom, click a pin to read about a business or place.
Plan a multi-stop route from this address: drop-off the kid, hit the office, head home. Live traffic from Google.
Try a preset
The district this address is assigned to. Ratings and reviews are hosted on GreatSchools.
Assigned districts can change and are not guaranteed. Confirm enrollment boundaries with the district directly before relying on them.
Schenectady is in Schenectady County, NY. There are currently 186 active listings here, ranging from $19,000 to $156,200,000. Listings in this address fall under the Schenectady school district. Priced near the area median of $279,900.
See Sharon's Schenectady community guideSharon represents buyers for this property. Your tour, offer, and inquiries go through her, not the listing brokerage.
The Thompson Real Estate Team · Listed by Samuel J Thompson (29516)
Contact: 518-331-6169
MLS #202623923 · Source: Global MLS, Inc.
IDX information is provided exclusively for consumers' personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Sharon Fronk Real Estate is committed to compliance with the Fair Housing Act and provides equal opportunity in housing.
Activity across 3 MLS listings of this property.
Real numbers from current MLS data. Not a third-party estimate.