Houston Refrigerated Logistics, Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317900,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.hrlcorp.com",
      "title": "Houston Refrigerated Logistics, Inc.",
      "description": "Houston Refrigerated Logistics, Inc. is a vertically integrated 3PL that specializes in storing refrigerated products and offering services that, in most cases, are unique to this industry.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69094,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-10-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 140,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21883,
      "ltop": "",
      "facebook": "https://www.facebook.com/houstonrefrigeratedlogistics/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/h_r_logistics/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 248,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957242a0-56da-11ed-b77c-b66e99367f32",
      "subdate": "Oct 24, 2019",
      "subcategory": "Shipping & Trucking",
      "request_types": "",
      "visitcount": 210
   },
   "visits": {
      "storefront": 210,
      "articles": 0,
      "videos": 0,
      "reviews": 19,
      "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": "Founded in 2013 by Dennis Carroll and Jeff Martinez, Houston Refrigerated Logistics, Inc. (HRL) has continually added to its service offerings to provide the most complete refrigerated storage solutions in the Houston area.",
      "service1": "Warehousing and Cross Dock Services",
      "service2": "Citrus Bagging",
      "service3": "Repack/Regrading",
      "service4": "Freight Management",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-10-24 10:06:37"
   },
   "location": {
      "uuid": "957242a0-56da-11ed-b77c-b66e99367f32",
      "link_id": 317900,
      "account_id": 69094,
      "company": "Houston Refrigerated Logistics, Inc.",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77012",
      "address": "8050 Harrisburg Blvd",
      "phone": "713-928-9940",
      "fax": null,
      "email": "hrlcorphouston@gmail.com",
      "name": "Houston Refrigerated Logistics, Inc.",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.7286294",
      "lon": "-95.2809336",
      "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": ""
}