123 Main Street

Delhi, NY 13753

$1,100,000
Price
4
Beds
2
Baths
8,000 Sq. Ft.
$138 / Sq. Ft.
8,000
Sq. Ft.
$138
per Sq. Ft.

Description

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...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!
  1. Listed by David C. Brower • Keller Williams Upstate NY Properties
    P: (607)-431-2540 C: (607)-435-4800 david.brower@kw.com

Property Details for 123 Main Street

Styles Of Residence
Triplex
On Waterfront
No
Parking Description
Gravel, Paved, Parking Available
Nearest Cross Street
Court
LISTING UPDATED: 10/08/2024 09:01 AM

Property Details for 123 Main Street

StatusActive
MLS #R1525314
Days on Market223
Taxes$9,061 / year
HOA Fees-
Condo/Co-op Fees-
Compass TypeMixed Use
MLS TypeResidential / Mixed Use
Year Built1900
Lot Size0.62 AC / 26,928 SF
CountyDelaware County

Building Information for 123 Main Street

Stories2Residences2Year Built1900Lot Size0.62 AC / 26,928 SF

Property Information for 123 Main Street

Summary
Location and General Information
  • Elementary School District: Delaware Academy
  • High School District: Delaware Academy
  • Middle Or Junior School District: Delaware Academy
  • Village: Delhi-Village
  • Human YN: Yes
Parking
  • Garage Spaces per Apt: .00
Taxes and HOA Information
  • Area NYSWIS Code: Delhi-Village-122801
  • Tax Annual Amount: $9,061.00
Virtual Tour
Property
Lot Information
  • Building Area Source: Other
  • Building Area Total: 8000.0
  • Land Features: Residential Lot
  • Num Of Acres: 0.6182
  • Lot Size Area: 0.6182
  • Lot Size Square Feet: 26928.0
  • Lot Size Units: Acres
  • Parcel Number: 122801-171-006-0010-003-000
  • Road Frontage: City Street, Main Thoroughfare
  • Lot Number: 3
Property and Assessments
  • Property Condition: Resale
  • Senior Community YN: No
  • Assessed Value: $155,600
  • Year Built: 1900
  • Year Built Description: Existing
  • Zoning Description: Other - See Remarks
Utilities
  • Electric Service: Circuit Breakers
  • Num Of Electric Meters: 3
  • Num Of Gas Meters: 1
  • Sewer Description: Connected
  • Utilities Available: Cable Available, High Speed Internet Available, Sewer Connected, Water Connected
  • Water Supply: Connected, Public
Interior and Exterior Features
Exterior Features
  • Construction Materials: Wood Siding
  • Exterior Features: Patio
  • Foundation Description: Poured, Stone
  • Patio And Porch Features: Patio
  • Roof Description: Asphalt, Metal, Shingle
  • Type Of Building: Mixed
Interior Features
  • Appliances: Electric Water Heater
  • Basement Description: Partial
  • Basement YN: Yes
  • Num Of Possible Bedrooms: 4
  • HVAC Type: Heat Pump, Zoned
  • Cooling YN: Yes
  • Num Fireplaces Total Calculated: 0
  • Fireplace YN: No
  • Floor Description: Hardwood, Other, See Remarks, Varies
  • Heating: Electric, Heat Pump, Propane, Other, See Remarks, Zoned, Baseboard, Hot Water
  • Heating YN: Yes
  • Interior Features: Ceiling Fans
  • Levels: Two
  • Sq Ft Total: 8000.0
  • Main Level Bathrooms: 0
  • Window Features: Thermal Windows
Multi Family
Multi-Family Information
  • Number Of Units In Community: 2
  • Number Of Units Total: 2
  • Operating Expense Includes: Accounting, Advertising, Electric, Fuel, Insurance, Licenses, Maintenance, Professional Management, Rent, Supplies, Trash, Utilities, Water Sewer
  • Stories: 2
  • Stories Total: 2
Unit 1
  • Unit Type Actual Rent: $850.00
  • Unit Type Baths Total: 1
  • Unit Type Beds Total: 2
  • Features: Oven/ Range,Refrigerator,Dining Area With Kitchen,Living Room
  • Unit Type Total Rent: $850.00
  • Unit Type Lease Expires: 10-31-2024
  • Unit Type Num Full Baths: 1
  • Unit Type Num Half Baths: 0
  • Unit Type Actual Rent Range: 850
Unit 2
  • Unit Type Actual Rent: $1,000.00
  • Unit Type Baths Total: 1
  • Unit Type Beds Total: 2
  • Features: Oven/ Range,Refrigerator,Microwave,Dining Area With Living Room,Living Room,Other - See Remarks
  • Unit Type Total Rent: $1,000.00
  • Unit Type Num Full Baths: 1
  • Unit Type Num Half Baths: 0
  • Unit Type Actual Rent Range: 1000
Rental
Rental Information
  • Rent Includes: Snow Removal, Water
  • Tenant Pays: All Utilities
  • Lease Amount Per Area Unit: Dollars Per Square Foot

Property History for 123 Main Street

DateEvent & SourcePriceAppreciation
DateEvent & SourcePrice

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 123 Main Street

Taxable ValueLand$29,700Additions$125,900Total$155,600
Tax Record2020$8,951 ($746 / month)
Home Facts
Lot Size26,928 SqFtStyleMiscellaneous CommercialCountyDELAWAREAPN122801 171.6-10-3

Schools near 123 Main Street

This home is within Delaware Academy Central School District At Delhi.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 12
Rating
School
Distance
Delhi Elementary School
PublicPK to 5

Delaware Academy High School
Public6 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Sorry, we can't find any similar homes at this time. Please check back later.

Similar Sold Homes

Sorry, we can't find any similar sold homes at this time. Please check back later.

123 Main Street is a mixed use property for sale in Delhi, NY 13753. This property was listed for sale on March 10, 2024 by Keller Williams Upstate NY Properties, it's currently listed at $1,100,000. It has been on the market for a total of 223 days and was last sold on March 4, 2010. This listing's school district is Delaware Academy Central School District At Delhi. Nearby schools include Delhi Elementary School and Delaware Academy High School. 123 Main Street is a 4-bed, 2-bath, 8,000 sqft mixed use property built in 1900.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Keller Williams Upstate NY Properties

The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers’ personal, non-commercial use. The data relating to real estate for sale or lease on this webpage comes from the the IDX Program of OneKey® MLS, Columbia Greene Northern Dutchess MLS, and Ulster County Board of REALTORS. Real estate listings held by brokerage firms other than Compass are marked with a OneKey® MLS, Columbia Greene Northern Dutchess MLS, or Ulster County Board of REALTORS Logo. Use of these search facilities other than by a consumer seeking to purchase or lease real estate is prohibited. The accuracy of all information is deemed reliable but not guaranteed and should be verified through personal inspection by and/or with appropriate professionals. The data contained herein is copyrighted by the IDX Program of OneKey® MLS, Columbia Greene Northern Dutchess MLS, and Ulster County Board of REALTORS and is protected by all applicable copyright laws. Any unauthorized dissemination of this information is in violation of copyright laws and is strictly prohibited. Information Copyright 2024, OneKey® MLS, Columbia Greene Northern Dutchess MLS, and Ulster County Board of REALTORS. All rights reserved. Data last updated: 10/08/2024 09:01 AM