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

3496a River Road
Equinunk, PA 18417

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1401 Square Feet
Agency: Matthew J. Freda Real Estate, Inc.
Agency Phone: (845) 887-5640

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Take me to the river! This beautifully wooded and secluded 7.76 acres includes 2 homes, and sits on a gorgeous stretch of the Upper Delaware River. This very special and peaceful property was developed, enjoyed and loved by 4 generations. All structures are in excellent condition, as they were stick-built by the family themselves. The camp and the authentic Finnish sauna, circa 1968; the larger house and garage in 1988. As you turn into the driveway from the quiet, town-maintained, rural road, you will find yourself relaxing into the seclusion of the property, surrounded by large, mature oak and white pine trees. The main house is open and bright, featuring 2 bedrooms, 1 full bath, a large kitchen with custom-made oak cabinets and a living room ready for friendly gatherings. Downstairs you will find the basement large enough for all to enjoy and room for another guest. There's a wood stove, a half bathroom, and a large laundry room that holds a workshop and hobby area. The shining feature of the home is the large covered front porch, from which you can see the river. Down closer to the river, you will find the Finnish sauna and the 2+ bedroom cabin. From the cabin porch, you can see the stunning clear view of the river that you will have as you sip your morning coffee in the company of the resident eagle family and other wildlife. The small, yet spacious-feeling, open floor plan of the cabin, with the river right out the front windows, is the cozy river-life vibe you are craving. The river frontage itself is one of the most beautiful, accessible and open ''beach'' areas on the river... ready for your kayaks, paddle boards, fly-fishing and swimming pleasure, as well as your summer campfires. The property is 5.5 miles from Callicoon, NY. Spectrum Cable and Internet will be available. The Upper Delaware River life you aspire to live of trout fishing, kayaking and swimming is right here - world class and second to none!
MlsNumber: --
ListingId: PW-243249


Listing Provided By: Matthew J. Freda Real Estate, Inc., original listing
Phone: (845) 887-5640
Office Phone: (845) 887-5640
Agent Name: Tom Freda
Disclaimer: Copyright © 2024 Pike/Wayne Association of Realtors MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App