Alliance Environmental Group

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 319078,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.alliance-enviro.com/",
      "title": "Alliance Environmental Group",
      "description": "Alliance Environmental Group is one of the leading environmental companies in California offering services including asbestos removal, mold remediation, lead paint removal, demolition, air duct, dryer vent, site, and kitchen exhaust hood cleaning, power washing, infection control, structural pasteurization, trauma, methamphetamine lab, and hoarding cleanup.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 70273,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-05-20T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 114,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1662,
      "ltop": "",
      "facebook": "https://www.facebook.com/allianceenvironmentalgroup/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/alliance-environmental/",
      "twitter": "https://twitter.com/allianceenviro",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/allianceenvironmentalgroup/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5876,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9578a446-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 20, 2020",
      "subcategory": "Pest Control",
      "request_types": "",
      "visitcount": 192
   },
   "visits": {
      "storefront": 192,
      "articles": 0,
      "videos": 0,
      "reviews": 17,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Alliance Environmental Group is one of the leading environmental companies in California offering services including asbestos removal, mold remediation, lead paint removal, demolition, air duct, dryer vent, site, and kitchen exhaust hood cleaning, power washing, infection control, structural pasteurization, trauma, methamphetamine lab, and hoarding cleanup.",
      "service1": "Environmental Companies Near Me",
      "service2": "Mold Remediation Los Angeles",
      "service3": "Asbestos Abatement",
      "service4": "Demolition Services",
      "service5": "Dryer Duct Cleaning",
      "service6": "HVAC Duct Cleaning",
      "service7": "Lead Paint Removal",
      "submit_dt": "2020-05-20 04:46:48"
   },
   "location": {
      "uuid": "9578a446-56da-11ed-b77c-b66e99367f32",
      "link_id": 319078,
      "account_id": 70273,
      "company": "Alliance Environmental Group",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1662",
      "zip": "91702",
      "address": "990 W. Tenth Street",
      "phone": "",
      "fax": null,
      "email": "allianceenviro1@gmail.com",
      "name": "Alliance Environmental Group",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "34.1396015",
      "lon": "-117.9212845",
      "cityname": "Azusa",
      "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": ""
}