McWhorter Law Firm

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 326329,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "http://www.mcwhorterlaw.com/",
      "title": "McWhorter Law Firm",
      "description": "McWhorter Law Firm, where excellence in legal representation meets unwavering dedication to our clients'' success. As a premier law firm specializing in real estate, probate, estate planning, and family law, we are committed to providing comprehensive and tailored solutions that navigate the intricate landscape of the legal world.McWhorter Law Firm is a trusted legal partner, who guides you through life''s legal complexities with professionalism, compassion, and unwavering dedication.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 77214,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-11-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 30,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 921,
      "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": 2250,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "3ecfc88f-82bc-11ee-8344-b66e99367f32",
      "subdate": "Nov 14, 2023",
      "subcategory": "Real Estate Law",
      "request_types": "",
      "visitcount": 70
   },
   "visits": {
      "storefront": 70,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "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": "2023-11-14 07:05:51"
   },
   "location": {
      "uuid": "3ecfc88f-82bc-11ee-8344-b66e99367f32",
      "link_id": 326329,
      "account_id": 77214,
      "company": "",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "921",
      "zip": "85295",
      "address": "4365 East Pecos Road, Suite 120",
      "phone": "(602) 830-3000",
      "fax": null,
      "email": "mcwhorterlaw@brite.email",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.2890081",
      "lon": "-111.695915",
      "cityname": "Gilbert",
      "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": ""
}