1620 Columbia Tpke Berne, NY 12023
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.
Cap rate
Implied · in-place · derived from last sale + estimated NOIValue
AI, CAP & Alternative Use estimations · Realmo proprietary blendComparables
6 recent transactions · within 1.5 miComparable in this City
Similar Nearby for Sale
Property description
Physical attributes from public recordsZoning & alternative use
No recorded transactions found for this property.
Costs & Benchmarks
Operating expenses, capex projections, utility benchmarks, and submarket comparables — all in one view.
Risks
Flood, climate, environmental, title, and tenant-concentration risk — surfaced with mitigations and source citations.