Foam cells are primarily located in the intima layer of blood vessels, particularly in areas prone to atherosclerosis such as the coronary arteries and the aorta. They can also be found in other tissues under certain pathological conditions, including chronic inflammation and certain types of infections.