Property summary
This exceptional investment opportunity presents a 14,564 square foot Walgreens pharmacy located at 1645 Columbia Turnpike, Castleton-on-Hudson, NY 12033. The property sits on a 1.95-acre lot and boasts a 9.00% cap rate with a strong NOI of $412,161. The current lease, a Net Lease (NN) agreement with a credit-rated tenant, expires March 31, 2027, offering 2.4 years of remaining term and five 5-year renewal options with rent bumps of 5% in option 1 and 10% in options 2-5. The building,… constructed in 2000, benefits from a high-traffic location along Columbia Turnpike (12,400 vehicles per day) and proximity to Interstate 90 (36,129 vehicles per day). This location, originally a Rite Aid, was converted by Walgreens in 2018, with Walgreens investing over $300,000 in renovations. The property features a drive-thru pharmacy and enjoys a strong demographic profile, with 28,497 people residing within a five-mile radius, boasting an average annual household income of $120,398. Nearby amenities include Tractor Supply Company, USPS, Curtis Lumber Co., Evergreen Country Club, and two new Amazon Fulfillment Centers less than 1.5 miles away. The asking price is $4,579,567, translating to a price per square foot of $314.44. This is a prime retail investment within the Albany MSA, a highly desirable market. The property's current 100% occupancy and strong sales history make it an attractive addition to any portfolio.
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
Value estimate
· Nov 2026Realmo valuation models over county records and 9 qualifying comparable sales.
Recently sold
Cap rate analysis
No income signal is modeled for this parcel yet — the Cap Rates tab runs the workflow.
Zoning insight
Location intelligence
Demand index: how under-served this business type is around this point — modeled from the LocInt grid (area demand vs. what already operates, adjusted by real visit traffic). Higher means stronger unmet demand.
Location
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 · 6 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
- 14,653 SF
- Lot area
- 1.95 ac
- Year built
- 2007
- Stories
- 1
- APN
- 384489 189.-5-1.12
- Zoning
- HC
- Assessed value · 2023
- $2,500,000
- Commercial (general) · current use
- Office Building
Cap rate calculated from real income and expense signals, benchmarked against sales of similar assets nearby.
from $199/month
Price sensitivity
The rate is the decision lever; valuation is the consequence.
The recorded zoning designation, what the district officially allows, and the municipal source it comes from.
Zoning designation
Registration is required before the official district profile is shown.
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— not in this plan -
Location Analytics— not in this plan
- 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— not in this plan
- 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.