Beach Homes Realty
Enter City, Zip or MLS

274 fingar road

Hudson, NY 12534

$2,250,000

Land
WaterfrontNew Listing
Image 1: Aerial View
Image 2: Aerial View
Image 3: Aerial View
Image 4: Aerial View
Status Active
MLS # 850930
County Columbia
More Info
Category Land
Status Active
MLS # 850930
County Columbia
Listed By: Listing Agent Dana Luke
Keller Williams Hudson Valley - (845) 481-2700
Experience quiet country living with this beautiful 69 acre mixed-use farm & investment property! *For additional info on rental units, etc. please see MLS# 850195 (residential income)* -- This unique property has so much to offer, including FOUR rental units (3 single family homes + a 3-bedroom apartment), a scenic creek that runs along the entire edge of the property (perfect for summer swims!) , stunning woodland trails with views of the mountains and farmland, along with multiple large barns & fertile soils, ideal for farming & agriculture. ---- The 2,157 sq. ft. historic stone house, built in 1780, has 2 bedrooms, 1.5 baths, hardwood floors, a large parlor, a dining room and living room, a porch overlooking the pond & a separate large carriage house 2 storage bays, a garage space, & a second floor that can be converted into additional storage or living space. This home has been recently updated & has a new roof & new septic system. ---On this property you will also find a large private pond (perfect for fishing!), tons of storage areas, and a 3-bay workshop (perfect for wood-working or other hands-on projects), several large barns capable of storing farm equipment, hay, boats, animals, lumber, vehicles, etc., and wooded areas for hiking & other ideal spots for hunting or camping. ---In addition to the stone house, this property also has 3 ADDITIONAL units. It also has a well and septic already set up for a potential 5th unit near the pond, making this an incredible investment opportunity! The fields can also be leased out to farmers for additional income & tax exemptions. ---The 3 additional units include: --"The Log House" which is a 1,068 sq. ft. single-family log home built in 2005, with 2 bedrooms (plus 2 garrett rooms on second floor), 1 bathroom, a full basement and a large wrap-around porch. --"The Ranch" which is a 1,425 sq. ft. ranch-style modular home built in 2005, with 3 beds and 2 baths, a large full walk-out basement, a beautiful spacious yard with a large pond, and a storage shed. There is also a small creek that runs along the back of the home, a large wrap-around porch, and a ton of privacy! -- *This unit is located on the opposite side of the road, along with the existing well & septic for potential 5th unit - this portion of the property would be easily subdividable.* ---"The Milkhouse Apartment" is a roughly 950 sq. ft. 3 bed, 1 bath apartment located on a second floor above the milkhouse. It has a spacious living room with a sliding door to the rear deck which allows for privacy and views of the back fields & the creek, and it also has a large storage unit underneath. ---The property also has 2 chicken coops if you are looking to raise your own chickens! There are also multiple large barns capable of housing many other animals, making this an ideal place for an animal sanctuary. ---This property offers both convenience & peace and quiet. It is located on a quiet back road, but less than 10 minutes from downtown Hudson, grocery stores, schools, restaurants, clothing stores, and the train station. Located in town of Greenport (does not have zoning). The possibilities here are endless -- come see it for yourself!
Location not available

Exterior Features

  • Garage No
  • Water Well, Private, Shared Well
  • Sewer Septic Tank
  • Lot Description Hilly, Irregular Lot, Part Wooded, Pasture, Private, Rolling Slope, Secluded, Views, Waterfront, Wooded

Neighborhood & Schools

  • Elementary School Montgomery C Smith Inter School
  • Middle School Contact Agent
  • High School Hudson High School

Financial Information

  • Parcel ID 104000-130-000-0001-009-000-0000

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Keller Williams Hudson Valley - (845) 481-2700
Listings courtesy of the One Key MLS as distributed by MLS GRID.

IDX information is provided exclusively for consumers’ personal noncommercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interestedin purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.

Based on information submitted to the MLS GRID as of 02/20/2026 05:17:09 UTC. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to: DMCAnotice@MLSGrid.com.

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner’s behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

© 2026 One Key MLS, Inc.
Listing data is current as of 02/20/2026.

Contact Our Agent

By clicking “Submit”, you agree that Beach Homes Realty, its affiliates, and real estate professionals may contact you by phone, text, or email to any phone number and email address you provided, including by automated means, even if your number is on a federal, state, or our internal Do Not Call list. You also agree to our Terms of Use and Privacy Policy.