Skip to main content
Serving Buyers & Sellers in Columbia County, NY

191 Columbia Turnpike, Hudson, NY 12534 (MLS# 20260113)


$1,999,000
191 Columbia Turnpike
Hudson, NY 12534
MLS# 20260113
7200 sqft


Building Facade
  1 / 16  
Building Facade 191 - Bldg4 191- Bldg3 191 - Bldg2 191-PL3 191 - PL -1 191-Lk 5 191-Lk 4 191- LK 3 191 - Lk2 191-LK 191-ST Unit 2 191- St Units 1 191-Aerial Plot 2 191- Aerial Plot 191-Survey

Property Description
Unusual opportunity to own 31.4 acres with your own 12+ acre lake, with a clubhouse! Unlock the future of your business on Clay Pond Farms, a centrally located, easily accessible property that blends endless opportunity for both business and recreation. Just minutes from downtown HUDSON NY this iconic property offers a prime opportunity for investors, developers, recreational and sports enthusiasts, or anyone with vision. Perhaps an 'In town' mens clubhouse, or a ' sportsmen's get away'. Set on 31.4 acres on Route 23B (Columbia Turnpike) this high-visibility property includes a 7200 sq. ft. tenants occupied COMMERCIAL BUILDING, with 8 OVER HEAD GARAGE BAYS, ample CLEARED ACREAGE, and also has a secluded, picturesque 12+- ACRE LAKE! This commercial zoned property is serviced by municipal water and sewer, provides ample parking for working or oversized construction vehicles and has easy access off State Route 23B. 
Directly across from the Columbia County Highway garage. The 7200SF building has endless possibilities ..light manufacturing, medical offices, showroom, warehouse, Gym/Recreation, and many other uses.
 Or expand it and go bigger on the additional acreage with a barn or large 'makers' shed. The crystal clear 12+-acre lake is 40 feet at its deepest and has big fish, frogs and turtles. Several spots for easy in for a clean swim. (Think your own private sporting camp.) This is an investment opportunity with endless potential. Centrally located to NYC, Albany, and The Berkshires. Easy to show and calls are welcome for any additional questions!

Details
Contract Information
Listing Agreement: Exclusive Right To Sell
Owner Name: Clay Pond Farm
Lease Considered YN: No
Current Price: $1,999,000
Original List Price: 1999000
List Price: $1,999,000
Status: Active
Listing Contract Date: 2026-01-09
Property Sub Type: Mixed Use
Location, Tax, and Legal
911 Address: 191 Route 23B
Township: Greenport
School District: Hudson City Schools
General Tax: 7378
School Tax: 8430.63
Town Tax: 5999.44
Village Tax: 0
Tax Annual Amount: 15808
Assessors Full Market Value: 1000000
Tax Assessed Value: 1000000
Parcel Number: 110.-1-49.120
Tax Lot: 0
Tax Block: 0
Tax Exemptions YN: No
Zoning: Commercial
Directions: From Route 66 go West onto 23B for 1-mile. From 9H in Claverack, go East on 23 to 23B. Parcel on right next to ADM facility. Directly across from the Greenport Town Garage.
General Property Information
Number Of Units Total: 0
Lot Size Acres: 31.4
Lot Size Dimensions: 31.4
Waterfront YN: Yes
Flood Plain YN: No
Frontage Length: Off 23-B
Sign On Property YN: Yes
Disclaimer: Information not guaranteed.
Basement YN: No
Stories: 0
List Price/SqFt: 277.64
Living Area: 7200
Year Built: 1964
Remarks and Miscellaneous
Public Remarks: Unusual opportunity to own 31.4 acres with your own 12+ acre lake, with a clubhouse! Unlock the future of your business on Clay Pond Farms, a centrally located, easily accessible property that blends endless opportunity for both business and recreation. Just minutes from downtown HUDSON NY this iconic property offers a prime opportunity for investors, developers, recreational and sports enthusiasts, or anyone with vision. Perhaps an 'In town' mens clubhouse, or a ' sportsmen's get away'. Set on 31.4 acres on Route 23B (Columbia Turnpike) this high-visibility property includes a 7200 sq. ft. tenants occupied COMMERCIAL BUILDING, with 8 OVER HEAD GARAGE BAYS, ample CLEARED ACREAGE, and also has a secluded, picturesque 12+- ACRE LAKE! This commercial zoned property is serviced by municipal water and sewer, provides ample parking for working or oversized construction vehicles and has easy access off State Route 23B. 
Directly across from the Columbia County Highway garage. The 7200SF building has endless possibilities ..light manufacturing, medical offices, showroom, warehouse, Gym/Recreation, and many other uses.
 Or expand it and go bigger on the additional acreage with a barn or large 'makers' shed. The crystal clear 12+-acre lake is 40 feet at its deepest and has big fish, frogs and turtles. Several spots for easy in for a clean swim. (Think your own private sporting camp.) This is an investment opportunity with endless potential. Centrally located to NYC, Albany, and The Berkshires. Easy to show and calls are welcome for any additional questions!
Status Change Information
Status Change Timestamp: 2026-01-09
Major Change Timestamp: 2026-01-09T19:38:39Z
Major Change Type: New Listing
Appliances
Electric Water Heater: 1
Water Heater: 1
Book Information
Liber/Book: 90
Page: 550
Section: 90
Construction Materials
Metal Siding: 1
Electric
Three Phase: 1
Exterior Features
Dock: 1
Private Entrance: 1
Storage: 1
Fencing
Chain Link: 1
Foundation Details
Slab: 1
Frontage Type
Lakefront: 1
Heating
Forced Air: 1
Natural Gas: 1
Possession
Close Of Escrow: 1
Road Frontage Type
State Road: 1
Road Surface Type
Paved: 1
Roof
Asphalt: 1
Metal: 1
Security Features
24 Hour Security: 1
Sewer
Public Sewer: 1
Showing Considerations
Occupied: 1
Structure Type
Manufactured House: 1
Water Source
Public: 1
Waterfront Features
Lake: 1
Documents Available
Survey: 1
Income and Expenses
Gross Income: 0
Maintenance Expense: 0
Current Use
Commercial: 1
Mixed Use: 1
Office: 1
Recreational: 1
Retail: 1
Warehouse: 1
Building Features
Overhead Door(s): 1
Business Type
Administrative and Support: 1
Barber/Beauty: 1
Commercial: 1
Construction/Contractor: 1
Locksmith: 1
Professional Service: 1
Professional/Office: 1
Recreation: 1
Retail: 1
Storage: 1
Warehouse: 1
Showing Requirements
24 Hour Notice: 1
Appointment Only: 1
Call Listing Agent: 1
No Lockbox: 1
Showing Service: 1
Text Listing Agent: 1
Location Tax and Legal
Street Number: 191
Street Name: Columbia Turnpike
County: Columbia
State: NY
Zip Code: 12534
Town (Taxable): Greenport
Property Features
Appliances: Electric Water Heater; Water Heater
Building Features: Overhead Door(s)
Business Type: Administrative and Support; Barber/Beauty; Commercial; Construction/Contractor; Locksmith; Professional Service; Professional/Office; Recreation; Retail; Storage; Warehouse
Construction Materials: Metal Siding
Current Use: Commercial; Mixed Use; Office; Recreational; Retail; Warehouse
Documents Available: Survey
Electric: Three Phase
Exterior Features: Dock; Private Entrance; Storage
Fencing: Chain Link
Foundation Details: Slab
Frontage Type: Lakefront
Heating: Forced Air; Natural Gas
Possession: Close Of Escrow
Road Frontage Type: State Road
Road Surface Type: Paved
Roof: Asphalt; Metal
Security Features: 24 Hour Security
Sewer: Public Sewer
Showing Considerations: Occupied
Structure Type: Manufactured House
Water Source: Public
Waterfront Features: Lake
Showing Requirements: 24 Hour Notice; Appointment Only; Call Listing Agent; No Lockbox; Showing Service; Text Listing Agent

Listing Courtesy of Houlihan Lawrence Inc.
Listing Agent: Paul Barrett

Information deemed reliable but not guaranteed.