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

260 Woody Lane Lane
Oxford, NC 27565
Scott Grissom with C-21 Hancock Properties, original listing - (919) 693-2257

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $765,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2302 Square Feet
Agency: C-21 Hancock Properties
Agency Phone: (919) 693-2257

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 31 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Extremely hard to find Home on 31.5 Acres. This very unique property is nestled off the road for ultimate privacy. Property is mostly wooded. Approximately 1.5 cleared acres for gardens or your hobby farm dreams. Survey on file. Property has already been surveyed into 3 ten acre tracts for future development. The rear of the property boarders Tabbs Creek. Covered front porch is great for rocking chairs and morning coffee. Open concept on the main level with Family rm, kitchen, dining and first bedroom. Cathedral ceiling in Family room gives you fantastic natural light. All appliances convey. Enjoy the beautiful backyard views from the rear deck. Great rollout canopy for additional shade. Lots of space for grilling and entertaining. Hot tub situated on the side porch for tranquil relaxation and privacy with views of the backyard. Loft bedroom with duel closets, on suite bathroom and lots for natural light. Walkout basement opens to a large covered patio with surrounding flower gardens. Full basement offers a flexible bedroom/office space, a second family room and a full bathroom. Laundry room is fully equipped with washer, Dryer and utility sink. 2 story Wired workshop is the building of your dreams. 2 shed roofs for keeping equipment out of the weather. Second floor would be great for storage, future man cave, art studio or kids club house. Possibilities are endless. 2 freestanding propane heaters already installed for additional heat source. If you are looking to escape the city of quite weekend or start a homestead, this is your opportunity!
MlsNumber: --
ListingId: 10038878


Listing Provided By: C-21 Hancock Properties, original listing
Phone: (919) 691-4234
Office Phone: (919) 693-2257
Agent Name: Scott Grissom
Disclaimer: Copyright © 2024 Triangle MLS, Inc. 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