Buy
  • Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
    Canada Listings (730)
    Mexico Listings (329)
    Central America Listings (620)
    Caribbean Islands Listings (46)
    Asia Listings (20) Europe Listings (9)
    Advanced Search
Sell Find an Agent
BeachHouse.com BeachHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BeachHouse.com logo
Share
BeachHouse.com logo
Ad #6411479
MLS #202521611
Listing photo

Incredible opportunity for mixed residential and commercial

Fairview lot: 2, Hudson, NY 12534
$499,000
--Beds
--Baths
--Sqft
5.8Acres

About this property

Incredible opportunity for mixed residential and commercial development in the heart of the Hudson-Greenport commercial and residential area. Access to public sewer and water, electric and gas. Close to Amtrak station. Permissible zoning and development friendly local officials. Great private location, set back from the Fairview Avenue thoroughfare. The best of both worlds: convenience to shopping and entertainment, yet privacy for residents. Easy access to Route 9, the Taconic Parkway, The New York State Thruway, the Catskills & the Berkshires. Also available together with a 2 Family needing restoration and 2 small lots.

Property Features

0 Beds
0 Baths
0 Sqft
5.8 Acres
Beachview
On Beachfront
$1,896 / yr property tax
Columbia County

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

David Birch

Barns & Farms Realty, LLC

518-928-7239

Location

Map
Listing Agent: David Birch (License #: 49BI0655816) 518-928-7239
Broker: Barns & Farms Realty, LLC 518-851-7727 Listing Site
Copyright © 2026 Global MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
BeachHouse.com
Printed Aug 12, 2026

Photo Gallery

Incredible opportunity for mixed residential and commercial - photo 1
Incredible opportunity for mixed residential and commercial - photo 2
Incredible opportunity for mixed residential and commercial - photo 3
Incredible opportunity for mixed residential and commercial - photo 4
Incredible opportunity for mixed residential and commercial - photo 5
Incredible opportunity for mixed residential and commercial - photo 6
Incredible opportunity for mixed residential and commercial - photo 7

$499,000

--
Beds
--
Baths
--
Sqft

Fairview lot: 2, Hudson, NY 12534

By contacting this agent you agree to these Terms and Conditions.
Home New York Greenport
Incredible opportunity for mixed residential and commercial - photo 1
Incredible opportunity for mixed residential and commercial - photo 2
Incredible opportunity for mixed residential and commercial - photo 3
Incredible opportunity for mixed residential and commercial - photo 4
Incredible opportunity for mixed residential and commercial - photo 5
MLS# 202521611
Acreage For Sale

Incredible opportunity for mixed residential and commercial

$499,000

Fairview lot: 2, Hudson, NY 12534

--
Beds
--
Baths
--
Sqft
5.8
Acres
$499,000
Fairview lot: 2, Hudson, NY 12534
-- Beds
-- Baths
-- Sqft
5.8 Acres
Incredible opportunity for mixed residential and commercial development in the heart of the Hudson-Greenport commercial and residential area. Access to public sewer and water, electric and gas. Close to Amtrak station. Permissible zoning and development friendly local officials. Great private location, set back from the Fairview Avenue thoroughfare. The best of both worlds: convenience to shopping and entertainment, yet privacy for residents. Easy access to Route 9, the Taconic Parkway, The New York State Thruway, the Catskills & the Berkshires. Also available together with a 2 Family needing restoration and 2 small lots.
393 days
on BeachHouse.com
0
view
0
saves

Property Details

HOME DETAILS

0 Beds
0 Baths
0 Sqft
5.8 Acres

BEACH & VIEW

Beachview
On Beachfront

FINANCIAL & COMMUNITY

$1,896 / yr property tax
Columbia County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
6411479
Viewed
0 time
Listing Status
Active
Added
Jul 14, 2025
Last Refreshed
Jul 03, 2026 06:17:28 PM

Listing Information

Data Source
Global MLS, Inc.
Source Property ID
202521611
Listing Agent: David Birch (License #: 49BI0655816) 518-928-7239
Broker: Barns & Farms Realty, LLC 518-851-7727 Listing Site
Copyright © 2026 Global MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home

Explore Similar Properties

For Sale
This can be your piece of paradise on the East End of Long - photo 1
This can be your piece of paradise on the East End of Long - photo 2
This can be your piece of paradise on the East End of Long - photo 3
This can be your piece of paradise on the East End of Long - photo 4
This can be your piece of paradise on the East End of Long - photo 5
This can be your piece of paradise on the East End of Long - photo 6
This can be your piece of paradise on the East End of Long - photo 7
This can be your piece of paradise on the East End of Long - photo 8
This can be your piece of paradise on the East End of Long - photo 9
This can be your piece of paradise on the East End of Long - photo 10
This can be your piece of paradise on the East End of Long - photo 11
This can be your piece of paradise on the East End of Long - photo 12
This can be your piece of paradise on the East End of Long - photo 13
This can be your piece of paradise on the East End of Long - photo 14
This can be your piece of paradise on the East End of Long - photo 15
This can be your piece of paradise on the East End of Long - photo 16
This can be your piece of paradise on the East End of Long - photo 17

$559,000

1 Beds | 1.0 Baths | 500 Sqft

31 Sage Blvd 31, Greenport, NY 11944

This can be your piece of paradise on the East End of Long

Added: 03/09/2026 • Updated: 07/06/2026
For Sale
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 1
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 2
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 3
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 4
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 5
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 6
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 7
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 8
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 9
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 10
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 11
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 12
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 13
Build Your Dream Home In The Bucolic Area Of Eastern Shores - photo 14

$549,000

0.55 Acres | Lot for sale

110 Homestead Way, Greenport, NY 11944

Build Your Dream Home In The Bucolic Area Of Eastern Shores

Added: 11/05/2025 • Updated: 07/06/2026
For Sale
Wonderful opportunity to build a Residential Home in the - photo 1
Wonderful opportunity to build a Residential Home in the - photo 2
Wonderful opportunity to build a Residential Home in the - photo 3
Wonderful opportunity to build a Residential Home in the - photo 4
Wonderful opportunity to build a Residential Home in the - photo 5
Wonderful opportunity to build a Residential Home in the - photo 6

$545,000

0.67 Acres | Lot for sale

620 Kerwin Blvd, Greenport, NY 11944

Wonderful opportunity to build a Residential Home in the

Added: 07/07/2026 • Updated: 07/07/2026
View More in Greenport View More in Greenport
SEARCH STATES
Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.08.11
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Greenport

Read more
Sort By:
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Greenport Real Estate Agent Info

About Greenport

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.08.11
Terms & Policy