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 ('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] => 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 ('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] => 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 ('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;
<< Go Back | All Foreclosures | | | All Cities

1144-1184 Hollister Hill Road
Delhi, NY 13753
Susan Muther with Keller Williams Upstate NY Properties, original listing - 431-2540
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $1,250,000
Beds: 6
Baths: Full: 5
Status: Active
SqFt: 4100 Square Feet
Agency: Keller Williams Upstate NY Properties
Agency Phone: 431-2540

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 158 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1982
Notes: Nestled in the breathtaking scenery of the Catskills, this retreat is more than a vacation home; it's a complete lifestyle. The stunning 158 acres, two homes, two ponds and all at the end of town-maintained road seamlessly blend comfort, luxury, and nature. Generations have played here. Now it is time for your generations to make their mark on this unparalleled destination.*** 2 Homes ***Upper - 3 bedrooms, 3 baths, over 2500 sqft living space, family room, vaulted ceiling open-concept great room, 2-side-wrap-around deck, 2-car garage. The gourmet kitchen is equipped with dual ovens, spacious prep-space and a view from the sink that is simply to-die-for. Wood floors, Thermopane windows, AND AN ELEVATOR! Sited overlooking a 1/3rd acre pond with distant mountain views.Lower - 3+ bedrooms and 2 full bathrooms, a galley kitchen, spacious dining area and living room centered on a wood-burning fireplace. Sliders open onto 15 x 30 deck. The bunk-room'' is something from out of a movie, with space for 10 rambunctious daemons! Outdoor Lifestyle - Imagine summer afternoons spent lounging on the open-air decks on either home, while the family fishes in your private 1/3rd acre pond. Smell the grilling as the summer barbecue performs its magic the entire family will enjoy. Or float across the newly fallen snow on your snowmobile, as you race through your private park-like setting with miles of trails tracing the Catskill Mountain ridge-tops. Whether it's hiking trails that meander through your property or winter sports just a short drive away, this retreat offers countless outdoor adventures year-round. AND a Barn - 60 x 35 Morton barn for tractors, ATVs, kayaks, and bicycles.This ideal location feels like a world away from the city, yet conveniently located just a couple of hours from New York City, making weekend escapes feasible and effortless AND literally minutes from the center of the charming village of Delhi, NY. With its unique combination of luxury, seclusion, and a robust outdoor lifestyle, this compound is truly a rare find. Seize the opportunity to invest in not only your personal sanctuary but also a legacy for your family that will provide joy and connection for years to come. Don't miss the chance to make your dream of a tranquil escape a realityyour future awaits in the heart of the Great Western Catskills.
MlsNumber: --
ListingId: 155102


Listing Provided By: Keller Williams Upstate NY Properties, original listing
Phone: (607) 746-3000
Office Phone: 431-2540
Agent Name: Susan Muther
Disclaimer: Copyright © 2024 Columbia Greene and Northern Dutchess MLS. 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