Skip to main content
Serving Buyers & Sellers in Columbia County, NY

223 – 225 Warren Street, Hudson, NY 12534 (MLS# 151586)


$2,200,000
223 - 225 Warren Street
Hudson, NY 12534
MLS# 151586
Status: Closed
8505 sqft


Photo 1
  1 / 29  
Photo 1 Photo 2 Photo 3 Photo 4 Photo 5 Photo 6 Photo 7 Photo 8 Photo 9 Photo 10 Photo 11 Photo 12 Photo 13 Photo 14 Photo 15 Photo 16 Photo 17 Photo 18 Photo 19 Photo 20 Photo 21 Photo 22 Photo 23 Photo 24 Photo 25 Photo 26 Photo 27 Photo 28 Photo 29

Property Description
Mixed-use opportunity in the heart of town! Two attached properties, 223 & 225 Warren St, includes 3 commercial units, 3 residential apartments, a 3-car garage, and a charming courtyard. Versatility defines these propertiesmaintain long-term commercial tenancies or unleash your entrepreneurial spirit running a business on Warren St. The 225 Warren Bar & Grill occupies the first floor, a thriving owner-occupied STR occupies the second floor, with a 4-bed apartment. The third floor houses long-term tenant in a 2-bed apartment.Meanwhile, 223 Warren St is home to the renowned Tanzy's breakfast spot, 225 Scoops ice cream shop (newly renovated), and a second-floor 2-bed apartment with a long-term tenant.The package includes a renovated 3-car garage and a backyard perfect for outdoor dining at the restaurants. Proximity to the Amtrak station enhances accessibility. 223 Warren is available for $925,000. 225 Warren Bar expresses interest in continuing to lease its space and will sign a lease with new owners.

Details
Contract Information
Listing Agreement: Exclusive Right To Sell
Owner Name: 225 Warren Holdings LLC
Current Price: $2,200,000
Original List Price: 2400000
Sold Price: $2,200,000
Status: Closed
Listing Contract Date: 2024-02-18
Property Sub Type: Business
Location, Tax, and Legal
911 Address: 223 & 225 Warren Street
School District: Hudson City Schools
General Tax: 0
School Tax: 18291.16
Town Tax: 17183.02
Village Tax: 0
Tax Annual Amount: 0
Tax Year: 0
Assessors Full Market Value: 1814102
Tax Assessed Value: 1415000
Parcel Number: 109.43-2-51
Tax Exemptions YN: No
Directions: 200 block on Warren Street on the south side.
General Property Information
Number Of Units Total: 6
Lot Size Acres: 0.15
Lot Size Dimensions: .15
Sign On Property YN: No
Disclaimer: Information not guaranteed.
Stories: 3
List Price/SqFt: 279.13
Sold Price/SqFt: 258.67
Living Area: 8505
Year Built: 1964
Remarks and Miscellaneous
CGR Public Historical Remarks: Ag District: No, Bedrooms: 8, FIPS Code: 21, Full Bathrooms: 3, Green Features: No, Half Bathrooms: 5, Lease Type: Net, Most Precise Vcty: Hudson, Quarter Bathrooms: 0, Special Conditions: None/Unknown, Year Built Exception: 0
Public Remarks: Mixed-use opportunity in the heart of town! Two attached properties, 223 & 225 Warren St, includes 3 commercial units, 3 residential apartments, a 3-car garage, and a charming courtyard. Versatility defines these propertiesmaintain long-term commercial tenancies or unleash your entrepreneurial spirit running a business on Warren St. The 225 Warren Bar & Grill occupies the first floor, a thriving owner-occupied STR occupies the second floor, with a 4-bed apartment. The third floor houses long-term tenant in a 2-bed apartment.Meanwhile, 223 Warren St is home to the renowned Tanzy's breakfast spot, 225 Scoops ice cream shop (newly renovated), and a second-floor 2-bed apartment with a long-term tenant.The package includes a renovated 3-car garage and a backyard perfect for outdoor dining at the restaurants. Proximity to the Amtrak station enhances accessibility. 223 Warren is available for $925,000. 225 Warren Bar expresses interest in continuing to lease its space and will sign a lease with new owners.
Status Change Information
Status Change Timestamp: 2025-04-02
Concessions: No
Buyer Financing: Cash
Concessions Amount: 0
Major Change Timestamp: 2025-04-14T13:44:17Z
Major Change Type: Price Reduced
Price Change Timestamp: 2025-04-14T13:44:17Z
Purchase Contract Date: 2025-02-12
Close Date: 2025-04-02
Close Price: 2200000
Appliances
Electric Water Heater: 1
Water Heater: 1
Construction Materials
Brick: 1
Frame: 1
Electric
100 Amp Service: 1
Foundation Details
Stone: 1
Heating
Radiant Floor: 1
Possession
Close Of Escrow: 1
Road Surface Type
Paved: 1
Roof
Asphalt: 1
Shingle: 1
Sewer
Public Sewer: 1
Water Source
Public: 1
Income and Expenses
Gross Income: 0
Maintenance Expense: 0
Current Use
Commercial: 1
Residential: 1
Other: 1
Business Type
Residential: 1
Restaurant: 1
Location Tax and Legal
Street Number: 223 - 225
Street Name: Warren
Street Suffix: Street
County: Columbia
State: NY
Zip Code: 12534
Town (Taxable): Hudson
Property Features
Appliances: Electric Water Heater; Water Heater
Business Type: Residential; Restaurant
Construction Materials: Brick; Frame
Current Use: Commercial; Residential; Other
Electric: 100 Amp Service
Foundation Details: Stone
Heating: Radiant Floor
Possession: Close Of Escrow
Road Surface Type: Paved
Roof: Asphalt; Shingle
Sewer: Public Sewer
Water Source: Public

Listing Courtesy of Copake Lake Realty Corp.
Listing Agent: Austin Urban

Information deemed reliable but not guaranteed.