Gulfview Plumbing & Water Treatment

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 324913,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://gulfviewplumbing.com/",
      "title": "Gulfview Plumbing & Water Treatment",
      "description": "Need an emergency plumber now? Call Gulfview Plumbing. We offer 24 hour emergency plumbing services for Clearwater, including holidays. Whether you have a backed-up drain, a hidden water leak causing damage to your home, or need to repair a broken sewer or water line, or no hot water, you can count on us for immediate assistance. Our technicians will arrive quickly to diagnose your issue and present you with solutions to your emergency. Call us at (727) 351-4700 for more information! ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 75899,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-05-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 42,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 3371,
      "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": 5009,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9a0bfc21-f86d-11ed-b5b4-b66e99367f32",
      "subdate": "May 22, 2023",
      "subcategory": "Home Plumbing",
      "request_types": "",
      "visitcount": 85
   },
   "visits": {
      "storefront": 85,
      "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 an emergency plumber now? Call Gulfview Plumbing. We offer 24 hour emergency plumbing services for Clearwater, including holidays. Whether you have a backed-up drain, a hidden water leak causing damage to your home, or need to repair a broken sewer or water line, or no hot water, you can count on us for immediate assistance. Our technicians will arrive quickly to diagnose your issue and present you with solutions to your emergency. Call us at (727) 351-4700 for more information! \r
",
      "service1": "Plumbing Comapny",
      "service2": "Water Heater Repair",
      "service3": "Drain Cleaning Services",
      "service4": "Water Softener Installation",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-05-22 06:55:13"
   },
   "location": {
      "uuid": "9a0bfc21-f86d-11ed-b5b4-b66e99367f32",
      "link_id": 324913,
      "account_id": 75899,
      "company": "Gulfview Plumbing & Water Treatment",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3371",
      "zip": "33764",
      "address": "2028 Diplomat Dr",
      "phone": "(727) 351-4700",
      "fax": null,
      "email": "g.ulfviewplumbingfl@gmail.com",
      "name": "Gulfview Plumbing & Water Treatment",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "27.9473981",
      "lon": "-82.7526239",
      "cityname": "Clearwater",
      "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": ""
}