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;

52-54 Cliff Road
Accord, NY 12404
Pamela Hoveling with Halter Associates Realty, original listing - (845) 331-3110

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1716 Square Feet
Agency: Halter Associates Realty
Agency Phone: (845) 331-3110

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 22 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Welcome to ''The Cliffs'' in Accord! A spectacular piece of serene property on the very private Cliff Road, a shoot off of picturesque Upper Whitfield Road in Accord, consisting of two adjoining parcels, both surveyed and on separate deeds. The first is #54, 17.2 acres, with expansive lawn surrounded by lush woodlands with home and large pole barn. The second, #52 is 4.3 acres with fully-functioning mobile home with its own septic, well and electric, available to be purchased together or separately. Enjoy the quiet breezes whispering through both hardwood and pines that wrap around a large lawn edged by woodland ferns and multiple paths, which lead into the woods for relaxing exploration and solitude. #54 features a modular, contemporary cape with modern south-facing wall of windows. The main level has an open kitchen, dining, living area with a full wall of glass sliders opening onto an12 x28 foot deck that runs the width of the house, bringing abundant light indoors with a second level view of the trees and surrounding acreage. It's a great entertaining spot with lots of space and a perfect place from which to view sunsets. Two bedrooms and a full bath complete the main level. The upper level ''loft'' space features an open space overlooking the main level and has one bed and full bath with multiple storage closets that would make for a very private primary suite. The lower level, with the entire footprint of the house, features more outdoor space with a stone patio directly under the deck with sliders that open out to the expansive lawn. This level also houses updated mechanicals, laundry and workshop with enough space left to make an ample recreation, craft, or large storage room. All this wrapped in vinyl siding and an up-to-date shingle roof and heat pumps making for low maintenance and year-round comfortable living. There is also an oil fueled back up system still in place. The 60 x 40 foot pole barn with 12 foot ceilings and 200 amp service, currently houses an out-of-home business and tremendous storage, making it a perfect place to store all kinds of outdoor vehicles or most anything else. The 15 x 40 office space within with separate entrance is heated ensuring year round comfort for day-to-day activities. Current minimum building lot size is two acres so there are investment possibilities, as well as building at least another dwelling. The adjoining parcel features an updated 2 beds, 1 bath mobile home on 4.3 pristine wooded acres. The home is fully functional with its own well, septic and electric, newer roof and many updates and is unoccupied and could easily be rented to offset carrying fees on the property. It could also be removed and another dwelling could be built. It shares a driveway with #50 and #54. No drive bys please.
MlsNumber: --
ListingId: 20244061


Listing Provided By: Halter Associates Realty, original listing
Phone: (845) 389-1844
Office Phone: (845) 331-3110
Agent Name: Pamela Hoveling
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