Realmo

Buy
- For Sale
- Post a Listing
Property Types
- Retail
  
  Automotive
  
  Auto Shop
  
  Drug Store
  
  Storefront
  
  Shopping Center
  
  Showroom
  
  Bank
- Office
  
  Office Units
  
  Building
  
  Creative Space
  
  Live - Work Space
  
  Medical Premises
- Residential Income
  
  Multifamily
  
  Duplex
  
  Triplex
  
  Quadplex
  
  Short Term Rental
- Restaurants
  
  Conventional Restaurant
  
  Bar & Pub
- Industrial
  
  Flex Space
  
  Manufacturing
  
  Brewery
  
  Distribution Center
- Warehouse
  
  Cold Storage
  
  Self Storage
- Mixed-Use
- Hospitality
  
  Hotel
  
  Motel
- Health Care
  
  Senior Housing
- Land
  
  Residential
  
  Commercial
  
  Recreation
  
  Industrial
  
  Agricultural
  
  Waterfront
  
  Hunting
- Agricultural
  
  Farms
  
  Ranches
- Specialty
  
  School
  
  Wedding Venue
Rent
- For Lease
- Post a Listing
Space Uses
- Retail
- Restaurant
- Office
- Medical Space
- Industrial
- Warehouse
- Flex
- Sports & Entertainment
Analytics
- Get Leads
- Property Insights
- Value Est
- Cap Rate Est
- Debts
- Zoning
- Locations
- Market TrendsSoon
- CRE Guide

Advertise Sign In

For Sale
- Retail
  - Automotive
  - Auto Shop
  - Drug Store
  - Storefront
  - Shopping Center
  - Showroom
  - Bank
- Office
  - Office Units
  - Building
  - Creative Space
  - Live - Work Space
  - Medical Premises
- Residential Income
- Restaurants
  - Conventional Restaurant
  - Bar & Pub
- Industrial
  - Flex Space
  - Manufacturing
  - Brewery
  - Distribution Center
- Warehouse
  - Cold Storage
  - Self Storage
- Mixed-Use
- Hospitality
  - Hotel
  - Motel
- Health Care
  - Senior Housing
- Land
  - Residential
  - Commercial
  - Recreation
  - Industrial
  - Agricultural
  - Waterfront
  - Hunting
- Agricultural
  - Farms
  - Ranches
- Specialty
  - School
  - Wedding Venue
For Lease
- Retail
- Restaurant
- Office
- Medical Space
- Industrial
- Warehouse
- Flex
- Sports & Entertainment
Get Leads
Property Insights
Value Est
Cap Rate Est
Debts
Zoning
Locations
Market TrendsSoon
CRE Guide
Advertise
Find Agents

New York

Live - Work Space

Columbia County, NY Live-work Space for Sale

List

Map

Brooklyn, NY Buffalo, NY New York, NY Bronx, NY Staten Island, NY Rochester, NY Queens, NY Albany, NY

Mixed-Use Building with Storefront

Updated: Apr 11

Mixed-Use Building with Storefront

9249 Route 22, Hillsdale, NY 12529

$255,000

2,304 sqft 0.32 AC lot

Three rentable spaces within a mixed residential/commercial building
2,304 square feet on a 0.32‑acre parcel
Commercial reception area, storefront, one‑bedroom apartment, and studio apartment
Route 22 location just south of the Route 22 and Route 23 intersection
Opposite Stewart’s in Hillsdale

Warren Street Live-Work Opportunity

Updated: Nov 3, 2025

Warren Street Live-Work Opportunity

705 Warren Street, Hudson, NY 12534

$1,975,000

5,750 sqft

Prime Warren Street location with live‑work zoning offering flexible usage for retail, residential, or creative endeavors.
Fully renovated and modernized 5,750 sq ft building with high‑end residential space and income‑generating rental/Airbnb apartment.
Extensive renovations including new electrical, plumbing, HVAC, roofs, windows, sprinkler system, and heated sidewalk.
Spacious ground floor showroom with chef's kitchen, open plan, and potential for various commercial uses.
Unobstructed park views and Catskill sunset views from upper floors.**

Live-Work and Retail Property

Live-Work and Retail Property

514 Warren Street, Hudson, NY 12534

$995,000

For-sale mixed-use live-work and retail property at 514 Warren Street in Hudson, with nearby Amtrak service.

Realmo Analytics Monitor Off-market properties and contact owners who are ready to sell. Many signals applied to make quality leads for you. Get Leads

Based on your search, we've compiled 72 Potential Opportunities for your consideration. Besides 3 Active listings in Columbia County, NY, we suggest exploring several alternatives: similar 69 Off-Market properties to explore as potential leads

Off-Market Properties in Columbia County, NY

Consider similar Off-Market properties in Columbia County, NY. You may contact the owners directly to inquire about their potential intentions to sell. To help you make a strong first impression, we can assist by reaching out to these owners with compelling proposals created using our AI tool.

526-528 Warren St

