Title Page Background
DEBUG FN args: Array ( [0] => 1826 [1] => [2] => [3] => agent ) BEFORE: Site: 1826 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1826 Igate: njhud LocID: 1826 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 = 1826 AND i.igate IN ('cihud','usahud','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 = 'cihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1826 [1] => [2] => [3] => lender ) BEFORE: Site: 1826 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1826 Igate: njhud LocID: 1826 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 = 1826 AND i.igate IN ('cihud','usahud','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 = 'cihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1826 [1] => [2] => [3] => other ) BEFORE: Site: 1826 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1826 Igate: njhud LocID: 1826 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 = 1826 AND i.igate IN ('cihud','usahud','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 = 'cihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

280 Dodd Rd
Windsor, NY 13865
John Myers with WHITETAIL PROPERTIES REAL ESTATE LLC (NY), original listing - (217) 285-9000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,299,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 5374 Square Feet
Agency: WHITETAIL PROPERTIES REAL ESTATE LLC (NY)
Agency Phone: (217) 285-9000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 152 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Let your country-living dreams come true with this park-like estate, in a very private location teeming with wildlife. Located within the Windsor School District, this immaculate, 5374 sq. ft. contemporary colonial, built in 2006, features 4 generous bedrooms, 4.5 bathrooms and ample room for large gatherings of family and friends, both inside and out. The updated, separate eat-in kitchen features new quartz counters and newer stainless steel appliances, including a glass range top with double oven, Frigidaire French door refrigerator, Jenn air grill, dishwasher, trash compactor, and garbage disposal. The kitchen has room for a full sized table for informal meals and is open to a family room with 20' ceilings and a propane fireplace for cozy gatherings, while a large separate dining room is located on the other side off the kitchen, perfect for more formal meals and entertaining. Off the sunny kitchen, a slider leads to a screened-in porch with a ceiling fan and then on to an open Trex deck area with an automated SunSetter awning for ultimate outdoor comfort. Additional rooms include an office, formal living room, den, a large hobby room (which could be used as a media room, play area or studio) and another sizeable family room with gas fireplace located in the light-filled, finished basement. Sliders from there lead to a large patio area and attached greenhouse outside. There is also a full sized shower/tub located in the utility room for doggie baths. Quality building features include a poured concrete foundation, easy care vinyl windows & siding, two 1000 gallon buried septic tanks, buried electrical service, central AC & heating systems, Generac propane back-up generator, Blink security cameras and Century alarm system and an oversized, 3 car attached garage with door openers. Outdoor features include manicured landscaping and a lovely .4 acre pond, as well as an orchard with both apple and pear trees. This incredible property provides multiple options for the new owner with 3 steel outbuildings, offering any number of uses including workshop, storage, art studio, potential for horses and/or small farm livestock. All buildings feature electrical power and concrete floors. The first is ~27'x 40' with a 10' roof extension and 10' overhead door. The second building is ~27' x 50' long and includes 6 propane heaters and floor drain, while the third building is ~24' x 45' with an overhead door on both ends. With over 150 acres, this property is ideal for outdoor enthusiasts, offering a diverse habitat, perfect for whitetail deer, wild turkey, and area wildlife. There are open areas for food plots, an amazing natural spring whose flowing waters feed into stream which runs through a section of a beautiful ravine, and acres of mature oaks running along a nice ridge, which produces acorn mast for wildlife, and ideal turkey roosts, along with stands of hemlock and other mixed hardwoods. Old logging trails offer easy access via ATV or horseback. This area is locally known for producing big bucks, with its long distances between roads and highways, creating a sanctuary-like habitat, while offering many choices for hunting stand locations, as deer traverse the benches from food to cover. On a recent visit, there were abundant deer sign including runs, last season's scrapes and buck rubs noted, including some on 4 inch trees. Strategically placed game cameras capture a variety of wildlife, showing this property has been managed for trophy whitetails, taken in years past. Amenities are easily available within 15 minutes in nearby Windsor, with additional shopping, restaurants, and entertainment in the greater Binghamton area within 15 minutes. NYC/George Washington Bridge is located just 2 hours and 45 minutes from this property.
MlsNumber: --
ListingId: 11496864


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 © 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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => broome [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: broome State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: broome State: NY 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 = 1826 AND i.igate IN ('cihud','usahud','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 = 'cihud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Shannon Yesalusky
Shannon Yesalusky
ASCIIRealty Solutions Group
Call Today: (607) 744-1765

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App