747 Columbia Street, Hudson, NY 12534 | MLS #20263390 | HUNT Real Estate
Contact

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Reload
 
  • 11 days on site
  • 0 views

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)

Source: Hudson Valley Catskill Regional MLS, MLS#: 20263390

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
  • Property Type
    Residential Income
  • Lot
    0.14 acres

Get in Contact

Would you like to know more about this property? We're here to help! Let's connect and find what you're looking for.

HUNT Real Estate
I agree to be contacted by HUNT Real Estate Corporation via call, email, and/or text for real estate services, even if my phone number is listed on a state or national Do Not Call list. Data will not be shared with third parties for marketing or promotional purposes. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. View HUNT Real Estate ERA's privacy policy here: https://www.huntrealestate.com/Privacy-Policy

Create a profile so you can receive updates on this property as soon as they happen!

  • Median Age
    46
  • Population Density
    202
  • College Educated
    41%
  • Estimated Median Income
    $54,159
  • Estimated Total Home Owners
    4,608
  • Estimated Total Renters
    3,159
  • Owner / Renter Divide
    59% / 41%
  • Estimated Average Household Size
    2
  • Total Population
    17,814
  • Community data courtesy of LiveBy, Inc.

Owning this Home

$
$ %
%
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

Want to talk? Contact us here.

Ready to Make Your Homeownership Dreams a Reality?

At HUNT Mortgage, we make finding the right home loan easy. We Provide exceptional service with affordable options tailored just for you.


Life at 747 Columbia Street

Schools


School data courtesy of LiveBy, Inc.
Ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating. The schools displayed on this website are for informational purposes only and may not represent a complete or up-to-date list. School assignments are subject to change and should be verified directly with the local school district. Please contact the appropriate school district to confirm school zoning and enrollment eligibility for this property.

History

Date Event Value Agent
6/23/2026Source: Hudson Valley Catskill Regional MLS Price Reduction
$1,900,000 -2.6%
6/23/2026Source: Hudson Valley Catskill Regional MLS Price Reduction
$1,900,000 -2.6%
6/18/2026Source: Hudson Valley Catskill Regional MLS Added to Database
June 18, 2026
5/26/2026Source: Hudson Valley Catskill Regional MLS Price Increase
$1,950,000 2.6%
5/26/2026Source: Hudson Valley Catskill Regional MLS Added to Database
May 26, 2026
Listing provided courtesy of The Kinderhook Group, Inc.- MLS# 20263390MLS Provider

The HUNT Family Of Companies