Estate Tree Services

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346458,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.estatetreeservices.com/",
      "title": "Estate Tree Services",
      "description": "Estate Tree Services provides expert tree care solutions for residential and commercial properties throughout Southern California. Our certified arborists specialize in tree trimming, removal, pruning, stump grinding, and emergency tree services. With a commitment to safety, professionalism, and customer satisfaction, we enhance the health and appearance of your landscape while protecting your property. Whether you need routine maintenance or storm damage cleanup, Estate Tree Services delivers reliable, high-quality work tailored to your needs. Trust our experienced team to keep your trees safe, strong, and beautiful year-round.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97153,
      "approve_dt": "2025-08-07T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-06T00: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": 5,
      "city_id": 2079,
      "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": "69b99a05-2a53-11f0-a909-b66e99367f32",
      "subdate": "May 06, 2025",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 6
   },
   "visits": {
      "storefront": 6,
      "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": "Estate Tree Services, formerly Timberwolfe, is a premier arborist company with over 25 years of experience serving the Lake Tahoe and Truckee areas. Owned and operated by Estate Landscape & Irrigation Inc., our fully licensed and insured team of dedicated arborists brings expertise in the region's unique mountain vegetation, treating every property with the same care and attention as if it were our own while maintaining the highest standards of safety and customer service.",
      "service1": "Tree Removal & Pruning",
      "service2": " Arborist Consultation & Assessment",
      "service3": " Mountain Vegetation Management",
      "service4": " Tree Health & Disease Treatment",
      "service5": " Emergency Tree Services",
      "service6": " Property Safety Evaluations",
      "service7": " Landscape Tree Planning & Installation",
      "submit_dt": "2025-05-06 08:23:39"
   },
   "location": {
      "uuid": "69b99a05-2a53-11f0-a909-b66e99367f32",
      "link_id": 346458,
      "account_id": 97153,
      "company": "Estate Tree Services",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2079",
      "zip": "96143",
      "address": "8491 Brook Ave, Kings Beach, CA 96143 USA",
      "phone": "530-386-3340",
      "fax": null,
      "email": "estatetreeservices1@gmail.com",
      "name": "Estate Tree Services",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "39.237266",
      "lon": "-120.0234344",
      "cityname": "Kings Beach",
      "statename": "California"
   },
   "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": ""
}