Title Page Background
DEBUG FN args: Array ( [0] => 1836 [1] => [2] => [3] => agent ) BEFORE: Site: 1836 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1836 Igate: njhud LocID: 1836 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 = 1836 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1836 [1] => [2] => [3] => lender ) BEFORE: Site: 1836 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1836 Igate: njhud LocID: 1836 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 = 1836 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1836 [1] => [2] => [3] => other ) BEFORE: Site: 1836 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1836 Igate: njhud LocID: 1836 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 = 1836 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

20 Orchard Hill Drive
Millbrook, NY 12545
Dominique Shuminova with William Pitt Sotheby's Interna, original listing - (845) 677-9822

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,995,000
Beds: 7
Baths: Full: 6, ½: 1
Status: Active
SqFt: 5486 Square Feet
Agency: William Pitt Sotheby's Interna
Agency Phone: (845) 677-9822

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1993
Notes: Luxurious Country Home with Stunning Hudson Valley Views Welcome to a breathtaking escape where modern luxury meets country tranquility.<br /> Nestled on 12+ lush acres with panoramic views of the Hudson Valley and Catskill Mountains and simply amazing sunsets. This fully renovated<br /> turnkey sanctuary is designed for relaxation, entertaining, and effortless living. Rolling meadows, manicured lawns, and a fenced pasture create<br /> a serene setting, with two paddocks and three run-in sheds equipped with water and electricity, make this an ideal haven for animal lovers. At<br /> the heart of the property, a heated Gunite pool with an expansive Bluestone lounging area offers the perfect spot to soak up the sun and unwind<br /> in total privacy. Step inside to a gracious foyer, where a striking curved staircase leads to the second-floor primary suite—your private retreat—<br /> along with an office, huge dressing room, two additional bedrooms and a guest suite. The third floor features a spacious loft with its own full<br /> bath, perfect for a home office, yoga studio, or creative space. Designed for both grand gatherings and everyday comfort, the main level boasts a<br /> light-filled living room with a wood-burning fireplace, a formal dining room, and an expansive deck where you can dine and entertain with a<br /> breathtaking backdrop or under the stars . The grand chef's kitchen is a masterpiece, featuring a cozy wood-burning fireplace, and French doors<br /> leading to a second private deck—an ideal setting for morning coffee or al fresco dining. An additional en suite bedroom, full laundry room and 3<br /> car garage complete the open flow that delivers space with privacy and cozy areas. The lower level offers a private retreat for guests or<br /> multigenerational living with two additional bedrooms, a spacious recreation room, and direct outdoor access. Thoughtfully renovated with<br /> modern convenience in mind, this home features a brand-new roof, HVAC system, and mechanicals—allowing you to move in and start enjoying<br /> the country lifestyle immediately. Whether you're looking for a personal retreat or a proven income-generating investment, this home offers<br /> both, with a highly successful short-term rental history and impressive revenue potential. Located just 90 minutes from New York City, 15<br /> minutes from Metro-North and the Taconic Parkway, and only 5 minutes from the wonderful Village of Millbrook, this home provides the perfect<br /> blend of seclusion and accessibility in an area known not only for its beauty but lifestyle appeal and climate resiliency. Escape to a place where<br /> every day feels like a getaway—where you can gather with loved ones, relax in style, partake in the many local sports/activities (Polo season is<br /> almost here!)and savor the beauty of nature.
MlsNumber: --
ListingId: 20251501


Listing Provided By: William Pitt Sotheby's Interna, original listing
Phone: (914) 291-9911
Office Phone: (845) 677-9822
Agent Name: Dominique Shuminova
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