Mercer Tree Service

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345536,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.mercertreeservice.net/",
      "title": "Mercer Tree Service",
      "description": "Mercer Tree Service is a leading provider of tree services throughout North Richland Hills and the surrounding region. Our specialists are able to provide full care for trees including inspections and trimming to ensure optimal health and address any structural issues.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96231,
      "approve_dt": "2025-10-03T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22250,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c6eab18c-1ba6-11f0-a909-b66e99367f32",
      "subdate": "Apr 17, 2025",
      "subcategory": "Tree Services",
      "request_types": "",
      "visitcount": 11
   },
   "visits": {
      "storefront": 11,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Mercer Tree Service is a trusted, professional tree care company serving North Richland Hills, Keller, Grapevine, Bedford, Southlake, and surrounding Tarrant County areas. They deliver quality tree services at affordable rates with a focus on safety, professionalism, and leaving properties clean after every job.",
      "service1": "Tree trimming",
      "service2": " Tree removal",
      "service3": " Stump grinding",
      "service4": " Dead branch removal",
      "service5": " Yard cleanup",
      "service6": " Residential tree care",
      "service7": " Emergency tree services",
      "submit_dt": "2025-04-17 16:12:36"
   },
   "location": {
      "uuid": "c6eab18c-1ba6-11f0-a909-b66e99367f32",
      "link_id": 345536,
      "account_id": 96231,
      "company": "Mercer Tree Service",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22250",
      "zip": "76180",
      "address": "6266 Shirley Dr",
      "phone": "(817) 247-5651",
      "fax": null,
      "email": "mercer.tree.tx@gmail.com",
      "name": "Mercer Tree Service",
      "status": "",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "North Richland Hills",
      "statename": "Texas"
   },
   "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": ""
}