Skip main navigation
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
    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!
    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#: R1583995MLS LogoOriginating MLS: Otsego-Delaware
    Travel times

    Tour with a buyer’s agent

    We’ll find a local expert to take you on a private tour of 123 Main St.

    Next available tour time:Today at 11am

    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