Total Drain Solutions

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346253,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.totaldrainsolutions.com",
      "title": "Total Drain Solutions",
      "description": "All residential and commercial property owners will need pipe restoration and rehabilitation at one point. At Total Drain Solutions, we take pride in our trusted experts who are more than capable of providing you with upfront pricing, no-obligation written estimates, and prompt project completion.Learn More: https://www.totaldrainsolutions.com/services/trenchless-sewer-repair/",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96948,
      "approve_dt": "2025-08-16T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-01T00: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": 3948,
      "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": 5018,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "a2347ba1-2696-11f0-a909-b66e99367f32",
      "subdate": "May 01, 2025",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 9
   },
   "visits": {
      "storefront": 9,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Total Drain Solutions is a trusted pipe restoration and rehabilitation company serving residential and commercial property owners with 50 years of combined industry experience. Our expert team provides upfront pricing, no-obligation written estimates, and prompt project completion while maintaining the highest level of integrity and customer service. We specialize in completely restoring damaged pipes for homes, apartments, offices, and commercial facilities throughout the local area, ensuring timely and professional solutions for all your drain and pipe needs.",
      "service1": "trenchless pipe lining",
      "service2": " sewer camera inspection",
      "service3": " hydro jetting services",
      "service4": " brush coating applications",
      "service5": " mechanical cleaning solutions",
      "service6": " sovent cleaning services",
      "service7": " trenchless sewer repair",
      "submit_dt": "2025-05-01 14:14:45"
   },
   "location": {
      "uuid": "a2347ba1-2696-11f0-a909-b66e99367f32",
      "link_id": 346253,
      "account_id": 96948,
      "company": "Total Drain Solutions",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3948",
      "zip": "34237",
      "address": "2401 15th Street Sarasota, FL ",
      "phone": "(941) 263-3317",
      "fax": null,
      "email": "totaldrainsolutionssarasota@gmail.com",
      "name": "Total Drain Solutions",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "27.3511036",
      "lon": "-82.5217217",
      "cityname": "Sarasota",
      "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": ""
}