Plumbing In Pink

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 318314,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.plumbinginpink.com/",
      "title": "Plumbing In Pink",
      "description": "Plumbing In Pink offers residential and light commercial plumbing services including water heaters, sewer, and drain repair, kitchen and bath fixture installation in Greenville, Spartanburg SC, and the surrounding area. We offer a two-year guarantee on all parts and labor supplied by our warranty. We are fully licensed and focused on customer satisfaction while offering affordable prices. Available emergency plumbing service call us at 864-605-7465 today to schedule your maintenance.\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69507,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-01-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 126,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 39,
      "city_id": 20303,
      "ltop": "",
      "facebook": "https://www.facebook.com/plumbinginpink/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/plumbinginpink",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/plumbinginpink/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5009,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95749270-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jan 14, 2020",
      "subcategory": "Home Plumbing",
      "request_types": "",
      "visitcount": 198
   },
   "visits": {
      "storefront": 198,
      "articles": 0,
      "videos": 0,
      "reviews": 19,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Plumbing In Pink offers residential and light commercial plumbing services including water heaters, sewer, and drain repair, kitchen and bath fixture installation in Greenville, Spartanburg SC, and the surrounding area. We offer a two-year guarantee on all parts and labor supplied by our warranty. We are fully licensed and focused on customer satisfaction while offering affordable prices. Available emergency plumbing service call us at 864-605-7465 today to schedule your maintenance.\r\n",
      "service1": "Commercial Plumbing",
      "service2": "Residential Plumbing",
      "service3": "Plumbing Services",
      "service4": "Plumbing Solutions",
      "service5": "Plumber",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-01-14 11:38:11"
   },
   "location": {
      "uuid": "95749270-56da-11ed-b77c-b66e99367f32",
      "link_id": 318314,
      "account_id": 69507,
      "company": "Plumbing In Pink",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20303",
      "zip": "29609",
      "address": "601 B Pine Knoll Drive",
      "phone": "864-605-7465",
      "fax": null,
      "email": "plumbinginpink@aol.com",
      "name": "Plumbing In Pink",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "34.896226",
      "lon": "-82.363636",
      "cityname": "Greenville",
      "statename": "South Carolina"
   },
   "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": ""
}