Holmes, Moore, Waldron, & Parrish P.L.L.C

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 313556,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "http://www.holmesmoore.com",
      "title": "Holmes, Moore, Waldron, & Parrish P.L.L.C",
      "description": "At Holmes, Moore, Waldron,&Parrish P.L.L.C., we offer quality legal services including  personal injury, criminal defense, drug offenses, dwi, domestic offense and many more. We believe in providing personal attention, accessible service and cost-effective representation to every client we serve. When facing a legal situation with the potential to significantly impact your life, you need a law firm who cares about your hardships and understands the importance of effectively resolving your legal problems",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 64782,
      "approve_dt": "2017-08-24T00:00:00.000Z",
      "source": null,
      "submit_dt": "2017-08-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 829,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22074,
      "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": 2184,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "955b3b91-56da-11ed-b77c-b66e99367f32",
      "subdate": "Aug 22, 2017",
      "subcategory": "Criminal Law",
      "request_types": "",
      "visitcount": 1055
   },
   "visits": {
      "storefront": 1055,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Our law office is a multi practice law firm delivering an uncompromising standard of legal service in the areas of personal injury, civil litigation, and criminal defense. When legal experience matters, there is no better choice than Holmes, Moore, Waldron, & Parrish P.L.L.C. Our team offers the personalized services you can depend on for your legal concern in Tyler, TX and Longview, TX.  When you need the expertise of knowledgeable criminal defense lawyers, you can depend on our legal team. The outcome of your criminal case will affect your life in a significant way. It is essential to consult with criminal lawyers who have your best interest as their primary focus. Our responsive team will always maintain open communication to help you resolve your legal concerns effectively.  If you are facing a DWI charge, drug charge, or domestic violence charge, our criminal lawyers have the in-depth knowledge to develop a sound defense for your case. Give your case the best chance of a successful outcome by working with a seasoned legal team that will be by your side every step of the way.  Whether you are faced with a personal injury or you need 24/7 emergency help for a DWI, we are always here when you need us. ",
      "service1": "domestic violence",
      "service2": " civil litigation",
      "service3": " attorney",
      "service4": " personal injury",
      "service5": " law firm",
      "service6": " criminal defense",
      "service7": " lawyer",
      "submit_dt": "2017-08-22 11:03:25"
   },
   "location": {
      "uuid": "955b3b91-56da-11ed-b77c-b66e99367f32",
      "link_id": 313556,
      "account_id": 64782,
      "company": "Holmes, Moore, Waldron, & Parrish P.L.L.C",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22074",
      "zip": "75601",
      "address": "110 West Methvin Street",
      "phone": "903-758-2200",
      "fax": null,
      "email": "holmesmoore1@hotmail.com",
      "name": "Holmes, Moore, Waldron, & Parrish P.L.L.C",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "32.4963745",
      "lon": "-94.7407173",
      "cityname": "Longview",
      "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": ""
}