Serrano & Serrano, LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 33193,
      "site_id": 18,
      "cat_id": 69,
      "priority": 1,
      "url": "http://www.SerranoLawyers.com",
      "title": "Serrano & Serrano, LLC",
      "description": "Skilled, Determined and Experienced lawyers. Personal Injury, Accidents, Social Security Disability, Workers Compensation, Divorce and Family Law, Criminal Defense, Immigration, Real Estate. Naugatuck office serves Waterbury.  Call 203 729-6100. We handle Social Security Disability cases in the Springfield - Holyoke, Massachusetts area.  Call Toll Free 800 856-6400. We speak Portuguese and Spanish.",
      "keywords": "Lawyer\r\nAttorney\r\nAccident\r\nPersonal Injury\r\nFatal Accident\r\nWrongful Death\r\nCar Accident\r\nTruck Accident\r\nMotorcycle Accident\r\nMotorcycle Accidents\r\nDog Bite\r\nLawyers\r\nAttorneys\r\nAccidents\r\nFatal Acc",
      "status": "5",
      "affiliate_id": 0,
      "cust_id": 28283,
      "approve_dt": "2007-11-15T00:00:00.000Z",
      "source": "2checkout",
      "submit_dt": "2007-11-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": 0,
      "ppc_points": 0,
      "link_points": 1,
      "clickcount": 3807,
      "referrals": 0,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 7,
      "city_id": 3086,
      "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": 641,
      "subcat_id": 757,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "94924619-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 14, 2007",
      "subcategory": "Motor Vehicle Defects Attorney",
      "request_types": "",
      "visitcount": 4332
   },
   "visits": {
      "storefront": 4332,
      "articles": 829,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 16,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Serrano Law Firm is a full-service legal practice led by Attorney John Serrano, who brings 30 years of experience helping individuals and families resolve complex legal matters. The firm is committed to providing skilled legal representation and achieving the best possible outcomes for clients across a wide range of practice areas.",
      "service1": "personal injury cases",
      "service2": " Social Security Disability claims",
      "service3": " workers compensation",
      "service4": " divorce proceedings",
      "service5": " criminal defense",
      "service6": " DWI/DUI representation",
      "service7": " immigration services",
      "submit_dt": "2007-11-14 00:00:00"
   },
   "location": {
      "uuid": "94924619-56da-11ed-b77c-b66e99367f32",
      "link_id": 33193,
      "account_id": 28283,
      "company": "Serrano Lawyers",
      "sid": 18,
      "country": 277,
      "countrycode": "US",
      "state": 7,
      "city": "3086",
      "zip": "06110",
      "address": "690 Flatbush Avenue",
      "phone": "860-236-9350",
      "fax": null,
      "email": null,
      "name": null,
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.7428504",
      "lon": "-72.7202248",
      "cityname": "Hartford",
      "statename": "Connecticut"
   },
   "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": 5
      },
      {
         "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": ""
}