EGW Water & Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 316175,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "http://www.egwwaterandplumbing.com",
      "title": "EGW Water & Plumbing",
      "description": "EGW Water & Plumbing manufactures and distributes to industry wholesalers a wide variety of quality waterworks and plumbing products. With our comprehensive product offering, we help manage inventory turns and reduce shipping costs by allowing you to consolidate orders into full freight allowed shipments. Contact us at 972.446.1655 or sales@egwusa.com to learn how EGW Water & Plumbing can help your business today!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 67376,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-11-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 106,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21497,
      "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": 5018,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9568fd39-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 22, 2018",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 119
   },
   "visits": {
      "storefront": 119,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "EGW Water & Plumbing manufactures and distributes to industry wholesalers a wide variety of quality waterworks and plumbing products. With our comprehensive product offering, we help manage inventory turns and reduce shipping costs by allowing you to consolidate orders into full freight allowed shipments. Contact us at 972.446.1655 or sales@egwusa.com to learn how EGW Water & Plumbing can help your business today!",
      "service1": "flange pack",
      "service2": "underground tracer wire",
      "service3": " flange bolt and gasket sets",
      "service4": "cathodic protection for pipelines",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2018-11-22 09:28:46"
   },
   "location": {
      "uuid": "9568fd39-56da-11ed-b77c-b66e99367f32",
      "link_id": 316175,
      "account_id": 67376,
      "company": "EGW Water & Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21497",
      "zip": "75006",
      "address": "1406 Hutton Drive",
      "phone": "972-446-1655",
      "fax": null,
      "email": "iac.seo.egwwaterandplumbing@gmail.com",
      "name": "EGW Water & Plumbing",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "32.9483562",
      "lon": "-96.9161808",
      "cityname": "Carrollton",
      "statename": "Texas"
   },
   "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": ""
}