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;

6232 County Route 27 Lot 4
Canton, NY 13617

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $589,000
Beds: 5
Baths: 1
Status: Active
SqFt: 4480
Agency: ListWithFreedom

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 2008
Notes: Large comfortable home built in 2008 on a large, quiet lot. Located near Partridge Run Golf Course, right off the Remington Bike Trail. This well-maintained two story home with a new roof in the fall of 2022 boasts an inviting front porch for entertaining or enjoying a quiet evening. Upon entering the house, there is a large mudroom entryway with tons of storage, including built-in cabinets and ample hanging racks. The large kitchen with a huge island for seating and prep has two sinks, black stainless steel appliances, lots of counter space, maple cabinetry, a large walk-in pantry, and a beautiful slate Rinnai fireplace. The dining room provides additional room for entertaining. The back of the house features a gorgeous south-facing sunroom with a gas stove and lots of light. The first floor bathroom features a granite topped vanity and walk-in stone shower. The large living room includes another slate Rinnai fireplace, cherry flooring, and room for a 75" television. Dual staircases lead to the second floor as well as the basement. The second floor boasts five bedrooms, all with large closets, including a master bedroom with en suite as well as a second bedroom with an attached bathroom. The other three bedrooms share a dual sink vanity with marble top, walk-in tile shower, and lots of storage. The master bedroom has a 10x11 walk-in closet and slate fireplace. The master bath has dual shower, separate toilet area, and a double sink vanity. The upstairs laundry room is spacious, with ample storage. The first and second floors boast individual heat zones and in-floor radiant heat. The dry unfinished basement houses the utilities, including an on demand water heater and fresh-air exchange system. The basement is foam block construction with open span floor trusses. There is a finished craft room and an unfinished office space as well. The attached two stall garage features 9' automatic doors and a large bonus room above. The property also includes a 26x36 garage built in 2020. The property includes 4.9 acres of the existing lot; an additional 8 acres are available for purchase separately.
MlsNumber: 49606


Listing Provided By: ListWithFreedom, original listing
Name: ListWithFreedom
Phone: (855) 456-4945
Office Name: ListWithFreedom
Office Phone: (855) 456-4945
Agent Name: Ralph Harvey III
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