Property Attributes
- MLS#20260291
- TypeSingle Family
- Listing Status Active
- CountyColumbia
- CityStuyvesant
- AreaStuyvesant
- Zip12156
- StyleFrench Provincial
- Year Built2003
- Taxes$ 34761
- Price$ 3,850,000
- Bedrooms5
- Full Bathrooms3
- Half Bathrooms3
- Sqr Footage7974
- Lot Size481 Acres
Data Source:
Ulster County MLS
Property Description
A private outdoor paradise perfect for recreation, agriculture, equestrian or hunting. This 9,565 sqft home has all one could ask for. Offering spacious living areas, hardwood floors, custom media room perfect for movie nights, sizable bedrooms, finished walk-out basement, there's ample space for both family and guests to gather and unwind. With spa/hot tub room, gym, a 2,400 sq. ft. heated garage with finished game room above, two accessory buildings providing additional storage or use as garden sheds, all connected by a stone patio with a covered grilling area ensure non stop fun and entertainment. Plus central air conditioning, backup generator, and high-speed internet. The home sits on 481 acres comprised of stunning forests and expansive fields, the property boasts 7+ miles of trails, 3 ponds, stream and reaches all the way to Schodack creek which ties to the Hudson River.
| Price History | |
|---|---|
| 1/22/2026 | Listed $4,200,000 |
| 5/12/2026 | 8$3,850,000 |
General Features
| Sewer | Septic Tank |
|---|---|
| Heating | Baseboard,Hot Water,Oil,Propane |
| Cooling | Central Air |
| Roof | Asphalt,Shingle |
| Appliances | Water Heater,Washer/Dryer,Washer,Refrigerator,Oven,Microwave,Freezer,Dryer,Dishwasher,Cooktop,Convection Oven |
| Zoning | Res |
| Garage Spaces | 4 |
| Patio/Porch Features | Patio |
| Architectural Style | French Provincial |
| Security Features | Security System |
| Construction Materials | Asphalt,Brick,Clapboard,Concrete,Frame,Stone,Other |
| Year Built | 2003 |
| Electric | 220 Volts |
| View | Forest,Meadow,Pasture,Pond,Rural,Water |
| Stories Count | 2 |
| Township | Stuyvesant |
| Property Subtype | Single Family Residence |
| Community Features | Fishing |
| County | Columbia |
| New Construction | false |
| Property Type | Residential |
| Attached Garage | true |
| Garage Y/N | true |
| Other Structures | Barn(s),Garage(s),Gazebo,Storage,Workshop |
| Full Baths | 3 |
| Status | Active |
| City | Stuyvesant |
| High School District | Ichabod Crane |
| MLS Area | Stuyvesant |
| Lot Size Units | Acres |
| Lot Size Square Feet | 20952360 |
| Tax Annual Amount | 34761 |
| MLS Area Minor | Stuyvesant |
| Standard Status | Active |
| Tax Assessed Value | 3400000 |
| Tax Lot | 20.112 |
| Legal Description | Rural/Agricultural |
| New Construction | false |
Interior Features
| Interior Amenities | Built-in Features,Cathedral Ceiling(s),Dry Bar,Eat-in Kitchen,Entrance Foyer,High Speed Internet,Hot Tub,In-Law Floorplan,Kitchen Island,Recreation Room |
|---|---|
| Basement | Exterior Entry,Finished,Full,Walk-Out Access |
| Flooring | Hardwood |
| Basement (Y/N) | true |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Above Grade Finished Area | 7974 |
| Half Baths | 3 |
| Laundry Features | Laundry Closet,Laundry Room,Main Level |
| Total Bedrooms | 5 |
| Below Grade Finished Area | 1591 |
| Total Baths | 6 |
Exterior Features
| Exterior Amenities | Dog Run,Lighting,Storage |
|---|---|
| Parking Features | Asphalt,Circular Driveway,Garage Faces Front,Driveway,Additional Parking |
| Lot Features | Agricultural,Back Yard,Many Trees,Meadow,Pasture,Private,Waterfall,Wooded |
| Water Source | Private,Well |
| Lot Size Area | 481 |
| Foundation Details | Concrete Perimeter |
| Building Area Total | 7974 |
| Lot Size Acres | 481 |
| Road Surface Type | Asphalt,Paved |
| Door Features | French Doors,Sliding Doors |
| Other Equipment | Other |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
©2019 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance
Information should be deemed reliable but not guaranteed, all representations are approximate, and individual verification is recommended. Copyright ©2018 All rights reserved. Last Update: September 24, 2026 8:15 AM UTC