Law Offices of S. Ouya Maina

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 328792,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://www.mainalaw.com/",
      "title": "Law Offices of S. Ouya Maina",
      "description": "Welcome to the Law Offices of S. Ouya Maina, your trusted partner in navigating the complex terrain of immigration law in Berkeley, California. Founded by Sam Ouya Maina, a seasoned immigration attorney with over 27 years of experience, we are committed to providing comprehensive legal solutions to individuals and families facing immigration challenges. At the Law Offices of S. Ouya Maina, we understand the significance of your immigration journey and the impact it has on your life.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 79621,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-02-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 14,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1684,
      "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": 2200,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "860eeef5-d756-11ee-8344-b66e99367f32",
      "subdate": "Feb 29, 2024",
      "subcategory": "Immigration Law",
      "request_types": "",
      "visitcount": 35
   },
   "visits": {
      "storefront": 35,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-02-29 23:01:51"
   },
   "location": {
      "uuid": "860eeef5-d756-11ee-8344-b66e99367f32",
      "link_id": 328792,
      "account_id": 79621,
      "company": "",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1684",
      "zip": "94704",
      "address": "2140 Shattuck Ave, #810",
      "phone": "4153916612",
      "fax": null,
      "email": "mainalaw@brite-post.com",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.8704084",
      "lon": "-122.268485",
      "cityname": "Berkeley",
      "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": ""
}