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

9774 Five Forks Road
Farmville, VA 23901
Alex James with Shaheen Ruth Martin & Fonville, original listing - (804) 288-2100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $845,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2687 Square Feet
Agency: Shaheen Ruth Martin & Fonville
Agency Phone: (804) 288-2100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 66 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Nestled in the heart of Farmville, Virginia, just 4 minutes away from Hampden Sydney College, this picturesque property at 9774 Five Forks Road offers the perfect blend of countryside tranquility and modern convenience. Spanning 66.1 acres, the land is ideal for recreational activities, equestrian, or simply enjoying nature’s beauty. This two level ranch built in 2002, was recently renovated and well-maintained by its previous owners. HVAC system is new as of 2021, hot water system is new as of 2022, and roof is new as of 2023. Inside the layout is very open, with the primary bedroom and two additional bedrooms on the east side of the home, and the living room, family room, and kitchen on the west side. The primary bedroom is bright and airy with stunning natural light. The primary bathroom features a sunken bathtub and double sink vanity. The kitchen is newly renovated and updated with new and stainless steel appliances.<br /> <br /> The basement includes a washer/dryer hookup, a full bathroom, large recreational room that is currently being used as a bedroom, and unfinished space that is perfect for storage. The basement walks out to a side outdoor patio. The outbuildings include a Barnmaster barn with stalls for horses, a feed room, and half bathroom, as well as a Quonset hut, indoor arena space, and workshop/garage. The outdoor arena space is competition size, and brightens nighttime riding with stadium lights. <br /> <br /> This home is situated just a short drive from Hampden-Sydney College, Longwood University, and the historic town of Farmville, offering local shops, dining, and schools while still maintaining a private, peaceful setting. Enjoy beautiful views and ample space for recreation with plenty of room for gardening, a horse stable, or creating your dream outdoor retreat. Don’t miss out on this rare opportunity – schedule a showing today and envision the possibilities this beautiful property holds!
MlsNumber: --
ListingId: 2429553


Listing Provided By: Shaheen Ruth Martin & Fonville, original listing
Phone: (804) 288-2100
Office Phone: (804) 288-2100
Agent Name: Alex James
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