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
Elizabeth Trego with Trego Realty Group, LLC, original listing - (315) 705-5542

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,900
Beds: 7
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2842 Square Feet
Agency: Trego Realty Group, LLC
Agency Phone: (315) 705-5542

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 30 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1999
Notes: It will be a challenge to find another house of this caliber and uniqueness. Sitting back from the road in privacy, surrounded by 30 wooded acres with trails, sits this stunning custom built home with over 5,600 square feet of living space. 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 a large, gorgeous ensuite 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 with two fans and lighting make it the perfect place for outdoor entertaining. 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. Want options? At the front of the property, you can parcel off and sell a 1 acre building lot in this desirable, quiet neighborhood. This lot has an existing septic and dug well and access to town water hookup.
MlsNumber: --
ListingId: 49489


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