Team Green Lawyers, PLLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 308455,
      "site_id": 37,
      "cat_id": 57,
      "priority": 0,
      "url": "http://www.TeamGreenLawyers.com",
      "title": "Team Green Lawyers, PLLC",
      "description": "Team Green Lawyers, PLLC. Former prosecutors now defending those charged with a crime. Specializing in DWI, Traffic & Vehicular charges, and Criminal Defense.  We understand that defending people who have been accused of a crime takes an understanding of the law, the process and the potential consequences. We have devoted our practice to helping people accused of a crime or violation get the best ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 59680,
      "approve_dt": "2014-12-23T00:00:00.000Z",
      "source": null,
      "submit_dt": "2014-12-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2991,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 15544,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 1657,
      "subcat_id": 2184,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "9542570d-56da-11ed-b77c-b66e99367f32",
      "subdate": "Dec 22, 2014",
      "subcategory": "Criminal Law",
      "request_types": "",
      "visitcount": 3175
   },
   "visits": {
      "storefront": 3175,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Green and Brenneck we understand that defending people who have been accused of a crime takes an understanding of the law, the process and the potential consequences. We have devoted our practice to helping people accused of a crime or violation get the best result possible. We take the time to get to know our clients, the facts and their concerns. We research the legal issues and test all of the theories that may help or hurt a clients particular situation. We are in the business of serving our clients and pride ourselves on honest, accurate and trustworthy representation.\r
You dont need a lawyer " you need a legal team.",
      "service1": "DWI",
      "service2": "Traffic & Vehicular",
      "service3": "Criminal Defense",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2014-12-22 17:54:26"
   },
   "location": {
      "uuid": "9542570d-56da-11ed-b77c-b66e99367f32",
      "link_id": 308455,
      "account_id": 59680,
      "company": "",
      "sid": 0,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "15544",
      "zip": "13202",
      "address": "100 Madison Street",
      "phone": "",
      "fax": "",
      "email": "mary@teamgreenlawyers.com",
      "name": "Team Green Lawyers, PLLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "43.0451206",
      "lon": "-76.1498437",
      "cityname": "Syracuse",
      "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": ""
}