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 = 1878 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 = 1878 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 = 1878 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;

1964 Glasco Tpke
Woodstock, NY 12498

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $895,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2219
Agency: Coldwell Banker Village Green Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1973
Notes: Here you will discover a spacious home nestled along a country road and backing up to forever wild land. This house has had a recent full renovation and is an easy 2 miles into the vibrant heart of Woodstock. The stunning residence blends an unbeatable combination of comfort, style and nature. Once inside you will visually discover two main elements of the home. To the left you'll find a large, open kitchen and dining area. It is the heart of the home and quite perfectly designed for gatherings and culinary adventures while a breakfast bar allows for casual meals. A well equipped kitchen offers modern appliances and ample quartz counter space to make meal preparation a delight.<br /> <br /> Adjacent to the kitchen is a full bathroom. The living room which spans the entire depth of the home, features sliding doors that open to a fabulous deck as well as a screened in porch with an amazing built-in fireplace. An interior fireplace is a star focal point of the living room design. The seamless flow of the living area creates an inviting atmosphere that brings the outdoors in. This creates all season enjoyment of the serene views of the adjoining ''forever wild'' parkland. In good weather nothing beats experiencing natures' beauty as enjoying it from the comfort of your own screened porch. Or having the ability to step out of the house to the expansive deck and soak in the peaceful surroundings or host memorable outdoor celebrations. A large fenced backyard yard surrounds the decking to keep pets safe and within sight. Four spacious bedrooms, loads of closet and storage spaces and immaculate recently renovated bathrooms add to the home's sparkling atmosphere. And, what could be nicer than driving into an oversized garage when it's dark or stormy? Here you can. Additionally there is a full-sized basement offering additional space for storage or finish to create a home gym or workspace.<br /> This 2 acre property is a mere two miles from the center of Woodstock where it's easy to immerse yourself in the community. Woodstock is more alive than ever with music, dining highlighted by a farm to table consciousness and rich with its 100 year old cultural history. The majestic Catskill Mountain trails and skiing are a short drive away offering endless opportunities for adventure seekers and nature lovers. Yes, this move-in ready home is perfectly suited for both relaxation and entertaining.
MlsNumber: 20242374


Listing Provided By: Coldwell Banker Village Green Realty, original listing
Name: Coldwell Banker Village Green Realty
Phone: (845) 679-2255
Office Name: Coldwell Banker Village Green
Office Phone: (845) 679-2255
Agent Name: Laurie Ylvisaker
Disclaimer: Copyright © 2024 Multiple Listing Service of Ulster County. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1878 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;
Real Estate Expert Photo for Kathleen Maxwell
Kathleen Maxwell
ASCIIKeller Williams Realty Hudson Valley North
Call Today!: (845) 430-1054

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App