Turner Plumbing Co

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309554,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "http://turnerplumbingco.com",
      "title": "Turner Plumbing Co",
      "description": "Phone: 904-396-7044\r\n\r\nExperience and training make the difference. The Turner Team has over 150 YEARS combined experience with Turner Plumbing and over 200 YEARS of experience in the industry. Our men use industry-leading technology to provide you with the most effective solutions to your plumbing needs. We take pride in our work as a 3rd generation plumbing company, and strive to provide excellence to our customers.\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60790,
      "approve_dt": "2015-05-26T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-05-23T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1174,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 3606,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 4974,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95489e23-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 23, 2015",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 1373
   },
   "visits": {
      "storefront": 1373,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Expert Plumber Serving Jacksonville, St Augustine and Northeast Florida Yulee Home\n\nTurner Plumbing has been serving the Jacksonville, St Augustine and Northeast Florida area for over 72 years.  Founded by Holly & Louise Turner, we are now a 3rd Generation family owned and operated plumbing company. Our team is filled with master plumbers that are a part of our family. The Turner Team has over 200 years of combined experience in the industry and almost 150 years of experience with Turner. Expert craftsmanship and superior service has been a hallmark of Turner Plumbing since it began in 1942. We would love to have you as a part of our loyal family",
      "service1": "Plumbing",
      "service2": " Emergency Plumbing",
      "service3": " Commercial Plumbing",
      "service4": " Bathroom Remodeling",
      "service5": " Water Heater Installation",
      "service6": "",
      "service7": "",
      "submit_dt": "2015-05-23 06:06:49"
   },
   "location": {
      "uuid": "95489e23-56da-11ed-b77c-b66e99367f32",
      "link_id": 309554,
      "account_id": 60790,
      "company": "Turner Plumbing Co",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3606",
      "zip": "32207",
      "address": "1903 Hendricks Ave",
      "phone": "",
      "fax": "",
      "email": "",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "30.3064615",
      "lon": "-81.6536894",
      "cityname": "Jacksonville",
      "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": ""
}