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;

2211 W Hubbell Hill Road
Margaretville, NY 12455
Katherine Keys with The Catskill Dream Team, original listing - (917) 558-0447

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 3
Baths: Full: 3
Status: Pending
SqFt: 1792 Square Feet
Agency: The Catskill Dream Team
Agency Phone: (917) 558-0447

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Welcome to the Hemlock Grove Streamside House<br /> <br /> Tucked away among towering evergreens, this contemporary 3-bedroom, 3-bath home is the ultimate hidden escape—you wouldn't even know it's there from the road. On 2.14 acres of woodlands and perennial gardens, the property offers ultimate seclusion, with your own private stream and protected DEP forever-wild land just across the way—ensuring no neighbors in sight.<br /> The first floor has an open-concept design, featuring a spacious kitchen with large pantry that flows into the dining and living areas, where a cozy wood stove adds warmth and charm. A full bath is also conveniently located on this level. Step outside the French doors onto the bluestone patio, complete with a hot tub, grill, picnic table, and fire pit area—perfect for relaxing or entertaining. Stone steps lead down to the perennial stream, which means all year you can enjoy the sounds of a babbling brook right from the house. Upstairs, you'll find three generously sized bedrooms, including a spacious primary suite with an attached bath. An additional adjoining room off the primary offers endless possibilities—a walk-in closet, home office, storage space, or whatever you envision.<br /> <br /> This home is thoughtfully updated with new mini-splits, new rain gutters, and a detached storage shed/workshop. With a proven track record as a successful Airbnb, it presents an incredible opportunity—whether you're seeking a private escape, an income-generating investment, or both. Just 2 hours and 15 minutes from NYC, under 20 minutes from Plattekill or Belleayre ski mountains, and only 10 minutes to the charming village of Margaretville with all the dining, amenities and shopping and Hannah Golf Course is right down the road. This one checks all the boxes - YOUR CATSKILL DREAM AWAITS!
MlsNumber: --
ListingId: 20250607


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