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

268 S Airport Road
Farmville, VA 23901

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,900
Beds: 3
Baths: 1
Status: Pending
SqFt: 2000
Agency: Mossy Oak Properties of VA

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 187 acre(s)
Property Type: Residential
Year Built: 2021
Notes: The 187+ acre “Dry Creek Farm” in Cumberland Co., presents a fantastic opportunity for residential, recreational, or agricultural use, located 4 miles N of Farmville & about 1-hr from Richmond! 2 parcels, 34 & 153.08 for a total of 187.08 acres offers potential to sell the 34 acres for an ROI. Most of the 153.08-acre parcel is fenced/cross-fenced for livestock & has 2 water stations connected to the well. The property has approx. 3,740’ of frontage along S Airport Rd, offering plenty of options for future home sites/a possible subdivision. The front portion of the property has approx. 19+ acres of fenced cutover. The remainder of the property consists of 31+ acres of pasture providing plenty of space for food plots, livestock grazing, or income from farming activities. The remaining acreage is a mix of loblolly pine, popular, & pin oak, which provide food for wildlife, stand locations, firewood, or income from a future timber harvest. Amish built in ‘21 a 2-story, 3 BR, 1 bath "barndominium" could be a great hunting lodge, home, or weekend getaway. The 1st flr features a concrete flr, garage doors, & plenty of windows for natural light. It was previously used as a woodworking shop & would be an ideal space for your hunting gear, UTV, or items that should be kept dry/secure. The 2nd flr has a kitchen w/ an open floor plan, a wood stove hookup (propane line run), 3 BR, 1 full bath w/ tub/shower, & partial laundry hookups. The septic system is the only item connected to electricity. The air-powered well pump needs a air compressor to work. A 40-gal propane hot water heater provides plenty of hot water. A 100-amp electric service is run adjacent to the home & could be converted to provide power to the home. Note - the structure is not wired for electricity. Overall, this parcel offers a blend of rural tranquility, convenience, & recreational potential, making it an attractive investment for those seeking a retreat property, hunting land, or a place to build their dream home in the country!
MlsNumber: 2411469


Listing Provided By: Mossy Oak Properties of VA, original listing
Name: Mossy Oak Properties of VA
Phone: (757) 876-9182
Office Name: MOP Land and Farms Realty
Office Phone: (844) 480-5263
Agent Name: Jacob Oliver
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