1297 Brookview Station Rd Castleton On Hudson, NY 12033
Estimated payment $12,849/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
Est. Annual Taxes
- $16,006
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 | $16,006 | $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
- L2 S Old Post Rd
- 966 Maple Hill Rd
- 2208 Brookview Rd
- 1707 Champagne Dr
- 847 Maple Hill Rd
- 84 Schuurman Rd
- 1468 Castleridge Rd
- 918 Ridgeview Cir
- 926 Ridgeview Cir
- 1480 Castleridge Rd
- 124 Schuurman Rd
- 20 Orchard Rd
- L1 Northern Blvd
- 1341 S Schodack Rd
- 4 Bellwood Ln
- 1140 van Hoesen Rd
- 10 Edgewood Terrace Unit 4
- 10 Edgewood Terrace Unit 2
- 27 Krista Ln
- 4 Horizon View Dr W
- 4 Horizon View Dr W Unit 3
- 5 Horizon View Dr W
- 737 Columbia Turnpike
- 2490 Pond View
- 95 Gilligan Rd
- 580 Columbia Turnpike Unit 204
- 580 Columbia Turnpike Unit 211
- 580 Columbia Turnpike Unit 201
- 580 Columbia Turnpike
- 365 Woodward Rd Unit One bedroom fully furnished rental
- 578 Columbia Turnpike Unit 207
- 1 Forrest Pointe Dr
- 73 Rockrose Dr
- 1-16 Mill Creek Dr
- 36 Donna Lynn Dr
- 43 Commons Dr