BlueHat LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 343517,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://bluehat.co/",
      "title": "BlueHat LLC",
      "description": "Based in Cincinnati, BlueHat is dedicated to delivering effective, straightforward technology solutions tailored to local businesses. Our roots are deeply embedded in the community, ensuring that our services are not only innovative but also practical and user-friendly. With a focus on trust and dependability, we strive to make technology accessible and beneficial, helping businesses overcome challenges and achieve their goals.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 94212,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 34,
      "city_id": 17251,
      "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": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "ffb839c9-fd75-11ef-a909-b66e99367f32",
      "subdate": "Mar 10, 2025",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-03-10 06:07:51"
   },
   "location": {
      "uuid": "ffb839c9-fd75-11ef-a909-b66e99367f32",
      "link_id": 343517,
      "account_id": 94212,
      "company": "BlueHat LLC",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "17251",
      "zip": "45040",
      "address": "6410 Thornberry Ct Suite E, Mason, OH 45040 USA",
      "phone": "513-234-4440",
      "fax": null,
      "email": "bluehatoh@gmail.com",
      "name": "BlueHat LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "39.3525462",
      "lon": "-84.3368419",
      "cityname": "Mason",
      "statename": "Ohio"
   },
   "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": ""
}