https://esquirelaw.com/

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 338615,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://esquirelaw.com/",
      "title": "https://esquirelaw.com/",
      "description": "Esquire Law is a dedicated personal injury law firm serving Arizona and Utah, with a strong focus on car accident cases. Our mission is to stand up for individualsnever big businesseswho are facing challenges after serious injuries, and we relentlessly pursue maximum compensation for each client. With a team of highly skilled lawyers, we bring together deep legal expertise and cutting-edge technology to deliver a streamlined, client-centered experience.Esquire Law''s approach combines compassion with strategic prowess, ensuring that every case is handled with meticulous care. If youre seeking a modern, responsive, and results-driven law firm, Esquire Law is here to fight for you every step of the way.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 89328,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-12-02T00: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": 3,
      "city_id": 990,
      "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": 2239,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "1706bdbe-b0f8-11ef-a909-b66e99367f32",
      "subdate": "Dec 02, 2024",
      "subcategory": "Legal Services",
      "request_types": "",
      "visitcount": 19
   },
   "visits": {
      "storefront": 19,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "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": "2024-12-02 21:55:05"
   },
   "location": {
      "uuid": "1706bdbe-b0f8-11ef-a909-b66e99367f32",
      "link_id": 338615,
      "account_id": 89328,
      "company": "https://esquirelaw.com/",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "990",
      "zip": "85016",
      "address": "2198 E Camelback Rd # 300, ",
      "phone": "",
      "fax": null,
      "email": "tania@oras.co",
      "name": "https://esquirelaw.com/",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.5097942",
      "lon": "-112.0349744",
      "cityname": "Phoenix",
      "statename": "Arizona"
   },
   "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": ""
}