Cronin, Fried, Sekiya, Kekina & Fairbanks

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347102,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://www.croninfried.com/?utm_source=GMB&utm_medium=organic&utm_campaign=Honolulu",
      "title": "Cronin, Fried, Sekiya, Kekina & Fairbanks",
      "description": "Cronin, Fried, Sekiya, Kekina %38 Fairbanks has been a staple of the Honolulu legal community since 1973, with attorneys committed to excellence who have achieved some of the largest settlements in Hawaii. Our experienced team understands the intricacies of medical malpractice and personal injury cases, putting our wealth of knowledge, longevity, and reputation to work for clients who have suffered serious injuries due to another's negligence.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97797,
      "approve_dt": "2025-07-28T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-19T00: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": 11,
      "city_id": 4763,
      "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": 2204,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "a07fcf07-3447-11f0-a909-b66e99367f32",
      "subdate": "May 19, 2025",
      "subcategory": "Law",
      "request_types": "",
      "visitcount": 57
   },
   "visits": {
      "storefront": 57,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 34,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Our attorneys at Cronin, Fried, Sekiya, Kekina and Fairbanks understand the value of a job well-done and have achieved some of the largest settlements in Hawaii. As a staple of the Honolulu legal community since 1973, we know the intricacies of medical malpractice and personal injury cases and what it takes to win.",
      "service1": "Medical Malpractice lawyer",
      "service2": "Personal Injury",
      "service3": "Motor vehicle accidents",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-05-19 00:24:29"
   },
   "location": {
      "uuid": "a07fcf07-3447-11f0-a909-b66e99367f32",
      "link_id": 347102,
      "account_id": 97797,
      "company": "Cronin, Fried, Sekiya, Kekina & Fairbanks",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 11,
      "city": "4763",
      "zip": "96813",
      "address": "841 Bishop Street, #501",
      "phone": "(808) 524-1433",
      "fax": null,
      "email": "croninfried@brite-post.com",
      "name": "Cronin, Fried, Sekiya, Kekina & Fairbanks",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "21.3074016",
      "lon": "-157.8612926",
      "cityname": "Honolulu",
      "statename": "Hawaii"
   },
   "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": ""
}