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

1058 Pine Log Rd
Skippers, VA 23879

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $515,000
Beds: 3
Baths: 2
Status: Active
SqFt: --
Agency: Long & Foster Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Property Type: Residential
Year Built: 1978
Notes: Welcome to 1058 Pine Log Road, a breathtaking retreat nestled in the serene countryside of Skippers, VA. A truly unique entrance welcomes you to this spectacular custom-built home, featuring a charming, covered bridge that gracefully guides you over a tranquil approx 1-acre pond. As you cross over, the beauty of the exposed aggregate driveway, elegantly illuminated by lights lining the path, sets the stage for the home that awaits. Nestled on over 3 acres with a beautiful landscape and over 9 acres of woods around, this exceptional property offers a perfect blend of sophistication and natural beauty. Step inside to discover a meticulously crafted interior where every detail has been thoughtfully considered. The main level welcomes you with a spacious layout, highlighted by a gourmet kitchen boasting top-of-the-line appliances, granite countertops, and custom cabinetry. Adjacent, the inviting living area beckons for cozy evenings by the fireplace, while the heated tile floor in the downstairs bath adds a touch of opulence. Ascending to the second floor, the primary suite awaits, offering a haven of relaxation complete with a full bath and views of the surrounding countryside. Additional bedrooms on the first floor provide comfort and versatility for family or guests. Outside, the expansive grounds offer endless possibilities for outdoor enjoyment. Whether you're fishing in the pond, hosting gatherings on the patio, or simply basking in the tranquility of nature, this property is a true oasis. Conveniently located just a short drive from Lake Gaston, you'll have easy access to water recreation and leisure activities. Plus, with Emporia and Roanoke Rapids nearby, shopping, dining, and entertainment are always within reach. Don't miss this rare opportunity to own your dream home in a truly idyllic setting. Schedule your private tour today and experience the beauty and serenity of country living at its finest!
MlsNumber: 2409897


Listing Provided By: Long & Foster Real Estate, original listing
Name: Long & Foster Real Estate
Phone: (888) 536-0216
Office Name: Village of Midlothian
Office Phone: (888) 536-0216
Agent Name: Megan K Little-Moran
Disclaimer: Copyright © 2024 Long & Foster Real Estate. 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