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 = 1855 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 = 1855 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 = 1855 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;

1 Route 13 North
Camden, NY 13316
Daniel Christmas with CHRISTMAS AND ASSOCIATES INC, original listing - (315) 245-5761

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $289,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: CHRISTMAS AND ASSOCIATES INC
Agency Phone: (315) 245-5761

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 60 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Property Overview: Nestled in the heart of Camden, NY, this extraordinary farmland property offers a rare combination of beauty, utility, and development potential. With hundreds of feet of serene riverfront, this land is perfect for building your dream horse farm, country home, or waterfront cabin. Key Features: Riverfront Beauty: Enjoy the picturesque views and tranquility of the river, bordered by majestic hardwoods. Development Potential: The property has been conceptually approved for subdivision, offering exciting opportunities for future development. Utilities Available: Municipal water and utilities available. Easy Access: A black top driveway from County Route 13 provides convenient entry to the property. Ideal Home Cabin Spots: Several prime locations near the road are perfect for building a country home with riverfront spots suitable for building a single cabin or family compound. Abundant Wildlife: The land is home to turkey, deer, and waterfowl, making it a hunter's paradise. Proximity to Outdoor Activities: In addition to being located on Fish Creek for fishing and kayaking, the property is just minutes away from the Mad River and only a half hour from Pulaski and the renowned Salmon River area. Village Charm: Located just two minutes from the quaint village of Camden, NY, offering small-town charm and community. Farming Potential: Fertile, productive meadows make this property perfect for small-scale farming. Horse Enthusiasts: Ample space and natural beauty offer an idyllic setting for equestrian activities. Outdoor Families: The land's diverse recreational possibilities make it perfect for families who love the outdoors.
MlsNumber: --
ListingId: 11359252


Listing Provided By: CHRISTMAS AND ASSOCIATES INC, original listing
Phone: (800) 229-7843
Office Phone: (315) 245-5761
Agent Name: Daniel Christmas
Disclaimer: Copyright © 2024 My State 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