Specialty Family Tree LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 333135,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://specialtyfamilytree.com/",
      "title": "Specialty Family Tree LLC",
      "description": "Specialty Family Tree is a family owned and operated tree care company based out of Springfield, Missouri. Our primary goal is to provide safe plant health care options, including tree trimming, tree removal, and stump removal. We also specialize in large hazardous tree removals and 24hr emergency storm work. We have over 25 years experience in the industry, we''re BBB accredited and offer free estimates. We truly care about our customers and treat each property as if it were our own!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 83912,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-07-18T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 25,
      "city_id": 12804,
      "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": 5884,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "ecbf10f1-44cb-11ef-8344-b66e99367f32",
      "subdate": "Jul 18, 2024",
      "subcategory": "Tree Services",
      "request_types": "",
      "visitcount": 18
   },
   "visits": {
      "storefront": 18,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Specialty Family Tree is a family owned and operated tree care company based out of Springfield, Missouri. Our primary goal is to provide safe plant health care options, including tree trimming, tree removal, and stump removal. We also specialize in large hazardous tree removals and 24hr emergency storm work. We have over 25 years experience in the industry, we're BBB accredited and offer free estimates. We truly care about our customers and treat each property as if it were our own!",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-07-18 06:06:53"
   },
   "location": {
      "uuid": "ecbf10f1-44cb-11ef-8344-b66e99367f32",
      "link_id": 333135,
      "account_id": 83912,
      "company": "Specialty Family Tree LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 25,
      "city": "12804",
      "zip": "65804",
      "address": "2936 South Brentmoor Avenue",
      "phone": "417-771-0553",
      "fax": null,
      "email": "spcltyfamilytree@mail-burst.com",
      "name": "Specialty Family Tree LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.1599022",
      "lon": "-93.2539717",
      "cityname": "Springfield",
      "statename": "Missouri"
   },
   "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": ""
}