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

6020 Mcclay Rd
Friendship, NY 14739
Paul Vaicunas with WHITETAIL PROPERTIES REAL ESTATE LLC (NY), original listing - (217) 285-9000

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 105 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2018
Notes: We are pleased to present a private home located just minutes from town on a dead-end road with privacy, acreage and woods. Located just 4.7 miles north of the town Friendship, NY and 5.75 miles south of Belfast NY, you will find a newer built 1,152 sqft home at the end of a private 890 foot long driveway. This property is the last home on Art McClay Road and opens to a large parking lot and farm. Upon on approach, home seekers will immediately be impressed by the privacy of country living with pasture and woods all around you. The home has a wonderful covered porch that wraps two sides of the house overlooking the yard and pasture. A perfect place to relax and sip coffee or listen to the crickets and songbirds. Inside, the home is open in design with a large kitchen dining room combo next to a large living room with a main floor owners' bedroom. Hardwood floors and built-in kitchen cabinets are features noted in this country charmer. Unique to the home is a large mudroom entrance for muddy boots and extra storage. The second level is a blank canvas for rooms and is currently one large room ready to be made into two or three more bedrooms pending your accommodation needs. There is a full basement, also ready to be made into whatever your accommodation might require. A separate entrance into the basement is also provided. The barn has several horse stalls, tie stalls and ample hay loft storage above, perfect for someone having livestock, light animals or horses. There is also a lean-to for equipment storage as part of the barn construction. The pasture is fenced and is approximately five acres. The rest of the property is approximately 95 acres of woods, with a trail network coursing through it from old logging roads. The woods are a mix stand of hardwood with representation of mostly maple, oak and cherry trees with one defined stand of planted pines. There is a pond in the south parcel just off the main trail and would be a great home to wood ducks and a place for game to water. Deer and turkey hunting can be enjoyed right out your back door. There is an electric service line on the property, for an easy connection to the home. This property would make a great off-the-grid opportunity or an easy conversion to modern living, or a newer hunting camp. With privacy, peace and quiet, and the tranquility of living on a dead-end road the fortunate new homeowner will enjoy a special location that's hard to find. ADDITIONAL INFORMATION: Dead end location, Newer home 2018, Hardwood floors, Metal roof, Covered wrap-around porch, Basement, Pasture, Barn, Hay Loft, No gas wells, Pond, New Building lot location is available on tillable acres, Big parking lot, Food plots opportunity, electric on site, Trails, Deer hunting, Spring water, needs septic, Agents must be present for showings, Sold AS IS. Disclaimer: Map illustrations are for reference purposes only and not the representations of the Listing agent or brokerage Whitetail Properties Real Estate LLC. Illustrations are provided by Land ID. Parties should be advised to confirm Illustrations with licensed professional service providers.
MlsNumber: --
ListingId: 11346353


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