The Harrin Group

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 313502,
      "site_id": 7,
      "cat_id": 70,
      "priority": 2,
      "url": "https://www.harringroup.com/",
      "title": "The Harrin Group",
      "description": "The Harrin Group, led by insurance agents in San Antonio, TX providing custom insurance solutions for international health, Medicare supplemental, retirement, and business continuation from top carriers such as Aetna, American General, Athene Annuity, Gerber Life, and Global Atlantic Financial Group.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 64728,
      "approve_dt": "2018-03-22T00:00:00.000Z",
      "source": null,
      "submit_dt": "2017-08-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 679,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22482,
      "ltop": "",
      "facebook": "https://www.facebook.com/TheHarrinGroup/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/the-harrin-group-llc.",
      "twitter": "https://twitter.com/harringroup",
      "googleplus": "https://plus.google.com/116315433750100899438",
      "youtube_channel": "https://www.youtube.com/channel/UCdLUxrLwz8bkGzJSmo9z1aQ",
      "youtube": "https://www.youtube.com/channel/UCdLUxrLwz8bkGzJSmo9z1aQ",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "https://www.harringroup.com/blog/",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 31,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "94f767d2-56da-11ed-b77c-b66e99367f32",
      "subdate": "Aug 04, 2017",
      "subcategory": "Life Insurance",
      "request_types": "",
      "visitcount": 881
   },
   "visits": {
      "storefront": 881,
      "articles": 0,
      "videos": 0,
      "reviews": 11,
      "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": "The Harrin Group, led by insurance agents in San Antonio, TX providing custom insurance solutions for international health, Medicare supplemental, retirement, and business continuation from top carriers such as Aetna, American General, Athene Annuity, Gerber Life, and Global Atlantic Financial Group.",
      "service1": "Independent Insurance Agents San Antonio TX",
      "service2": "International Health Insurance Plans",
      "service3": "Medicare Supplemental",
      "service4": "Retirement Solutions",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2017-08-04 09:56:57"
   },
   "location": {
      "uuid": "94f767d2-56da-11ed-b77c-b66e99367f32",
      "link_id": 313502,
      "account_id": 64728,
      "company": "The Harrin Group",
      "sid": 7,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22482",
      "zip": "78258",
      "address": "906 Lightstone Dr.",
      "phone": "",
      "fax": null,
      "email": "marvinbon5@gmail.com",
      "name": "The Harrin Group",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.6429037",
      "lon": "-98.4981958",
      "cityname": "San Antonio",
      "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": ""
}

all our featured social media