Realmo Analytics

Get reports on 50M+ commercial properties in the US. Find and target property leads based on your business goal.

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
Last sale Mar 2026 · $40,000
Individually Owned Owner of record is an individual.
Saved · see the list in your Dashboard
Market Trends Soon

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…

Ownership intelligence

Who controls the opportunity?

Owner of record from public deeds, plus portfolio, hold profile and investor signals where the data supports them. Included with a plan.

Owner contacts

Can we reach the decision maker?

Skip-traced phones and e-mails of the owner. Included with a plan.

Debts

What is owed, to whom, and when it comes due

Recorded lenders, amounts and estimated maturities of the owner's loan book — included with a plan.

Property tax

No data for this section
What does the county charge?

No tax or assessment record is on file for this parcel in the county feed.

Value estimate

· Oct 2026No data for this section
What is it worth?

No value estimate could be modeled: the record carries too little market input for this parcel.

Recently sold

No data for this section
What actually traded nearby?

No cleaned sale $/SF benchmark exists for this use type in this ZIP, submarket or county yet.

Cap rate analysis

How does the asset earn?

No income signal is modeled for this parcel yet — the Cap Rates tab runs the workflow.

Zoning insight

No data for this section
What can be built here?

No zoning code is on file for this parcel. Coverage grows with every catalog release.

Location intelligence

Which uses thrive at this corner?
Best fit: Daycare Center
Demand index
Daycare Center7.7

Location

1297 Brookview Station Rd Castleton-on-Hudson, NY 12033
County assessor · not on file Recorded deeds · 4 transfers Qualifying comp sales · not on file Zoning catalog · not on file

Every figure names its source: public record, benchmark, or modeled. Coverage varies by property — thin data is stated as missing, never invented.

Comparables

6 recorded sales · 14 properties nearby
Recent sales nearby
6 recorded sales in this ZIP, last 8 years
Address Sale price Sold Size
33 Commercial, Castleton, NY 12033-1913 $50,000 May 2025 No data
1603 Columbia, Castleton, NY 12033-9543 $360,000 Sep 2023 2,400 SF
1651 Columbia, Castleton, NY 12033-9534 $200,000 May 2023 11,710 SF
1607 Columbia, Castleton, NY 12033-9579 $300,000 Apr 2022 3,692 SF
Columbia, Castleton On Hudson, NY 12033 $875,000 Feb 2021 848 SF
1817 Columbia, Castleton, NY 12033-9621 $110,000 Jun 2020 2,192 SF
Sale prices and dates as our records hold them, one row per building. A deed can cover more of a building than the size shown, so read the price against the size rather than dividing one by the other.
Comparable nearby
6 properties of the same type nearby
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
Why this one?
Saved
Reason not saved — we won't ask again