Water Pump Services Company | HVAC, Fire Pumps

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 313325,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "http://www.callaghanpump.com/",
      "title": "Water Pump Services Company | HVAC, Fire Pumps",
      "description": "Callaghan Pumps and Controls Inc. is one of the most renowned names when it comes to Water Pump Services, HVAC Sales and Service, Fire Pumps, and Booster Pump Sales.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 64554,
      "approve_dt": "2018-03-20T00:00:00.000Z",
      "source": null,
      "submit_dt": "2017-05-25T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 591,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 29,
      "city_id": 0,
      "ltop": "",
      "facebook": "http://facebook.com/",
      "tiktok": null,
      "linkedin": "http://linkedin.in/",
      "twitter": "http://twitter.com/",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "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": 6601,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "955a8fda-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 25, 2017",
      "subcategory": "HVAC",
      "request_types": "",
      "visitcount": 780
   },
   "visits": {
      "storefront": 780,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "If you want service, experience, competence, reliability, and quality products, then Callaghan Pump and Controls is the answer for all of your pumping needs. Callaghan Pump and Controls has been serving the greater New York Metropolitan area for over 14 years. Featured projects to which we have supplied pumps include the world’s largest package fire pump system (located at JFK), all of the pumps that kept the Lincoln Tunnel dry and open during Super Storm Sandy, and supplied pumps for the Brookhaven National Laboratory’s Ion Collider. ",
      "service1": "Aurora Pump NYC",
      "service2": "Gorman-Rupp Pumps NYC",
      "service3": "packaged fire pump systems",
      "service4": "End Suction Pumps",
      "service5": "HVAC Pumps",
      "service6": "",
      "service7": "",
      "submit_dt": "2017-05-25 07:27:20"
   },
   "location": {
      "uuid": "955a8fda-56da-11ed-b77c-b66e99367f32",
      "link_id": 313325,
      "account_id": 64554,
      "company": "Water Pump Services Company | HVAC, Fire Pumps",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 29,
      "city": "",
      "zip": "07601",
      "address": "106 Hobart Street",
      "phone": "201-621-0505",
      "fax": null,
      "email": "callaghanpump01@gmail.com",
      "name": "Water Pump Services Company | HVAC, Fire Pumps",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.87501",
      "lon": "-74.050229"
   },
   "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": ""
}