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 = 1878 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 1878 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 1878 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;

544 Herdman Road
Shandaken, NY 12480
Jasmine Jordaan with Halter Associates Realty, original listing - (845) 679-2010

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,695,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3392 Square Feet
Agency: Halter Associates Realty
Agency Phone: (845) 679-2010

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 36 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: Welcome to The Big Red House, an oasis at the end of a private road surrounded by Mountain Views, a stream and open skies. This property has everything you would want. Hike along miles of hiking trails on your 35 private acres with state land abutting on two sides; or drop in on the custom made skateboard ramp; or maybe just relax and meditate listening to the sounds of the stream; or sit by your pond taking in the breathtaking foliage. After a full day gather your friends around the fire pit and gaze at the Incredible night sky full of stars & constellations. This is a flower lovers paradise with perennials surrounding you throughout the spring and summer. Gather bouquets upon bouquets of peonies, lilacs, lilies, large cotton candy hydrangeas, daffodils and more.<br /> <br /> Once you manage to tear yourself away from the outdoor delights the interior does not disappoint. Beaming with light in all seasons with multiple spaces to gather. Whip up culinary treats in your custom chefs kitchen while entertaining your guests in this open floor plan kitchen, dinning and family room. When solitude beckons enjoy snuggling up by the crackling wood burning fire watching wildlife pass by outside your bucolic meadow. A separate grand room with a magnificent floor to ceiling stone propane fireplace is perfect for watching movies, hosting a fabulous dance party or a musical performance.<br /> <br /> If you want to expand your sanctuary and add a pool, studio, garage or several other homes there are multiple spots that could accommodate your wish.<br /> <br /> When the improbable desire to leave occurs you have many possibilities nearby. Within ten minutes you will find yourself swimming at Belleayre Beach in the summer or within 15 minutes skiing on Belleayre Mountain in the winter. Phoenicia, with its many dinning options, theater and Sunday farmers market, is only 10 minutes away. Great nearby fine dining at Peekamoose, Urban Cowboy, Dandelion, The Shandaken Inn, and the Foxfire Mountain House as well as casual dinning at The Phoenicia Diner, The Pines, Woodstock Brewing, Brio's, Bettina and Tito's Banditos. When wanting to explore more outdoor adventures there are multitudes of opportunities from nearby Fox Hollow trail to the Ashokan rail trail among other hiking trails, to golfing, fishing, watering holes, and kayaking the Esopus river. When you are exhausted from all your exploring head to the Emerson Resort and Spa for a massage, steam and sauna or sit in their hot tub overlooking the stream.<br /> <br /> The Big Red House has had only 3 owners since it was built in 1990. The current owners have lovingly renovated almost everything in the house and have enjoyed the home for the past ten years. Please ask for the list of the extensive renovations.
MlsNumber: --
ListingId: 20243783


Listing Provided By: Halter Associates Realty, original listing
Phone: (845) 661-4808
Office Phone: (845) 679-2010
Agent Name: Jasmine Jordaan
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 = 1878 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;
Real Estate Expert Photo for Eliana Amodio
Eliana Amodio
ASCIIAmodio Real Estate & Prop
Call Today!: (561) 322-8428

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App