Perched atop a generational apple orchard, Harvest Moon Estate offers a peaceful respite and sweeping views of the Catskill Mountains and Hudson Valley. Built between 2015-2019, this enchanting three-building estate harmonizes with its natural surroundings and celebrates handcrafted artistry. Privately situated on 18+ acres, it’s just minutes from downtown Hudson and amenities, making it the perfect upstate retreat.Home to a local artist, Harvest Moon Estate features exquisite handmade ceramic tile work and fixtures, designed specifically for each functional use and unique artistic statement. These custom touches exemplify the estate’s thoughtful construction, reflecting both artistic flair and practical design.The Main House opens through an orchard-red door into a spacious layout designed for entertaining and one-level living. Expansive views and high ceilings are complemented by custom carpentry and hand-carved ceramic installations. Indoor and outdoor living blend with a four-season veranda, porches, a terraced lawn, and an outdoor pizza oven. The main level includes an open kitchen, living room, dining room, office, and laundry room, as well as an efficient wood-burning masonry stove wrapped in mosaic tile and a cozy propane iron fireplace with antique surround. The exceptional primary suite offers a screened sleeping porch, two full baths, and two walk-in closets, while the expansive upstairs has three bedrooms and full bath. The finished basement provides additional flexibility.Set amongst the apple trees, the Guest House currently operates as a successful Airbnb. It can be configured as one residence or divided into two fully equipped units. The upper level features a bedroom, sleeping loft, and two full baths, while the lower level includes two bedrooms and two full baths, each with its own outdoor porch space. Each unit has kitchen washer/dryer, split heating and cooling systems, and radiant floor heating. It is available fully furnished, making it ideal to continue as a rental property or part of a family compound.At the top of the hill sits the Studio, a haven for creative pursuits offering an open workspace with 16-ft ceilings and east, south, and west-facing light, a lofted one-bedroom apartment, an outdoor patio, and a zen garden. The building is equipped with solar panels and an EV charger.Blending country living, artisanal craftsmanship, and modern convenience, Harvest Moon Estate offers a unique sanctuary and upstate opportunity.
Property Details
Price:
$2,995,000
MLS #:
153855
Status:
Active
Beds:
9
Baths:
11
Address:
223 Schoolhouse Road
Type:
Single Family
Subtype:
Deeded
Neighborhood:
claverack
City:
Hudson
Listed Date:
Aug 1, 2024
State:
NY
Finished Sq Ft:
12,997
ZIP:
12534
Lot Size:
18 acres
Courtesy of Houlihan Lawrence Inc.. Disclaimer: All data relating to real estate for sale on this page comes from the Broker Reciprocity (BR) of the Columbia County and Northern Dutchess MLS. Detailed information about real estate listings held by brokerage firms other than Canaan Realty include the name of the listing broker. Neither the listing company nor Canaan Realty shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. The Broker providing this data believes it to be correct, but advises interested parties to confirm any item before relying on it in a purchase decision. Copyright 2024. Columbia County and Northern Dutchess MLS. All rights reserved.
223 Schoolhouse Road
Hudson, NY
See this Listing
Mortgage Calculator
Schools
School District:
Hudson
Interior
# of Fireplaces
1
Basement
Finished, Walkout, Interior Entry, Other
Electric
200 Amps, Other, Solar Panels
Floors
Cement, Hardwood, Tile, Wood
Full Bathrooms
10
Half Bathrooms
1
Heat Type
Central, Fireplace(s), Forced, Radiant, Heat Pump, Solar, Other
Exterior
# of Garage Spaces
0.00
Color
Black, Red, Blue
Construction
Frame
Foundation
Poured Concrete, Slab
Garage
Attached
Paved Street
Yes
Roof
Shingle
Sewer
Septic Tank
Siding
Cedar, Shingle, Wood
Views
Catskills, Country, Far Reaching, Farmland, Hilltop, Mountain, Panoramic, Pastoral, Valley View, Orchard
Financial
School Tax
16269.04
Map
Community
- Address223 Schoolhouse Road Hudson NY
- AreaClaverack
- CityHudson
- CountyColumbia
- Zip Code12534
Similar Listings Nearby
- 256 Island Drive
Copake, NY$3,875,000
7.44 miles away
- 204 Lasher Avenue
Germantown, NY$3,875,000
8.96 miles away
- 49 Sunset Circle
Germantown, NY$3,850,000
6.85 miles away
- 20 22 Smithfield Road
Amenia, NY$3,850,000
22.54 miles away
- 100 Bellevue Road
Highland, NY$3,650,000
34.00 miles away
- 0 Rowe Road
Milan, NY$3,500,000
16.33 miles away
- 7 Stoneridge Drive
Colonie, NY$3,500,000
36.55 miles away
- 174 Vandenburgh Road
Coxsackie, NY$3,500,000
13.69 miles away
- 1142 Batter Street
Duanesburg, NY$3,500,000
48.47 miles away
- 1142 Batter Street
Duanesburg, NY$3,499,999
48.47 miles away