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

9440 Skaneateles Tpke
Hubbardsville, NY 13355

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,000
Beds: 4
Baths: 2
Status: Active
SqFt: 1086
Agency: VANDEWATER & ASSOCIATES INC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 60 acre(s)
Property Type: Residential
Year Built: 1989
Notes: 60 BREATHTAKING ACRES BROOKFIELD MADISON COUNTY, NY Located between the beautiful Catskill Mountains and the Southern Tier of Central New York, this unique estate covers 60 acres in Brookfield, Madison County. It includes a farmhouse that dates back to 1801 and served as a Stagecoach Stop, Tavern, and Inn on Skaneateles Turnpike. The exquisite historic farmhouse was fully renovated in 1980 with a block foundation, and a poured concrete basement floor, and has been updated every year since. The current owner has meticulously modernized this 4-bedroom, 2 full-bathroom property, featuring a living room and dining room with a breathtaking stone fireplace complete with a wood storage elevator leading to the basement. There is also a den and an enclosed heated porch off the living quarters. The master suite is located on the first floor, while three other bedrooms, a full bathroom, and a walk-in attic are on the second floor. The second log structure, "The Chalet," was fully renovated in 2018 and features two bedrooms, one bathroom, a laundry room, and a loft area on the second floor overlooking a magnificent spring-fed 1.5-acre stocked pond with pavilions, a cooking area, and a fire pit. Bathrooms with running water and a septic system are available, as well as a storage shed, a sandy beach with a diving board, a floating platform, a boat dock, and several campsites that can accommodate large RVs. The property is surrounded by manicured fields and has many groomed trails throughout the woodlands. It is also very close to the famous Charles E Baker State Forest, which features over 130 miles of horse and hiking trails. The estate has a new addition, which is a complete turnkey property, priced at $799,000. The 30 X 45 garage built on a concrete slab features 12' ceilings, a 10 X 10 garage door on the front, and an 8 X 10 garage door on the side. Additionally, it has a 10 X 45 shed roof on the east side for equipment storage.
MlsNumber: 11202386


Listing Provided By: VANDEWATER & ASSOCIATES INC, original listing
Name: VANDEWATER & ASSOCIATES INC
Office Name: VANDEWATER & ASSOCIATES INC
Office Phone: (315) 348-8884
Agent Name: Rebecca MacKenzie
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.


Local Real Estate Expert

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 = 1849 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;
Real Estate Expert Photo for Linda Messerschmidt
Linda Messerschmidt
ASCIIKeller Williams Syracuse Realty
Call Today!: (845) 559-3000
Office: (315) 701-6923

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App