{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 348114,
"site_id": 76,
"cat_id": 11,
"priority": 2,
"url": "http://www.pinevalleyturf.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 98809,
"approve_dt": null,
"source": null,
"submit_dt": "2025-06-04T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 2,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 32,
"city_id": 15945,
"ltop": "",
"facebook": "",
"tiktok": null,
"linkedin": "",
"twitter": "",
"googleplus": "",
"youtube_channel": null,
"youtube": "",
"youtube_title": null,
"pinterest": "",
"yelp": "",
"foursquare": "",
"instagram": "",
"tripadvisor": null,
"trustpilot": null,
"blog_link": null,
"ss_exchange": 0,
"googlebot": null,
"yahoobot": null,
"msnbot": null,
"author_id": null,
"subcat_id": 5870,
"d_url": null,
"approved": null,
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "0db66800-40f2-11f0-a909-b66e99367f32",
"subdate": "Jun 04, 2025",
"subcategory": "Lawn Service",
"request_types": "",
"visitcount": 37
},
"visits": {
"storefront": 37,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 12,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Since 2005, Pine Valley Turf has been the trusted choice for professional lawn care and landscaping services in Charlotte, Concord, Huntersville, and surrounding North Carolina communities. We proudly serve homeowners, commercial properties, and HOAs with comprehensive solutions to keep your outdoor spaces healthy and beautiful. Our lawn care services include fertilization, weed control, core aeration, overseeding, mowing, and more to promote a lush, green lawn. We also offer full-service landscaping, including seasonal plantings, vibrant annual flowers, softscape design, mulch installation, and yard cleanups. Let us bring out the best in your property-year-round.",
"service1": "Lawn Care Programs",
"service2": "Mosquito Control",
"service3": "Tree and Shrub Care",
"service4": "Mulch and Rock Installations",
"service5": "Core Aeration",
"service6": "",
"service7": "",
"submit_dt": "2025-06-04 03:14:40"
},
"location": {
"uuid": "0db66800-40f2-11f0-a909-b66e99367f32",
"link_id": 348114,
"account_id": 98809,
"company": "Pine Valley Turf Management, LLC",
"sid": 76,
"country": 277,
"countrycode": "US",
"state": 32,
"city": "15945",
"zip": "28079",
"address": "8320 Indian Trail Fairview Rd",
"phone": "+1 (704) 412-4311",
"fax": null,
"email": "pinevalleyturf@mail-burst.com",
"name": "Pine Valley Turf Management, LLC",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "35.1065629",
"lon": "-80.5718681",
"cityname": "Indian Trail",
"statename": "North Carolina"
},
"socialmedia": [
{
"title": "Facebook",
"ptype_id": 29,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "Instagram",
"ptype_id": 30,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "Youtube",
"ptype_id": 31,
"dbtable": "links_socialmedia",
"item": "Youtube Video",
"cnt": null
},
{
"title": "LinkedIn",
"ptype_id": 32,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "TikTok",
"ptype_id": 33,
"dbtable": "links_socialmedia",
"item": "Videos",
"cnt": null
},
{
"title": "Twitter",
"ptype_id": 34,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "Reddit",
"ptype_id": 37,
"dbtable": "links_socialmedia",
"item": "Reddit",
"cnt": null
},
{
"title": "SnapChat",
"ptype_id": 38,
"dbtable": "links_socialmedia",
"item": "SnapChat",
"cnt": null
}
],
"promos": [
{
"item": "article",
"cnt": 0
},
{
"item": "video",
"cnt": 0
},
{
"item": "product",
"cnt": 0
},
{
"item": "coupon",
"cnt": 0
},
{
"item": "service",
"cnt": 0
},
{
"item": "article_external",
"cnt": 0
},
{
"item": "video_external",
"cnt": 0
},
{
"item": "product_external",
"cnt": 0
},
{
"item": "coupon_external",
"cnt": 0
},
{
"item": "service_external",
"cnt": 0
}
],
"featuredproduct": ""
}
all our featured social media
