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

570 Pumpkin Lane
Clinton, NY 12514
E. Elizabeth Peters with Corcoran Country Living - Millbrook Office, original listing - 677-0505

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,945,000
Beds: 6
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4208 Square Feet
Agency: Corcoran Country Living - Millbrook Office
Agency Phone: 677-0505

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 85 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1860
Notes: Sited on one of the most beautiful parcels in the Hudson Valley, this idyllic estate on a quiet country lane offers endless possibilities with the features of a mini-resort. Set on a knoll overlooking a gorgeous, spring-fed pond complete with gazebo, swing and swim-up dock, this historic country retreat includes the circa 1860 main house, a separate guest apartment with views of an additional pond, a gunite pool with pool house, a tennis court, golf green with three separate tee boxes, and a large sports barn which offers a fully equipped gym on the upper level and a first floor basketball court (and potential indoor pickle-ball court). The renovated vintage Colonial has five bedrooms, three and a half baths, a chef's kitchen with top of the line appliances (including three ovens and two dishwashers) perfect for cooking and gathering with an adjacent sitting room and fireplace; a spacious dining room with a delightful breakfast nook; a light-filled living room with a fireplace and hidden cabinets for storing wood, a family room/den with a fireplace, a wet bar and plenty of storage, as well as an all-season, window filled sunroom with radiant heated stone flooring and views to the back lawn and hot tub. The second floor offers four bedrooms, three newly done baths with linear drains, an office, a well appointed laundry room and a walk-up attic. There is a Sonos sound system with indoor and outdoor speakers, whole house generator and security system. Outdoors, incredible recreational options abound with two swimming ponds, sweeping lawns, a 50 ft. heated gunite pool and a pool house complete with kitchen, full bath, laundry, internet and Sonos sound (indoor and out), golf, tennis and sports barn. Additionally, there is a three-car garage and guest apartment with a full bath and kitchenette, a second barn for storage or workshop and a fully enclosed and irrigated vegetable garden. The grounds are magical and noteworthy, with lovely stone terraces, perennial gardens, a charming playhouse, specimen trees, rock walls, running brook and a waterfall. A superb location less than 2 hours from NYC, minutes to the Taconic State Parkway, 20 minutes to Millbrook and Rhinebeck Villages, and convenient to all the Hudson Valley has to offer.
MlsNumber: --
ListingId: 154624


Listing Provided By: Corcoran Country Living - Millbrook Office, original listing
Phone: (845) 677-0505
Office Phone: 677-0505
Agent Name: E. Elizabeth Peters
Disclaimer: Copyright © 2025 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 = 1836 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 Lance Pahucki
Lance Pahucki
ASCIIRE/MAX Town & Country
Call Today!: (845) 344-7337

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App