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

18525 Frog Level Road
Ruther Glen, VA 22546

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $550,000
Beds: 3
Baths: 1
Status: Active
SqFt: 1232
Agency: Berkshire Hathaway HomeServices Select Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 36 acre(s)
Property Type: Residential
Year Built: 1999
Notes: Welcome to this Bungalow nestled on 36 Acres of Serenity!<br /> The current owners have raised horses, donkeys, goats, sheep, turkeys, chickens, quail, pheasants, rabbits and dogs. All pens and pastures are currently accommodating. Currently on the land, there are ten open acres, to the north side is a 56x56 closed barn with full utilities/bathrooms and a stage. Owners have used barn for a variety of things including parties, weddings, animals, etc. At the back of the land, is a large spring filled pond, on the west side of the land is a large pole shed with electricity and a storage trailer connected along with a numerous amount of sheds and closed fenced areas w/small pastures, run in sheds, 40x40 area with run in sheds for fowl, two large dog pens, two additional sheds for hay and a green house. Also located on the west side is a two bedroom trailer that is currently winterized and can be fully functioning in no time. Some bonuses to the west side of the land are the most breathtaking views of the sunset along with small producing orchard of apples, pears, plums grapes and walnut trees. On the south side of the land there are two driveway entrances and a 25 foot round pool. On the East side of the land is a 1.5 acre horse pasture with run in barn. <br /> The land offers ground pumps that come from the main springs so you will never run out of water. <br /> <br /> Don't miss out on this great opportunity to see this one. The possibilities are endless here.
MlsNumber: VACV2005924


Listing Provided By: Berkshire Hathaway HomeServices Select Realty, original listing
Name: Berkshire Hathaway HomeServices Select Realty
Phone: (540) 371-7653
Office Name: Berkshire Hathaway HomeServices PenFed Realty
Office Phone: (540) 371-7653
Agent Name: Stacy Priddy
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