Borehole Pumps: Borehole pumps are specialized to extract water from deep underground resources. These pumps are specifically engineered to work in boreholes, which can be slim, deep wells drilled in to the Earth’s surface area. Sump Pumps: following around the list, Sump Pumps stop flooding and water accumulation in basements or crawl spaces.