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 = 1875 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 = 1875 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 = 1875 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;

656 White Roe Lake Road
Livingston Manor, NY 12758

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,000
Beds: 5
Baths: 5
Status: Active
SqFt: 1490
Agency: Country House Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential
Year Built: 2005
Notes: Welcome to Roe Pond - a sprawling property where the private pond is your personal oasis. This sizable estate in Livingston Manor isn't just a large home with views; it's a generational gem waiting for your family gatherings or the ultimate playground for your wildest weekend getaways.<br /> <br /> Upon entering the large foyer, you'll see views across the canopy from the large living room windows. The massive kitchen is ready to host dinner parties with all your friends and family while the five bedroom and bonus basement space are here for everyone to crash for the night. The first floor offers two bedrooms, one with an en suite bathroom, plus a massive kitchen with pantry, and living area that walks out to the deck with views. Upstairs you'll find a primary suite, large office, and two additional bedrooms with a shared bath. A second living area will greet you at the top of the steps - perfect for a reading nook or kids' zone. And then there's the basement, which is already a finished, walkout bonus space for additional guests, a studio, office, or gym. The attached two-car garage leading into the basement offers the ultimate ease of living in this generous home.<br /> <br /> Picture this: lazy summer afternoons spent lounging by your private pond, with the occasional splash as someone cannonballs in. The basketball court - yes there's a basketball court - in the lower yard could be re-envisioned as an outdoor living area, or just keep it for some competitive fun. The massive yard is begging for epic gatherings from elegant garden parties to raucous bonfires under the stars. This place is the blank canvas for your weekend gathering masterpiece.<br /> <br /> Nestled in the serene heart of Livingston Manor, this property offers the kind of seclusion that makes you wonder if civilization even exists beyond your borders. But fear not, the town is just a five minute scenic drive away. Engage in some trout fishing in the Willowemoc Creek, hike the picturesque trails of Catskill Park, shop around on Main St, dine at the DeBruce, or sip on artisanal brews at the nearby breweries. And don't forget to pay a visit to the Bethel Woods Center for the Arts for an array of entertainment, only 30 minutes away.
MlsNumber: 20242080


Listing Provided By: Country House Realty, Inc., original listing
Name: Country House Realty, Inc.
Phone: (845) 985-5116
Office Name: Country House Realty, Inc.
Office Phone: (845) 397-2590
Agent Name: Arlena Armstrong-petock
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 = 1875 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;
Jason Grossman
ASCIIKeller Williams
Call Today!: (845) 796-6065

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App