Title Page Background
DEBUG FN args: Array ( [0] => 1835 [1] => [2] => [3] => agent ) BEFORE: Site: 1835 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1835 Igate: njhud LocID: 1835 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 = 1835 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1835 [1] => [2] => [3] => lender ) BEFORE: Site: 1835 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1835 Igate: njhud LocID: 1835 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 = 1835 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1835 [1] => [2] => [3] => other ) BEFORE: Site: 1835 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1835 Igate: njhud LocID: 1835 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 = 1835 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

312 Decker Road
Stamford, NY 12167
Hillary Kolos with Compass Greater NY, LLC, original listing - (838) 877-8283

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $429,900
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1152 Square Feet
Agency: Compass Greater NY, LLC
Agency Phone: (838) 877-8283

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: Watch the sun set every evening from this sweet updated chalet overlooking the Western Catskills. If you are a horse enthusiast or on the lookout for an amazing outbuilding, there is a beautiful new three-stall horse barn with electric and water that can also be easily reimagined as a studio, gym or garage. <br /> <br /> The lovingly renovated house has a classic chalet layout with cathedral ceilings, open kitchen and living/dining room, cozy pellet stove, and two glass sliders facing sweeping mountain views to the west. Two bedrooms (one with a washer and dryer) and a renovated bathroom round out this floor. Upstairs is the spacious loft - currently set up with a bed - which offers more room for an office or living space. <br /> <br /> This home has had extensive renovations including the addition of new siding, a deck, Anderson windows, doors, flooring, roof, well tank, hot water heater and a mini-split with AC. The kitchen and bathroom have also been totally updated. The only thing left to do is move in! <br /> <br /> And no need to board your horses far away, this property lets you keep them close by and happy. The 24'x30' center aisle horse barn has three 10'x12' matted stalls and a 10'x12' tack room and is surrounded by 2700 square feet of mud-free crusher stone drylot paddock. The adjoining grass pasture is surrounded by 1200' of board and electric fencing. Across the over 5 acres, there are even more features - like the large open yard, wooded area, two sheds and multiple raised garden beds. <br /> <br /> Less than 10 minutes away are the villages of Stamford and Hobart with their cute shops, new community pool, and the Catskills Scenic Rail Trail. A little over 20 mins away is skiing at Plattekill Mountain and other cute towns like Roxbury, Margaretville and Bovina. All this and about 2.5 hours from the GW Bridge in NYC.
MlsNumber: --
ListingId: 20251006


Listing Provided By: Compass Greater NY, LLC, original listing
Phone: (838) 877-2247
Office Phone: (838) 877-8283
Agent Name: Hillary Kolos
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App