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 = 1833 AND i.igate IN ('usahud','wihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wihud', 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 = 1833 AND i.igate IN ('usahud','wihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wihud', 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 = 1833 AND i.igate IN ('usahud','wihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wihud', 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;

45 Tamarac Road
Copake, NY 12516
Lindsay LeBrecht with Copake Lake Realty Corp., original listing - 325-9741

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 3456 Square Feet
Agency: Copake Lake Realty Corp.
Agency Phone: 325-9741

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Pampered & Private. Do unto others . . . is the theme of this home. The seller wanted the new owner to move in with a fresh coat of paint, new carpeting, new appliances and many upgrades. On a private dead-end road, nature abounds. The rear of the property backs onto wetlands and then to a summer camp. Well protected.The main level has an open floorplan: Living room (with fireplace insert)/dining area and kitchen. Off the living room is the sun room and one of the exits to the deck.Up one-half of a level are the sleeping quarters and laundry: Primary en-suite (with both tub and shower), two more bedrooms and a full hallway bathroom. The lower level is ~1728 of open space. Wood stove sitting area, space for a dining/game table, larger room for a pool table and other activities. Two bonus rooms. French door to the exterior. Equi-distance to Hudson, NY and Great Barrington, MA. Catamount Adventure Park (snow skiing, longest zip line in the USA) is about 15 minutes away.. The Harlem Valley Rail Trail (bicycling path), farm-to-table restaurants, antiquing, hiking, theatre and concerts. So much to do year-round or just curl up with a book in front of the fireplace. Separate expansive two-car, over-sized garage with space above to be finished by the new owner. Separate electric meter. Both.Amtrack and MetroNorth are about 1/2 hour away. Approximately two hours from New York City. So close to everything, but far enough away.
MlsNumber: --
ListingId: 155475


Listing Provided By: Copake Lake Realty Corp., original listing
Phone: (518) 325-9741
Office Phone: 325-9741
Agent Name: Lindsay LeBrecht
Disclaimer: Copyright © 2024 Columbia Greene and Northern Dutchess MLS. 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