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;

422 Waterview Drive
Andes, NY 13731
Katherine Keys with The Catskill Dream Team, original listing - (917) 558-0447

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2556 Square Feet
Agency: The Catskill Dream Team
Agency Phone: (917) 558-0447

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 97 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1981
Notes: Welcome to Pepacton Overlook Lodge - a once-in-a-lifetime Catskills property with unmatched views of the Pepacton Reservoir, exceptional privacy, and direct access to pristine wilderness. Set on 97 private acres, and surrounded by over 5,000 acres of protected State and DEP forever-wild land in the Delaware Wild Forest, this rare estate offers a level of seclusion and natural beauty that's almost impossible to find - and all just 2 hours and 20 minutes from NYC, if you can believe it.<br /> <br /> The 4-bedroom, 2.5-bath home spans three finished levels, thoughtfully designed for full-time living, multi-generational use, or income potential. The main level features a bright, open-concept great room with a stone fireplace, an open kitchen and dining area, a primary suite with full bath and walk-in closet, an additional bedroom and full bath, and laundry. Step outside the great room onto the full-length deck and take in the truly unique mountain and reservoir views.<br /> <br /> Upstairs, the third level includes two additional bedrooms, a shared half bath, and a spacious loft-style flex living area that overlooks the great room - ideal for guests, office space, or creative use. The finished walk-out lower level is cozy and inviting, with a wood-burning stove, wood accents, and flexible space perfect for movie nights, game nights, or relaxed gatherings after a day on the trails.<br /> <br /> The land is a dream for outdoor lovers - with private trails for hiking, ATVs, or snowmobiling, a tree stand at the ridge for hunters or wildlife observers, and no through traffic at the top of a quiet dead-end road. A spring-fed pond with a swimming dock is perfect for summer dips or trout fishing, and a detached garage/workshop provides ample storage for all your gear and toys.<br /> <br /> This property is also protected by a conservation easement, ensuring the long-term preservation of its natural beauty while offering significant property tax benefits and the assurance that the land will remain undeveloped for generations to come. The easement maintains the ecological integrity and character of the land, enhancing its value as a true legacy property in the Catskills.<br /> <br /> Just 20-25 minutes to Belleayre Mountain, and a short drive to the charming villages of Andes and Margaretville, as well as multiple trailheads. For water lovers, the Pepacton Reservoir offers boating and fishing, making this an ideal home base for year-round recreation.<br /> <br /> Whether you're seeking a rare upstate escape, a turn-key mountain retreat, or a legacy holding with protected land and breathtaking reservoir views, Pepacton Overlook Lodge is truly a one-of-a-kind offering in the heart of the Catskills. YOUR CATSKILL DREAM AWAITS!
MlsNumber: --
ListingId: 20251560


Listing Provided By: The Catskill Dream Team, original listing
Phone: (917) 399-3243
Office Phone: (917) 558-0447
Agent Name: Katherine Keys
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