{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 343468,
"site_id": 76,
"cat_id": 11,
"priority": 2,
"url": "https://www.ballwintreeservice.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 94163,
"approve_dt": null,
"source": null,
"submit_dt": "2025-03-07T00: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": 25,
"city_id": 12142,
"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": 5884,
"d_url": null,
"approved": null,
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "8b259359-fb53-11ef-a909-b66e99367f32",
"subdate": "Mar 07, 2025",
"subcategory": "Tree Services",
"request_types": "",
"visitcount": 25
},
"visits": {
"storefront": 25,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 9,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Ballwin Tree Service has been serving West Saint Louis County for 15 years, providing expert tree trimming and removal. Led by ISA Certified Arborist Matt Neal, our team is committed to preserving the health of your trees while protecting your property. We don't use spikes when trimming to prevent damage and disease, ensuring the best care for your trees. We take pride in our attention to details, moving outdoor furniture and cleaning up debris so your yard is left spotless. As members of the Tree Care Industry Association, we adhere to the highest industry standards.",
"service1": "Tree Trimming",
"service2": "Tree Removal",
"service3": "Stump Removal",
"service4": "Tree Stump Grinding",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2025-03-07 12:56:10"
},
"location": {
"uuid": "8b259359-fb53-11ef-a909-b66e99367f32",
"link_id": 343468,
"account_id": 94163,
"company": "Ballwin Tree Service",
"sid": 76,
"country": 277,
"countrycode": "US",
"state": 25,
"city": "12142",
"zip": "63005",
"address": "100 Chesterfield Business Parkway",
"phone": "(314) 799-1461",
"fax": null,
"email": "ballwintreeservice@brite-mail.com",
"name": "Ballwin Tree Service",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "38.6675074",
"lon": "-90.619",
"cityname": "Chesterfield",
"statename": "Missouri"
},
"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
