Black Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 327225,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "http://www.blackplumbing.com/",
      "title": "Black Plumbing",
      "description": "Need a fully-licensed plumber in the Sweetwater area? You can count on Black Plumbing, day or night. Our team of highly experienced plumbers offers a wide range of residential and commercial plumbing services to meet your needs. With quality you can count on, fair prices, and timely service, we''re here to provide the Sweetwater area with the highest quality plumbing services around. Whether you need a leaky faucet fixed or a contractor to install a trenchless drain, we can handle any job.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 78082,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-12-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 30,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22616,
      "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": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4eac7cc7-a5e6-11ee-8344-b66e99367f32",
      "subdate": "Dec 29, 2023",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 86
   },
   "visits": {
      "storefront": 86,
      "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": "Need a fully-licensed plumber in the Sweetwater area? You can count on Black Plumbing, day or night. Our team of highly experienced plumbers offers a wide range of residential and commercial plumbing services to meet your needs. With quality you can count on, fair prices, and timely service, we're here to provide the Sweetwater area with the highest quality plumbing services around. Whether you need a leaky faucet fixed or a contractor to install a trenchless drain, we can handle any job.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-12-29 01:05:07"
   },
   "location": {
      "uuid": "4eac7cc7-a5e6-11ee-8344-b66e99367f32",
      "link_id": 327225,
      "account_id": 78082,
      "company": "Black Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22616",
      "zip": "79556",
      "address": "609 East Broadway Avenue",
      "phone": "+1 325-236-1790",
      "fax": null,
      "email": "blackplumbingtxs@mail-burst.com",
      "name": "Black Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "32.4732689",
      "lon": "-100.4024129",
      "cityname": "Sweetwater",
      "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": ""
}