Waterfront Restaurant in Barcelona
For Sale
Contact for pricing
8254 1st St, Westfield, NY 14787
Turnkey waterfront restaurant with bar, dining, and lakeside tiki bar.
Property Size4,938 SF
Price / SF$303.75
Days on Market142
Property Features for 8254 1st St
General Information
Standard status
Active
Size
4,938 SF
Property subtype
Business for Sale, Land
Zoning
C
Building Details
Stories
1
Listing Agency:
Agresti Real Estate
(814) 449-7973
Listed By:
Jake Scheloske · License #PA RS.318016
Source:
Crexi
Added: Mar 24
Changed: Aug 8
Last Checked: Aug 11 at 7:44AM
Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of Agresti Real Estate
Investment Insights
Based on property information with market context.
This is an opportunity to own a waterfront restaurant and building located in Barcelona Harbor, New York, along the shores of Lake Erie. The property offers direct waterfront access. Inside, there is a full bar and a dining space. The sale includes all furniture, fixtures, and equipment. The commercial kitchen features deep fryers, stoves, ovens, a dishwashing station, and a walk-in refrigerator and freezer. Outside, there is a tiki bar and a koi pond. Guests can access the restaurant by boat. The property size is 4938 square feet. This established waterfront business has views, character, and income potential on Lake Erie. It is currently operating as When Pigs Fly BBQ Pit.
Key Highlights
- Direct waterfront access on Lake Erie
- Turnkey restaurant business opportunity, includes all furniture, fixtures, and equipment
- Fully equipped commercial kitchen with deep fryers, stoves, ovens, dishwashing station, walk‑in refrigerator and freezer
Financial Insights
Estimated NOI and Cap Rate
NOI = area × lease_rate × (100 − vacancy) / 100 × (1 − expense_ratio). Net Operating Income — what the owner takes home each year before mortgage payments and income tax. Effective rent (asking rent minus vacancy losses) minus operating costs (taxes, insurance, maintenance, management).
NOI / Yr
$64,930
Cap rate = NOI / list price × 100. Capitalization rate — annual return on a fully cash purchase, before financing. NOI divided by price. Higher means more income per dollar invested, but usually also more risk or older condition. 5–8% is typical for stabilized commercial property; double digits often signal distressed deals.
Cap Rate
4.33%
Suggested Prices Based on Cap Rates
Cap rates vary significantly by property type, market, and asset quality.
Typical U.S. stable-market ranges:
Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+)
Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand)
Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically)
Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher)
Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk)
Self-Storage — 5.5% to 7.5%
Medical Office — 6.0% to 7.5%
Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term
Rules of thumb:
Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%).
Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C.
Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI.
Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
Cap Rate 5%
$1,298,600
$1.3M
Cap Rate 7%
$927,571
$927.6K
Cap Rate 9%
$721,444
$721.4K
Market Conditions
NOI Build-Up for 4,938 SF
Vacancy — income lost from leasable area expected to sit empty during the year, subtracted from gross rent.
EGI (Effective Gross Income) — gross rent minus vacancy losses, the realistic income before paying operating costs.
OpEx (Operating Expenses) — recurring costs to operate the property (property tax, insurance, utilities, maintenance, management); excludes financing and capital improvements.
NOI (Net Operating Income) — income a property generates after operating costs but before financing and taxes.
Gross rent
$88.9K $18.00/SF
− Vacancy
−$2.3K −$0.47/SF
EGI
$86.6K $17.53/SF
− OpEx
−$21.6K −$4.38/SF
NOI
$64.9K $13.15/SF
Area
Chautauqua County, NY
Vacancy
2.60%
Lease Rate
$18.00 /SF/Yr
Expense Ratio
25.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap rates vary significantly by property type, market, and asset quality.
Typical U.S. stable-market ranges:
Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+)
Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand)
Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically)
Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher)
Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk)
Self-Storage — 5.5% to 7.5%
Medical Office — 6.0% to 7.5%
Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term
Rules of thumb:
Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%).
Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C.
Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI.
Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
Cap Rate 5%
$1,298,600
Cap Rate 7%
$927,571
Cap Rate 9%
$721,444
Alternative Uses
Best Use
Specialty Retail
$927.6K
$811.6K – $1.08M
NOI $64,930 @ 7.0% cap · market cap 4.33%
Second Best
—
—
no second resolved use
Theoretical Best
Office A
$1.48M
$1.29M – $1.72M
NOI $103,461 @ 7.0% cap · market cap 6.90%
Zoning and permitted uses should be independently verified with authorities.
Property Analytics
Property Profile
Current Use
Location Intelligence
Trade Area within ½ mile
47
Businesses Nearby
Well-served
Demand for This Use
Explore this area
Business Placement
Demographics for 14787, NY
4,825
Population
2,669
Households
1.8
Avg Household Size
49
Median Age
29%
College-Educated
89%
High-School Grad
42.7 sq mi
ZIP Area
113
Density / Sq Mi
$47,656
Median Household Income
$46,684
Median Earnings
$685
Median Rent
$116,100
Median Home Value
Market
Vacancy Rate% for Retail in Northeast region
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.
Frequently Asked Questions
What type of property is this?
Conventional restaurant - Turnkey waterfront restaurant with bar, dining, and lakeside tiki bar.
Where is this conventional restaurant located?
The property is located at 8254 1st St Westfield, NY.
What is the asking price?
The asking price for this property is $1,499,900.
What are key features of this property?
This property features: Direct waterfront access on Lake Erie; Turnkey restaurant business opportunity, includes all furniture, fixtures, and equipment; Fully equipped commercial kitchen with deep fryers, stoves, ovens, dishwashing station, walk‑in refrigerator and freezer
