Rooter Hero® Plumbing Orange County

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317983,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://rooterhero.com/orange-county/",
      "title": "Rooter Hero® Plumbing Orange County",
      "description": "Looking for Plumbing Services in Orange County? Call (844) 219-2215 to get an insured plumber to your home on time and get the issues fixed with little downtime.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69177,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-11-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 795,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1633,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/rooterhero",
      "googleplus": "https://goo.gl/maps/dij99FNFWq2SdjP2A",
      "youtube_channel": "https://www.youtube.com/channel/UCKWH9U_3URmOJlLezFYt1QA",
      "youtube": "https://www.youtube.com/channel/UCKWH9U_3URmOJlLezFYt1QA",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9572bd5b-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 08, 2019",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 1124
   },
   "visits": {
      "storefront": 1124,
      "articles": 0,
      "videos": 250,
      "reviews": 26,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Rooter Hero Plumbing Orange County is a local plumbing company based in Orange County that offers a high standard of workmanship with a personal touch. We specialize in a range of different services from gas fitting, residential and commercial, kitchen renovations, bathroom renovations, maintenance plumbing, blocked drains, hot water systems, and much more to list.  With a team of highly skilled and knowledgeable plumbers at our disposal, no job is ever deemed too small or large, and we take great pleasure rectifying any problem associated with plumbing. For the best commercial and residential plumbing solution in Orange County, contact our experts now! To learn more, contact us at (949) 329-2066 visit https://rooterhero.com/orange-county/",
      "service1": "Plumbing Orange County",
      "service2": "Drain Cleaning Orange County",
      "service3": "Sewer Repair Orange County",
      "service4": "Emergency Plumbing Orange County",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-11-08 12:45:49"
   },
   "location": {
      "uuid": "9572bd5b-56da-11ed-b77c-b66e99367f32",
      "link_id": 317983,
      "account_id": 69177,
      "company": "Rooter Hero® Plumbing Orange County",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1633",
      "zip": "92805",
      "address": "1328 South Allec Street",
      "phone": "(949) 329-2066",
      "fax": null,
      "email": "RooterheroOC@gmail.com",
      "name": "Rooter Hero® Plumbing Orange County",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.8156641",
      "lon": "-117.8997717",
      "cityname": "Anaheim",
      "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": 1
      },
      {
         "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": ""
}