747 Columbia Street, Hudson
$1,950,000
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)
Cable Available, Electricity Connected, Natural Gas Available, Sewer Available, Water Connected, See Remarks
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
Central Air, Ductless, ENERGY STAR Qualified Equipment
Frame, HardiPlank Type, Shingle Siding, See Remarks
Courtyard, Garden, Permeable Paving, Private Entrance
Frame, HardiPlank Type, Shingle Siding, See Remarks
The data relating to real estate on this website comes in part from the IDX of the Multiple Listing Service of Ulster County, Inc. Real estate listings held by brokerage firms other than Flemming Realty are marked with IDX logo and the detailed information about them includes the name of the listing broker.
Copyright © 2026 by the Multiple Listing Service of Ulster County, Inc. All Rights Reserved.
All information provided is deemed reliable but is not guaranteed and should be independently verified.
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
