Trust Rooter Plumbing & Drain Cleaning

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348330,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.trustrooter.com/",
      "title": "Trust Rooter Plumbing & Drain Cleaning",
      "description": "Do you need a plumber in Pompano Beach, FL area? Trust Rooter Plumbing & Drain Cleaning offers 24-Hour emergency plumbing repair and installation services in Pompano Beach and all nearby towns. We are a family own and operated company, providing plumbing and drain cleaning local services. We value honesty and integrity in all aspects of our business. We offer a variety of Plumbing services that are customizable to each individual project. We specialize in a variety of related service and installation projects. We pride ourselves on the quality of our work as well as our commitment to outstanding results. We look forward to building lasting relationships with our clients and guarantee your satisfaction!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99025,
      "approve_dt": "2025-07-14T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 3883,
      "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": 4974,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "283cd2bf-4456-11f0-a909-b66e99367f32",
      "subdate": "Jun 08, 2025",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 26
   },
   "visits": {
      "storefront": 26,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Trust Rooter is a family-owned and operated plumbing company committed to delivering exceptional plumbing products and services to residential and commercial customers. From simple repairs to complete system installations, we provide reliable, professional plumbing solutions backed by quality craftsmanship and trusted service.",
      "service1": "residential plumbing",
      "service2": " commercial plumbing",
      "service3": " new construction plumbing",
      "service4": " plumbing remodeling",
      "service5": " emergency plumbing repairs",
      "service6": " drain cleaning",
      "service7": " plumbing system installation",
      "submit_dt": "2025-06-08 10:48:48"
   },
   "location": {
      "uuid": "283cd2bf-4456-11f0-a909-b66e99367f32",
      "link_id": 348330,
      "account_id": 99025,
      "company": "Trust Rooter Plumbing & Drain Cleaning",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3883",
      "zip": "33069",
      "address": "1771 Blount Rd STE 215",
      "phone": "(954) 707-6556",
      "fax": null,
      "email": "leroygallegoshaoq7879@gmail.com",
      "name": "Trust Rooter Plumbing & Drain Cleaning",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "26.2516617",
      "lon": "-80.1659037",
      "cityname": "Pompano Beach",
      "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": ""
}