Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
9 Beds
11 Baths
12,997 sqft

$3,100,000

223 Schoolhouse Road, Hudson NY, 12534

Price per sqft$238.52
Property size12,997 sqft
Property typeResidential

Overview

Sold

Closed

Listed Aug 1, 2024

Updated Jun 9

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.

Additional information

MLS® ID
153855

Interior Features

Bedrooms
9
Bathrooms
11
Fireplace
Yes
Cooling
Yes
Heating
Yes
Basement
Yes

Exterior Features

Lot Size
18.43 Acres

Other Property Details

Garage
Yes
View
Yes
MLS provider logo

Listed by Shaina Marron with Houlihan Lawrence Inc.
Listing Contact:  

The IDX display contains information sourced from the Hudson Valley Catskill Region MLS as of 6/9/2026. This data is intended solely for personal, non-commercial use and is not to be utilized for any other purposes except to identify potential properties for purchase. Although the MLS data displayed is typically considered reliable, it is not guaranteed to be accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and are advised to conduct their own investigations or seek professional assistance. Other sources besides the Listing Agent may have contributed to the MLS data presented. Unless expressly specified in writing, the Broker/Agent has not confirmed any information obtained from external sources. The Broker/Agent may or may not have acted as the Listing and/or Selling Agent and cannot guarantee the accuracy of property locations displayed on any map. Any compensation offers are solely made to participants of the MLS where the listing is registered.

©2026 Hudson Valley Catskill Region MLS all rights reserved.

Data last updated on 6/9/2026 at 4:47 PM UTC

 

Powered by Luxury Presence