OFFICE/RESIDENTIAL (MIXED USE)

526-528 Warren St, Hudson, NY 12534

Estimated value:

$805,000

6,785 sqft 0.08 AC lot

1727 Rte 9th 9

OFFICE/RESIDENTIAL (MIXED USE)

1727 Rte 9th 9, Germantown, NY 12526-5514

Estimated value:

$280,000

492 sqft 10.70 AC lot

2 Church Ave

OFFICE/RESIDENTIAL (MIXED USE)

2 Church Ave, Germantown, NY 12526-5748

Estimated value:

$260,000

4,128 sqft 0.08 AC lot

541 Warren St

OFFICE/RESIDENTIAL (MIXED USE)

541 Warren St, Hudson, NY 12534-2801

Estimated value:

$1,475,000

6,324 sqft 0.07 AC lot

234 Warren St, Unit 236

OFFICE/RESIDENTIAL (MIXED USE)

234 Warren St, Hudson, NY 12534-2126

Unit 236

Estimated value:

$3,360,000

4,725 sqft 0.12 AC lot

35 Hudson Ave

OFFICE/RESIDENTIAL (MIXED USE)

35 Hudson Ave, Chatham, NY 12037-1103

Estimated value:

$180,000

1,692 sqft 0.09 AC lot

66 Grn St

OFFICE/RESIDENTIAL (MIXED USE)

66 Grn St, Hudson, NY 12534-2371

Estimated value:

$275,000

2,994 sqft 0.54 AC lot

801 Columbia St

OFFICE/RESIDENTIAL (MIXED USE)

801 Columbia St, Hudson, NY 12534-2336

Estimated value:

$280,000

4,553 sqft 0.04 AC lot

38 Main St

OFFICE/RESIDENTIAL (MIXED USE)

38 Main St, Chatham, NY 12037-1203

Estimated value:

$265,000

2,708 sqft 0.13 AC lot

352 Warren St

OFFICE/RESIDENTIAL (MIXED USE)

352 Warren St, Hudson, NY 12534-2419

Estimated value:

$275,000

4,027 sqft 0.07 AC lot

354 Warren St

OFFICE/RESIDENTIAL (MIXED USE)

354 Warren St, Hudson, NY 12534

Estimated value:

$290,000

3,924 sqft 0.07 AC lot

550-552 Columbia St

OFFICE/RESIDENTIAL (MIXED USE)

550-552 Columbia St, Hudson, NY 12534

Estimated value:

$290,000

2,972 sqft 0.14 AC lot

3020 Main St

OFFICE/RESIDENTIAL (MIXED USE)

3020 Main St, Valatie, NY 12184-7700

Estimated value:

$95,000

1,200 sqft 0.06 AC lot

12913 State Rte 22

OFFICE/RESIDENTIAL (MIXED USE)

12913 State Rte 22, Canaan, NY 12029-2117

Estimated value:

$355,000

1,165 sqft 8.50 AC lot

962 State Rte 203

OFFICE/RESIDENTIAL (MIXED USE)

962 State Rte 203, Chatham, NY 12037-2918

Estimated value:

$275,000

1,487 sqft 1.00 AC lot

1315 State Rte 66

OFFICE/RESIDENTIAL (MIXED USE)

1315 State Rte 66, Ghent, NY 12075-2917

Estimated value:

$260,000

2,604 sqft 1.60 AC lot

921-923 Columbia St

OFFICE/RESIDENTIAL (MIXED USE)

921-923 Columbia St, Hudson, NY 12534

Estimated value:

$305,000

2,480 sqft 0.15 AC lot

454-456 Warren St

OFFICE/RESIDENTIAL (MIXED USE)

454-456 Warren St, Hudson, NY 12534

Estimated value:

$3,225,000

8,572 sqft 0.14 AC lot

318 Warren St

OFFICE/RESIDENTIAL (MIXED USE)

318 Warren St, Hudson, NY 12534-6401

Estimated value:

$3,715,000

5,746 sqft 0.07 AC lot

720-724 Warren St

OFFICE/RESIDENTIAL (MIXED USE)

720-724 Warren St, Hudson, NY 12534

Estimated value:

$1,935,000

16,614 sqft 0.16 AC lot

322-324 Warren St

OFFICE/RESIDENTIAL (MIXED USE)

322-324 Warren St, Hudson, NY 12534

Estimated value:

$3,715,000

13,237 sqft 0.14 AC lot

Columbia County, NY Live-Work Space Market Trends and Statistics

Explore 72 live-work space for sale in Columbia County, NY, showcased through 3 active listings on our real estate platform. These investment opportunities span a total of 8,054 square feet of properties for sale, with an estimated market value of $3,225,000.

Sale prices for live-work properties in Columbia County, NY start at $255,000, averaging $1,075,000, and reaching up to $1,975,000 — offering options for a variety of budgets and business needs. Daily updated analytics ensure you stay ahead with the latest data and market trends.

List

Map

Why this one?

Saved