Fly Ash Port Arthur

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 318678,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://hastenchemical.com/fly-ash",
      "title": "Fly Ash Port Arthur ",
      "description": "Hasten Chemical is a team of professionals who work to maximize the bottom line results of its clients. As a wholesaler of chemical products, Hasten provides unconditional commitment to excellence in quality that will provide consistent results, and make us the partner of choice to help produce and maintain growth of Products and Service Companies.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69872,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-03-09T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 114,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21883,
      "ltop": "",
      "facebook": "https://www.facebook.com/hastenenergy",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/hasten-energy-solutions/",
      "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": 263,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95769fa4-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 09, 2020",
      "subcategory": "Delivery Service",
      "request_types": "",
      "visitcount": 142
   },
   "visits": {
      "storefront": 142,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Hasten Chemical is a team of professionals who work to maximize the bottom line results of its clients. As a wholesaler of chemical products, Hasten provides unconditional commitment to excellence in quality that will provide consistent results, and make us the partner of choice to help produce and maintain growth of Products and Service Companies.",
      "service1": "hasten chemical",
      "service2": "Port Arthur Fly Ash",
      "service3": "Fly Ash Port Arthur",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-03-09 12:44:08"
   },
   "location": {
      "uuid": "95769fa4-56da-11ed-b77c-b66e99367f32",
      "link_id": 318678,
      "account_id": 69872,
      "company": "Fly Ash Port Arthur ",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77002",
      "address": "hastenchemical.com@gmail.com",
      "phone": "8326557763",
      "fax": null,
      "email": "hastenchemical.com@gmail.com",
      "name": "Fly Ash Port Arthur ",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.752554",
      "lon": "-95.3704009",
      "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": ""
}