Technical
Financial
Distress signals
Property profile

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

OFF-MARKET
Retail properties & Spaces
Property ID
US63-2674898
12,648 SF 117.63 ac lot Built 1830
Individually Owned
Saved · see the list in your Dashboard

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 Retail properties & Spaces
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

Current use

Occupant on record · Public records
  • Orchard
  • Bar & Pub

Location

1297 Brookview Station Rd Castleton-on-Hudson, NY 12033
Castleton-on-Hudson metro
Google Maps

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

since 2026
4 recorded transactions
2026
$40,000
2025
$1.8M
2019
$1.0M
2019
Price N/A

Comparables

6 recent transactions · within 1.5 mi
Comparable in this city
6 recent transactions
Recent comparable sales
Sale price & price/SF · Sale date & distance · Adjustments & confidence
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.
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