Sharon FronkRealtor® · Howard Hanna
LoadingActive
New Listing
$515,900
Lot 2 Green Avenue
Castleton-on-Hudson, NY 12033 · Rensselaer County
4Beds
2.5Baths
1,900Sq Ft
0.30 acresLot Size
$272Per Sq Ft
Est. P&I $2,609/moGet pre-qualified
Single Family 1 day on market
MLS# 202624994 Updated 10h ago
Sharon’s Take
This new construction colonial in Castleton-on-Hudson offers four bedrooms and two and a half bathrooms in approximately 1,900 square feet. The home includes a fireplace, vaulted ceilings, walk-in closets, and a full unfinished basement for future expansion. Central air, natural gas, high-speed internet, a two-car garage, and a driveway are standard. Located in the Maple Hill High School district near the village center and elementary school, this riverside community provides access to Riverfront Park, walkable Main Street shops and dining, and convenient commuting to Albany and points south.
Sharon Fronk · Howard Hanna Capital Region
About this property
New Construction offered by EW Birch Builders! Close to Village and near elementary school! Features 4 bed, 2.5 bath Colonial or choose from variety of models to make your own! High end features including slider at dining, granite counters, Fireplace, VLT flooring, ceramic tile, blacktop driveway, Versetta Stone accents and more. Schodack Schools. Photos are examples of Finishes.
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
$272
Days on market
1
Fresh listing
Curious whether this home is priced right for the neighborhood?
Ask Sharon for the compsProperty details
21 facts pulled straight from the MLS listing.
Overview
Property TypeSingle Family
Sub-TypeSingle Family Residence
Days on Market1
StatusActive
MLS Number202624994
ListedAugust 28, 2026
Interior
Bedrooms4
Bathrooms2 full, 1 half
Living Area1,900 sq ft
Interior Features
Full Unfinished BasementHigh Speed InternetVaulted Ceiling(s)Walk-In Closet(s)Ceramic Tile BathCentral AirNatural GasFireplace
Exterior & Lot
Lot Size0.30 acres
Exterior Features
LightingGarage2 Car GarageDriveway
Building & Construction
Construction
StoneVinyl Siding
Financial
List Price$515,900
Price per Sq Ft$272
Est. Monthly P&I$2,609/mo
Location
CountyRensselaer
School DistrictSchodack
Listing Details
Listed ByJohn W Mesko of Coldwell Banker Prime Properties
Data SourceSpark Platform / Global MLS
Last UpdatedAug 29, 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.
- StartLot 2 Green 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 115% above 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.
Coldwell Banker Prime Properties · Listed by John W Mesko (8491)
Contact: 518-466-9700
MLS #202624994 · 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.
