Title Page Background
HFQUERY 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 = 1875 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1875 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1875 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

106 Porcupine Road
Grahamsville, NY 12740

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $895,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2760
Agency: Fresh Air Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 1997
Notes: In search of an idyllic mountaintop retreat with stunning panoramic views, surrounded by forever wild land with easy access to big mountain hiking, world class cycling (where the US national team trains), and all manner of outdoor activity where the only sights, smells and sounds you'll experience are those produced by nature? If so, this property is not to be missed. <br /> <br /> Perched on a hill overlooking a large meadow and forest beyond sits this custom designed post-and-beam chalet. Built by the current owners who spared no expense, the interior is defined by an expansive open plan main level includes: a spacious living room/dining area with solid cherry wood floors, a wall of windows, a vaulted cedar-clad ceiling and a custom Finnish Tulikivi soapstone wood stove/bake oven; a chef's kitchen complete with a SubZero refrigerator, a gas range and double wall ovens, custom birch cabinetry, granite kitchen island and plentiful counter space; a glass enclosed breakfast nook/sunroom that leads directly to a large deck; and a library/office with built-in cherry bookshelves. The primary suite on the upper level includes solid birch flooring, two walk-in closets that flank the bed, a private deck and a glass enclosed, light-filled ensuite bathroom that includes a soaking tub with marble decking and a custom-Italian tiled walk-in shower. The lower level includes two guest bedrooms, a large laundry room and bonus space that can serve as a home gym, office or additional living space. <br /> <br /> Whole house radiant efficiently heats the entire structure. High-speed internet makes working from home a seamless experience. Very low total annual taxes of $4,760 (some of the lowest in Ulster County) make it attractive vis-a-vis other towns in Ulster.<br /> <br /> Outside, the property is extensively landscaped with a plethora of perennials strategically planted to produce flowers throughout the season, a productive vegetable/flower garden, a massive yard, a large woodshed and two additional storage sheds. <br /> <br /> The Sundown Wild Forest is in close proximity where you'll find incredible hiking trails including the Red Hill Fire Tower, Slide and Table Mountain to name just a few of the many options. Just 20 mins from the property are the Blue Hole at Peekamoose, an ideal spot to take a summer dip, the Russian Mule Craft Brewery, and Hemlock Neversink, which offers yoga and art classes as well as Bittersweet, its upscale restaurant. The closest main towns are Livingston Manor and Ellenville. <br /> <br /> An additional 4 acre adjacent lot is separately available for purchase.
MlsNumber: 20242177


Listing Provided By: Fresh Air Realty, original listing
Name: Fresh Air Realty
Phone: (917) 597-7474
Office Name: Fresh Air Realty
Office Phone: (917) 597-7474
Agent Name: Joseph Satto
Disclaimer: Copyright © 2024 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

HFQUERY 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 = 1875 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Jason Grossman
ASCIIKeller Williams
Call Today!: (845) 796-6065

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App