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

875 Eastland Drive
Charles Town, WV 25414
Carolyn Snyder with Snyder Bailey & Associates, original listing - (304) 267-1050

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $874,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 5262 Square Feet
Agency: Snyder Bailey & Associates
Agency Phone: (304) 267-1050

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Enjoy beautiful views of the Blue Ridge Mountains from this prestigious home in one of Jefferson County's premier communities. This spacious high quality home sited on 1.27 acres with mature specimen trees, and beautiful landscaping provides a peaceful, private setting. From the covered porch you will enjoy the peacefulness and privacy of a large outdoor jucuzzi hot tub and in-ground heated saltwater pool with waterfall. and view . This comfortable home has a large oversized primary master suite on the first floor with fireplace and separate seating area for those cozy quiet evenings, a large wrap around walk in closet big enough for any fashionista. The primary bath features large tiled walk-in shower, double sinks, jacuzzi tub and large closet for linens. There are 3 large bedrooms on the second floor as well as a second laundry room and two full baths ; one has an oversized jacuzzi tub, double sink, large closet for linens. The custom kitchen features top of the line stainless steel appliances with black granite countertops and double ovens. In the library there is a custom built in floor to ceiling bookcase with storage on bottom. Separate dining room. Lower level offers 6 windows providing lots of light for the spacious family, recreation room. Walk out French doors open to a covered grotto with lighting , fan and beautiful Pennsylvania Blue Stone. Also included on the lower level is a 2nd laundry room with separate folding room, walk-in pantry and spacious finished storage room. The house has a 3 car finished garage plus a separate 12x 18 shed designed to match home. Many upgrades include wood floors home internet system, central sound system, built in Nutone vacuum, Culligan water softener and home filtration system Handy commuter location for N. Va, DC commuter train, Frederick Md. Great family inter generational home, great home for entertaining, great home to enjoy. Exceptional property.
MlsNumber: --
ListingId: WVJF2015040


Listing Provided By: Snyder Bailey & Associates, original listing
Phone: (304) 267-1050
Office Phone: (304) 267-1050
Agent Name: Carolyn Snyder
Disclaimer: Copyright © 2024 Bright MLS. 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 = 2985 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 Sonja Bushue
Sonja Bushue
ASCIIHome Sweet Home Team brokered by Samson Properties
Call Today!: (304) 886-8732

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App