Majestic Tree Care Ltd

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 319924,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://majestictreecareltd.co.uk",
      "title": "Majestic Tree Care Ltd",
      "description": "This trusted tree care company is a family-run business serving Hertfordshire, North London, Middlesex, and Buckinghamshire with highly qualified tree surgeons delivering professional, skilled tree services. With years of experience and a commitment to 100% customer satisfaction, they've built their reputation on repeat business and recommendations, focusing on exceptional customer service and value for money throughout areas including Hemel Hempstead, Watford, Harrow, Chesham, and surrounding regions.                                                                                                                                                                                                                                                                            ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 71118,
      "approve_dt": "2026-01-09T00:00:00.000Z",
      "source": null,
      "submit_dt": "2020-10-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 114,
      "referrals": null,
      "country": 265,
      "countrycode": "UK",
      "loc_id": 265,
      "state_id": 0,
      "city_id": 476,
      "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": 5732,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957ca94a-56da-11ed-b77c-b66e99367f32",
      "subdate": "Oct 04, 2020",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 137
   },
   "visits": {
      "storefront": 137,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "With over ten years of experience, Majestic Tree Care offers expert tree and landscaping services to both residential and commercial clients. We’re committed to delivering top-quality work on projects of any size, ensuring every job is completed to the highest standard.\n
\n
\nOur clients range from homeowners and local councils to housing associations, estate managers, landscapers, property developers, and commercial organisations. We hold full Public Liability Insurance to £5million, giving you complete peace of mind.",
      "service1": "tree removal and felling",
      "service2": " tree pruning and trimming",
      "service3": " stump grinding and removal",
      "service4": " hedge trimming and maintenance",
      "service5": " emergency tree services",
      "service6": " tree health assessments and surveys",
      "service7": " tree planting and care",
      "submit_dt": "2020-10-04 03:22:41"
   },
   "location": {
      "uuid": "957ca94a-56da-11ed-b77c-b66e99367f32",
      "link_id": 319924,
      "account_id": 71118,
      "company": "Majestic Tree Care Ltd",
      "sid": 6,
      "country": 265,
      "countrycode": "UK",
      "state": 0,
      "city": "476",
      "zip": "HP3 9JJ",
      "address": "19 Alldicks Rd",
      "phone": "01442 817732",
      "fax": null,
      "email": "majestictreecareltduk@outlook.com",
      "name": "Majestic Tree Care Ltd",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "London",
      "statename": ""
   },
   "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": ""
}