WaterWork Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317015,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://waterworkplumbing.com",
      "title": "WaterWork Plumbing",
      "description": "
\r\nService Hours: Monday to Friday: 8:30AM to 5PM, Saturday 9AM to 2PM\r\nPayments Accepted: Cash, Credit Card",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68212,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-05-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 177,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 22,
      "city_id": 10334,
      "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": 5000,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956d6c0d-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 16, 2019",
      "subcategory": "Plumbing Services",
      "request_types": "",
      "visitcount": 218
   },
   "visits": {
      "storefront": 218,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "WaterWork Plumbing has hand-picked a team of committed professionals who will take care of your residential or commercial plumbing needs with the expertise and efficiency you deserve. Our team members come from different backgrounds and have varying years of experience in the plumbing field, but they do have at least one thing in common u2013their passion to ensure that every customer gets the best possible service. ",
      "service1": "drain cleaning",
      "service2": "plumbing services",
      "service3": "plumbing company",
      "service4": "plumbers near me",
      "service5": "plumbers",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-05-16 05:25:44"
   },
   "location": {
      "uuid": "956d6c0d-56da-11ed-b77c-b66e99367f32",
      "link_id": 317015,
      "account_id": 68212,
      "company": " WaterWork Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10334",
      "zip": "48220",
      "address": "1049 Hilton Rd.",
      "phone": "2485428022",
      "fax": null,
      "email": "waterworkplumbingusa@gmail.com",
      "name": " WaterWork Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.4549725",
      "lon": "-83.1230863",
      "cityname": "Ferndale",
      "statename": "Michigan"
   },
   "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": ""
}