SERCA pumps are primarily located in the membranes of the sarcoplasmic reticulum in muscle cells and the endoplasmic reticulum in other cell types. They are abundant in excitable cells like cardiomyocytes and skeletal muscle cells, but they are also found in non-excitable cells such as hepatocytes and neurons.