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

76 Floyd Ackert Road
West Park, NY 12493
Justin Phillips with United Real Estate HV Edge, original listing - (845) 204-6939

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,250,000
Beds: 6
Baths: Full: 4, ½: 3
Status: Active
SqFt: 9500 Square Feet
Agency: United Real Estate HV Edge
Agency Phone: (845) 204-6939

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1979
Notes: Welcome to Riverside Solace! A Private Oasis nestled in the charming West Park Hamlet of Ulster County NY. This home is Perfectly situated along the western banks of the Hudson valley, approximately 80 miles north of New York city, making it accessible to both city dwellers and those looking for a quieter, riverside community. This distinctive contemporary tri-level residence is perfectly tucked away in a secluded enclave. A true riverside oasis and haven of tranquility. The river views from nearly every room create a sense of peace and calm. With the opportunity for a private dock, lush, and landscaped grounds, this is the epitome of riverside living. Discover serenity and natural beauty in this home that rests on the edge of the river. The tranquil views, combined with well-appointed living spaces, create a retreat where you can unwind and recharge. This riverside custom designed solace offers 10,000 sqft, including 6 bedrooms and 7 baths. The primary bedroom is complete with a dual facing fireplace, large ensuite bathroom, jacuzzi tub with waterfall, built in radio system, gym, sauna and private river view terrace! This home is perfect for entertaining with an exquisite indoor and outdoor dining area, exterior wood burning stove, cabana, inground pool and patio, all overlooking the river. Enjoy the custom cabinetry, built in luxury appliances, wet bar, butlers pantry, cathedral ceilings and more. Every room has a story to tell with its unique contribution. With Perfect proximity to other Hudson valley towns there are many activities and experiences to enjoy. Hiking, fishing, boating, picnicking, community events, culinary delights and all the historical significance the town has to offer. This property presents a compelling opportunity for those seeking to maximize their investment with in-law suite and two bedroom cabana. This property is more than just a place to call home; it's a prime income-generating opportunity. With its exceptional layout, stunning aesthetics, and ideal location, it's perfectly poised to become your lucrative event venue investment. Owner financing is a viable option for qualified buyers who seek an alternative to traditional lending. Beyond the aesthetics, this home offers an atmosphere that is impossible to convey through descriptions alone. It's a feeling of comfort, a sense of belonging, and the promise of a brighter future. You'll sense the potential for relaxation, inspiration, and the life you've always imagined the moment you step foot on this riverside solace. Schedule your private tour today to learn more and take advantage of this extraordinary opportunity.
MlsNumber: --
ListingId: 20243820


Listing Provided By: United Real Estate HV Edge, original listing
Phone: (914) 456-3574
Office Phone: (845) 204-6939
Agent Name: Justin Phillips
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','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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