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;

496 Mountain View Avenue
Hurley, NY 12443
Alex Stier with Keller Williams Realty HV Nort, original listing - (845) 481-2700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3176 Square Feet
Agency: Keller Williams Realty HV Nort
Agency Phone: (845) 481-2700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1987
Notes: Escape to the tranquility of sought-after Historic Hurley in Ulster County with this captivating home nestled on a serene .57 acre lot. Located in a peaceful, quiet neighborhood, this property offers the perfect retreat while still being convenient to Kingston & the famous Waterfront District, Woodstock, New Paltz, The Hurley Rail Trail, Skiing in the Catskills, the Hudson River and the NYS Thruway.<br /> Built in 1987 by a skilled contractor, this unique residence spans an impressive 3176 square feet, boasting 4 bedrooms and two and a half baths. The thoughtful design and meticulous craftsmanship are evident throughout, offering both functionality and charm.<br /> As you step inside, you're greeted by a warm and inviting atmosphere, with ample natural light streaming through the windows and illuminating the spacious living areas. The heart of the home is the well-appointed kitchen, featuring modern appliances, plenty of cabinet space, and a convenient peninsula - perfect for serving, gatherings or casual meals. A convenient ½ bath is close by which also houses the newer Maytag washer and dryer. The eat-in kitchen opens to a covered screened porch and BBQ area. <br /> But perhaps the most impressive feature on this level is the copper-ceiling foyer, with French Doors that leads into the dual multi-level expansive Great Rooms, featuring a brick working fireplace, high vaulted ceilings, special lighting and unique ceiling fans. The Main Level also includes a formal living room and elegant dining room for hosting dinner parties. <br /> The Upper Level includes a primary suite with an ensuite full bath and ample closet space. The large guest bedroom with newly installed 3/4'' oak hardwood flooring has private access to the main bath for guest privacy along with a separate opening onto the reading balcony overlooking the great rooms. Two other bedrooms complete this upper level.<br /> The additional, totally unique feature of this home is the expansive walk-out basement, spanning approx. 2,000 square feet and boasting two 16-foot garage areas - a dream space for hobbyists, car enthusiasts, or anyone in need of ample storage or workshop space. This Walk-in lower level is equipped with two automatic 16-foot insulated garage doors, one of which features a 10x16 foot Sunsetter retractable awning. One bay is currently equipped with a heavy-duty electric automotive lift, available for purchase with the property. There is an attached single bay area and a separate mechanical area housing a monitored security systems with glass breakage, temperature, and other alarm features. The mechanical room setup includes a 200-amp electrical service with a 6500 Watt generator and a separate garage subpanel. The in-basement oil tanks, dual furnaces, water softener, water filter, and four mini-splits round out some of well-maintained items. All mechanicals have been professionally serviced annually, along with recent septic pumping have been performed. Water is supplied by Rolling Meadows Water Corporation.<br /> Outside, the landscaped yard offers a peaceful oasis for outdoor enjoyment, with plenty of space for gardening & soaking in the natural beauty of the surroundings. The driveway is complete with 2 storage sheds and a blacktopped circular driveway including a 25' x 15' outdoor covered parking area. There is an additional driveway for extra vehicle or trailer parking. <br /> Don't miss your chance to own this one-of-a-kind home in a coveted Hurley location. Schedule a showing today and experience the best of country living with all the conveniences of modern amenities just minutes away.
MlsNumber: --
ListingId: 20242432


Listing Provided By: Keller Williams Realty HV Nort, original listing
Phone: (518) 281-8700
Office Phone: (845) 481-2700
Agent Name: Alex Stier
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