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

490 Mill Road
Millerton, NY 12546

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1784
Agency: The Machree Group, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 1896
Notes: Hi. Looks good. See below for very minor changes. Brackets are for removing and parentheses are to add. Let me know and thanks. Unveiling the ultimate retreat for those seeking a legal Airbnb, vacation haven, or year-round sanctuary. Prepare to be captivated by the mesmerizing melody of the Webutuck Creek as it serenades you from your own private back pea gravel patio. Set upon an expansive 4-plus-acre parcel, encompassing two lots, this Millerton gem promises an unparalleled embrace of untouched nature on both sides of the tranquil creek. Welcome to the epitome of rustic charm, (epitomized by) this timeless barn-style abode also boasts(ing) a detached 2-car garage. Step inside and be enchanted by the inviting open floor plan, where a majestic original wood-burning fireplace commands attention, setting the stage for convivial gatherings or intimate fireside retreats. Channel your inner chef in the sumptuous kitchen adorned with marbled quartz countertops, pristine white cabinets, and luxurious brass accents, all complemented by top-of-the-line stainless steel appliances. Gaze out onto the lush surroundings through expansive windows while the warm wood floors beckon you to unwind in style. Upstairs, discover two generously proportioned guest bedrooms bathed in natural light, alongside a bright full guest bathroom. But hold onto your awe because the pièce de résistance awaits – the master ensuite, a haven boasting unobstructed vistas of the Webutuck Creek and verdant grasslands beyond. Experience year-round comfort with dedicated Mitsubishi heat pumps keeping you cozy in winter and cool in summer, while an installed universal EV charger in the garage ensures modern convenience. Additional delights include the option for an outdoor shower hookup perfect for rinsing off after a refreshing dip in the creek. Convenience meets tranquility with a large utility/laundry room on the first floor catering to all your country house storage needs. Revel in the abundance of closet space and (revel) in a home where every detail exudes excellence and freshness. Step outside to embark on endless strolls or epic bike rides along the coveted Bronx Railtrail, conveniently accessible just beyond your doorstep. And when it's time for a leisurely morning coffee or a delightful lunch, Millerton's charming main street beckons with its array of restaurants, shops, and upstate events. “Just a short nature walk away.” Why dream of vacations when you can call this idyllic haven home? Don't miss your chance to own a slice of paradise. This is more than a home – it's an invitation to live the life you've always imagined.
MlsNumber: 20240876


Listing Provided By: The Machree Group, LLC, original listing
Name: The Machree Group, LLC
Phone: (Uni) ted-Stat xes18456791237
Office Name: The Machree Group, LLC
Office Phone: (Uni) ted-Stat xes18456791237
Agent Name: Machree Quaker
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 = 1836 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 Anthony Buoncora
Anthony Buoncora
ASCIICentury 21 Alliance Group
Call Today!: (845) 235-2321

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App