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

600 Sandhurst Drive
Prince George, VA 23805

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $389,000
Beds: 5
Baths: 3
Status: Pending
SqFt: 2771
Agency: RVA Realty Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 1980
Notes: Welcome to your dream country retreat! Nestled on just over 5 acres of serene, rural landscape, this stunning 2-story brick house offers tranquility and space, yet is conveniently located less than 15 minutes from town. With 5 bedrooms and 2771 square feet of living space, this home is perfect for families seeking comfort and privacy.<br /> <br /> Key Features:<br /> <br /> Size & Layout:Spacious 2-story brick house spanning 2771 square feet.<br /> Five bedrooms offering ample space for family and guests.<br /> Unique layout with an additional bedroom off the primary bedroom, perfect for use as an office or extra bedroom.<br /> Cedar closet in the offset room provides added storage and charm.<br /> <br /> Modern Amenities:New roof installed just three years ago, ensuring durability and peace of mind.<br /> Two newer HVAC systems, replaced in 2017 and 2020, providing efficient climate control throughout the home.<br /> Emergency propane-fed Generac Generator with weekly self-test, offering security and reliability during power outages.<br /> Solar light in the primary bathroom for eco-friendly illumination.<br /> Spacious 43 square foot walk-in closet in the primary bedroom for all your storage needs.<br /> <br /> Outdoor Living: Relax and unwind on the back screened-in rear porch, spanning over 205 square feet, ideal for enjoying the tranquil surroundings.<br /> Fresh gravel recently laid on the driveway, ensuring easy access to the property year-round.<br /> <br /> Location & Setting: Situated on a quiet and secluded 5-acre lot, providing privacy and serenity.<br /> Rural location offers a peaceful escape from the hustle and bustle of city life.<br /> Just a short drive, less than 15 minutes, to town for convenient access to amenities and services.<br /> <br /> Don't miss out on this incredible opportunity to own your own piece of paradise! Schedule a viewing today and experience the charm and comfort this country home has to offer.
MlsNumber: 2408807


Listing Provided By: RVA Realty Inc., original listing
Name: RVA Realty Inc.
Phone: (804) 803-1635
Office Name: RVA Realty, Inc
Office Phone: (804) 803-1635
Agent Name: Chris Hargrave
Disclaimer: Copyright © 2024 Central Virginia Regional Multiple Listing Service. 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