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','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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','vahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;

523 Parmenter Rd
Potsdam, NY 13676

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $269,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 1912
Agency: Fiacco Realty, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 1990
Notes: This beautiful, move in ready log home has 3 bedrooms, 3 bathrooms, triple pain windows that open 2 different ways, lovely landscaping, a sauna, a woodstove, and more and is situated on 3.5 acres in Hannawa Falls, just minutes from Potsdam! This home was built in 1990 and has been well maintained. As you enter the driveway you will love the privacy of the tree lined driveway and road. Then you will see the beautiful log home with an attached garage, an enclosed front porch, a covered front porch, a deck on the end of the home that wraps around the back of the home, a garden area, a sauna, a shed, a wood shed and the lovely landscaping. As you enter the home you will see the open concept living area with a wonderful vaulted ceiling, great beams, wood flooring, nice lighting and many windows for plenty of natural light. The living room has a woodstove for extra warmth on the cold winter nights. The dining room has glass doors that lead to the wrap around deck and the back yard. The wonderful kitchen has stainless steel appliances, plenty of cabinets and counter space. Down the hall you will find the mudroom/laundry room with a door that leads to the enclosed front porch so you can enter the home through that door as well. Then you will find two bedrooms and a full bathroom. At the end of the hall is the door to the attached two stall garage. As you walk up the beautiful staircase you will enjoy looking down onto the living room and dining room and there is a landing area at the top of the stairs. The very spacious primary bedroom with a walk in closet and the primary bathroom are the only rooms on the second floor. Off the kitchen is the basement where you will find two finished rooms, a full bathroom with a jet bathtub/shower, the utilities and a storage/workshop area. There is another door in the storage room that leads to a set of stairs that takes you to the attached garage. This beautiful, move in ready home with great privacy is priced to sell and could be the oasis that you've been looking for! Schedule your showing very soon because this gem will go quickly!
MlsNumber: 49581


Listing Provided By: Fiacco Realty, LLC, original listing
Name: Fiacco Realty, LLC
Phone: (315) 854-7529
Office Name: Fiacco Realty, LLC
Office Phone: (315) 854-7529
Agent Name: Amanda Fiacco
Disclaimer: Copyright © 2024 St. Lawrence Board of Realtors. 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