Schedule a Showing
Share
Print
|
Mixed-Zoned Property with Immense Potential Mixed zoning allows for the integration of residential, commercial, and recreational uses within a single development, creating walkable, integrated communities that promote efficiency and reduce vehicle reliance, significantly enhancing urban livability and sustainability. Hence the possibilities! Welcome to your next chapter in the versatile space of 4 Delaware Avenue. The main floor features an open floor plan with two bedrooms and one bathroom. The partially finished basement includes an additional bathroom, a desk area, an office, and a large open room. Having most recently housed a daycare for over 10 years, this property offers the unique opportunity to live or rent upstairs while running a business or renting out the lower level. Located uptown in the Greenport/Hudson business district, the property is surrounded by established amenities including dental offices, shopping centers, supermarkets, and more. Accessibility is a priority, with convenient handicap-accessible entrances located at both the side and rear of the building. The upstairs unit is currently rented for 1,900 per month. Please allow 48 hours' notice for showing requests, as the tenant works from home.
Property Type(s):
Single Family
| Last Updated | 2/11/2026 | Year Built | 1989 |
|---|---|---|---|
| Community | Greenport | County | Columbia |
Additional Details
| AREA | Greenport |
|---|---|
| BASEMENT | FINISHED, Yes |
| HEAT | FORCED AIR |
| LOT | 0.46 acre(s) |
| LOT DIMENSIONS | 0.46 |
| PARKING | Paved, Parking Lot |
| SEWER | Public Sewer |
| STYLE | RAISED RANCH |
| TAXES | 2791 |
| WATER | Public |
| ZONING | Converted Res COM 1 |
Location
Contact us about this Property
| / | |
| We respect your online privacy and will never spam you. By submitting this form with your telephone number you are consenting for Lindsay LeBrecht to contact you even if your name is on a Federal or State "Do not call List". | |
Listed with Columbia County RE Specialist
IDX information © 2026 by the Hudson Valley Catskills Region Multiple List Service. All Rights Reserved.
The data relating to real estate on this website comes in part from the IDX of the Hudson Valley Catskills Region Multiple List Service.
Information is deemed reliable but is not guaranteed accurate by the MLS. 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.
This IDX solution is (c) Diverse Solutions 2026.
Twitter
Facebook
Email