JCS Tree Care Professionals

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 342202,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://jcstree.com/",
      "title": "JCS Tree Care Professionals",
      "description": "JCS Tree Care Professionals is a trusted name in tree service, offering expert care for the beautiful trees of Southfield, Michigan. Our skilled team specializes in keeping your trees healthy and your property safe with services such as tree trimming and tree removal. When you need ''tree removal Royal Oak MI'', we are the professionals you can count on to do the job efficiently and safely. We understand that every tree is unique, which is why we provide customized solutions to meet your specific needs. Our commitment to excellence ensures that your landscape will thrive under our dedicated care. At JCS Tree Care Professionals, we take pride in delivering top-notch service that respects both the environment and our clients'' properties. Whether it''s maintaining the natural beauty of your trees or removing them when necessary, trust us to bring expertise and quality to every task.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 92896,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-02-10T00: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": 0,
      "city_id": 0,
      "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": 5731,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "48afd16f-e7e0-11ef-a909-b66e99367f32",
      "subdate": "Feb 10, 2025",
      "subcategory": "Web Design",
      "request_types": "",
      "visitcount": 6
   },
   "visits": {
      "storefront": 6,
      "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": "2025-02-10 18:53:15"
   },
   "location": {
      "uuid": "48afd16f-e7e0-11ef-a909-b66e99367f32",
      "link_id": 342202,
      "account_id": 92896,
      "company": "",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "",
      "zip": "",
      "address": "Southfield MI 48034 ",
      "phone": "",
      "fax": null,
      "email": "jcstreecareprofessionals@outlook.com",
      "name": "JCS Tree Care Professionals",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.4966195",
      "lon": "-83.2880591"
   },
   "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": ""
}