Service Squad

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 333110,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.callservicesquad.com/",
      "title": "Service Squad",
      "description": "When unexpected plumbing issues arise in Pasadena, CA, homeowners and businesses alike turn to Service Squad, a trusted Plumbing Company ready to address all their plumbing needs. Our skilled professionals are equipped to handle a vast array of plumbing services, from fixing leaky faucets to unclogging drains and everything in between. With a commitment to quality and customer satisfaction, Service Squad ensures that every job is completed with the utmost precision and care. We understand the urgency that comes with plumbing problems, that's why we're dedicated to providing timely and efficient solutions that minimize disruptions to your daily routine. Our team is well-versed in local plumbing codes and can tackle any challenge with confidence. Whether you're dealing with an emergency or planning maintenance, our Plumbing Company stands ready to bring you peace of mind with exceptional service right here in Pasadena.\n
\n
\nCompany Email: Info@callservicesquad.com\n
\n
\nCompany Hours: Monday to Friday: 07:00-20:00, Saturday, Sunday: Closed",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 83887,
      "approve_dt": "2025-10-08T00:00:00.000Z",
      "source": null,
      "submit_dt": "2024-07-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 7,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2337,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "7b293f87-446d-11ef-8344-b66e99367f32",
      "subdate": "Jul 17, 2024",
      "subcategory": "Home Plumbing",
      "request_types": "",
      "visitcount": 15
   },
   "visits": {
      "storefront": 15,
      "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": "Service Squad is a locally owned and operated full-service plumbing company serving Pasadena, CA, and surrounding areas for over 25 years. They offer 24/7 emergency plumbing services and specialize in trenchless solutions. Their prompt, professionally trained, and fully equipped team delivers reliable results for all residential and commercial plumbing needs with a commitment to excellent service and customer satisfaction.",
      "service1": "24/7 Emergency Plumbing",
      "service2": " Trenchless Pipe Repair",
      "service3": " Drain Cleaning",
      "service4": " Water Heater Services",
      "service5": " Pipe Repair and Replacement",
      "service6": " Plumbing Maintenance",
      "service7": " Sewer Line Services",
      "submit_dt": "2024-07-17 18:50:48"
   },
   "location": {
      "uuid": "7b293f87-446d-11ef-8344-b66e99367f32",
      "link_id": 333110,
      "account_id": 83887,
      "company": "Service Squad",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2337",
      "zip": "91101",
      "address": "680 E Colorado Blvd, Suite 180",
      "phone": "(626) 333-6519",
      "fax": null,
      "email": "servicesquadCA@outlook.com",
      "name": "Service Squad",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "34.1470005",
      "lon": "-118.0690249",
      "cityname": "Pasadena",
      "statename": "California"
   },
   "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": ""
}