747 Columbia Street
Hudson, NY 12534
5
Bed
5
Bath
6,049Sqft
0.14Acre(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
Property Details
Map
Map
What's Nearby
Nearby Areas
Features
-
Bedroom Information
Total beds: 5Bathroom Information
Total Baths: 5Room 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: 3 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: LevelProperty 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: $1900000 Original 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: OtherJunior 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)
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.
Nearby Home Value
| Address | Estimate | Bed | Bath | Sq. Ft | Lot Size |
|---|---|---|---|---|---|
| 6627-6633 Park Place, Hudson, NY, 12534 | $1,475,000 | 14 | -- | 8,477 | 8,477 SqFt |
| 274 Fingar Road, Hudson, NY, 12534 | $2,250,000 | 10 | 6 | -- | |
| 10 Oakwood Boulevard, Hudson, NY, 12534 | $640,000 | 4 | 2 | 1,912 | 1,912 SqFt |
| 24 Aitken Avenue, Hudson, NY, 12534 | $750,000 | 6 | -- | 2,772 | 2,772 SqFt |
| 212 Joslen Boulevard, Hudson, NY, 12534 | $730,000 | 5 | 3 | 3,900 | 3,900 SqFt |
| 50-56 Parkwood Boulevard, Hudson, NY, 12534 | $995,000 | 8 | 8 | 3,925 | 3,925 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 |
| 823 Warren Street, Hudson, NY, 12534 | $799,000 | 5 | 4 | 2,622 | 2,622 SqFt |
| 825 Union Street, Hudson, NY, 12534 | $874,900 | 4 | 4 | 3,414 | 3,414 SqFt |
Similar Multifamily To 747 Columbia Street
Nearby For Sale
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 08/15/2026 @ 03:57
More Cities with for Sale by Owner Homes
- Hudson Homes For Sale By Owner
- Athens Homes For Sale By Owner
- Claverack Homes For Sale By Owner
- Columbiaville Homes For Sale By Owner
- Ghent Homes For Sale By Owner
- Catskill Homes For Sale By Owner
- Philmont Homes For Sale By Owner
- Stuyvesant Homes For Sale By Owner
- Livingston Homes For Sale By Owner
- Craryville Homes For Sale By Owner
- Coxsackie Homes For Sale By Owner
- Germantown Homes For Sale By Owner
- West Coxsackie Homes For Sale By Owner
- Climax Homes For Sale By Owner
- Kinderhook Homes For Sale By Owner
- Ancram Homes For Sale By Owner
- Hillsdale Homes For Sale By Owner
- Purling Homes For Sale By Owner
- Elizaville Homes For Sale By Owner
- Chatham Homes For Sale By Owner
Homes around $1,900,000
Verify Your Email
Please enter the 6-digit verification code
sent to your email address.