Sold

223 Schoolhouse Road, Hudson, NY 12534

Beds
9
Baths
11
Sqft
12,997

View property features, location on map, relevant school information and overview from seller's agent.

Listed byHoulihan Lawrence Inc.
  • 3
  • 0

Overview

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.

Location

Full feature list

Basic info

Number of bedrooms
9
Number of bathrooms
11
Square feet
12,997
Lot size (acres)
18.43

Interior features

Basement
Yes, Finished
Fireplaces
1

Utilities

Heating
Forced air, Heat pump, Radiant
Cooling
Central air
Sewer
Septic tank
Water
Well, Private

Public schools

Loading

Disclaimer: Certain information displayed on this listing has been derived from parties other than Final Offer, LLC. Information provided and their sources have been deemed reliable, but accuracy of information is not guaranteed and therefore should be independently verified.

Sourced from: Columbia Greene Northern Dutchess MLS MLS®#: 153855

The data relating to real estate for sale on this website comes in part from the Internet Data exchange (IDX) program of the Columbia Greene Northern Dutchess MLS. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed. Copyright ©2026 Columbia Greene Northern Dutchess MLS. All rights reserved.