First Time on the Market in over 50 Years! A Rare Opportunity Awaits. Cherished by the same family for generations, this property is available for the first time in decades. Once a thriving apple farm, it offers endless potential for agricultural use, a wedding venue, brewery, or your dream country retreat. With three parcels, it features a vibrant brook and stunning Catskills views. Stroll the grounds, taking in the perfumed scent of apples, lush greenery, and natural beauty. The classic farmhouse has timeless curb appeal. This is a once-in-a-lifetime opportunity to own a piece of history.
Single-familyProperty Type
1840Year Built
15.1 acresLot Size
$350Est. Price/Sq.Ft.
2 garage spacesParking
Listing by Scott Varley• KW Platform
•518-281-6808 (agent)
•scottvarley@kw.com (agent)
Bought with Anthony D'Argenzio• Houlihan Lawrence Inc
First Time on the Market in over 50 Years! A Rare Opportunity Awaits. Cherished by the same family for generations, this property is available for the first time in decades. Once a thriving apple farm, it offers endless potential for agricultural use, a wedding venue, brewery, or your dream country retreat. With three parcels, it features a vibrant brook and stunning Catskills views. Stroll the grounds, taking in the perfumed scent of apples, lush greenery, and natural beauty. The classic farmhouse has timeless curb appeal. This is a once-in-a-lifetime opportunity to own a piece of history.
Global MLS #202428098
Jan 17, 2025
Sold
$850,000
$341/sq ft
Jan 14, 2025
Pending
—
Dec 3, 2024
Contingent
—
Oct 25, 2024
Listed
$877,777
$352/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Columbia County
APN
102889 141.-1-4
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 25, 2024.
Property details
Parking
Parking Information
Has Garage
# of Garage Spaces: 2
# of Parking Total: 20
Parking Features: Off Street, Detached, Driveway
Interior
Bathroom Information
# of Bathrooms (Full): 2
# of Bathrooms (Total Integer): 2
Bath Levels: Full Bath 1: 1st
Bath Levels: Full Bath 2: 1st
Room 1 Information
Type: Living Room
Level: First
Room 2 Information
Type: Family Room
Level: First
Room 3 Information
Type: Kitchen
Level: First
Room 4 Information
Type: Dining Room
Level: First
Room 5 Information
Type: Other
Description: sunroom
Level: First
Room 6 Information
Type: Other
Description: room next to the family room
Level: First
Room 7 Information
Type: Foyer
Level: First
Room 8 Information
Type: Primary Bedroom
Level: Second
Room 9 Information
Type: Bedroom
Level: Second
Room 10 Information
Type: Other
Description: Wetbar
Level: Second
Room 11 Information
Type: Other
Description: Room between the bedrooms
Level: Second
Basement Information
Basement: Bilco Doors, Full, Walk-Out Access
Laundry Features
Laundry Features: Electric Dryer Hookup, Laundry Room, Washer Hookup
Fireplace Information
Has Fireplace
# of Fireplaces Total: 2
Fireplace Features: Bedroom
Interior Features
# of Rooms Total: 11
Appliances: Refrigerator
Flooring: Wood
Window Features: Double Pane Windows
Exterior
Exterior Features
Roof: Metal
Exterior Features: Other, Barn
Other Structures: Storage, Barn(s), Garage(s)
Property Information
Property Sub Type: Single Family Residence
Property Condition: Fixer
Foundation Details: Stone
Living Area: 2,491
Construction Materials: Wood Siding
Lot Information
Lot Size Acres: 15.1
Lot Size Square Feet: 657,756
Lot Features: Rolling Slope, Mountain(s), Road Frontage, Views, Wooded
WaterfrontYN: Yes
Waterfront Features: Creek
Water Body Name: Claverack Creek
Financial
Tax Information
Tax Annual Amount: $5,970.38
Tax Annual Amount: $5,970.38
Financial Details: General Taxes: $1,979.99
Financial Details: School Taxes: $3,990.39
Utilities
Heating & Cooling
Has Heating
Heating: Oil
Utility Information
Sewer: Septic Tank
Location
School Information
School District: Hudson
Location Information
Directions: New York 23B E. to Millbrook Road in Claverack, continue on Millbrook Rd., The property is on both School House Rd and Millbrook Rd
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Columbia County
APN: 102889 141.-1-4
Home facts updated by county records on Oct 25, 2024
Around this home
Schools
K - 12
Preschool & daycare
Montgomery C Smith Intermediate School
Public PreK-5 • Assigned • 4.7mi
2/10
Hudson Junior Senior High School
Public 1-12 • Assigned • 5.1mi
4/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
7 days above 97° expected this year, 16 days in 30 years
4/10 Wind Factor
10% chance of strong winds in next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Hudson, NY • 12534
Average low and high temperatures (°F)
32
18
35
20
52
32
62
41
69
50
81
60
85
65
81
57
77
53
63
43
52
34
37
22
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 8.8 hours in
June and 3.7 hours in December, placing it below the
U.S. average for solar exposure.
8.8 hrs
3.7 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$829,000 – $1.00M
Sell confidently with a local market expert in Hudson. 3 minutes to get started.