Title Page Background
DEBUG FN args: Array ( [0] => 1901 [1] => [2] => [3] => agent ) BEFORE: Site: 1901 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1901 Igate: njhud LocID: 1901 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1901 AND i.igate IN ('cihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1901 [1] => [2] => [3] => lender ) BEFORE: Site: 1901 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1901 Igate: njhud LocID: 1901 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1901 AND i.igate IN ('cihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1901 [1] => [2] => [3] => other ) BEFORE: Site: 1901 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1901 Igate: njhud LocID: 1901 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1901 AND i.igate IN ('cihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

480 Alvis Boswell Road
Yanceyville, NC 27379
Keith Brouillard with Carolina Forestry, original listing - (919) 510-4663

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $989,900
Beds: 1
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1292 Square Feet
Agency: Carolina Forestry
Agency Phone: (919) 510-4663

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 135 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Stunning house and land in southern Caswell County, NC. This well-manicured 135 acres includes a newly built (2012) 1,292 sq ft house overlooking a pond and a 1,200 sq ft barn to hold all your tractors, ATVs and other land managing equipment. The property has been transformed by the current owner into a unique and wonderful recreational property with miles of trails, food plots, fencing, road improvements and preservation of the old existing buildings. The land is already set up for hunting, ATV riding and anything outdoorsy.<br /> The house is a 1 bedroom, 1.5 bath home built on a slab with an oversized garage that will fit multiple cars or ATVs. The house and barn are both Morton Buildings, which are high quality, post-frame construction, including 2x6 walls and steel roof and siding, also known as a ''Barndominium''. The interior of the house has all the amenities including granite countertops, dishwasher, central heat/air, washer/dryer, casement windows, gas stove and a large family room. All appliances and furniture stay with the house, except a few select pieces. The garage has plenty of space for 2 vehicles and extra room for all your workshop needs. The air compressor and garage gas heater stay. The 10'x60' covered porch overlooks the peaceful pond and manicured yard. The outdoor furniture, boat, picnic table and firepit stays for the new owner's enjoyment.<br /> The land consists of two tax parcels totaling 135 acres and includes about 8 acres in cleared land/food plots, 64 acres of 18 yr old planted loblolly pines and the remaining acreage in various hardwood stands and creek bottoms. Multiple creeks traverse the land and provide excellent wildlife corridors. The owner has created so many trails throughout the property; you could get to any part of the land within minutes on an ATV. There is an old log cabin and cemetery located on the property. Deer feeders and storage container goes with the property. The ATVs, tractors and other farm equipment can be purchased separately. <br /> Located south of Yanceyville, NC and about 20 minutes to Burlington, NC, and less than an hour to Durham or Chapel Hill. Bring your family and enjoy this beautiful, well-maintained home and land getaway. Listing agent must be present for all showings.
MlsNumber: --
ListingId: 10097576


Listing Provided By: Carolina Forestry, original listing
Phone: (919) 906-2807
Office Phone: (919) 510-4663
Agent Name: Keith Brouillard
Disclaimer: Copyright © 2025 Doorify MLS of North Carolina. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => caswell [3] => NC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: caswell State: NC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: caswell State: NC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1901 AND i.igate IN ('cihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for KRYSTAL BRICKLES
KRYSTAL BRICKLES
ASCIIMantle Realty
Call Today!: (919) 666-8107

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App