Champion Plumbing Sewer & Drain LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 339624,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://championplumbingsewer.com/",
      "title": "Champion Plumbing Sewer & Drain LLC",
      "description": "Champion Plumbing Sewer & Drain LLC is your trusted partner for plumbing solutions in Cape Coral, FL. From expert plumbers to efficient drain cleaning services, we ensure reliable solutions tailored to your needs. Count on us for top-notch plumbing expertise and exceptional customer service.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 90331,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-12-23T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 3341,
      "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": "35e571b6-c107-11ef-a909-b66e99367f32",
      "subdate": "Dec 23, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 35
   },
   "visits": {
      "storefront": 35,
      "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": "Champion Plumbing Sewer&Drain LLC is your trusted partner for plumbing solutions in Cape Coral, FL. From expert plumbers to efficient drain cleaning services, we ensure reliable solutions tailored to your needs. Count on us for top-notch plumbing expertise and exceptional customer service.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-12-23 08:23:38"
   },
   "location": {
      "uuid": "35e571b6-c107-11ef-a909-b66e99367f32",
      "link_id": 339624,
      "account_id": 90331,
      "company": "Champion Plumbing Sewer & Drain LLC",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3341",
      "zip": "33909",
      "address": "931 NE 7th St Suite B",
      "phone": "239-257-2249",
      "fax": null,
      "email": "championplumbingsewer1@gmail.com",
      "name": "Champion Plumbing Sewer & Drain LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "26.6653061",
      "lon": "-81.9540294",
      "cityname": "Cape Coral",
      "statename": "Florida"
   },
   "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": ""
}