$975,000
About this home
Once in a lifetime opportunity! Here’s your chance to own O’Neill’s Shire Pub, a gathering place and the social hub of the vibrant Delhi community. The establishment seamlessly blends tradition with modern amenities, creating a haven for those seeking classic and traditional culinary favorites, craft beers, and unique cocktails. The property has been entirely rebuilt from the studs in, ensuring a turn-key and efficient foundation for your business. Indulge in the charm of this meticulously updated establishment, featuring a well-appointed commercial kitchen ready to bring culinary dreams to life. The cozy pub and dining room create an inviting atmosphere for unforgettable dining experiences. Enjoy the fresh air and scenic surroundings in the newly designed outdoor space, perfect for al fresco meals and spirited gatherings. "The Speakeasy" is a clandestine retreat ideal for intimate meetings and small get-togethers. Two spacious apartments add versatility to this property. One is expertly set up for Airbnb, offering short-term accommodation options, while the other is leased on a yearly basis, providing a steady income stream. Don't let this exciting opportunity pass you by!
Affordability — calculate your monthly payment
Adjust your budget to see what's left after housing, utilities and transportation. Numbers below assume a 5% down, 30YrJumbo at 4% APR.
- Real estate (PITI + HOA + PMI)
- $6,774
- Utilities
- $4,218
- Transportation
- $0
- Other (entertainment)
- $138
Quick facts
At a glance
Home features
Lot features
Rectangular, RectangularLot
Neighborhood — 13753
| Metric | This ZIP | County | USA |
|---|---|---|---|
| Population | 3,538 | 19,351,094 | 299,088,112 |
| Population Change Since1990 | -6.00% | 8.00% | 20.00% |
| Population Density | 39 | 395 | — |
| Male | 1,808 | 9,381,926 | 147,432,321 |
| Female | 1,730 | 9,969,168 | 151,655,844 |
| Never Married | 1,530 | 4,946,391 | 63,775,926 |
| Married | 1,073 | 7,166,701 | 123,120,365 |
| Separated | 239 | 1,159,673 | 12,639,686 |
| Widowed | 175 | 1,110,245 | 15,467,586 |
| Divorced | 172 | 1,210,448 | 23,075,029 |
| Number Of House Hold | 886 | 7,102,016 | 111,826,380 |
| Average House Hold Size | 2.51 | 2.64 | 2.60 |
| Medial Age | 25.75 | 36.53 | 35.46 |
| Median House Hold Income | $43,124 | $49,847 | $48,276 |
| Average House Hold Income | $52,245 | $70,032 | $63,629 |
| P C I | $15,509 | $26,569 | $24,529 |
| M D I | $37,425 | $42,210 | $41,133 |
| A T H E | $45,041 | $54,185 | $50,898 |
| S T R | 8.00% | 4.00% | — |
| W C J | 80.45% | 81.55% | 77.74% |
Data via Certihomes neighborhood index. Comparisons across this ZIP, county and the United States.
Map & walkability
Open in Google Maps →Listing information last refreshed 1/12/2025. Provided courtesy of Keller Williams Upstate NY Properties via Buffalo MLS. Information deemed reliable but not guaranteed.