Active
123 Main Street, Delhi NY 13753
MLS# R1583995
$975,000
Price
4
Beds
2
Baths
8,000
Living Area (Sq.Ft.)
0.618
Lot Area (Acres)
$975,000
Price
4
Beds
2
Baths
8,000
Living Area (Sq.Ft.)
0.618
Lot Area (Acres)
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!
Status
Active
Property Type
Residential
Property Sub Type
MixedUse
Year Built
1900
Parcel Number
171.6-10-3
Unit Number
--
Lot Features
Other, Rectangular, Rectangular Lot, Residential Lot, See Remarks
Levels
Two
Building Area Source
Other
Lot Size Dimensions
66X408
Stories
2
Bath Rooms Full
2
Property Condition
Resale
Elementary School District
Delaware Academy
Middle Or Junior School District
Delaware Academy
High School District
Delaware Academy
Location
Listing Agent
David C. Brower
Listing Office
Keller Williams Upstate NY Properties
Owner Name
--
Owner Phone
--
Possession
CloseOfEscrow
Special Listing Conditions
Standard
Listing Terms
Cash, Conventional
Listing Agreement
ExclusiveRightToSell
Listing Contract Date
2025-01-11
Owner Pays
Snow Removal, Water
Rent Includes
Snow Removal, Water
Tenant Pays
AllUtilities
Fire Places Total
1
Interior Features
Ceiling Fans
Flooring
Hardwood, Other, See Remarks, Varies, Vinyl
Fire Place
true
Cooling
true
Cooling Features
HeatPump,Zoned
Heating
true
Heating Features
Electric, Heat Pump, Propane, Other, See Remarks, Zoned, Baseboard, Hot Water
Appliances
Electric Water Heater
Electric
Circuit Breakers
Window Features
ThermalWindows
Garage
--
Garage Spaces
0
Architectural Style
Triplex
Exterior Features
Patio, Propane Tank Leased
Water Source
Connected, Public
Sewer
Connected
Roof
Asphalt, Metal, Shingle
Utilities
Cable Available, High Speed Internet Available, Sewer Connected, Water Connected
Parking Features
Gravel, Paved, Parking Available
Foundation Details
Poured,Stone
Basement
Partial
Construction Materials
Wood Siding
Patio And Porch Features
Patio
No schools found
Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated 06/27/2025.
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.
Listed By
Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated 06/27/2025.
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.