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;

39 Elm St
Norwood, NY 13668
Amanda Fiacco with Fiacco Realty, LLC, original listing - (315) 854-7529

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $173,000
Beds: 4
Baths: Full: 1, ½: 1
Status: Active
SqFt: 2088 Square Feet
Agency: Fiacco Realty, LLC
Agency Phone: (315) 854-7529

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1852
Notes: This lovely 4 bedroom, 1.5 bathroom home with a covered front/side porch, a deck, a second story enclosed sun porch, a paved driveway and a detached, heated garage with electricity, water and a second story for storage, all situated on 1.2 acres of land with a spacious yard is ready for new owners. As you enter the front door you will see the foyer with a beautiful staircase with lovely woodwork. From the foyer you will enter the large living room with hardwood floors and plenty of natural light. Part of the living room could be used as a dining room also. Then you will enter the spacious eat in kitchen with french doors that lead out onto the side deck. Off the kitchen you will find a room that could be a downstairs bedroom, an office, a playroom or a mudroom, with a door that leads to the back yard and a staircase which leads to the walk-up attic. Off that room is the laundry room with enough space to add a half bathroom. Off the living room is the half bathroom that has another door that leads to the downstairs bedroom, office or playroom, which has another door that brings you back to the foyer. Upstairs you will find a bedroom to the left of the staircase with a walk in closet, hardwood floors and a tall ceiling. Off that room you will see the enclosed second story sun porch with lots of windows for natural light. Then you will find a full bathroom located at the top of the stairs. The next bedroom has another small room attached that could be used for an office and it has a cedar lined walk in closet. The next bedroom is large with tall ceilings and another walk in closet. In the basement you will find the natural gas boiler and on demand natural has hot water heater. The detached two car garage has electricity, water and plenty of room upstairs for storage. You will enjoy spending time relaxing on the covered front porch, the deck, the large yard, or either of the enclosed porches. This home is close to the grocer store, the park, the beach, restaurants and only 5 minutes from Potsdam. Schedule your showing soon!
MlsNumber: --
ListingId: 50435


Listing Provided By: Fiacco Realty, LLC, original listing
Phone: (315) 261-9809
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