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

4555 Elwood Rd
Cincinnatus, NY 13040
John Myers with WHITETAIL PROPERTIES REAL ESTATE LLC (NY), original listing - (217) 285-9000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $529,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2560 Square Feet
Agency: WHITETAIL PROPERTIES REAL ESTATE LLC (NY)
Agency Phone: (217) 285-9000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 63 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1900
Notes: A perfect mix of antique and modern awaits in this beautiful late 1800's barn conversion with its open layout and country chic designed by a professional architect. The sun-filled, open layout includes many original hand hewn beams and gorgeous floors made from locally sourced pine, blue stone at the entries, along with additional antique relics and hand crafted features throughout *see the hay pulley system in the peak of the cathedral ceilings. The wall mounted buffet in the dining area was designed by the renowned architect I.M. Pei, per the Seller. Great meals are waiting to be made in the high end kitchen with granite counters, blonde maple shaker cabinets, and stainless steel appliances. There 3 bedrooms and 3 full sized bathrooms: two of the ample sized bedrooms are located on the main floor, each with its own full bath, and a huge primary bedroom is in the loft with its own ensuite bathroom. Sliding glass doors in the living area and one bedroom both lead to a large deck off the back of the house , overlooking the creek, meadows, and woods beyond. The house is heated with forced air propane furnace and cooled with Central Air. Additional room for family, friends or consider a rental unit / Airbnb opportunity with the 20 ft x 24 ft Guest house with front deck, featuring 1 bedroom, 1 bath and open living area. The land consists of 8 acres of tillable ag fields, currently in hay with large areas of meadows and brushy undergrowth, ideal habitat for local wildlife, particularly whitetail deer. The property slopes gently up from Wells Creek, with 1914' of frontage crossing through the property behind the barn, and up to the wooded area in the back. There are trails cut in providing access, with great hunting, including a tower stand that stays, and all kinds of outdoor enjoyment opportunities. There are two small ponds as well. Amenities are available close-by with Taylor located just 4 miles away, and Cincinnatus in 6.5 miles. Additional shopping, restaurants and entertainment are available within a 20 mile commute to Cortland, or an hour to either Syracuse or Binghamton. NYC/George Washington Bridge is just 3.5 hours away. This is a great opportunity to own a very unique property that embraces our agricultural history balanced with modern amenities and comfort and offers a year round home, vacation getaway and income potential with the farmland and guest cottage.
MlsNumber: --
ListingId: 11334534


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