1297 Brookview Station Rd Castleton On Hudson, NY 12033
Estimated payment $15,535/month
About This Lot
Imagine being the proprietor of a 117-acre farm where the views are breath taking and the ambiance includes families and friends stopping by to purchase fresh baked goods in the retail store, picking farm fresh apples eating and drinking in a space where people gather to celebrate milestones events.
Welcome to Windy Hill Orchard, a large farm/orchard with retail operations, various event venues and a single-family home as well as housing for seasonal workers.
Turnkey Listing includes real estate (100+ acres), retail building (gift shop and bakery), commercial kitchen, cidery bar, warehouses (cold storage as well as regular storage), multiple out buildings, single family home currently rented, seasonal housing for workers.
Windy Hill Orchard has a Farm Cidery License and has produced hard cider since 1996. The Windy Hill Hard Cider Bar serves NYS brewed, distilled, beer wine and spirits.
Windy Hill Orchard is located in the Town of Schodack in Rensselaer County.
During the season there are special events featuring bands, food trucks, wagon rides in the orchard. Excellent reputation for quality food, beautiful location, seasonal events. Listing includes real estate, business and furniture, fixtures and equipment.
Please contact Jessica Richer or Karen Wentz for more information at Hanna Commercial Real Estate.
Copyright 2025 Global MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Property Details
Property Type
- Land
Additional Features
- Current uses include orchard, agribusiness
- Apple Orchard
Map
Home Values in the Area
Average Home Value in this Area
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2024 | $47,686 | $861,400 | $328,000 | $533,400 |
| 2023 | $29,794 | $861,400 | $328,000 | $533,400 |
| 2022 | $29,509 | $861,400 | $328,000 | $533,400 |
| 2021 | $29,010 | $861,400 | $328,000 | $533,400 |
| 2020 | $23,073 | $861,400 | $328,000 | $533,400 |
| 2019 | -- | $861,400 | $328,000 | $533,400 |
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 08/30/2024 08/30/24 | For Sale | $2,200,000 | -- | $174 / Sq Ft |
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Deed | $1,800,000 | -- | |
| Deed | $1,025,682 | -- | |
| Deed | -- | -- | |
| Deed | -- | Steven D Farer | |
| Interfamily Deed Transfer | -- | Steven D Farer | |
| Deed | $6,500 | -- | |
| Interfamily Deed Transfer | -- | -- |
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $180,000 | Purchase Money Mortgage | |
| Previous Owner | $900,000 | Purchase Money Mortgage |
- 2 Farm View Dr
- 1898 Brookview Rd
- 5 Strawberry Fields Dr
- 3 Strawberry Fields Dr
- 2208 Brookview Rd
- 84 Schuurman Rd
- 1468 Castleridge Rd
- 918 Ridgeview Cir
- 922 Ridgeview Cir
- 1709 Julianne Dr
- 905 Ridgeview Cir
- 933 Ridgeview Cir
- 124 Schuurman Rd
- 20 Orchard Rd
- L1 Northern Blvd
- 2256 Old Post Rd N
- 1399 van Hoesen Rd
- 4 Bellwood Ln
- 110 Green Ave
- 24 Estate Dr
- 2-4 Horizon View Dr W Unit 11
- 4 Horizon View Dr W
- 4 Horizon View Dr W Unit 3
- 737 Columbia Turnpike
- 2490 Pond View
- 95 Gilligan Rd
- 580 Columbia Turnpike
- 578 Columbia Turnpike Unit 403
- 5 Maine Ave Unit A
- 1 Forrest Pointe Dr
- 1-16 Mill Creek Dr
- 36 Donna Lynn Dr
- 43 Commons Dr
- 26 E Wiggand Dr
- 1035 Us Route 9w
- 100 Orchard St
- 30 Hague Blvd
- 5 Maple St
- 68 Orinsekwa Rd
- 101 Orinsekwa Rd