Property Lookup
Property Lookup
  • For Sale
  • For Lease
  • Recently Sold
  • Property Lookup
  • Brokers
Back to Search
Property profile & analytics

1297 Brookview Station Rd Castleton-on-Hudson, NY 12033

  • Commercial real estate
  • 12,648 SF
  • 117.63 lot acres
OFF-MARKET
Value Estimation
Location Intelligence
Property ID
US63-2674898
The Realmo ID is a unique identifier assigned to every property, incorporating country codes and precise geo-coordinates for 300x300-foot land blocks. It enables standardized data collection and seamless integration of disparate sources such as ownership, tax, title data and physical specifications. By aggregating current and historical records, the Realmo ID powers advanced analytics and delivers deep, verifiable insights for real estate professionals.

Current Use by Public Records

  • Windy Hill Orchard / Orchard
  • Windy Hill Cidery & Winery / Cider Bar

Property Details for 1297 Brookview Station Rd

Year built
1830
Lot size
117.63 lot acres
Property size
12,648 SF
Property type
Commercial real estate

Description

This exceptional 117.63-acre property in Castleton-on-Hudson, NY, presents a unique investment opportunity. Known as Windy Hill Orchard, this established farm boasts a 12,648 square foot main building, encompassing retail space, ample storage, and office areas. The existing retail operation offers a proven track record and benefits from a strong reputation for quality products and seasonal events. The property includes a substantial parking area accommodating 4,000 vehicles, primarily unpaved. Infrastructure includes a septic tank, well water, and 200-amp three-phase electric service. Heating options are diverse, featuring electric, forced air, natural gas, oil, pellet stove, and propane systems, while cooling is provided by a central air system and other methods. The buildings feature a mix of asphalt, metal, rubber, and shingle roofing. The property is zoned RA - Residential Agriculture, offering flexibility for future development. Built in 1830, the property includes nine at-grade doors and three loading docks, enhancing operational efficiency. The substantial lot size provides ample space for expansion or diversification of existing operations. This turnkey operation includes real estate, business assets, and existing furniture, fixtures, and equipment. The property's idyllic setting and established reputation make it an attractive investment for both agricultural and commercial ventures. The address is 1297 Brookview Station Rd, Castleton-on-Hudson, NY 12033. The asking price is $2,200,000.

Value Estimation

Powered by Realmo proprietary methodology Last update: July 3, 2025
  • CAP approach

  • Comparable approach

  • Alternative Use

Location Insight

  • Map
  • Local Demand
City
Castleton-on-Hudson
County
Rensselaer
State
New York
Longitude
-73.7092392
Latitude
42.5376724
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message