Panorama Tree Care

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 327262,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://www.panoramatreeservice.com/",
      "title": "Panorama Tree Care",
      "description": "Panorama Tree Care, a top tree service provider in Tampa, has been serving Hillsborough County for over 22 years. Our team, composed of skilled and certified arborists, offers a wide range of tree care services. Whether you need tree removal, trimming, stump removal, or tree planting, we''re equipped to handle your needs with precision and care. We''re dedicated to ensuring customer satisfaction and aim to surpass your expectations in every service we provide. Our focus on detail and our ability to tailor our services to your unique needs set us apart. Get in touch with us for a complimentary estimate and let us address all your tree care requirements.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 78117,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-01-01T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 27,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 4011,
      "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": 5178,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "28deca30-a8a9-11ee-8344-b66e99367f32",
      "subdate": "Jan 01, 2024",
      "subcategory": "Landscaping",
      "request_types": "",
      "visitcount": 59
   },
   "visits": {
      "storefront": 59,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-01-01 13:24:58"
   },
   "location": {
      "uuid": "28deca30-a8a9-11ee-8344-b66e99367f32",
      "link_id": 327262,
      "account_id": 78117,
      "company": "Panorama Tree Care",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "4011",
      "zip": "33611",
      "address": "4006 S West Shore Blvd",
      "phone": "813-234-9842",
      "fax": null,
      "email": "panoramatreeservice09@outlook.com",
      "name": "Panorama Tree Care",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "27.9060956",
      "lon": "-82.5264896",
      "cityname": "Tampa",
      "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": ""
}