Allied All City Inc. Sewer, Plumbing Services and Repairs New York City

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 312516,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "http://alliedallcityinc.com/",
      "title": "Allied All City Inc. Sewer, Plumbing Services and Repairs New York City ",
      "description": "Allied/All-City Inc. is one of the leading plumbing and sewer services agencies in New York Area featured on Angie’s List as well as the local Plumbing Departments. It is best known for its guaranteed service, 24 hour emergency support and master technicians. Whether you need an old water-line replacement, new plumbing connection or damaged sewer repair, Allied/All-City is ready to support you even in odd hours and with an affordable charge. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 63750,
      "approve_dt": "2016-08-29T00:00:00.000Z",
      "source": null,
      "submit_dt": "2016-08-20T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 2,
      "clickcount": 1756,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 14814,
      "ltop": "",
      "facebook": "https://www.facebook.com/pages/AlliedAll-City-Inc/155774751127245",
      "tiktok": null,
      "linkedin": "",
      "twitter": "http://twitter.com/AlliedAllCity",
      "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": 5026,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9555be89-56da-11ed-b77c-b66e99367f32",
      "subdate": "Aug 20, 2016",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 2029
   },
   "visits": {
      "storefront": 2029,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "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": "Your complete plumbing, heating, sewer & drain and environmental services experts. We service all of Nassau, Suffolk Counties on Long Island, New York as well as the 5 Boroughs of New York City. Allied/ All City services residential, commercial, industrial and municipal properties throughout our service area. \n

\nAllied/All-City Inc. is one of the leading plumbing and sewer services agencies in New York Area featured on Angieu2019s List as well as the local Plumbing Departments. \n

\nIt is best known for its guaranteed service, 24 hour emergency support and master technicians. Whether you need an old water-line replacement,\nnew plumbing connection or damaged sewer repair, Allied/All-City is ready to support you even in odd hours and with an affordable charge.",
      "service1": "sewer services",
      "service2": "Plumbing Services",
      "service3": "Plumbing Repairs",
      "service4": "Plumber",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2016-08-20 07:00:43"
   },
   "location": {
      "uuid": "9555be89-56da-11ed-b77c-b66e99367f32",
      "link_id": 312516,
      "account_id": 63750,
      "company": "Allied All City Inc.",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "14814",
      "zip": "11726",
      "address": "130 Lambert Ave",
      "phone": "631-957-5023",
      "fax": null,
      "email": "admin@alliedallcityinc.com",
      "name": "Allied All City Inc.",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.681076",
      "lon": "-73.3895106",
      "cityname": "Copiague",
      "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": ""
}