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;

113, 119 Hough Rd
Massena, NY 13662

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,000
Beds: 7
Baths: 3
Status: Active
SqFt: 5684
Agency: Trego Realty Group, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 30 acre(s)
Property Type: Residential
Year Built: 1999
Notes: It will be a challenge to find another house of this caliber and uniqueness. Sitting back from the road, surrounded by 30 wooded acres with trails, sits this stunning custom built home with over 5,800 square feet of living space that has been retrofitted to be ADA accessible. All doorways are at least 32" inches, some are 36". There is a custom built roll in shower and a wheelchair elevator in the attached 2 car garage to enter the home. Outdoors, the paver patio was redone to include ramps. There is also a lift for the pool. Upon entering this split level home, the upper level invites you into an expansive, open area comprising of the dining room, living room, family room and a sitting area reminiscent of a sunroom with its French doors leading to the multi-level paver stone back patio. The kitchen, with its eat in counter at the island, is large with ample cabinet space and access to the patio area. The rest of the first floor has 4 bedrooms, including the primary bedroom with the ADA en-suite bathroom, a second full bathroom and the laundry room. The lower level is fully finished with a large built in bar area, living room, 3 more bedrooms, one with a massive walk in closet, a half bath, a craft room with built in counter and cabinets and the utility room. Outdoors, at the front of the property is a second garage/workshop. The pool is heated and is lit at night and there is an 8x8 hot tub. The gazebo is massive with two fans and lighting. The lower patio has a firepit to enjoy and you are steps away to 30 acres of wooded trails for all of you outdoor enthusiasts to enjoy it quiet privacy.
MlsNumber: 49489


Listing Provided By: Trego Realty Group, LLC, original listing
Name: Trego Realty Group, LLC
Phone: (315) 705-5542
Office Name: Trego Realty Group, LLC
Office Phone: (315) 705-5542
Agent Name: Elizabeth Trego
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