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;

320 Chapel Hill Road
Colton, NY 13676
Haley Billings with Nikki Coates & Associates LLC, original listing - (315) 265-4303

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $325,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1728 Square Feet
Agency: Nikki Coates & Associates LLC
Agency Phone: (315) 265-4303

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 28 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2001
Notes: Welcome to 320 Chapel Hill Road! Discover this picturesque 28.2-acre property, perfect for those seeking a small farm or a peaceful retreat surrounded by nature. The home has hardwood floors throughout, and the kitchen stands out with oak cabinets, stainless steel refrigerator, a gas range, a large pantry, and an island. Adjacent to the kitchen is a separate dining area, and just beyond, a convenient laundry/mudroom with washer and dryer hookups, counter space, and cabinetry for storage. This is where you access the attached two-car garage. There is also a spacious living room with a stove and an inviting sun room. The primary bedroom features French doors that open to a private deck with views of the backyard. The en-suite bathroom includes both a jetted tub and a separate shower, as well as a walk-in closet. Other notable amenities in the home include a central vacuum system, a full home water filtration system, and a radon mitigation system. Beyond the main house, this property has two outbuildings, including a two-stall horse barn complete with a tack room, space for hay storage, frost-free water lines, and a watering system. An additional outbuilding offers even more possibilities for horses, livestock, or hobby farming. Buyers will appreciate the professionally landscaped stonework and walkways by Willow Tree, along with the covered front porch, perfect for enjoying the peaceful surroundings. The high and dry basement features a root cellar and pantry with built-in shelving. Recent improvements include a metal roof, reinforced and waterproofed foundation, and board-and-batten siding. This property also offers an artesian spring that flows year-round and the timeless charm of stone walls that border some of the acreage. Whether you're looking to establish a small farm or simply enjoy the beauty of the outdoors, this property offers many possibilities for a variety of buyers.
MlsNumber: --
ListingId: 50484


Listing Provided By: Nikki Coates & Associates LLC, original listing
Phone: (315) 262-5213
Office Phone: (315) 265-4303
Agent Name: Haley Billings
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