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','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 = 1836 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 = 1836 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;

490 Mill Road
Millerton, NY 12546
Machree Quaker with The Machree Group, LLC, original listing - (845) 679-1237

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $648,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1784 Square Feet
Agency: The Machree Group, LLC
Agency Phone: (Uni) ted-Stat xes18456791237

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1896
Notes: 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: --
ListingId: 20240876


Listing Provided By: The Machree Group, LLC, original listing
Phone: (845) 679-1237
Office Phone: (845) 679-1237
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','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 Lance Pahucki
Lance Pahucki
ASCIIRE/MAX Town & Country
Call Today!: (845) 344-7337

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App