You're browsing as guest. Top-line numbers are free. Full reports — owner contacts, refine, methodology — are paid. Guest mode. Top-line is free.
Back to Search
Property profile & analytics
OFF-MARKET
Commercial real estate

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

12,648 SF 117.63 ac lot Built 1830
Individually Owned
Property ID
US63-2674898
Property summary
AI-generated overview

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.

Property profile
Verified
Property type Commercial real estate
Year built 1830
Total area 12,648 SF
Lot 117.63 ac (5,123,963 SF)
UPID US63-2674898
Cap rate & NOI
Priority signal for investors
Implied cap rate, NOI & suggested price
Cap rate vs submarket · NOI estimate · 3 price anchors
Implied cap rate, NOI & suggested price
Cap vs submarket · NOI estimate · 3 price anchors
Current use
Occupant on record · Public records
  • Windy Hill Orchard Orchard
  • Windy Hill Cidery & Winery Bar & Pub
Value estimations
Realmo proprietary · 4 methods
AI Approach AI
by Request
CAP Approach CAP
by Request
Comparable Approach Comparable
by Request
Blend (final) Blend
by Request
Owner & transaction history
Eric Seeberger
Eric Seeberger
since 2026
4 recorded transactions
2026
$40,000
2025
$1.8M
2019
$1.0M
2019
Price N/A
Zoning & alternative use
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Try Rey
Ask anything about this address in plain English.
“Is 15.6% cap rate sustainable?” · “Best tenant mix for BU1?” · “What’s the redev upside?”
You own 1297 Brookview Station Rd?
List it free. Reach 20,000 daily buyers.
We’ve already pulled the facts. Confirm photos + price and you’re live in 2 minutes.
List this address →
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