191 Columbia Turnpike, Greenport

$1,999,000

0 Bed
0 Bath
7,200 Sqft
31.4 Acres
0 Garage

Unusual opportunity to own 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!

Essential Information
MLS® #155080
Price$1,999,000
Bathrooms0.00
Square Footage7,200
Acres31.40
Year Built1964
TypeCommercial Sale
Sub-TypeBusiness
StatusActive
Community Information
Address191 Columbia Turnpike
CityGreenport
CountyColumbia
StateNY
Zip Code12534
Amenities
Is WaterfrontYes
WaterfrontLake
Interior
HeatingForced Air, Natural Gas
Appliances

Water Heater, Electric Water Heater

Exterior
ExteriorMetal Siding
RoofAsphalt, Metal
ConstructionMetal Siding
FoundationSlab
Exterior Features

Dock, Private Entrance, Storage

School Information
DistrictHudson
Listing Details
AgentPaul Barrett
Listing Courtesy of Houlihan Lawrence Inc.
LISTING MAP

Get directions to this property:

Properties for Sale Similar to 191 Columbia Turnpike, Greenport, NY

Photo of Listing #153986

73 - 79 N Second Street, Hudson

$2,350,000 - 8,300 Sf

MLS® # 153986

Ulster County Board of Realtors Logo
Photo of Listing #144893

469 Fairview Avenue, Greenport

$1,590,000 - 2 Baths, 3,000 Sf

MLS® # 144893

Ulster County Board of Realtors Logo
Photo of Listing #156717

705 Warren Street, Hudson

$2,495,000 - 4,000 Sf

MLS® # 156717

Ulster County Board of Realtors Logo

Ulster County Board of Realtors Logo The data relating to real estate on this website comes in part from the IDX of the Multiple Listing Service of Ulster County, Inc. Real estate listings held by brokerage firms other than Flemming Realty are marked with IDX logo and the detailed information about them includes the name of the listing broker.

Copyright © 2025 by the Multiple Listing Service of Ulster County, Inc. All Rights Reserved.

All information provided is deemed reliable but is not guaranteed and should be independently verified.

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.