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

36 Mansion Grounds Road
Gouverneur, NY 13642

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 5
Baths: 5
Status: Active
SqFt: 4088
Agency: LaValley Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2002
Notes: This exquisite lakefront retreat stands as a testament to refined elegance and natural splendor. Situated on the shores of Sylvia Lake, the grandeur of this 5-bedroom, 4.5-bath estate unfolds like a masterpiece of architectural poetry. As you approach along the winding driveway, framed by lush foliage and vibrant blooms, the home emerges, its façade a harmonious blend of charm and modern sophistication. Stepping through the front door, you are greeted by a bright and spacious foyer, setting the tone for what lies beyond. The main level unfolds seamlessly, where the gourmet kitchen, dining area, and living room flow in perfect harmony. Vaulted ceilings in the main living room soar overhead, while a grand stone fireplace commands attention, offering warmth and ambiance on cooler evenings. The gourmet kitchen is a chef's delight, appointed with top-of-the-line appliances, custom cabinetry, and a spacious island that doubles as a gathering place for family and friends. Oversized windows frame sweeping views of the lake, transforming meal preparation into a feast for the senses. The primary bedroom reigns supreme. Here, you will also find a private en-suite bath that offers a luxurious oasis complete with a soaking tub, and dual vanities. The remaining bedrooms are equally inviting, each offering plush accommodations, ample closet space, and access to well-appointed bathrooms that rival those of a five-star resort. Every corner of this home has been thoughtfully designed to provide comfort and luxury. Outside, there is a separate Playhouse, an oversized garage, a single vehicle garage, and a large storage building to store all of the toys. There is an expansive deck overlooking the shimmering waters, and a lakeside gazebo where you can enjoy the tranquil landscape.
MlsNumber: 201861


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: Kathryn (Kate) Bencze
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