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

128 Mount Pisgah Rd
Windham, NY 12496
Kathy Marino with Bunce Realty, original listing - 734-4461

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,599,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: 4233 Square Feet
Agency: Bunce Realty
Agency Phone: 734-4461

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Spectacular Windham Home on Nearly 10 Acres with Stunning Views of Windham Mountain Ski Resort. Nestled in the heart of the Catskills, this remarkable Windham home offers nearly 10 acres of private, tree-lined tranquility, surrounded by preserved State Land. With over 4,200 square feet of living space across three spacious levels, this property is the ultimate mountain retreat for family, friends, or as a high-end Airbnb investment. Step inside to a quintessential ski mudroom. From here, enter the expansive lower-level game room, a true highlight of the home. Whether you're playing pool, ping pong, or enjoying other activities, this space is perfect for entertaining. This floor also features a large bedroom with three bunk beds and a washer/dryer area. The heart of the home is the main level, where the open-concept design includes the chef's kitchen equipped with granite countertops, center island with bar stools, stainless steel appliances and a Wolf range oven/stove. Adjacent to the kitchen, the grand living room boasts cathedral ceilings with stunning natural woodwork and a floor-to-ceiling stone fireplace. The living room also opens onto a large deck, perfect for outdoor dining, entertaining by the fire pit, or simply relaxing in the hammock. This level includes an ensuite bedroom, as well as an additional bedroom and bath. Upstairs, a bright loft area offers a cozy spot to read, unwind, or enjoy board games. Two additional bedrooms and baths provide ample space for guests, including a second ensuite bedroom. This suite features a walk-in closet, a reading nook, and its own private deck with two chairs, ideal for taking in the spectacular mountain views and tranquil surroundings. The property also features an oversized garage, outdoor jacuzzi and the added benefit of a babbling brook nearby. This home comes with a host of upgrades to ensure comfort and convenience, including seven A/C units (one in each bedroom), a new generator, new well filtration system, and a freshly re-stoned driveway. Recent tree removal has opened up additional views, and the property is also equipped with a new commercial washer/dryer and a stackable washer/dryer for added convenience. Whether you're looking for a successful Airbnb investment or a peaceful family getaway, this Windham home has it all.
MlsNumber: --
ListingId: 155213


Listing Provided By: Bunce Realty, original listing
Phone: (518) 734-4461
Office Phone: 734-4461
Agent Name: Kathy Marino
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.


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 = 1842 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 Lisa Jaeger
Lisa Jaeger
ASCIIColdwell Banker Village Green Realty
Call Today!: (518) 755-2573

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App