747 Columbia St, Hudson, NY 12534
- Beds
- 5
- Baths
- 5
- Sqft
- 6,049
View property features, location on map, relevant school information and overview from seller's agent.
- 0
- 0
Overview
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)
Location
Full feature list
Basic info
- Property type
- Multi-family
- Number of stories
- 3
- Number of bedrooms
- 5
- Number of bathrooms
- 5
- Square feet
- 6,049
- Lot size (acres)
- 0.14
- Year built
- 1959
Interior features
- Basement
- Yes, Partially finished
Utilities
- Heating
- Other
- Cooling
- Ductless, ENERGY STAR-qualified Equipment, Central Air
- Sewer
- Public Sewer
- Water
- Public Water
Taxes
- Tax Annual Amount
- $20,590
Public schools
Disclaimer: Certain information displayed on this listing has been derived from parties other than Final Offer, LLC. Information provided and their sources have been deemed reliable, but accuracy of information is not guaranteed and therefore should be independently verified.
Sourced from: Hudson Valley Catskills/Ulster County MLS MLS®#: 20263390 Last checked: …

The data relating to real estate for sale on this website comes in part from the Internet Data exchange (IDX) program of the Ulster County Board of REALTORS®. 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. Information deemed reliable but not guaranteed. Copyright ©2026 Ulster County Board of REALTORS®, Inc.