The increasing demand for cement cannot be adequately met by relying solely on Ordinary Portland Cement (OPC). To address this demand while ensuring the durability of eco-friendly concrete, it has become essential to incorporate mineral additives and by-products as substitutes, enhancing performance without compromising quality. In the construction industry, OPC and river sand are critical materials, yet they are increasingly scarce and limited in availability. Moreover, cement is a significant contributor to carbon dioxide (CO2) emissions. Consequently, the partial replacement of cement and natural sand in concrete with waste materials or by-products has become imperative, ensuring the quality of the final product remains uncompromised. The partial substitution of OPC with Metakaolin (MK) and Silica Fume (SF), along with the use of 100% manufactured sand (MS) as a replacement for natural sand, has been implemented successfully. Utilizing 100% MS in combination with OPC and SF has produced more durable concrete with reduced chloride ingress and improved performance compared to concrete made with 100% river sand. In addition to cost benefits, this study mitigates river sand depletion and addresses environmental and sustainability concerns, making a significant contribution to the advancement of green concrete.