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!
For sale
$975,000
123 Main St, Delhi, NY 13753
4beds
8,000sqft
Mixed Use, Triplex, Multi Family
Built in 1900
-- sqft lot
$-- Zestimate®
$122/sqft
$-- HOA
What's special
Newly designed outdoor spaceWell-appointed commercial kitchen
- 104 days
- on Zillow |
- 316 |
- 1 |
Zillow last checked: 7 hours ago
Listing updated: January 11, 2025 at 09:12am
Listing by:
Keller Williams Upstate NY Properties 607-431-2540,
David C. Brower 607-435-4800
Source: NYSAMLSs,MLS#: R1583995
Originating MLS: Otsego-Delaware

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
Heating
- Electric, Heat Pump, Propane, Other, See Remarks, Zoned, Baseboard, Hot Water
Cooling
- Heat Pump, Zoned
Appliances
- Included: Electric Water Heater
Features
- Ceiling Fan(s)
- Flooring: Hardwood, Other, See Remarks, Varies, Vinyl
- Windows: Thermal Windows
- Basement: Partial
- Number of fireplaces: 1
Interior area
- Total structure area: 8,000
- Total interior livable area: 8,000 sqft
Property
Parking
- Parking features: Gravel, Paved, Parking Available
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio
- Exterior features: Patio
Lot
- Size: 0.62 Acres
- Dimensions: 66 x 408
- Features: Other, Rectangular, Residential Lot, See Remarks
Details
- Parcel number: 171.6103
- Zoning description: Other - See Remarks
- Special conditions: Standard
Construction
Type & style
- Home type: MultiFamily
- Architectural style: Triplex
- Property subtype: Mixed Use, Triplex, Multi Family
Materials
- Wood Siding
- Foundation: Poured, Stone
- Roof: Asphalt,Metal,Shingle
Condition
- Resale
- Year built: 1900
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Connected
- Water: Connected, Public
- Utilities for property: Cable Available, High Speed Internet Available, Sewer Connected, Water Connected
Community & HOA
Location
- Region: Delhi
Financial & listing details
- Price per square foot: $122/sqft
- Tax assessed value: $155,600
- Annual tax amount: $9,352
- Date on market: 1/11/2025
- Listing terms: Cash,Conventional
- Tenant pays: All Utilities
- Loading
- Loading