Patriot Plumbing & Rooter

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346785,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "http://patriotrooter.com/",
      "title": "Patriot Plumbing & Rooter",
      "description": "Patriot Plumbing in Irvine, CA, ensures high-quality plumbing repairs and installations. Their experienced team is dedicated to excellence.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97480,
      "approve_dt": "2025-07-30T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2055,
      "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": "4c401f0c-2f6d-11f0-a909-b66e99367f32",
      "subdate": "May 12, 2025",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 8
   },
   "visits": {
      "storefront": 8,
      "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": "Patriot Plumbing is a trusted, family-run plumbing business based in Irvine, proudly serving Orange County and South Bay/Los Angeles with specialists who bring extensive knowledge and experience to all your plumbing needs. Our commitment goes beyond just fixing problems—we promise to deliver the best service possible at affordable prices, only charging customers when we provide successful solutions. We stand behind our work with the longest guarantees in the industry, show up on time, and keep our promises while walking you through needed repairs and options. Available 24/7 for emergency services, we combine professional expertise with personal accountability to ensure your plumbing issues are resolved correctly the first time.",
      "service1": "emergency plumbing repairs",
      "service2": " drain cleaning",
      "service3": " water heater installation",
      "service4": " pipe repair",
      "service5": " toilet installation",
      "service6": " leak detection",
      "service7": " sewer line ",
      "submit_dt": "2025-05-12 20:11:32"
   },
   "location": {
      "uuid": "4c401f0c-2f6d-11f0-a909-b66e99367f32",
      "link_id": 346785,
      "account_id": 97480,
      "company": "Patriot Plumbing & Rooter",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2055",
      "zip": "92618",
      "address": "18 Technology Dr Ste 129",
      "phone": "(949) 502-3354",
      "fax": null,
      "email": "patriotrootermarketing@gmail.com",
      "name": "Patriot Plumbing & Rooter",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.6514211",
      "lon": "-117.7372457",
      "cityname": "Irvine",
      "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": ""
}