This study explores the longstanding trade-off between sound absorption and compressive strength in cementitious materials by incorporating hollow glass microspheres, cenospheres, and rubber powders through innovative foaming techniques. While traditional approaches to improving acoustic performance often reduce structural integrity, this research achieves both goals simultaneously. Detailed material characterization, including particle size distribution and hydration kinetics, revealed that finer particles promote early hydration and enhance microstructural density, whereas larger particles extend hydration and influence acoustic properties. The combination of macropores and controlled foaming increased sound absorption by 30-35 % while maintaining compressive strength exceeding 50 MPa, far surpassing ASTM C330 standards for lightweight mortars. This work highlights the potential of lightweight, high-performance composites in urban construction and noise mitigation applications, offering an improved balance of mechanical and acoustic properties.