Pump It Up Pump Service, Inc

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345271,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://pumpituppump.com",
      "title": "Pump It Up Pump Service, Inc",
      "description": "Top-Rated Residential Well Service Contractor in Phoenix Arizona specializing in \"out of water\" calls, well pump repair & installation, well rehabilitation, well monitoring, well inspections and well water testing services. *Weekends & After Hours Available for Emergency Well Service Calls Only*.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95966,
      "approve_dt": "2025-10-07T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 990,
      "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": 288,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "827bb4a9-18fc-11f0-a909-b66e99367f32",
      "subdate": "Apr 14, 2025",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 23
   },
   "visits": {
      "storefront": 23,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Residential Water Well Pump Contractor in Phoenix Arizona providing services all over Arizona. Specializing in the following residential well services: well pump repair and installation, well development, well repair and rehab, well water testing, water pump sales, well inspections, flow tests, well abandonment, aquifer test pumping, domestic agricultural water systems, machine shop service, well monitoring and water storage tank installation, replacement and repair. We work directly with manufacturers and distributors to ensure our customers get the best product to be installed. *Weekends&After Hours Available for Emergency Well Service Calls Only*.\r
",
      "service1": "Well Pump Repair",
      "service2": "Well Services",
      "service3": "Well Repair",
      "service4": "Well Inspections Near Me",
      "service5": "Well Water Testing",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-04-14 06:48:44"
   },
   "location": {
      "uuid": "827bb4a9-18fc-11f0-a909-b66e99367f32",
      "link_id": 345271,
      "account_id": 95966,
      "company": "Pump It Up Pump Service, Inc",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "990",
      "zip": "85043",
      "address": "2849 S 49th Ave",
      "phone": "623-582-5069",
      "fax": null,
      "email": "pumpituppumpserviceinc@outlook.com",
      "name": "Pump It Up Pump Service, Inc",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.4202732",
      "lon": "-112.1651903",
      "cityname": "Phoenix",
      "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": ""
}