The primary objective of this research is to utilize an industrial waste byproduct such as waste foundry sand (WFS) as an alternative for fine aggregate in self-compacting concrete (SCC). This research focuses on the use of WFS in SCC to enhance durability and mechanical properties, to find an alternative for fine aggregate in SCC, to reduce the disposal challenges of WFS, and to make SCC lightweight and environmentally friendly. Initially, WFS was treated with chemical (H2SO4), segregating, and sieving to remove the foreign matter and clay content. For this study, WFS is considered in varying percentages such as 0, 10, 20, 30, 40, and 50. For this investigation, M60 grade SCC is considered as per Indian standards and EFNARC guidelines. After that, this research focuses on tests on various fresh properties of SCC in each batch to find the flowability and passing ability of various mixes prepared using WFS. Similarly, the mechanical properties of SCC such as compressive, flexural, and split tensile strength tests were performed at 7, 28, and 90 days curing periods, respectively. Likewise, durability properties of SCC were found in all the mixes prepared using WFS such as water absorption, sorptivity, resistance to chemical attack, and chloride ion penetration; tests of these properties were performed at 28 and 90 days curing periods, respectively. Based on the experimental investigation of SCC, it was found that WFS can be used in M60 grade SCC as an alternative for fine aggregate up to 30% without compromising much on its properties. Finally, this establishes that using treated WFS in SCC helps in reducing the generation of waste and prevails as a meaningful utilization method. This research will also establish that the use of treated WFS will reduce the density and make SCC a lightweight, green, and sustainable material.