Share This Listing

Message

938 characters remaining

Hmm, there seems to have been an error sending your message. Please try again.

Your email has been sent.

Still interested?

Contact the brokers for more information about this property

Investment Highlights

  • Fully Equiped Restaurant with Studio Apartment in Front Building
  • Private Alley/ Courtyard
  • Radiant Heated Floors in Residential Units
  • Two-Family Industrial-Chic Building in Rear
  • True Mixed Use Property Retail/Residential

Executive Summary

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 private 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)

Property Facts

Price $1,950,000
Price / SF $603.34 / SF
Sale Condition Lease Option
Sale Type Investment or Owner User
Status Active
Number of Properties 2
Individually For Sale 0
Total Building Size 3,232 SF
Total Land Area 0.06 AC

Properties

Property Name / Address Property Type Size Year Built Individual Price
747 Columbia St, Hudson, NY 12534 Retail 3,232 SF 1850 -
Show More > < Show Less
  • Listing ID: 40982128

  • Date on Market: 6/19/2026

  • Last Updated:

  • Address: Li'l Deb's Oasiis -Mechanic's Apartments, Hudson, NY

Link copied
Your LoopNet account has been created!

Please Share Your Feedback

We welcome any feedback on how we can improve LoopNet to better serve your needs.
X
{{ getErrorText(feedbackForm.starRating, "rating") }}
255 character limit ({{ remainingChars() }} charactercharacters remainingover)
{{ getErrorText(feedbackForm.msg, "rating") }}
{{ getErrorText(feedbackForm.fname, "first name") }}
{{ getErrorText(feedbackForm.lname, "last name") }}
{{ getErrorText(feedbackForm.phone, "phone number") }}
{{ getErrorText(feedbackForm.phonex, "phone extension") }}
{{ getErrorText(feedbackForm.email, "email address") }}