JB Water & Air

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349904,
      "site_id": 58,
      "cat_id": 53,
      "priority": 0,
      "url": "https://www.jbwaterandair.com/",
      "title": "JB Water & Air",
      "description": "At JB Water & Air, we bring over 40 years of trusted experience to residential & commercial customers in Mesa, AZ & surrounding areas. As a leading provider of plumbing, HVAC, & water treatment solutions, we’re proud to offer fast, reliable service—including 24/7 emergency HVAC and plumbing repairs. From AC repair, maintenance, and installation to heating repair, water heater service, leak detection, and repiping. We specialize in drain cleaning, pipe repair and replacement, sewer and water line services, and expert fixture installation. Our advanced water treatment systems include reverse osmosis, water distillation, and more. Whether you need help with your home or business, JB Water & Air delivers workmanship & honest service every time.\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100599,
      "approve_dt": "2025-09-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-08-31T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 961,
      "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": 4218,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "59d405ff-86bf-11f0-bb42-b66e99367f32",
      "subdate": "Aug 31, 2025",
      "subcategory": "Air Conditioning",
      "request_types": "",
      "visitcount": 50
   },
   "visits": {
      "storefront": 50,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 22,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At JB Water & Air, we bring over 40 years of trusted experience to residential & commercial customers in Mesa, AZ & surrounding areas. As a leading provider of plumbing, HVAC, & water treatment solutions, we’re proud to offer fast, reliable service—including 24/7 emergency HVAC and plumbing repairs. From AC repair, maintenance, and installation to heating repair, water heater service, leak detection, and repiping. We specialize in drain cleaning, pipe repair and replacement, sewer and water line services, and expert fixture installation. Our advanced water treatment systems include reverse osmosis, water distillation, and more. Whether you need help with your home or business, JB Water & Air delivers workmanship & honest service every time.\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t",
      "service1": "water distillation systems",
      "service2": " plumbing services",
      "service3": " water treatment solutions",
      "service4": " water quality testing",
      "service5": " system installation",
      "service6": " equipment maintenance",
      "service7": " water purification consultation",
      "submit_dt": "2025-08-31 23:08:05"
   },
   "location": {
      "uuid": "59d405ff-86bf-11f0-bb42-b66e99367f32",
      "link_id": 349904,
      "account_id": 100599,
      "company": "JB  Water Air",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "961",
      "zip": "85215",
      "address": "3932 E Presidio St.",
      "phone": "480-969-3193",
      "fax": null,
      "email": "marketingjbwaterandair1@gmail.com",
      "name": "JB Water & Air",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Mesa",
      "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": ""
}