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

95 Harris Hollow Road
Washington, VA 22747

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $565,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1653
Agency: Washington Fine Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1978
Notes: This is a real diamond in the rough that needs a bit of paint while the other updates can take place a little along. It's a very solid brick rambler on 1.2 open acres. The floor plan is a traditional 3BR (primary suite has shower, no tub), 2.5 BA home with a fireplace in the family room, a huge country kitchen with loads of table space, a formal dinning room and an office or living room. Plus a pantry/laundry room, garage and one-room basement for storage just in case the large closets aren't quite large enough. There's also a sliding door to the extremely private screened porch that has amazing views of the Blue Ridge Mt's /Shenandoah National Park and if you look right, you can see Skyline Drive and one house off in the distance.<br /> It's a classic late 1970's/80's rambler with an authentic yellow bathroom that's just not bad enough that it has to be updated. But with Comcast or Starlink internet available and cell coverage it's connected and ready for the work from home owner.<br /> The views from the level 1.2 acres are beautiful-mountains, trees, cows and hay fields. The house feels private with the mature landscaping and the way it's cleverly sited on the property. The backyard is perfect for star gazing, comet watching and, hopefully, an aurora will return. <br /> The location is right outside the town of Washington limits, just a saunter away from shops and dining. (RH Ballards, Ours Noir, The Inn at Little Washington) With a short drive of under 10 min is Sperryville that offers breweries and more local shops. Hiking trails abound, being so close to Shenandoah National Park.<br /> This is a great house, looking for a buyer who has some vision.
MlsNumber: VARP2001220


Listing Provided By: Washington Fine Properties, original listing
Name: Washington Fine Properties
Phone: (540) 687-6395
Office Name: Washington Fine Properties, LLC
Office Phone: (540) 675-1488
Agent Name: Amy Timbers
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