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

1463 Goodnow Flow Road
Newcomb, NY 12852

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $495,000
Beds: 3
Baths: 1
Status: Active
SqFt: 3120
Agency: Higher Places Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 800 acre(s)
Property Type: Residential
Year Built: 1980
Notes: LAKEFRONT: Very Rare Opportunity: Well-built, easy to maintain home with membership in a sportsman club. Own all the land with just 15 other members (fractional). 800 acres including Otter Pond, a private lake. The home is South facing offering outstanding views from a covered porch, kitchen, dining area, living room. Varnished knotty pine is throughout the interior with beamed cathedral ceiling living area, floor to ceiling large stone chimney, wall of windows looking at the lake and mountains. The kitchen has beautiful cabinets, new appliances. Three bedrooms all in knotty pine. Finished walk-out basement with a soapstone woodstove, lake views, office area, bedroom, laundry room, and big closets. The large attached garage with varnished ceiling/walls, built in cabinets, closets, and ceramic tile floor. Plus, separate 3 car garage which can fit a boat. Total garage space for 4 cars. Generac Generator, fully insulated. The home has a private license for the land it's on with 150' located on the private spring fed Otter Pond. Swimming/boating dock, perimeter of the pond is about a mile to paddle. Enjoy hunting, fishing, paddling, snowmobiling, 4 wheeling, x-country skiing, snowshoeing all on the 800 acres of private and adjacent to State Land. Total Taxes: $2,331.91, Dues: $1100 year<br /> 1463 Goodnow Flow Rd, Newcomb, NY<br /> Shown by appointment only.
MlsNumber: 200859


Listing Provided By: Higher Places Realty, original listing
Name: Higher Places Realty
Phone: (518) 582-2305
Office Name: Higher Places Realty
Office Phone: (518) 582-2305
Agent Name: S Judith (Judy) Morris
Disclaimer: Copyright © 2024 Adirondack Champlain Valley 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