Property
$2,250,00069.02 Acres12 beds • 6 baths
For Sale
For Sale
$2,250,00069.02 Acres
For Sale
12 beds • 6 baths

274 Fingar Road, Hudson, NY 12534 - Columbia County

Static Google Map
Property ID 23420575

Is this your property? Sell it faster with premium placement and targeted ads.

MULTI_FAMILY - Ranch - Hudson, NY

Experience quiet country living with this beautiful mixed-use farm & investment property! 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 & freshly painted & 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 965 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. The large open fields offer wide views of the night sky, perfect for star-gazing! Come see it for yourself, the possibilities are endless! --(Located in the town of Greenport [no zoning]) (Associated with MLS#850930 (land))

Copyright © 2025 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

From elevation to risk assessment

Search for detailed parcel information including; Elevation & Vegetation Maps, Ownership Information, Detailed Parcel Information, Crop History Map, Soil Survey Productivity Data, and more.

Research Parcel Information
Contact Seller

Keller Williams Hudson Valley

License #10401390348

Kingston, NY

(845) 481-2700
Listing provided by
Dana Luke
Keller Williams Hudson Valley(914) 403-6165
Source: ListHub, MLS# 850195
Listing status: Active
Listing last updated: December 3, 2025 at 7:46 PM
Listing last checked: December 3, 2025 at 7:30 PM
Report this listing
D

Dana Luke

Keller Williams Hudson Valley
View Phone Number

Message

Is this your property? Sell it faster with premium placement and targeted ads.

Dana Luke

Keller Williams Hudson Valley