Mayer Tree Service

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344787,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://mayertree.com/",
      "title": "Mayer Tree Service",
      "description": "Mayer Tree Service provides professional tree service & plant health care in Essex, MA as well as the North Shore of Massachusetts & Southern New Hampshire.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95482,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-04-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 286,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 21,
      "city_id": 9958,
      "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": 2998,
      "subcat_id": 5884,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "2240e457-111f-11f0-a909-b66e99367f32",
      "subdate": "Apr 04, 2025",
      "subcategory": "Tree Services",
      "request_types": "",
      "visitcount": 689
   },
   "visits": {
      "storefront": 689,
      "articles": 246,
      "videos": 141,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 19,
      "services": 109,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Mayer Tree Service are passionate about the services that we provide and love to develop and maintain long lasting relationships with our valued customers.\r

Over the past several years, word of mouth has traveled on how great and reliable Mayer Tree Service treats their customers and co-workers. These referrals have expanded our customer base farther away from our main office located in Essex Massachusetts. To support the needs of our loyal customers and to continue the development our team members, we opened several office locations throughout Massachusetts and New Hampshire. This strategy has proven positive in our ability to respond and deliver timely services throughout the New England region. To know more, visit https://mayertree.com/ or call +1 978 997 8998\r
\r
Business Address: 9 Scotts Way, Essex, MA, 01929, United States\r
\r
Business Mail: service@mayertree.com\r
 \r
Website: https://mayertree.com/\r
\r
Hours of operation: Monday to Friday : 8 am - 5 pm\r
Emergency Service Available 24/7\r
\r
Payment Methods: Cash, Check, Credit Cards\r
\r
Service Areas: Essex, MA; Lynn, MA; Salem, MA; Wenham, MA; Andover, MA; Beverly, MA; Ipswich, MA; Peabody, MA; Haverhill, MA; Georgetown, MA; Gloucester, MA; Newburyport, MA; Essex County, MA; Manchester by the Sea, MA; Plaistow, NH; Lincoln, MA; Newbury, MA; Danvers, MA; Lawrence, MA; Hampstead, MA; Amesbury, MA; Salisbury, MA; Tewksbury, MA; Lowell, MA; Billerica, MA; Burlington, MA; Acton, MA; Waltham, MA; Woburn, MA; Lynn, MA; Concord, MA; Sudbury, MA; Marlborough, MA; Shrewsbury, MA; Westborough, MA; Framington, MA",
      "service1": "Tree Services",
      "service2": "Plant Healthcare",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-04-04 06:36:26"
   },
   "location": {
      "uuid": "2240e457-111f-11f0-a909-b66e99367f32",
      "link_id": 344787,
      "account_id": 95482,
      "company": "Mayer Tree Service",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 21,
      "city": "9958",
      "zip": "01929",
      "address": "9 Scotts Way",
      "phone": "978 997 8998",
      "fax": null,
      "email": "mayertreessex@gmail.com",
      "name": "Mayer Tree Service",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.6248014",
      "lon": "-70.8143644",
      "cityname": "Essex",
      "statename": "Massachusetts"
   },
   "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": 6
      },
      {
         "item": "video",
         "cnt": 3
      },
      {
         "item": "product",
         "cnt": 0
      },
      {
         "item": "coupon",
         "cnt": 0
      },
      {
         "item": "service",
         "cnt": 3
      },
      {
         "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": ""
}