Building Details

Building materials Steel Beam

Roof type Shingle

Listing Agency: Barns & Farms Realty LLC d***@hvreal.com Show Phone

Listed By: David Birch · License #49BI0655816 Show Phone

Added: Jul 16 Changed: Oct 2 Last Checked: Oct 19 at 12:06PM

Report an Issue

MLS# 202621952

Copyright © 2026 Global MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Ask AI about this property

Review the available facts, identify missing information and prepare questions for the agent.

What should I ask the agent before proceeding? What information is missing from this listing?

Investment Insights

Based on property information with market context.

This restaurant facility includes separate bar and dining operations alongside an adjoining ballroom suited to dancing or private affairs. The property occupies 1.66 acres and features steel-beam construction, a shingle roof, forced-air heat, central air, and an accessible approach with ramp.

Located at 17 Cherry Plain Square in Berlin, the property sits just off Route 22 and near Ski Jiminy. A creek is among the site’s waterfront features. Water service is provided by a well, with septic tank sewer service.

Key Highlights

• Separate bar and restaurant areas with adjoining ballroom
• 1.66‑acre commercial property in Berlin, NY
• Located just off Route 22 near Ski Jiminy

Financial Insights

Estimated NOI and Cap Rate

NOI / Yr

$85,358

Cap Rate

9.08%

Suggested Prices Based on Cap Rates

Cap Rate 5%

$1,707,160 $1.7M

Cap Rate 7%

$1,219,400 $1.2M

Cap Rate 9%

$948,422 $948.4K

Is this asking price fair?

Market Conditions

NOI Build-Up for 5,500 SF

Gross rent

$118.8K $21.60/SF

− Vacancy

−$5.0K −$0.91/SF

EGI

$113.8K $20.69/SF

− OpEx

−$28.5K −$5.17/SF

NOI

$85.4K $15.52/SF

Area

Rensselaer County, NY

Vacancy

4.20%

Lease Rate

$21.60 /SF/Yr

Expense Ratio

25.00%

Simulate Cap Rate and NOI

Suggested Prices Based on Cap Rates

Cap Rate 5%

$1,707,160

Cap Rate 7%

$1,219,400

Cap Rate 9%

$948,422

Alternative Uses

Best Use

Specialty Retail

$1.22M

$1.07M – $1.42M (±1% cap)

NOI $85,358 @ 7.0% cap · market cap 9.08%

Second Best

—

—

no second resolved use

Theoretical Best

Office A

$1.37M

$1.20M – $1.60M (±1% cap)

NOI $96,244 @ 7.0% cap · market cap 10.24%

Zoning and permitted uses should be independently verified with authorities. How Realmo checks its estimates

Property Analytics

Unlock full access to Insights Subscribe to Realmo Intelligence

Open Analytics

Current Use

Conventional restaurants

Suggested Use

Top Pick Food Market Restaurant Bar & Pub

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

Turnkey business

Opportunity

Yes

Highway access

Yes

Paved road access

Location Intelligence

Trade Area within ½ mile

14

Businesses Nearby

Well-served

Demand for This Use

Explore this area Business Placement

Demographics for 12022, NY

896

Population

455

Households

2

Avg Household Size

45

Median Age

25%

College-Educated

81%

High-School Grad

23.7 sq mi

ZIP Area

38

Density / Sq Mi

$77,386

Median Household Income

$41,532

Median Earnings

$1,073

Median Rent

$179,700

Median Home Value

Market

Vacancy Rate% for Retail in Northeast region

6% 2019

7.1% 2020

6.5% 2021

6% 2022

5.7% 2023

5.6% 2024

6% 2025

Frequently Asked Questions

What type of property is this?

Conventional restaurant - Commercially zoned property combines food-service areas with an adjoining event room.

Where is this conventional restaurant located?

The property is located at 17 Cherry Plain Square Berlin, NY.

What is the asking price?

The asking price for this property is $940,000.

What are key features of this property?

This property features: Separate bar and restaurant areas with adjoining ballroom; 1.66‑acre commercial property in Berlin, NY; Located just off Route 22 near Ski Jiminy