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

10130 Us Highway 340
Shenandoah, VA 22849

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,000
Beds: 4
Baths: 2
Status: Active
SqFt: 3244
Agency: Skyline Team Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Property Type: Residential
Year Built: 1913
Notes: LOOKING FOR COUNTRY LIFE? Well, this GORGEOUS property has it all!! As you're welcomed into the house, you will notice the large eat-in kitchen with custom oak cabinets that provide lots of storage. Right of the kitchen you have an expansive dining room to entertain your family and guests. Interior glass French doors guide you into the formal living room that welcomes you with the large wood burning fireplace. There are chestnut wood floors throughout most of the house, that give you the charm and character this historical home was built with. Before you head upstairs there is another family room and full bath. Upstairs you will find 3 bedrooms, a large bathroom, and a bonus room that could be used as a grand sunroom, living area or even create your own primary suite. The bonus areas of this home are waiting for you to pour your love and creativity in. The most eye-catching room of the house is the bright sunroom, this is the focal point of the home! This expansive sunroom has tile floors, floor to ceiling windows and French doors to extend the square footage out to the patio! All of this with 11+/- acres with SPECTACULAR views of the Blue Ridge Mountain, and endless blue skies. Several barns and buildings are on the property, being used for cattle, but other farm animals are WELCOME! This parcel has 2 tax map id’s, one parcel that contains the barns and fields include 7.8 +/- acres and the 2nd parcel with the farmhouse contains 3.5 +/-acres. Both parcels are listed together but can be sold separately. Conveniently located off US 340 South, just a short trip away from all the amenities the Shenandoah Valley has to offer, such as: The Shenandoah River, Massanutten Ski Lodge, Luray Caverns, and the Skyline Drive. COME see for yourself what this property has to offer!!
MlsNumber: VAPA2002006


Listing Provided By: Skyline Team Real Estate, original listing
Name: Skyline Team Real Estate
Phone: (540) 459-5555
Office Name: Skyline Team Real Estate
Office Phone: (540) 459-5555
Agent Name: April Judd
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App