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;

3402 Nys Route 73
Keene, NY 12942

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $279,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Engel & Volkers lake Placid Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Lots And Land
Year Built: --
Notes: New kitchen floor just added to 3 BR, 2 BA home on a private 10 acres is nestled just outside the town of Keene in the Adirondack mountains of upstate New York. Trails right out your door for leisurely walks or fun ATV rides. Enjoy the serene natural surroundings of this spacious, open concept home with tons of light streaming in through the large windows. All appliances are included and the high ceilings add depth to the living area. The primary bedroom adjoins a large bath with separate soaking tub and standup shower and completed by an ample walk in closet. If working from home is your ideal situation, this is the home for you, excellent internet service with underground fiber optics! Give the existing garden your personal touches to enjoy watching your favorite flowers, vegetables or herbs come to life. The location is ideal, just 15 minutes from the Village of Lake Placid, 30 minutes to the Adirondack Northway (I-87). Whiteface Mountain is a quick drive to satisfy the outdoor enthusiast in you. Tons of hiking, biking, skiing at your fingertips, not to mention fantastic area dining spots and activities at the 1980 Olympic venues in the region. The outbuildings include a shed for storage or a workshop, an old barn that needs your imagination to bring it back to life. Upgrades include a new gutter system with leaf guards, new flooring in many areas, the spacious kitchen/dining area provides the opportunity for everyone to be a part of the action! Lots of cupboards and counter space for the chef in your house. Comfortable, one floor living with primary at one end and guest rooms on the other end. Great spot to retreat to after a long day on the trails!
MlsNumber: 200898


Listing Provided By: Engel & Volkers lake Placid Real Estate, original listing
Name: Engel & Volkers lake Placid Real Estate
Phone: (518) 523-4404
Office Name: Engel & Volkers Lake Placid Real Estate
Office Phone: (518) 523-4404
Agent Name: Brenda Goulette
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