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

28-30 Old Hotel Road
Tupper Lake, NY 12986
Lisa Gillis with Merrill L. Thomas - Gillis Team, original listing - (518) 359-9797

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,900,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 1422 Square Feet
Agency: Merrill L. Thomas - Gillis Team
Agency Phone: (518) 359-9797

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: Set against the picturesque backdrop of Upper Saranac Lake, this property offers a truly enchanting experience with its breathtaking views of the lake and mountains nestled within a secluded cove. Spanning an expansive 4.76 acres, this estate boasts an impressive 500 feet of pristine shoreline along Upper Saranac Lake, providing unparalleled access to the water's edge and a wealth of waterfront activities.<br /> <br /> The main residence, a charming year-round home, features three bedrooms and two baths and offers the perfect blend of rustic charm and modern comfort. A central focal point of the living space is a cozy fireplace, creating a warm and inviting atmosphere, perfect for relaxing evenings with family and friends. While the main residence showcases the timeless appeal of Adirondack living, it also presents an opportunity for upgrades to tailor the space to your preferences.<br /> <br /> In addition to the main home, the property includes a delightful seasonal guest cottage, offering a private retreat for visitors. This cozy cottage comes complete with its own septic system and electric meter, ensuring convenience and independence for guests.<br /> <br /> Beyond the comfortable dwellings, the property's vast acreage provides ample space for outdoor activities, whether it's picnicking by the shoreline, exploring nature trails, or simply enjoying the tranquility of the surrounding landscape.<br /> <br /> With its unique combination of natural beauty, extensive shoreline, and charming accommodations, this property on Upper Saranac Lake offers an idyllic retreat for those seeking a quintessential Adirondack experience.
MlsNumber: --
ListingId: 200700


Listing Provided By: Merrill L. Thomas - Gillis Team, original listing
Phone: (518) 354-1666
Office Phone: (518) 359-9797
Agent Name: Lisa Gillis
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