CCertihomes
123 Main Street, Delhi, NY 13753

$975,000

4 beds 2 baths 8,000 sqft Built 1900131 days on marketActive

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.

Your estimated payment
$8,611/mo

Real estate (PITI + HOA + PMI)
$6,774
Principal + interest$4,422
Property tax + insurance$1,986
PMI / 2nd mortgage$366
Utilities
$4,218
Heating + cooling$1,957
Internet + TV + phone$138
Water + sewer + garbage$58
Transportation
$0
Other (entertainment)
$138
$8,611/mo TLC
Budget$9,111/mo
Remaining after TLC$500/mo
Purchase price
$975,000
Down payment
$48,750 (5%)
Loan amount
$926,250
APR
4%

Quick facts

Type
MixedUse
Style
Triplex
Year built
1900
Lot size
0.6182 ac
Stories
2
Heating
Electric, HeatPump, Propane, Other, SeeRemarks, Zoned, Baseboard, HotWater
Cooling
HeatPump, Zoned
Water
Connected, Public
HOA
Annual tax
$9,352
MLS #
R1583995
County
Delaware

At a glance

Fireplace
Basement

Home features

Appliances
ElectricWaterHeater
Interior
CeilingFans
Exterior
PatioPropaneTankLeased
Parking
GravelPavedParkingAvailable
Flooring
Hardwood, Other, SeeRemarks, Varies, Vinyl
Roof
Asphalt, Metal, Shingle
Sewer
Connected

Lot features

Other, Rectangular, RectangularLot, ResidentialLot, SeeRemarks

Neighborhood — 13753

MetricThis ZIPCountyUSA
Population3,53819,351,094299,088,112
Population Change Since1990-6.00%8.00%20.00%
Population Density39395
Male1,8089,381,926147,432,321
Female1,7309,969,168151,655,844
Never Married1,5304,946,39163,775,926
Married1,0737,166,701123,120,365
Separated2391,159,67312,639,686
Widowed1751,110,24515,467,586
Divorced1721,210,44823,075,029
Number Of House Hold8867,102,016111,826,380
Average House Hold Size2.512.642.60
Medial Age25.7536.5335.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 R8.00%4.00%
W C J80.45%81.55%77.74%
(Zip) Code
13753

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/11/2025. Provided courtesy of Keller Williams Upstate NY Properties via Buffalo MLS. Information deemed reliable but not guaranteed.