Rooter Hero® Plumbing East Bay

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317989,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://rooterhero.com/locations/northern-california/san-mateo/",
      "title": "Rooter Hero® Plumbing East Bay",
      "description": "Call (844) 219-2215 to fix any plumbing issue from leaky faucets to septic systems or to replace an entire sewer line in San Mateo, CA, with less downtime.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69183,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-11-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 195,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2466,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/rooterhero",
      "googleplus": "https://g.page/rooter-hero-plumbing-east-bay",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "https://rooterhero.com/blog",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 4974,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9572c543-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 10, 2019",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 296
   },
   "visits": {
      "storefront": 296,
      "articles": 0,
      "videos": 0,
      "reviews": 22,
      "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": "Rooter Hero Plumbing East Bay is a San Mateo CA s fast and reliable plumbing destination! We offer fast and reliable services for all types of plumbing issues for domestic, commercial, and industrial sectors. Our 24 X7 hour emergency plumbers in San Mateo CA are available round-the-clock, be it day or night. You can fully rely on Rooter Hero Plumbing East Bay when you face plumbing issues. No matter where you live in San Mateo, we can have a plumber to your home in no time. Do you have leaking pipes or clogged drains? You might need to employ the help of Rooter Hero Plumbing East Bay. To learn more, contact us at (510) 298-1492 or visit https://rooterhero.com/locations/northern-california/san-mateo/",
      "service1": "Plumbing East Bay",
      "service2": "Drain Cleaning East Bay",
      "service3": "Sewer Repair East Bay",
      "service4": "Emergency Plumbing East Bay",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-11-10 13:39:43"
   },
   "location": {
      "uuid": "9572c543-56da-11ed-b77c-b66e99367f32",
      "link_id": 317989,
      "account_id": 69183,
      "company": "Rooter Hero® Plumbing East Bay",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2466",
      "zip": "94577",
      "address": "10956 Bigge St",
      "phone": "(510) 298-1492",
      "fax": null,
      "email": "RooterheroEB@gmail.com",
      "name": "Rooter Hero® Plumbing East Bay",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.7261154",
      "lon": "-122.1859709",
      "cityname": "San Leandro",
      "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": ""
}