Tree Service Denver LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349566,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://treeservicedenverllc.com/",
      "title": "Tree Service Denver LLC",
      "description": "Welcome to Tree Service Denver, your trusted tree care experts serving the Denver, CO area. With years of experience, a passion for trees, and a commitment to excellence, we offer a full range of professional tree services designed to enhance the health and beauty of your property. Whether you need routine maintenance, emergency tree removal, or stump grinding, we’ve got you covered.\n\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100261,
      "approve_dt": "2025-07-24T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-07-24T00: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": 6,
      "city_id": 2782,
      "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": 6647,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9f78de3c-6881-11f0-a909-b66e99367f32",
      "subdate": "Jul 24, 2025",
      "subcategory": "Cleaning Supplies",
      "request_types": "",
      "visitcount": 51
   },
   "visits": {
      "storefront": 51,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 24,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Tree Service Denver LLC is a certified and insured tree care company serving the Denver, CO metro area with years of experience and a passion for excellence. Their team of certified arborists and skilled professionals provides comprehensive tree services focused on safety, quality, and customer satisfaction, offering both residential and commercial solutions with a commitment to environmental responsibility.",
      "service1": "Tree Planting Denver",
      "service2": "Land & Lot Clearing Denver",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-07-24 11:30:38"
   },
   "location": {
      "uuid": "9f78de3c-6881-11f0-a909-b66e99367f32",
      "link_id": 349566,
      "account_id": 100261,
      "company": "Tree Service Denver LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 6,
      "city": "2782",
      "zip": "80219",
      "address": "56 Hazel Ct",
      "phone": "720-807-2785",
      "fax": null,
      "email": "treeservicllc@gmail.com",
      "name": "Tree Service Denver LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Denver",
      "statename": "Colorado"
   },
   "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": ""
}