Perched high on a hill on a country road in lower Columbia County amid extensive apple orchards and Victorian farmhouses, this sleek custom built ranch house offers spectacular year round Catskill Mountain views. This light filled 3 bedroom, 2 bath 1512 sq. ft. home complete with Central Air built in 2004 says new, new, new. The comfortable open plan living area adjoins a pristine heated 2 car+garage and the 48 foot covered rear porch adds 3 season outdoor enjoyment --just imagine the sunsets over the mountains! Country living at it's best, yet only minutes from the amenities available in the Town of Claverack and the City of Hudson. 2 hours form NYC. 40 min from Albany
ManufacturedProperty Type
2004Year Built
1.5 acresLot Size
$321Est. Price/Sq.Ft.
2 car garageParking
Listing by Kathy Duffy• Four Seasons Sotheby's Int.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
3
Baths
2
Stories
1
Lot width
—
Lot depth
—
Lot size
1.5 Acres
Year renovated
—
Sq. Ft.
1,512
Year built
2004
Style
Single Family Residential
County
Columbia County
APN
102889A13100000010691200000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 28, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 2
Parking Features: Attached
Interior
Bathroom Information
# of Full Bathrooms: 2
Heating & Cooling
Has Heating
Heating: Baseboard, Hot Water, Oil
Interior Features
Window Features: Insulated Windows
Appliances: Other, Water Heater, Washer, Refrigerator, Range, Microwave, Dryer, Dishwasher
Flooring: Carpet, Tile
Has Fireplace
# of Fireplaces: 1
Fireplace Features: Gas Log, Living Room
Room Information
# of Rooms Total: 6
Has Basement
Basement Details: Full
Exterior
Exterior Features
Patio And Porch Features: Deck, Porch
Roof: Asphalt, Shingle
Building Information
Structure Type: Manufactured House
Levels: One
# of Stories Total: 1
Construction Materials: Vinyl Siding, Other
Foundation Details: Concrete Perimeter
Property Features
Has View
Other Structures: Shed(s)
Property Information
Property Type: Residential
Property Sub Type: Manufactured Home
Raw Mls Property Sub Type: Single Family Residence
Lot Information
Road Surface Type: Paved
Lot Size Area: 1.5
Lot Size Units: Acres
Lot Size Acres: 1.5
Zoning Description: Res/Ag
Utilities
Utility Information
Water Source: Private, Well
Electric: 200+ Amp Service
Sewer: Septic Tank
Location
Schools Information
High School District: Hudson
Location Information
Directions: East from Hudson on Rte 23B to 4-Way Light in the center of Claverack (Rte 23 and Rte 9H) Right onto Rte 9H, Left onto Rte 27,Right onto Schoolhouse, right onto Millbrook. #124 is the 2nd house on your left.
Public facts
Beds: 3
Baths: 2.0
Sq. Ft.: 1,512
Stories: 1.0
Lot Size: 1.5 acres
Style: Single Family Residential
Year Built: 2004
Year Renovated: —
County: Columbia County
APN: 102889A13100000010691200000
Home facts updated by county records on Aug 28, 2026
Around this home
Schools
Montgomery C Smith Intermediate School
Public PreK-5 • Assigned • 4.6mi
2/10
Hudson Junior Senior High School
Public 1-12 • Assigned • 4.9mi
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
65
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.