Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Listing photo for 223 Schoolhouse Rd, Hudson, NY
Previous View the Previous slide Next View the next slide

223 Schoolhouse Rd,

Hudson, NY

$2,995,000

9 Beds
11 Baths
12,997 Sqft
18.43 Acres

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.

Facts & Features
MLS® # 153855
Price $2,995,000
Bedrooms 9
Bathrooms 11.00
Full Baths 10
Half Baths 1
Square Footage 12,997
Acres 18.43
Type Residential
Sub-Type Residential
Style Contemporary, Cottage, Country French, Farm House, Traditional
Status Active
MLS cgndmls
Community Information
Address 223 Schoolhouse Rd
Area Claverack
City Hudson
County Columbia
State NY
Zip Code 12534
Amenities
Garages Attached
View Catskills, Country, Far Reaching, Farmland, Hilltop, Mountain, Panoramic, Pastoral, Valley View, Orchard
Is Waterfront No
Has Pool No
Interior
Appliances Counter Top Range, Dishwasher, Disposal, Freezer, Microwave, Wall Oven, Refrigerator, Water Treatment, Built-In Range, Washer/Dryer
Heating Central, Fireplace(s), Forced, Radiant, Heat Pump, Solar, Other
Cooling Central Air
Has Basement Yes
Basement Finished, Walkout, Interior Entry, Other
Fireplace Yes
# of Fireplaces 1
Fireplaces Living Room, Kitchen
Exterior
Exterior Cedar, Shingle, Wood
Windows Casement, Crankout, Double Hung, Screens
Roof Shingle
Construction Frame
Foundation Poured Concrete, Slab
School Information
District Hudson
Additional Information
Date Listed August 1st, 2024
Days on Market 15
Listing Details
Listing Courtesy of Houlihan Lawrence Inc.
Mortgage Calculator

This mortgage calculator can be used to figure out monthly payments of a home mortgage loan, based on the home's sale price, the term of the loan desired, buyer's down payment percentage, and the loan's interest rate.

Purchase & Financing Information

Yes, I would like more information from Coldwell Banker Village Green Realty. Please use and/or share my information with a Coldwell Banker Village Green representative to contact me about my real estate needs.

By clicking Inquire I agree a Coldwell Banker Village Green Realty representative may contact me by phone or text message including by automated means about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the privacy policy 

Listing information last updated on August 16th, 2024 at 1:05pm EDT.