223 Schoolhouse Road

Hudson, NY 12534

$2,995,000
Price
9
Beds
10
Baths
1
1/2 Bath
12,997 Sq. Ft.
$230 / Sq. Ft.
12,997
Sq. Ft.
$230
per Sq. Ft.

Description

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...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.
  1. Listed by Shaina Marron • Houlihan Lawrence Inc.
  2. Listed by Anthony Dargenzio • Houlihan Lawrence Inc.

Amenities

  • Air Conditioning
  • Basement
  • Formal Dining Room
  • Fully Furnished
  • Guest House
  • High Ceilings
  • Laundry
  • Laundry in Building
LISTING UPDATED: 11/07/2024 12:12 PM

Property Details for 223 Schoolhouse Road

StatusContract
MLS #153857
Days on Market89
Taxes-
HOA Fees-
Condo/Co-op Fees-
Compass TypeMulti Family
MLS TypeMulti Family / Multi Family
Year Built2015
Lot Size18.43 AC / 802,810 SF
CountyColumbia County

Building Information for 223 Schoolhouse Road

Stories-Residences3Year Built2015Building Size-Lot Size18.43 AC / 802,810 SF

Property Information for 223 Schoolhouse Road

Summary
Location and General Information
  • ZIP: 12534
  • County: Columbia
  • State: NY
  • Flood Zone: Unknown
  • Directions: take New York 23B E. to Millbrook Road in Claverack, continue on Millbrook Rd., turn left to schoolhouse Road, property is on the left
Taxes and HOA Information
  • Assessment: 690000
  • Association: Columbia County & Northern Dutchess MLS
  • Town Tax: $11,668
  • Tax Map ID: 131.-2-11
  • Tax Exemptions: No
  • School Tax: $16,269
School Information
  • School District: Taconic Hills
Owner
  • Owner Name: Sears Living Trust
Property
Lot Information
  • Square Footage: 12997.0
  • Acres: 18.43
  • Lot Square Footage: 802811.0
  • Lot Measurement: Acres
Property and Assessments
  • Year Built: 2015
  • Picture Count: 77
  • Board Loaded: No
  • Property Disclaimer: Information not guaranteed.
  • Sign on Property: Yes
  • Signed Led Paint Disclosure: No
  • Condition: Excellent
  • Construction: Frame
  • FIPS Code: 21
Utilities
  • Water: Well
  • Sewer: Septic Tank
  • Electric: 200 Amps, Generator Hookup
Interior and Exterior Features
Interior Features
  • Foundation: Poured Concrete, Slab
  • Basement: Dry, Finished, Full, Walkout, Bath/Stubbed, Exterior Entry, Interior Entry
  • Color: Black, Red, Blue
  • # of Furnaces: 3
  • # of Heaters: 3
  • # of Meters: 3
  • Water Heater: Electric
  • Windows: Casement, Crankout, Double Hung, Screens
  • Heat Type: Electric, Forced, Heat Pump, Radiant, Solar, Central, Ductless, Fireplace(s), Wood Stove
Exterior Features
  • Paved Street: Yes
  • Roof: Asphalt, Shingle
  • Siding: Cedar, Shingle, Wood
Room Information
Bathrooms
  • Bathrooms: 11
  • Full Bathrooms: 10
  • Half Bathrooms: 1
Bedrooms
  • Bedrooms: 9
Multi Family
Multi-Family Information
  • # of Units: 3
  • Inc/Exp State Available: No
Rental
Rent Information
  • Lease Type: Net

Property History for 223 Schoolhouse Road

DateEvent & SourcePriceAppreciation
DateEvent & SourcePrice

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 223 Schoolhouse Road

Taxable ValueLand$79,000Additions$611,000Total$690,000
Tax Record2021$1,843 ($154 / month)
Home Facts
Beds3Baths3.5Total Finished SqFt2,788 SqFtAbove Grade Finished SqFt2,788 SqFtStories3Lot Size426,888 SqFtStyleSingle Family ResidenceYear Built2016Zoning07 - MIXEDCountyCOLUMBIAAPN102889 131.-2-11

Schools near 223 Schoolhouse Road

This home is within Taconic Hills Central School District.
Rating
School
Type
Grades
Distance
Public - PK to 6
Public - 7 to 12
Rating
School
Distance
Taconic Hills Elementary School
PublicPK to 6

Taconic Hills High School
Public7 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Sorry, we can't find any similar homes at this time. Please check back later.

Similar Sold Homes

Sorry, we can't find any similar sold homes at this time. Please check back later.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Houlihan Lawrence Inc.

The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers’ personal, non-commercial use. The data relating to real estate for sale or lease on this webpage comes from the the IDX Program of OneKey® MLS, Columbia Greene Northern Dutchess MLS, and Ulster County Board of REALTORS. Real estate listings held by brokerage firms other than Compass are marked with a OneKey® MLS, Columbia Greene Northern Dutchess MLS, or Ulster County Board of REALTORS Logo. Use of these search facilities other than by a consumer seeking to purchase or lease real estate is prohibited. The accuracy of all information is deemed reliable but not guaranteed and should be verified through personal inspection by and/or with appropriate professionals. The data contained herein is copyrighted by the IDX Program of OneKey® MLS, Columbia Greene Northern Dutchess MLS, and Ulster County Board of REALTORS and is protected by all applicable copyright laws. Any unauthorized dissemination of this information is in violation of copyright laws and is strictly prohibited. Information Copyright 2024, OneKey® MLS, Columbia Greene Northern Dutchess MLS, and Ulster County Board of REALTORS. All rights reserved. Data last updated: 11/07/2024 12:12 PM