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;

2014 Florence Rd
Camden, NY 13316
Timothy Kent with WHITETAIL PROPERTIES REAL ESTATE LLC (NY), original listing - (217) 285-9000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $179,900
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: WHITETAIL PROPERTIES REAL ESTATE LLC (NY)
Agency Phone: (217) 285-9000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Welcome to THE hub of Tug Hill adventure! This 5.3-acre recreational paradise in Osceola, NY puts you right in the center of the action, with snowmobile trail C4 running through the property, the legendary East Branch of the Salmon River along its edge, and nearly a dozen state forests within easy reach. Snowmobilers, start your engines! This is the EPI-CENTER of some of the most exhilarating trails in the region, offering tens-if not hundreds-of miles of seamless riding through Tug Hill's legendary winter wonderland. Anglers, get ready! With prime frontage on the East Branch of the Salmon River, you're steps away from phenomenal trout and salmon fishing. Dip in to cast a line in your own backyard and experience world-class angling that brings in fishermen by the thousands without ever leaving home. Turnkey for your retreat! Already set up for a travel trailer, this property includes hookups for electricity, water, and septic, making it easy to park your rig and settle in for the season. Don't have a travel trailer? The seller is willing to sell their 2022 40-foot all season Forest River Montana 5th Wheel Travel Trailer to help you make the most of the site. (for an additional 85k) Kick back and relax! A cozy man cave/she shed provides the perfect spot to unwind, whether it's enjoying your morning coffee on the porch overlooking the river or an evening cocktail after a full-throttle day on the trails. Serious storage for serious adventurers! A renovated two-car garage and 4-bay storage container offer plenty of space to lock up your sleds, ATVs, hunting or fishing gear, and anything else your outdoor-loving heart desires. The Osceola Hotel & Osceola Outpost - Almost Right Across the Street! When it's time to swap trail stories, tell lies about the one that got away grab a cold one at the World-Famous Osceola Hotel, just a short walk away. If you've been searching for the perfect basecamp for year-round adventure-whether it's snowmobiling, fishing, hunting, or just soaking up the great outdoors-this is it! Prime Tug Hill Location - Don't miss out on this rare find in the heart of one of upstate New York's most sought-after recreational regions. Lock in your Tug Hill getaway before someone else does! Contact us today for more details or to schedule a showing!
MlsNumber: --
ListingId: 11416815


Listing Provided By: WHITETAIL PROPERTIES REAL ESTATE LLC (NY), original listing
Phone: (585) 648-8944
Office Phone: (217) 285-9000
Agent Name: Timothy Kent
Disclaimer: Copyright © 2025 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