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

1620 Columbia Tpke Berne, NY 12023

4,120 SF 1.03 ac lot Built 1829
Property ID
Property summary
AI-generated overview

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.

Property profile
Verified
Property type Retail properties & Spaces
Year built 1829
Total area 4,120 SF
Lot 1.03 ac (44,867 SF)
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
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
Owner on record
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 1620 Columbia Tpke?
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