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

185 Stone Church Road
Kingston, NY 12401

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,199,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2640 Square Feet
Agency: HRH Development Brokers LLC
Agency Phone: (347) 609-8548

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Welcome to 185 Stone Church, an exceptional 6-acre property boasting breathtaking southern vistas, unparalleled privacy, and seasonal mountain panoramas just moments from the Ashokan Reservoir. Currently with 9 months remaining under construction, Ango, the latest masterpiece from Hudson River Homes, is set to redefine luxury living. Translating to 'Dwelling in Peace', this residence embodies a seamless fusion of expansive design and contemporary minimalism, highlighted by a roofline reminiscent of flight. Spanning 2,640 square feet, this meticulously planned ranch-style layout offers an array of features. Upon entering through the 4x10 glass door, you're greeted by a grand foyer showcasing a laundry room and powder room, leading seamlessly into a sprawling open-concept living, kitchen, and dining area spanning over 1,000 square feet. A double-sided wood-burning fireplace creates an inviting ambiance drawing attention to the soaring 19 foot ceiling height, wood wall accents adds warmth, while 10-foot high sliding doors and large bays allow uninterrupted views of the surrounding natural splendor. With three bedrooms, two full baths, and a powder room, this home provides a serene retreat. The primary bedroom is a haven of tranquility, featuring expansive windows, wood wall accents, and access to a deck overlooking the landscape. A walk-in closet, en suite bath with a curbless shower, dual shower systems and freestanding stone resin bath, complete the luxurious spa experience. The kitchen, with its soaring ceilings, is designed for both culinary enthusiasts and entertainers alike. Equipped with a Fisher Paykel appliance package, wine fridge, sizable pantry, and abundant cabinet storage, it's a space bathed in natural light, courtesy of surrounding windows. Constructed as a slab-on-grade home with finished concrete floors and zoned radiant heating, Ango ensures comfort and efficiency. Additional climate control features include a zoned cooling system, Energy Recovery Ventilation (ERV) system, whole-house dehumidifier, and a whole-house water filter. The standing seam galvalume roof adds durability and a contemporary aesthetic. This remarkable property also includes a guest house, offering even more versatility. For further details, refer to associated documents or inquire directly. Welcome home to Ango, where contemporary elegance meets tranquil living.
MlsNumber: --
ListingId: 20243879


Listing Provided By: HRH Development Brokers LLC, original listing
Phone: (347) 609-8548
Office Phone: (347) 609-8548
Agent Name: Zachary Gumpel
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 = 1878 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;
Real Estate Expert Photo for Eliana Amodio
Eliana Amodio
ASCIIAmodio Real Estate & Prop
Call Today!: (561) 322-8428

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App