Hummingbird Rooter and Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 327281,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://hummingbirdrooter.com/",
      "title": "Hummingbird Rooter and Plumbing",
      "description": "Hummingbird Rooter & Plumbing is your trusted source for addressing a wide range of plumbing needs, both for residential in commercial properties in Phoenix, AZ. We offer services in all your plumbing repair and installation requirements. Our proficiency extends to various areas, including drain cleaning, septic services, and precise camera-based identification of sewer line issues. Whether it''s a remodeling project or a large-scale commercial construction endeavor, our plumbing services are here to assist. We leverage cutting-edge hydrojetting methods for sewer line maintenance and guarantee top-tier water heater installations and repairs. Call us at (602)-549-1515 for details!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 78136,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-01-02T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 23,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 0,
      "city_id": 0,
      "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": 5732,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c1c33ca2-a94e-11ee-8344-b66e99367f32",
      "subdate": "Jan 02, 2024",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 58
   },
   "visits": {
      "storefront": 58,
      "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": "Hummingbird Rooter&Plumbing is your trusted source for addressing a wide range of plumbing needs, both for residential in commercial properties in Phoenix, AZ. We offer services in all your plumbing repair and installation requirements. Our proficiency extends to various areas, including drain cleaning, septic services, and precise camera-based identification of sewer line issues. Whether it's a remodeling project or a large-scale commercial construction endeavor, our plumbing services are here to assist. We leverage cutting-edge hydrojetting methods for sewer line maintenance and guarantee top-tier water heater installations and repairs. Call us at (602)-549-1515 for details!",
      "service1": "24hr Plumber Near Phoenix, AZ ",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-01-02 09:10:21"
   },
   "location": {
      "uuid": "c1c33ca2-a94e-11ee-8344-b66e99367f32",
      "link_id": 327281,
      "account_id": 78136,
      "company": "",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "",
      "zip": "85012",
      "address": "3191 N Central Ave Suite 183 #3247",
      "phone": "(602)-549-1515 ",
      "fax": null,
      "email": "hummingbirdrooter.marketing@gmail.com",
      "name": "Hummingbird Rooter and Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.4852274",
      "lon": "-112.0737131"
   },
   "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": ""
}