Search
Waterfront Restaurant With Full Bar
For Sale
$1,249,900

8254 1ST Street, Westfield, NY 14787

CommercialSale, Westfield, NY

Property Size4,938 SF
Price / SF$253.12
Days on Market285

Property Features for 8254 1ST Street

General Information

Property type Commercial Sale
Property subtype Other
Zoning description C
Parking 50
Elementary school district Westfield
Middle school district Westfield
High school district Westfield
Directions Head East on W Lake Road, Left onto Main St followed by the first Right, When Pigs Fly BBQ Pit on the Left.
Subdivision 99 - Other
Standard status Active
APN 00-0-000000
Size 4,938 SF

Taxes and HOA fees

Tax Year 2025
Tax Annual Amount 12845
Expense value 30000
Expense SecurityDeposit
Expense freq. One Time

Utilities

Sewer type Septic Tank
Heating system Natural Gas, Forced Air
Cooling system Central Air
Water source Public

Amenities

tiki bar
koi pond

Building Details

Year built 1970
Building materials Frame
Listing Agency: Agresti Real Estate
Listed By: Makenzie Agresti · License #AB069569
Added: Jan 6 Changed: Oct 17 Last Checked: Oct 18 at 8:06PM
MLS# 189227

Copyright © 2026 Greater Erie Board of Realtors MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Rey
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.

Investment Insights

Based on property information with market context.

This 4,938-square-foot restaurant property includes a frame building with a full bar, dining area, and commercial kitchen. Kitchen equipment includes deep fryers, stoves, ovens, a dishwashing station, and walk-in refrigeration with freezer capacity. Furniture, fixtures, and equipment are included in the sale. The building was constructed in 1970 and features forced-air heating, natural gas service, central air conditioning, public water, and a septic tank.

The property sits along Lake Erie at Barcelona Harbor and provides direct waterfront access. Exterior features include a tiki bar and koi pond, with space for guests arriving by boat to pull up along the waterfront. The property is located at 8254 1ST Street in Westfield, NY.

Key Highlights

  • 4,938‑square‑foot restaurant building constructed in 1970
  • Direct Lake Erie waterfront access at Barcelona Harbor
  • Full bar, dining area, and commercial kitchen

Financial Insights

Estimated NOI and Cap Rate

NOI / Yr
$64,930
Cap Rate
5.19%
Suggested Prices Based on Cap Rates
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
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 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 (±1% cap)
NOI $64,930 @ 7.0% cap · market cap 5.19%
Second Best
Industrial
$436.3K
$381.8K – $509.0K (±1% cap)
NOI $30,540 @ 7.0% cap · market cap 2.44%
Theoretical Best
Office A
$1.48M
$1.29M – $1.72M (±1% cap)
NOI $103,461 @ 7.0% cap · market cap 8.28%
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

When Pigs Fly ... Restaurant

Suggested Use

Top Pick Auto Repair Shop Plumbing Service (Bike/Boat/Book/etc) Store Cafe & Coffee Shop Storage Facility Fish Market

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

Location Intelligence

Trade Area within ½ mile

47
Businesses Nearby
Well-served
Demand for This Use

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
Check the figures for this property Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics

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 - Frame building with a commercial kitchen, outdoor tiki bar, and direct access to Lake Erie.
Where is this conventional restaurant located?
The property is located at 8254 1ST Street Westfield, NY.
What is the asking price?
The asking price for this property is $1,249,900.
What are key features of this property?
This property features: 4,938‑square‑foot restaurant building constructed in 1970; Direct Lake Erie waterfront access at Barcelona Harbor; Full bar, dining area, and commercial kitchen
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
Why this one?
Saved
Reason not saved — we won't ask again