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

330 Middlemist Road
Delhi, NY 13753

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,275,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3257
Agency: Keller Williams Upstate NY Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 121 acre(s)
Property Type: Residential
Year Built: 1875
Notes: Cradled in the Western Catskill mountains, at the headwaters of the Delaware river, is the ultra-private Middlemist Farm.Setting: Circa 1870's upright-wing farmhouse updated to full modern home(06). 121acs w mix of hay fields, woodlands & 2 spring-fed ponds w great views.Home: Meticulously modernized, centered on chef's-dream kitchen, w energy-efficient appliances, exposed beams, & soaring ceilings illuminated by skylights. Brazilian soapstone countertops, 6+ burner WOLF range w high-velocity hood + dedicated warming drawer. Dual dishwashers, trash-compactor, & GE Profile fridge all incorporated into hand-crafted cupboards, for a seamless look through the kitchen. Multiple sinks, hidden appliance niches & a fantastic base-board kick vacuum (connected central vacuum) all set on foot-warming, tiled, radiant-flooring. A sun-drenched solarium makes a lovely breakfast room or better office. Dedicated prep-kitchen w fridge, sink & counterspace for larger parties (space doubles as 1st floor laundry & a convenient mudroom & side entrance).Beds & Baths: 3 bdrms on 2nd flr offer privacy & comfort. Primary suite w dedicated full bath, closet spaces, & cheerful bedroom w vaulted ceiling & new carpet. 2 bdrms in original part of house share spacious central bath w dual sinks & tub-shower. Powder room & coat closet are accessed in the central hall, as well as the grand living room w floor to ceiling built-in book shelves. Double French-doors open to the pergola-shaded porch overlooking acres of groomed rock & perennial gardens & front pond.Gardens & Out Buildings: Hi-fenced 85 x 40 veggie garden w raised beds, fruit trees & berries. Charming period 2 flr garden shed, + spacious 1400sqft, 3-bay (1 heated) garage, and a very special 35 x 26 ft (1800sqft), 2 flr barn/studio building (w water, solar power, & propane heat).Utilities: All-modern systems w state-of-the-art geothermal heating, solar electric, & radiant floor heating (kitchen). Heat exchangers + modern AC. Clean, dry basement w access to systems, + root cellar & wine cellar.Land, Ponds, & Views: Acres of stone-wall lined & farmer-maintained fields accent woodlots. Trails through the property, including lovely moss-covered walking path to the 2nd stone-scaped pond in eastern field.Surround: modern luxury & ecological awareness just minutes from Delhi, NY-SUNY Delhi, county seat, & upstate NY's most approachable main streets. Under 3 hours from GWB-a magical destination you may never wish to leave.
MlsNumber: 152312


Listing Provided By: Keller Williams Upstate NY Properties, original listing
Name: Keller Williams Upstate NY Properties
Phone: 431-2540
Office Name: Keller Williams Upstate NY Properties
Office Phone: 431-2540
Agent Name: Susan Muther
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