Title Page Background
DEBUG FN args: Array ( [0] => 1831 [1] => [2] => [3] => agent ) BEFORE: Site: 1831 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1831 Igate: njhud LocID: 1831 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1831 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1831 [1] => [2] => [3] => lender ) BEFORE: Site: 1831 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1831 Igate: njhud LocID: 1831 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1831 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1831 [1] => [2] => [3] => other ) BEFORE: Site: 1831 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1831 Igate: njhud LocID: 1831 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1831 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

452 North St
Greene, NY 13778

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: WHITETAIL PROPERTIES REAL ESTATE LLC (NY)

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other

Window Features

Parking Features: Garage
Waterfront Features: Waterfront

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 604 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Rare opportunity to purchase a very large tract of intact land in the Southern Tier, with quality, harvest ready timber, which, with proper management, could potentially be self-sustaining as far as property taxes and offers an amazing hunting property, vacation getaway or build your year round home on this private "estate". The heavily wooded property features two streams, including 2080 frontage on Indian Brook, and 2714 feet frontage on Halfway Brook, a registered trout stream, as well as your own private 5.45 acre natural pond. The forested areas are a mix of all hardwoods (oak, cherry, maple, etc), softwoods and wild apple trees. The oak and wild apples provide mast and attractive food sources for the local whitetail deer, wild turkey and other native wildlife. This diverse habitat also offers areas of brushy undergrowth creating ideal browse and cover for the whitetail, while clearings spotted around the property have been used for food plots, with strategically placed, mix of hunting stands (over 40 per the owner). With a property this size, it is large and diverse enough to hold mature bucks, with relatively easy to navigate terrain, along with a ridge running through the center where deer like to run and bed. Nice sized trails run along the ridge and throughout the property providing easy access throughout. The property is bordered on 2 sides by paved, maintained roads as well as a section of a seasonal use road traversable with an ATV or side by side (or horseback!). The property has a gated entrance and most of the perimeter is painted and posted so the borders are easily identified. This property offers considerable income potential with timber trees already identified and documented, managed under the guidance of a professional Forester. Mature trees have been numbered and recorded, being monitored for future timber harvests. There is power available along North Street as well as along the paved section of Beeman Hill Road. Amenities are easily available nearby within 5.5 miles to Smithville Flats, 7 miles to Whitney Point, 9 miles to Greene and very commutable distance of 20 miles to Binghamton. Additional fishing and water sports are available just 6 miles away at Dorchester Park, on the 1200 acre Whitney Point Reservoir, renowned for pike, bass and crappie fishing among other species, it features a public boat launch, public beach, picnic areas, camping and miles of hiking trails as well as hunting on the Whitney Point Multiple Use Area with an additional 4645 acres of public state lands. This is an amazing hunting and wildlife property, rarely available in this area with this amount of acreage and is located just 3 hours from NYC/George Washington Bridge. Enjoy your private hunting compound, camp or build an amazing vacation getaway or your new year round home.
MlsNumber: --


Listing Provided By: WHITETAIL PROPERTIES REAL ESTATE LLC (NY), original listing
Phone: (217) 285-9000
Office Phone: (217) 285-9000
Agent Name: John Myers
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