Hammerschmidt Broughton Law Corporation

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 311332,
      "site_id": 37,
      "cat_id": 57,
      "priority": 0,
      "url": "http://hbcriminaldefense.com/first-offense-dui/",
      "title": "Hammerschmidt Broughton Law Corporation",
      "description": "The attorneys of Hammerschmidt Broughton Law Corporation bring more than 100 years of combined experience to Central California clients, including those in Fresno, Kings, Madera, Tulare and Merced counties. We are committed to providing the highest level of legal representation to people accused of crimes.\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 62566,
      "approve_dt": "2016-01-12T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-12-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1058,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1962,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 2184,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95525268-56da-11ed-b77c-b66e99367f32",
      "subdate": "Dec 27, 2015",
      "subcategory": "Criminal Law",
      "request_types": "",
      "visitcount": 1178
   },
   "visits": {
      "storefront": 1178,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "The attorneys of Hammerschmidt Broughton Law Corporation bring more than 100 years of combined experience to Central California clients, including those in Fresno, Kings, Madera, Tulare and Merced counties. We are committed to providing the highest level of legal representation to people accused of crimes.\n\nOur lawyers have brought more than 350 cases to jury trial, including both state and federal crimes.\nAt Hammerschmidt Broughton, we focus on being proactive and doing everything we can to help you achieve the best result possible. We also understand that being accused of a crime can be one of the most stressful and difficult points in your life. Our team will help you manage that stress by keeping you up to date and making sure you feel confident about your case. We have a saying in our office, “our goal is to contact you more than you contact us”.\n\nOur criminal defense attorneys are here to help. Call or email us today to schedule a free case evaluation with an attorney at Hammerschmidt Broughton Law Corporation.\n",
      "service1": "Drug crimes",
      "service2": " DUI and BUI",
      "service3": " Felony crimes",
      "service4": " Murder",
      "service5": " Homicide",
      "service6": " Violent crimes",
      "service7": " White collar crimes",
      "submit_dt": "2015-12-27 12:38:19"
   },
   "location": {
      "uuid": "95525268-56da-11ed-b77c-b66e99367f32",
      "link_id": 311332,
      "account_id": 62566,
      "company": "Hammerschmidt Broughton Law Corporation",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1962",
      "zip": "93721",
      "address": "2445 Capitol Street",
      "phone": "",
      "fax": "",
      "email": "hbcriminaldefense@openmailbox.org",
      "name": "Hammerschmidt Broughton Law Corporation",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "36.7360473",
      "lon": "-119.7839406",
      "cityname": "Fresno",
      "statename": "California"
   },
   "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": ""
}