Brown Immigration Law

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344656,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://www.brown-immigration.com/",
      "title": "Brown Immigration Law",
      "description": "Brown Immigration Law is a comprehensive immigration law firm representing individuals, families, small businesses, and major corporations through complex U.S. immigration matters. We help clients navigate the intricate web of federal immigration law and cut through bureaucratic red tape when dealing with the State Department, U.S. Citizenship and Immigration Services (USCIS), and the Department of Homeland Security (DHS). With experience handling diverse immigration challenges, we provide strategic counsel and effective solutions tailored to each client's unique circumstances.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95351,
      "approve_dt": "2025-10-31T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-02T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 34,
      "city_id": 16891,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "2333123f-0f75-11f0-a909-b66e99367f32",
      "subdate": "Apr 02, 2025",
      "subcategory": "Immigration Law",
      "request_types": "",
      "visitcount": 47
   },
   "visits": {
      "storefront": 47,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 18,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Brown Immigration Law is dedicated to fostering growth and creating lasting impacts for individuals and families pursuing brighter futures. With five offices and a global reach, our firm provides experienced counsel in all areas of immigration law.",
      "service1": "family-based immigration",
      "service2": " employment-based visas",
      "service3": " business immigration",
      "service4": " green card applications",
      "service5": " citizenship and naturalization",
      "service6": " deportation defense",
      "service7": " visa applications",
      "submit_dt": "2025-04-02 03:47:02"
   },
   "location": {
      "uuid": "2333123f-0f75-11f0-a909-b66e99367f32",
      "link_id": 344656,
      "account_id": 95351,
      "company": "Brown Immigration Law",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "16891",
      "zip": "44113",
      "address": "1468 W 9th St, Ste 705",
      "phone": "(216) 861-4414",
      "fax": null,
      "email": "brownimmigratio@brite-email.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.4973754",
      "lon": "-81.6995391",
      "cityname": "Cleveland",
      "statename": "Ohio"
   },
   "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": ""
}