Website: http://treeremovalhouston247.com/

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 334033,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://tree-removalhouston.com/",
      "title": "Website: http://treeremovalhouston247.com/",
      "description": "At Tree Removal Houston 247, we''re more than just arborists - we''re guardians of your landscape''s health and safety. Our seasoned professionals boast over 25 years of collective experience, equipped to handle any tree-related challenge Houston throws our way. We pride ourselves on our rapid response, often reaching clients within 30 minutes of their call. Our services extend beyond mere tree removal, we offer a full spectrum of arboricultural care, including emergency services, stump grinding, precision trimming, and nutrient-rich fertilization. We''re deeply rooted in the Houston community, serving both homeowners and businesses with equal dedication. Our commitment to transparency is evident in our clear, upfront pricing and satisfaction guarantee.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 84790,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-08-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 12,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21883,
      "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": 5182,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "cdcc1f9b-5728-11ef-ab46-b66e99367f32",
      "subdate": "Aug 10, 2024",
      "subcategory": "Landscaping Trees",
      "request_types": "",
      "visitcount": 26
   },
   "visits": {
      "storefront": 26,
      "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": "Tree removal, tree removal service, emergency tree service, tree removal Houston, emergency tree cutting,  tree trimming Houston\r
",
      "service1": "Emergency Tree Service  ",
      "service2": "Residential Tree Services",
      "service3": "Commercial Tree Services",
      "service4": " Tree Stump Removal",
      "service5": " Tree Trimming",
      "service6": " Tree Fertilization Service",
      "service7": "",
      "submit_dt": "2024-08-10 14:57:04"
   },
   "location": {
      "uuid": "cdcc1f9b-5728-11ef-ab46-b66e99367f32",
      "link_id": 334033,
      "account_id": 84790,
      "company": "Tree Removal Houston 247",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77007",
      "address": "2109 Crockett St",
      "phone": "4094196673",
      "fax": null,
      "email": "tree-removalhouston@outlook.com",
      "name": "Tree Removal Houston 247",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "29.7734391",
      "lon": "-95.3797608",
      "cityname": "Houston",
      "statename": "Texas"
   },
   "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": ""
}