Altair Law LLP

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 352748,
      "site_id": 37,
      "cat_id": 57,
      "priority": 0,
      "url": "https://altairlaw.com/",
      "title": "Altair Law LLP",
      "description": "Phone:509 588 7993\nHours:Mon-Fri: 9 am- 5 pm; Sun-Sat: Closed\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 103502,
      "approve_dt": "2026-04-21T00:00:00.000Z",
      "source": null,
      "submit_dt": "2026-04-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": null,
      "countrycode": null,
      "loc_id": null,
      "state_id": null,
      "city_id": null,
      "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": 2172,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c68a2290-3d44-11f1-bb42-b66e99367f32",
      "subdate": "Apr 21, 2026",
      "subcategory": "Attorney Legal Services",
      "request_types": "",
      "visitcount": 5
   },
   "visits": {
      "storefront": 5,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Altair Law LLP is a San Francisco-based trial firm specializing in personal injury, automobile accidents, construction accidents, product liability, and wrongful death. We fight for the underdog—meeting clients at home or in the hospital to provide trusted guidance and deliver real results for individuals and families. Call today for the justice you deserve.",
      "service1": "Premises Liability",
      "service2": "Product Liability",
      "service3": "Medical Malpractice",
      "service4": "Consumer Protection Litigation",
      "service5": "Employment Law",
      "service6": "Catastrophic Injury",
      "service7": "Personal Injury",
      "submit_dt": "2026-04-21 05:41:42"
   },
   "location": {
      "uuid": "c68a2290-3d44-11f1-bb42-b66e99367f32",
      "link_id": 352748,
      "account_id": 103502,
      "company": "Andje  Medina",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2456",
      "zip": "94104",
      "address": "465 California Street, 5th Floor",
      "phone": "509 588 7993",
      "fax": null,
      "email": "legaldirectorylinks+AltairlawNapsSanFrancisco@gmail.com",
      "name": "Altair Law LLP",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "San Francisco",
      "statename": "California"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "LinkedIn",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "TikTok",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Twitter",
         "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": ""
}