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

35 Harlemville Road
Claverack, NY 12529
Chris Getman with Houlihan Lawrence Inc., original listing - 677-6161

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,295,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 7200 Square Feet
Agency: Houlihan Lawrence Inc.
Agency Phone: 822-0300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 129 acre(s)
Property Type: Residential-Other
Year Built: 1980
Notes: Where Norman charm meets Hudson Valley splendor, "Dragonfly" stands as a fine example of country living - a rare 130-acre estate that marries grand European sophistication with the pastoral beauty of Claverack. Just twenty minutes from the cultural centers of Hudson and the Berkshires, this property strikes a balance between secluded sanctuary and connected countryside living.A winding private drive leads to the 7,200-square-foot Normandy-style residence with its stately stucco facade. Inside "Dragonfly'', the great room emerges as the heart of this extraordinary home, where soaring ceilings and dramatic walls of glass dissolve the boundary between interior luxury and a wall of white birches and the natural woodlands that lead to the private swimming pond beyond.Twin wood-burning fireplaces anchor this light-drenched gathering space, which flows to outdoor terraces and a dining room that adapts as gracefully to intimate family gatherings as it does to large dinner parties. The chef's kitchen has a professional-grade 48-inch range, generous island, and abundant storage, with a wall of french doors opening to a large terrace for summer gatherings.The primary suite is accessible via a sculptural staircase with a beautiful artisanal, wrought iron railing. The suite features a sitting room, spa-inspired bathroom with dual shower and soaking tub, walk-in closet, and a serene bedroom warmed by a gas fireplace. A private balcony offers a view over the estate's pastoral panorama.Four additional en-suite bedrooms are distributed throughout the residence, ensuring privacy and comfort for family and guests alike. The home's lower level spans the full footprint, including dedicated quarters for a caretaker."Dragonfly" is more than a home; it's a rare mix of architectural grace and a natural landscape that threads through the historic, stone walls to the private swimming pond and dock.For the discerning buyer seeking an extraordinary estate property in one of the Hudson Valley's most coveted locations, this singular offering is worth a visit.
MlsNumber: --
ListingId: 155308


Listing Provided By: Houlihan Lawrence Inc., original listing
Phone: (845) 677-6161
Office Phone: 677-6161
Agent Name: Chris Getman
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App