Happy’s Tree Service, LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 322466,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.happystreeservice.com/",
      "title": "Happy’s Tree Service, LLC",
      "description": "We are a Tree Service located in Clearwater Fl. We offer all aspects of tree service from tree trimming to large tree removal by Certified Arborist. We do not sub out anything as we own all of our equipment. We are a family owned and operated company since 1989. We offer free estimates.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 73594,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2022-07-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 79,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 3371,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "958b0420-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 07, 2022",
      "subcategory": "Tree Services",
      "request_types": "",
      "visitcount": 126
   },
   "visits": {
      "storefront": 126,
      "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": "We are a Tree Service located in Clearwater Fl. We offer all aspects of tree service from tree trimming to large tree removal by Certified Arborist. We do not sub out anything as we own all of our equipment. We are a family owned and operated company since 1989. We offer free estimates.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2022-07-07 09:04:18"
   },
   "location": {
      "uuid": "958b0420-56da-11ed-b77c-b66e99367f32",
      "link_id": 322466,
      "account_id": 73594,
      "company": "Happy’s Tree Service, LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3371",
      "zip": "33755",
      "address": "1623 Windsor Dr",
      "phone": "727-365-1803",
      "fax": null,
      "email": "happystreeservice01@gmail.com",
      "name": "Happy’s Tree Service, LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "27.9949318",
      "lon": "-82.7708868",
      "cityname": "Clearwater",
      "statename": "Florida"
   },
   "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": ""
}