HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

Let's Find Your Next Property.

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic. Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

About Us

  • Who We are
  • Meet the Team

Resources

  • Latest Blogs
  • Free Vendor List
  • PracticalGuides
  • Need Funding?
  • Property Inspector
  • Down Payment Eligibility

Communities

  • Otsego County
  • Schoharie County
  • Chenango County
  • Delaware County
  • Greene County
  • Broome County
  • Oneida County
  • Montgomery County
  • Ulster County

Disclosures

  • Standard Operating Procedure
  • NYS Buyer-Seller
  • NYS Landlord-Tenant
  • Tenant Rights Notice
  • Fair Housing Notice
  • Privacy Policy
  • Location Services
  • Properties Preferences
  • Map Data Attribution

© 2026 Homes, Farms & Land. All rights reserved.

Property at 49 Columbia Turnpike, Greenport, NY 12534
CLOSED
0
$349,999

49 Columbia TurnpikeGreenport, NY, 12534

4 Beds2 Baths1,440 SqFt0.05 Acres
Money Maker Alert!! Nestled in the heart of Hudson, just minutes from Warren Street, the hospital, and Amtrak, this fully revamped gem is ready to roll! Currently pulling in $1,850/month from the 1st-floor unit and boasting a solid Airbnb track record of $120-$180 a night! Whether you're an owner-occupant or looking for an investment, this is the one. Enjoy the best of Hudson with theaters, antique shops, chic boutiques, only a stones throw away. And with the Hudson Valley, Saugerties, Northern Catskills, and Capital District just a short drive away, adventure is always at your doorstep. With less than 2 hours to NYC, the world is your oyster! Ready for a low-maintenance investment that practically runs itself? This is the opportunity you've been waiting for!
1 / 11

Est. Monthly

$1,659/MO

$349,999

49 Columbia Turnpike, Greenport, NY

4 Beds2 Baths1,440 SqFt0.05 Acres

Money Maker Alert!! Nestled in the heart of Hudson, just minutes from Warren Street, the hospital, and Amtrak, this fully revamped gem is ready to roll! Currently pulling in $1,850/month from the 1st-floor unit and boasting a solid Airbnb track record of $120-$180 a night! Whether you're an owner-occupant or looking for an investment, this is the one. Enjoy the best of Hudson with theaters, antique shops, chic boutiques, only a stones throw away. And with the Hudson Valley, Saugerties, Northern Catskills, and Capital District just a short drive away, adventure is always at your doorstep. With less than 2 hours to NYC, the world is your oyster! Ready for a low-maintenance investment that practically runs itself? This is the opportunity you've been waiting for!

StatusClosed
Property TypeMulti Family
Property SubtypeDuplex
Year Built1949
Days on Market111 days

Est. Monthly Payment

$1,658.99

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

49 Columbia Turnpike

Greenport, NY 12534 • Columbia
4
Beds
2
Baths
1,440
SqFt
0.05
Acres
Status
Closed
Property Type
Multi Family
Property Subtype
Duplex
Year Built
194977 years ago
Days on Market
111 days
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $3,158
  • School Taxes
    $2,305
  • Town/County Taxes
    $853
Property History
  • Closed
    Jul 23, 2025 • GLOBAL MLS • 202514601
    $349,999
  • Listed for sale
    Apr 3, 2025 • GLOBAL MLS • 202514601
    $349,999
Mortgage Calculator
Estimated monthly payment for this property
$1,658.99
Down Payment
Interest Rate
Loan Term
%
%
yearsyrs.
Affordability Checkoptional
$

Enter your annual income to see if this home fits your budget

Private Mortgage Insurance

Not required — down payment above 20%
MLS Information
  • Source
    Global MLS
  • MLS#
    202514601
  • Listing Office
    Venture Realty Partners
  • Last Updated
    282 days ago

Climate & Systems

  • Heating
    Ductless

Interior Features

  • Flooring
    Hardwood
  • Basement
    Unfinished

Parking

  • Parking Features
    Driveway
  • Parking Spaces
    3

Lot & Grounds

  • Lot Size
    0.05 acres
  • Lot Features
    Cleared
  • Exterior Features
    None

Type

  • Property Type
    Multi Family
  • Property Subtype
    Duplex
  • Architectural Style
    Traditional

Structure

  • Construction
    Wood Siding
  • Roof
    Asphalt
  • Foundation
    Block

Condition

  • Year Built
    1949
  • Days on Market
    111 days
  • Water
    Public
  • Sewer
    Public Sewer
  • Electric
    200+ Amp Service
  • Utilities
    Cable Available

607-282-6242, (607) 282-6242, or +1 607 282 6242

Kevin Lucero

Kevin Lucero

Lic. Real Estate Salesperson

CallEmail
Picked for you

Similar Properties

Handpicked listings that match what you're looking at

View all →
  • 70 N Lake Avenue, Albany, NY 12206ACTIVE$315,000

    70 N Lake Avenue, Albany, NY 12206

    4 Beds3 Baths1,610 SqFt0.05 Acres

    LISTING BY JANNAH REALTY LLC

  • 199 N Lake Avenue, Albany, NY 12206ACTIVE$320,000

    199 N Lake Avenue, Albany, NY 12206

    8 Beds2 Baths2,032 SqFt0.11 Acres

    LISTING BY GROUP TWENTY SIX NY LLC

  • 807 Craig Street, Schenectady, NY 12307ACTIVE$324,900

    807 Craig Street, Schenectady, NY 12307

    6 Beds2 Baths2,220 SqFt0.07 Acres

    LISTING BY TRIPLE T PREMIER REALTY LLC

  • 1063 University Place, Schenectady, NY 12308ACTIVE$324,999

    1063 University Place, Schenectady, NY 12308

    8 Beds3 Baths3,290 SqFt0.1 Acres

    LISTING BY FOUR SEASONS SOTHEBY'S INTERNATIONAL REALTY

  • 131 Furman Street, Schenectady, NY 12304ACTIVE$325,000

    131 Furman Street, Schenectady, NY 12304

    5 Beds3 Baths2,330 SqFt0.13 Acres

    LISTING BY DUFEK REAL ESTATE GROUP, LLC

  • 631 Washington Avenue, Albany, NY 12206ACTIVE$325,000

    631 Washington Avenue, Albany, NY 12206

    5 Beds2 Baths2,272 SqFt0.09 Acres

    LISTING BY GABLER REALTY, LLC

  • 1111 Fort Hunter Road, Rotterdam, NY 12303ACTIVE$327,900

    1111 Fort Hunter Road, Rotterdam, NY 12303

    3 Beds2 Baths1,644 SqFt0.49 Acres

    LISTING BY HOWARD HANNA CAPITAL INC

  • 146 David Avenue, Cheektowaga, NY 14225ACTIVE$329,000

    146 David Avenue, Cheektowaga, NY 14225

    6 Beds3.5 Baths2,867 SqFt0.19 Acres

    LISTING BY KELLER WILLIAMS REALTY WNY

  • 1209 State Route 52, Fallsburg, NY 12759ACTIVE$329,888

    1209 State Route 52, Fallsburg, NY 12759

    5 Beds2 Baths1,785 SqFt0.2762 Acres

    LISTING BY LOMBARDO HOMES & ESTATES

  • 46 Park Street, Buffalo, NY 14201ACTIVE$329,900

    46 Park Street, Buffalo, NY 14201

    3 Beds2.5 Baths1,695 SqFt0.0675 Acres

    LISTING BY KELLER WILLIAMS REALTY WNY