Active

747 Columbia Street

Hudson, NY 12534
Mark as Favorite
Bed 5

Bed

Bath 5

Bath

SqFt6,049

Sqft

Acres0.14

Acre(Lot)

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 parcel s. 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)

Read More Expand

Detail Ic Property Details

Property Type : Residential Income

Price : $1,950,000

AD Id : 85489010

MLS Id : 20263390

Beds : 5

Lot Size : 0.14 Acre

Living Area Size : 6,049

Year Built : 1959

County : Columbia

  • Map Map

Map

Map What's Nearby

Map Nearby Areas

Feature Features

  • Bedroom Information

    Total beds: 5

    Bathroom Information

    Total Baths: 5

    Room Information

    Has Basement: Yes Basement: Dirt Floor, Partial, Unfinished
  • Flooring Information

    Combination
  • Roofing Information

    Asphalt, Flat
  • Interior Features

    Roof: Asphalt, Flat Appliances: Bar Fridge, Built-In Gas Range, Dryer, Dishwasher, ENERGY STAR Qualified Appliances, Free-Standing Gas Oven, Gas Water Heater, Microwave, Range Hood, Tankless Water Heater, Washer, Washer/Dryer Stacked
  • Heating & Cooling

    Has Heating: Yes Heating: Other, Varies by Unit Has Cooling: Yes Cooling: Central Air, Ductless, ENERGY STAR Qualified Equipment

  • Building Information

    Year Built: 1959 Building Area Total: 6049 Construction Materials: Frame, HardiPlank Type, See Remarks, Shingle Siding Stories: 31 Private Pool: No
  • Exterior Features

    Exterior Features: Courtyard, Garden, Private Entrance, Permeable Paving

  • Lot Information

    Main Square Feet: 0.14 Acres Lot Size Acres: 0.14 Lot Size Square Feet: 6098.4 Lot Description: Level

    Property Information

    Subdivision: Other Source Property Type: Residential Income MLS Area Minor: Hudson Zoning Description: General Commercial Transitional District - Allows the highest density with minimal setbacks. Property SubType: Multi Family Property Age: 67

  • Listing Price Information

    Listing Price: $1950000

  • Tax Information

    Parcel Number: 110.53-2-31.21 and 110.53-2-31.22 Tax Lot: 31 Tax Block: 2 Annual Tax: $20590

  • School Information

    Elementary School: Other
    Junior High School:
    Senior High School:
  • Utility Information

    Natural Gas Available, Cable Available, Electricity Connected, Sewer Available, See Remarks, Water Connected
  • Location Information

    WaterSource: Public Security Features: Carbon Monoxide Detector(s), Prewired, Smoke Detector(s)
Sell a home like this and save $116,501 Find out How

How much is this property worth?

Curious about this home's true market value? Use our free Home Evaluation Tool to instantly get a personalized Comparative Market Analysis (CMA) report. Make smarter, data-driven decisions before you buy.

Images
Loading, please wait...

Nearby Home Value

Address Estimate Bed Bath Sq. Ft Lot Size
274 Fingar Road, Hudson, NY, 12534 $2,250,000 10 6 --
4 Delaware Avenue, Hudson, NY, 12534 $350,000 2 2 1,170 1,170 SqFt
34-36 Fairview Avenue, Hudson, NY, 12534 $2,995,000 24 -- 12,600 12,600 SqFt
212 Joslen Boulevard, Hudson, NY, 12534 $740,000 5 3 3,900 3,900 SqFt
854 Columbia Street, Hudson, NY, 12534 $475,000 4 2 2,280 2,280 SqFt
854 Columbia Street, Hudson, NY, 12534 $475,000 4 2 2,280 2,280 SqFt
49 - 51 Worth Avenue, Hudson, NY, 12534 $850,000 8 3 3,939 3,939 SqFt
823 Warren Street, Hudson, NY, 12534 $799,000 5 4 2,622 2,622 SqFt
825 Union Street, Hudson, NY, 12534 $899,900 4 4 3,414 3,414 SqFt
22 S 7th Street, Hudson, NY, 12534 $850,000 1 2 2,208 2,208 SqFt

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.

ByOwner last updated this listing 06/19/2026 @ 09:25

MLS: 20263390 LISTED BY: Victor Mendolia, The Kinderhook Group, Inc. SOURCE: Hudson Valley Catskills Region Multiple List Service (Ulster County Board of REALTORS)

Homes around $1,950,000

Selling? Save $116,501 when you sell a home like this

Tour with a ByOwner Agent