Plumber Peoria AZ

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317584,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "http://www.royalflushplumbingpeoriaaz.com",
      "title": "Plumber Peoria AZ",
      "description": "Have your water, drain leakages fixed, boilers, water heaters installed and serviced. Get quality plumbing services from Royal Flush Plumbing Peoria AZ.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68782,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-08-13T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 128,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 988,
      "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": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95708bff-56da-11ed-b77c-b66e99367f32",
      "subdate": "Aug 13, 2019",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 151
   },
   "visits": {
      "storefront": 151,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "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": "Royal Flush Plumbing Peoria AZ are licensed domestic and commercial plumbers equipped to offer an extensive range of specialist services as listed below. Royal Flush Plumbing Peoria AZ offers quality plumbing services to Peoria, AZ including commercial and residential installation, repair and more!",
      "service1": "Grease Traps",
      "service2": "Pipe Inspection",
      "service3": "Sewer and Drain Cleaning",
      "service4": "Bathroom and Kitchen Plumbing",
      "service5": "Water Heaters",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-08-13 11:48:59"
   },
   "location": {
      "uuid": "95708bff-56da-11ed-b77c-b66e99367f32",
      "link_id": 317584,
      "account_id": 68782,
      "company": "Plumber Peoria AZ",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "988",
      "zip": "85382",
      "address": "8615 W Paradise Ln",
      "phone": "",
      "fax": null,
      "email": "Andre-Remmersa@outlook.com",
      "name": "Plumber Peoria AZ",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.6326092",
      "lon": "-112.2429424",
      "cityname": "Peoria",
      "statename": "Arizona"
   },
   "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": ""
}