All Hours Plumber

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 330030,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://allhoursplumber.com/",
      "title": "All Hours Plumber",
      "description": "Tampa Plumbers - Residential and Commercial Plumbing and Drain Cleaning Services in Tampa, St. Petersburg, Clearwater, Wesley Chapel, and the surrounding Tampa Bay Communities\n\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 80841,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-04-18T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 20,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 4011,
      "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": 5877,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "fea8680d-fd4d-11ee-8344-b66e99367f32",
      "subdate": "Apr 18, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 79
   },
   "visits": {
      "storefront": 79,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 21,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "All Hours Plumber is your clear choice when it comes to plumbing services. What sets us apart from the competition is our unwavering commitment to reliability, expertise, and innovation. We're available 24/7, 365 days a year, ensuring we're there when you need us most. Our team of experienced and certified plumbers is equipped with cutting-edge technology, allowing us to tackle any plumbing issue efficiently.",
      "service1": "24 Hour Emergency Plumbing Services",
      "service2": "Drain Cleaning",
      "service3": "Hydro Jetting Drains & Sewer Lines",
      "service4": "Water Heater Repair & Installation",
      "service5": "Sewer Repair & Replacements",
      "service6": "Whole House Re-Piping",
      "service7": "Toilet Repair & Installation",
      "submit_dt": "2024-04-18 06:36:32"
   },
   "location": {
      "uuid": "fea8680d-fd4d-11ee-8344-b66e99367f32",
      "link_id": 330030,
      "account_id": 80841,
      "company": "All Hours Plumber",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "4011",
      "zip": "33609",
      "address": "5401 W Kennedy Blvd Suite 100",
      "phone": "813-774-1199",
      "fax": null,
      "email": "allhoursplumber@hotmail.com",
      "name": "All Hours Plumber",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "27.9458578",
      "lon": "-82.5339718",
      "cityname": "Tampa",
      "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": 1
      },
      {
         "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": ""
}