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

38 State Route 28
Inlet, NY 13360

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,450,000
Beds: 13
Baths: 6
Status: Active
SqFt: 3400
Agency: LaValley Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 1930
Notes: CAMP CLIFFVIEW OF FOURTH LAKE. This exquisite 3rd generation Adirondack estate promises an unparalleled escape from the ordinary. Resting on four private acres with over 300 feet of shoreline on Fourth Lake, this estate has been perfectly restored and has been meticulously maintained over the years. The multi-building estate consists of the Main House, Guest House, Carriage House, Game Room, and Boathouse. <br /> The Main House sits majestically overlooking the lake with its south facing cantilevered deck and one mile across water views. With five bedrooms and three baths, it comfortably sleeps 12 guests anytime of the year. The Guest House has its own unique style and provides cozy comfort and a large deck of its own. With one floor living, the guest house has it all with living and dining rooms, a large bedroom and bath, and a well-equipped kitchen. The 2nd floor of the Carriage House has classic Adirondack bunkhouse styling. With seven bedrooms, the Carriage House sleeps 14 guests. Included among the sleeping quarters, there is a quaint sitting area, a full kitchen, and a full bath. The 3rd floor has an additional full bath. The Game Room is perfect for gamesmanship among family, friends, and guests. Separate recreational buildings of this type are a common feature of the Adirondack great camp style. The Boathouse is unique in its own way as the architecture brought the old and new perfectly together. The original boathouse was completely renovated and includes a newly constructed, fully equipped boathouse with three boat bays, each with its own boatlift system. The upper level of the boathouse has a huge space and is awaiting its future purpose. A property of this quality rarely becomes available but is being offered for sale for the first time in generations. The estate is being sold fully furnished. Camp Cliffview is a wonderful property that is ready for the next family to create memories for generations to come.
MlsNumber: 200450


Listing Provided By: LaValley Real Estate, original listing
Name: LaValley Real Estate
Phone: (518) 359-9440
Office Name: Coldwell Banker Whitbeck Assoc Tupper Lake
Office Phone: (518) 359-9440
Agent Name: Matthew Ellis
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