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;

90 County Route 38
Norfolk, NY 13667

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 6
Baths: Full: 7
Status: Active
SqFt: 3741 Square Feet
Agency: Sandstone Realty
Agency Phone: (315) 265-2111

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 268 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1993
Notes: What an opportunity to purchase this amazing property with just over 268 acres! There are multiple buildings that include a 7 bedroom Cape Cod home, a detached 4 car garage, a second detached garage, 3 additional cabins, a pole barn and even more. As you enter the drive of this private property and bear to the right, you will follow a narrow portion of the Raquette River and end at the main home and two detached garages. The picturesque Cape Cod home has an inviting front porch overlooking the river and a huge back deck that overlooks the pasture and cabins. A vaulted living room with clear story windows and a balcony above are enhanced with a gorgeous stone fireplace that space the height of the space and wood floors. The sprawling dining room has room has detailed wood ceilings, large windows and room to fit many people! Of the dining a living spaces is the fully functional kitchen with white cabinetry, ample storage and access to the side covered patio. The back of the home is currently set as a game room, completed with a ping-pong table, foosball table, pool table and tons of additional seating. There is also a main floor bathroom off this space. A large main floor primary suite features a bathroom with tub and separate shower and another room that is currently used as an office. Up the wooden staircase are 2 additional bedrooms and a big bathroom with a claw foot tub and separate shower. The lower level living area is home to the laundry room, a bathroom and the additional bedrooms. The paved driveway spans past the home and connects with the detached 4 car garage. There are three main bays facing the driveway and a 4th door around the side. An outdoor staircase brings you to the second floor space that is currently being used for storage, but has the potential to be completed into something more. A second detached garage has three overhead doors, a large interior storage room and is used to store off-roading vehicles. Travel around the pasture and you will be led to the three cabins. Each of these cabins has water, electricity and a heating source. Two of the cabins are 1 bedroom and 1 bathroom with an open living space, full-width screen porch and privacy. The third cabin has an addition which has transformed it into a 3 bedroom, 1 bathroom dwelling. There is so much to this property that you have to not only look at the photos, but see it in person to truly appreciate everything that is has to offer.
MlsNumber: --
ListingId: 49158


Listing Provided By: Sandstone Realty, original listing
Phone: (315) 244-1663
Office Phone: (315) 265-2111
Agent Name: Katie Geidel
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