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;

453 Cold Brook Dr
Colton, NY 13625
Amanda Fiacco with Fiacco Realty, LLC, original listing - (315) 854-7529

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $284,000
Beds: 2
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1560 Square Feet
Agency: Fiacco Realty, LLC
Agency Phone: (315) 854-7529

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1995
Notes: MOVE IN READY LOVELY LOG CABIN - SITUATED ON 10 ACRES ON COLD BROOK DRIVE IN SOUTH COLTON! This two bedroom, 2.5 bathroom home with an open concept living area, a large walk out basement, a detached garage, covered front porch, large back deck and a circle driveway could be yours! As you enter the home through the front door you will see the very spacious open concept living room and kitchen with plenty of room for a dining room table or an island with bar stools. There are plenty of windows for natural light. The kitchen has an ample amount of hickory cabinets, a stainless steel refrigerator and a glass top stove that convey with the home. Off the kitchen is the laundry room for your convenience. As you go down the hallway you will see the full bathroom with a handicap walk-in shower/bathtub with a door, a toilet, a vanity and a closet for storage. Across the hall you will see on of the bedrooms. At the end of the hall you will find the large primary bedroom with two walk-in closets. Then you will see the primary bathroom with a spacious jet bathtub. There is a chairlift on the staircase that leads down to the basement where you will find a large open area where you could make a few more bedrooms, another living room, a gym or an office. There are windows on the back wall and a door that leads to the back yard for your convenience. You will also find a half bathroom, a forced air furnace, storage shelves and a work shop in the basement. There are glass french doors in the kitchen that lead to the large back deck where you can relax, have BBQ's or play games. There is a covered front porch for your enjoyment as well. There is a chairlift on the side staircase of the home as well. Then you will find the two car detached garage and a carport. You can also have fun making trails to ride or walk on throughout the 10 acres that surround the home. Higley Flow State Park owns the land to the left of this home and the camp ground is across the road. So you can enjoy cross country skiing on the trails across the road. The home is located just outside the Adirondack Park but you are very close to trails to ride on, mountains to climb and many bodies of water to go boating and fishing. This home is not too far from Lake Placid, Saranac Lake, Tupper Lake and Cranberry Lake. Schedule your showing soon to see this lovely log home nestled in the woods!
MlsNumber: --
ListingId: 50691


Listing Provided By: Fiacco Realty, LLC, original listing
Phone: (315) 261-9809
Office Phone: (315) 854-7529
Agent Name: Amanda Fiacco
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