About 747 Columbia Street
These are two adjacent buildings on two parcels. One is the 3-story building that currently houses Li'l Deb's Oasis (747 Columbia Street).There is one fully renovated Studio apt on the second floor rear. The second floor above the restaurant currently serves as a private dining room and there is also a fantastic third floor attic space. Could make a deluxe duplex apartment. The second building is a former auto repair garage, converted to two industrial-chic apartments known as The Mechanic Apartments (747 1/2 Columbia Street aka 747 Columbia St. Rear) The second building houses one 2-bedroom 2-bath unit and the other a spacious light-filled studio unit with huge skylight. The properties are only being sold together.747 1/2 sits behind 747, down a small alley which is part of the parcels. 747 Columbia St = Parcel # 110.53-2-31.21 (Front Property) 747-1/2 Columbia St (aka 747 Columbia St Rear) = Parcel # 110.53-2-31.22 (Rear Property)
Features of 747 Columbia Street
| MLS® # | 20262709 |
|---|---|
| Price | $1,900,000 |
| Bathrooms | 5.00 |
| Square Footage | 6,049 |
| Acres | 0.14 |
| Year Built | 1959 |
| Type | Commercial Sale |
| Sub-Type | Other |
| Status | Active |
Community Information
| Address | 747 Columbia Street |
|---|---|
| Area | Hudson |
| Subdivision | Other |
| City | Hudson |
| County | Columbia |
| State | NY |
| Zip Code | 12534 |
Amenities
| Utilities | Cable Available, Electricity Connected, Natural Gas Available, Sewer Available, Water Connected, See Remarks |
|---|---|
| Parking Spaces | 3 |
| Is Waterfront | No |
Interior
| Appliances | Washer/Dryer Stacked, Washer, Tankless Water Heater, Range Hood, Microwave, Gas Water Heater, Free-Standing Gas Oven, ENERGY STAR Qualified Appliances, Dryer, Dishwasher, Built-In Gas Range, Bar Fridge |
|---|---|
| Heating | Varies by Unit, Other |
| Cooling | Central Air, Ductless, ENERGY STAR Qualified Equipment |
| Has Basement | Yes |
| Basement | Dirt Floor, Partial, Unfinished |
| Fireplace | No |
Exterior
| Exterior | Frame, HardiPlank Type, Shingle Siding, See Remarks |
|---|---|
| Exterior Features | Courtyard, Garden, Permeable Paving, Private Entrance |
| Lot Description | Level, Subdivide Possible |
| Roof | Asphalt, Flat |
| Construction | Frame, HardiPlank Type, Shingle Siding, See Remarks |
| Foundation | Combination, Slab |
School Information
| District | Hudson City Schools |
|---|---|
| Elementary | Other |
Additional Information
| Date Listed | May 26th, 2026 |
|---|---|
| Days on Market | 56 |
| Zoning | GCT |
| Short Sale | No |
| RE / Bank Owned | No |
Listing Details
| Agent | Victor Mendolia |
|---|---|
| Agent | Matthew Lynch |
| Office | The Kinderhook Group, Inc. |