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;

30 Hamilton Smith Road
Hammond, NY 13646
Erin E Meyer with Meyer Real Estate LLC, original listing - (315) 323-1293

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $159,900
Beds: 4
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1404 Square Feet
Agency: Meyer Real Estate LLC
Agency Phone: (315) 323-1293

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1880
Notes: Charming 4 BR, 1.5 bath stone home built in 1880 sits on 2.7 acres just outside the village of Hammond with a location that could not be more ideal as you are just minutes to the St. Lawrence River and Black Lake. The updates, improvements and restoration of this home all were done with careful consideration and planning as the main objective was to modernize while restoring & highlighting its original beauty, detail and craftsmanship that these homes are known so well for. The stone exterior has been repointed, 3 new small porches, new windows, a new metal roof all completed in the past five years. All of the electrical and plumbing has been updated, additional insulation added & water and sewer lines are new. The main level was redesigned to give an open concept allowing flow between the living room, dining room and kitchen area… it also allows you to appreciate all of the details, to appreciate and the focal point is the beautifully restored stone faced fireplace with built in side warming areas. Although now it is decorative, it would be very easy to open up….. a wood stove insert was the main source of heat when the owners lived there full-time and used the furnace as a back up. The hardwood floors are stunning with a simple design in the dining area. Laundry closet on the main level set up for stackables & a full bath with tub shower combo. The second floor is was redesigned with the owners adding 2 additional bedrooms and a half bath, giving you 4 nice size bedrooms. The before and after pictures are astounding, all it needs now is a new owner to make it their own.
MlsNumber: --
ListingId: 50688


Listing Provided By: Meyer Real Estate LLC, original listing
Phone: (315) 323-1293
Office Phone: (315) 323-1293
Agent Name: Erin E Meyer
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