Sharon FronkRealtor® · Howard Hanna
LoadingActive
$11,100 price cut · was $99,900
$88,800
45 Stimpson Avenue
Castleton-on-Hudson, NY 12033 · Rensselaer County
2Beds
1Baths
770Sq Ft
0.16 acresLot Size
1939Year Built
$115Per Sq Ft
Est. P&I $449/moGet pre-qualified
Single Family 92 days on market
MLS# 202619046 Updated 2 months ago
Sharon’s Take
This 1939 cottage in Castleton-on-Hudson offers 770 square feet on a modest lot with potential for renovation. The two-bedroom, one-bath home is priced for investors and requires significant work. Located in this walkable river village near Riverfront Park and minutes from Albany, the property sits in the Maple Hill Central school district with no HOA fees. The listing is for cash buyers only and sells as-is.
Sharon Fronk · Howard Hanna Capital Region
About this property
FIX & FLIP. Nice area, potential galore. Great schools, Needs major renovation. Selling AS IS! Assignment of contract, cash (bank check) buyers only. Do all inspections before making offer. 10% deposit required.
Is it priced right?
The price signals we can read on this listing today. For a true sense of value against recent Castleton-on-Hudson sales, Sharon will pull the comparable closings and walk you through them.
Price per sq ft
$115
Days on market
92
Price reduced
$11,100
from $99,900
Curious whether this home is priced right for the neighborhood?
Ask Sharon for the compsProperty details
32 facts pulled straight from the MLS listing.
Overview
Property TypeSingle Family
Sub-TypeSingle Family Residence
Year Built1939
Days on Market92
StatusActive
MLS Number202619046
ListedJune 8, 2026
Interior
Bedrooms2
Bathrooms1 full
Living Area770 sq ft
Heating
Other
Flooring
WoodCeramic Tile
Basement
Crawl Space
Exterior & Lot
Lot Size0.16 acres
Lot Features
OtherLevelLandscaped
Exterior Features
Other
Building & Construction
Architectural Style
Cottage
Construction
Other
Roof
Other
Foundation
Combination
Sewer
Public Sewer
Water Source
Public
Financial
List Price$88,800
Price per Sq Ft$115
Original List Price$99,900
Listing Terms
Cash
Est. Monthly P&I$449/mo
Location
CountyRensselaer
School DistrictSchodack
Listing Details
Listed ByArnold J Greenberg of Starr Real Estate
Data SourceSpark Platform / Global MLS
Last UpdatedJul 9, 2026
What's nearby
Google Maps view. Pan, zoom, click a pin to read about a business or place.
Commute Planner
Plan a multi-stop route from this address: drop-off the kid, hit the office, head home. Live traffic from Google.
- Start45 Stimpson Avenue, Castleton-on-Hudson, NY 12033
Try a preset
Schools
The district this address is assigned to. Ratings and reviews are hosted on GreatSchools.
Schodack
Assigned school district
Assigned districts can change and are not guaranteed. Confirm enrollment boundaries with the district directly before relying on them.
About Castleton-on-Hudson, NY
Castleton-on-Hudson is in Rensselaer County, NY. There are currently 11 active listings here, ranging from $88,800 to $759,000. Listings in this address fall under the Schodack school district. Priced 63% below the Castleton-on-Hudson median of $239,900.
See Sharon's Castleton-on-Hudson community guideYou might also like
Sharon represents buyers for this property. Your tour, offer, and inquiries go through her, not the listing brokerage.
Starr Real Estate · Listed by Arnold J Greenberg (7117)
Contact: 518-229-8784
MLS #202619046 · 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.
