Mirador Law

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337454,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://miradorlaw.com/",
      "title": "Mirador Law",
      "description": "Mirador Law represents personal injury victims and people accused of crimes throughout the Bay Area and Northern California. Our mission is to represent real people with real problems and we have a proven track record of achieving excellent results for our clients. Our personal injury attorneys handle auto, truck, motorcycle, bicycle and pedestrian accidents. We also handle slip and fall cases, abuse cases, dog bite and wrongful death cases. Our criminal lawyers handle a wide range of cases, including DUI, domestic violence, sex, fraud, guns, drugs and homicide cases. We handle cases in Alameda, Contra Costa, San Francisco, San Mateo and Santa Clara counties. Call us for a free initial consultation.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88183,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 11,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2360,
      "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": 2204,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4e7eb98f-95e9-11ef-ab46-b66e99367f32",
      "subdate": "Oct 29, 2024",
      "subcategory": "Law",
      "request_types": "",
      "visitcount": 40
   },
   "visits": {
      "storefront": 40,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Mirador Law represents personal injury victims and people accused of crimes throughout the Bay Area and Northern California. Our mission is to represent real people with real problems and we have a proven track record of achieving excellent results for our clients. Our personal injury attorneys handle auto, truck, motorcycle, bicycle, and pedestrian accidents. We also handle slip and fall cases, abuse cases, dog bites, and wrongful death cases.",
      "service1": "personal injury lawyer",
      "service2": "car accident lawyer",
      "service3": "truck accident lawyer",
      "service4": "motorcycle accident lawyer",
      "service5": "accident lawyer",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-29 11:31:15"
   },
   "location": {
      "uuid": "4e7eb98f-95e9-11ef-ab46-b66e99367f32",
      "link_id": 337454,
      "account_id": 88183,
      "company": "",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2360",
      "zip": "94588",
      "address": "6601 Owens Drive",
      "phone": "+1 925-460-8484",
      "fax": null,
      "email": "bonjourandthorman@brite.email",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "37.6979424",
      "lon": "-121.9081059",
      "cityname": "Pleasanton",
      "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": ""
}