Berardi Immigration Law-Immigration Law

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 311348,
      "site_id": 37,
      "cat_id": 57,
      "priority": 0,
      "url": "http://www.berardiimmigrationlaw.com",
      "title": "Berardi Immigration Law-Immigration Law",
      "description": "Berardi Immigration Law is the highly reputed immigration law firm that is providing all kind of US immigration services to the individuals, businesses and Nonprofit organizations since 2005.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 62582,
      "approve_dt": "2016-01-08T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-12-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4188,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 14736,
      "ltop": "",
      "facebook": "https://www.facebook.com/berardiimmigrationlaw",
      "tiktok": "",
      "linkedin": "https://www.linkedin.com/company/berardi-immigration-law",
      "twitter": "https://twitter.com/berardiimmlaw",
      "googleplus": "https://plus.google.com/105454200252008518727/abou",
      "youtube_channel": "",
      "youtube": "https://www.youtube.com/user/BerardiImmigration",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 2200,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "955267e9-56da-11ed-b77c-b66e99367f32",
      "subdate": "Dec 29, 2015",
      "subcategory": "Immigration Law",
      "request_types": "",
      "visitcount": 4611
   },
   "visits": {
      "storefront": 4611,
      "articles": 0,
      "videos": 0,
      "reviews": 30,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Managing Partner Rosanna Berardi founded our firm in 2005 after working as an INS Inspector, INS Attorney, a University Immigration Lawyer and an Associate at one of Western New York’s largest corporate firms. Her vision to create a premier immigration legal services team was realized through consistent, proven results for our clients. Today, we are respected across America, Canada and the world for our firm’s knowledge, insight and strategies meeting the long and short term goals of businesses and individuals. Our exceptional service will help make your move to the U.S. as easy and stress-free as possible.\nBerardi Immigration Law is a full-service immigration law firm.  Our Immigration Lawyers offer a full range of immigration services to both businesses and individuals in Southern Ontario, Canada and all other areas of the world. We are experienced Immigration Lawyers  and uniquely qualified to manage clients’ most contentious and unusual immigration needs. We recognize that swift resolution of immigration related issues is integral to a client’s ability to conduct business or reach their personal goals in the United States.\n",
      "service1": "U.S. immigration for Canadians",
      "service2": " Working in the U.S.",
      "service3": " Criminal waivers",
      "service4": " Marriage in the U.S.",
      "service5": " U.S. green cards",
      "service6": " Citizenship",
      "service7": " Visa application",
      "submit_dt": "2015-12-29 07:04:21"
   },
   "location": {
      "uuid": "955267e9-56da-11ed-b77c-b66e99367f32",
      "link_id": 311348,
      "account_id": 62582,
      "company": "Berardi Immigration Law",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "14736",
      "zip": "14221",
      "address": "2300 Wehrle Drive",
      "phone": "716-634-1010",
      "fax": "",
      "email": "berardiimmigration@gmail.com",
      "name": "Berardi Immigration Law-Immigration Law",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.956921",
      "lon": "-78.708584",
      "cityname": "Buffalo",
      "statename": "New York"
   },
   "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": ""
}