Title Page Background
DEBUG FN args: Array ( [0] => 1878 [1] => [2] => [3] => agent ) BEFORE: Site: 1878 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1878 Igate: njhud LocID: 1878 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1878 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1878 [1] => [2] => [3] => lender ) BEFORE: Site: 1878 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1878 Igate: njhud LocID: 1878 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1878 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1878 [1] => [2] => [3] => other ) BEFORE: Site: 1878 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1878 Igate: njhud LocID: 1878 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1878 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

236 Spillway Road
West Hurley, NY 12491
Laura Warren with Coldwell Banker Village Green, original listing - (845) 679-2255

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $500,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1588 Square Feet
Agency: Coldwell Banker Village Green
Agency Phone: (845) 679-2255

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1825
Notes: Situated on a quiet road within easy reach of Woodstock and Kingston - and only two hours from NYC - this charming farmhouse offers the perfect blend of character, comfort, and convenience.<br /> As you approach, a graceful circular drive provides ample parking and easy access. The charming covered front porch overlooks thoughtfully landscaped gardens, where a seasonal brook winds its way among roses, lilacs, wisteria, hydrangeas, and fruit trees, anchored by two magnificent 200-year-old catalpa trees. It's the perfect spot for your morning coffee, or simply relaxing in nature.<br /> Inside, the open-concept living, dining, and kitchen area features original beams, Acadia wood floors, and a striking stone fireplace with a wood-burning stove that adds warmth and ambiance, providing heat to both floors of the main house in winter. The kitchen is designed for both function and charm, with a fireclay farmhouse sink, butcher block counter tops, a gas range, marble-topped peninsula with seating for four and a pantry. <br /> A separate wing with its own entrance and radiant heat features a home office and a bright 25' x 22' flex space with cathedral ceilings, sprung wood floors and two sets of barn doors, with views over the gardens. Whether used as a studio, gym, or creative retreat, this area adapts easily to your lifestyle. <br /> Sliding doors from the living room open to a spacious screened-in porch overlooking the serene back garden with a firepit, ideal for dining, entertaining, or relaxing. A raised wooden walkway leads to a six-person Michael Phelps-series hot tub, and beyond, trails meander through the woods, offering a peaceful retreat just steps from your door.<br /> Upstairs in the main house, the light-filled primary bedroom includes wood floors, a walk-in closet, and access to 450 sq. ft. of attic storage. A second bedroom and a full bath with marble flooring complete this level.<br /> This home is not only charming but also cost-efficient, with a multi-boiler heating system with on-demand hot water, a leased solar panel system and low property taxes.<br /> Outdoor and cultural enthusiasts alike will appreciate the proximity to year-round activities, including the Ashokan Rail Trail, with 11.5 miles of scenic paths perfect for walking, running and biking along the reservoir, as well as the region's vibrant arts, dining and music scenes.
MlsNumber: --
ListingId: 20251245


Listing Provided By: Coldwell Banker Village Green, original listing
Phone: (845) 679-2255
Office Phone: (845) 679-2255
Agent Name: Laura Warren
Disclaimer: Copyright © 2025 Multiple Listing Service of Ulster County. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => ulster [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: ulster State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: ulster State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1878 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Win Morrison
ASCIIWIn Morrison Realty
Direct: (845) 339-1144

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App