Realmo Analytics
Unlock property reports, ownership, financials, or compile property list owners likely to sell.
We will call you to discuss how Realmo analytics may help you.
Property summary
This exceptional mixed-use property in Castleton-on-Hudson, NY, presents a unique investment opportunity. Located at 1620 Columbia Turnpike, this 4,120 square foot building sits on a 1.03-acre lot with 208.8 feet of road frontage, experiencing high traffic volume (approximately 25,000+ vehicles daily). The property features a former restaurant space with a fully equipped kitchen, offering potential for a bar/restaurant, bed and breakfast, or other commercial ventures. Above the commercial… space are three renovated apartments, each with separate utility meters, hardwood floors, wall-to-wall carpeting, new appliances, and fresh paint. A charming two-bedroom cottage is situated at the rear of the property. The building, constructed in 1829, is a two-story structure with 30 parking spaces and is zoned HC. Utilities include natural gas, a private well, and septic system, with public water hook-up availability. Its convenient location offers close proximity to shopping centers, restaurants, Albany, and the New York State Thruway. The property includes four units in total. The asking price is $310,000. APN: 178.-11-21.
Ownership intelligence
Owner of record from public deeds, plus portfolio, hold profile and investor signals where the data supports them. Included with a plan.
Owner contacts
Skip-traced phones and e-mails of the owner. Included with a plan.
Debts
Recorded lenders, amounts and estimated maturities of the owner's loan book — included with a plan.
Property tax
No data for this sectionNo tax or assessment record is on file for this parcel in the county feed.
Value estimate
· Nov 2026No data for this sectionNo value estimate could be modeled: the record carries too little market input for this parcel.
Recently sold
No data for this sectionNo cleaned sale $/SF benchmark exists for this use type in this ZIP, submarket or county yet.
Cap rate analysis
No income signal is modeled for this parcel yet — the Cap Rates tab runs the workflow.
Zoning insight
No data for this sectionNo zoning code is on file for this parcel. Coverage grows with every catalog release.
Location intelligence
Location
Every figure names its source: public record, benchmark, or modeled. Coverage varies by property — thin data is stated as missing, never invented.
Comparables
1 recorded sale · 5 properties nearbyComparable nearby
Instant AI valuation built from comps, income signals, and proprietary benchmarks.A defensible range, not a single guess.
from $199/month
- GBA
- 4,120 SF
- Lot area
- 1.03 ac
- Year built
- 1829
Cap rate calculated from real income and expense signals, benchmarked against sales of similar assets nearby.
from $199/month
The recorded zoning designation, what the district officially allows, and the municipal source it comes from.
No zoning code is on file for this parcel. Zoning coverage grows with every catalog release — check back, or open Location Intelligence for use analysis of this corner.
Unlock the evidence behind ownership: portfolio, transactions, debt and any signals we can model, to help you decide who to contact next.
Registration is required before any owner information is shown.
Phones and e-mails of the people behind this property's owner, traced from licensed contact data.
Owner phones and e-mails come with a plan - traced from licensed contact data, with verification and Do-Not-Call flags on every number.
The mortgage data comes with a plan: recorded loans of the owner - lender, amount, rate and the estimated maturity - as part of the Ownership Intelligence workspace.
Registration is required before any owner information is shown.
Rey answers here. ChatGPT, Grok and Claude get the same data packet.
Includes: Price & PSF · Cap rate · Location · Zoning
Our comps and market reports get this label in your Google results.
One click on Google
- 10 Targeted Leads
- 1 Full Property Report
- Lead Lists by Intent
- Signals & Scores
- Building Details
- Value Estimation
- Cap Rate Evaluation
- Liens & Mortgages
- Ownership & Contacts
- Local Market trends
- Zoning Insight
- Location Analytics
- 300 Targeted Leads a month
- 30 Full Property Reports
- Lead Lists by Intent
- Signals & Scores
- Building Details
- Value Estimation
- Cap Rate Evaluation
- Liens & Mortgages
- Ownership & Contacts
- Local Market trends
- Zoning Insight
- Location Analytics
- 1,500 Targeted Leads a month
- 150 Full Property Reports
- Lead Lists by Intent
- Signals & Scores
- Building Details
- Value Estimation
- Cap Rate Evaluation
- Liens & Mortgages
- Ownership & Contacts
- Local Market trends
- Zoning Insight
- Location Analytics
The PDF can’t be displayed here
Use Download PDF or Open in new tab above to view the sample report.
Sample leads
-
Off Market
1201, CAPTAINS BAY RD, AK
Absentee
1201, CAPTAINS BAY RD, AK
-
Off Market
AK
Absentee
AK
-
Off Market
W, BROADWAY, AK
Absentee
W, BROADWAY, AK
-
Off Market
551 W, BROADWAY, AK
Absentee
551 W, BROADWAY, AK
Sample leads
-
Off Market
1404, ATS, AK
Loan from 20067.7% rateColumbia State Bank
1404, ATS, AK
-
Off Market
1503, BALLYHOO RD, AK
Loan from 2009Columbia State Bank
1503, BALLYHOO RD, AK
-
Off Market
721 E, DEPOT DR, AK
Loan from 2019Northrim Bank
721 E, DEPOT DR, AK
-
Off Market
AK
Loan from 2019Northrim Bk
AK
Still being built. It lands here next, beside the two above.
The PDF can’t be displayed here
Your browser has no PDF viewer of its own.
