Dimensional stones are natural stones with unique patterns, radiant colors, and different textures used majority for flooring and cladding of the building. Due to their strong, durable properties, they can be easily transformed into different sizes to be used for various construction works. Because of this, a huge amount of waste is generated, leading to environmental pollution. The presented research focuses on the effect of various properties, i.e., Workability in the fresh state, Mechanical and Water Permeability properties at the hardened state of Dimensional Limestone Slurry Waste (DLSW) incorporating in Self-Compacting Concrete (SCC) as a replacement of Fine Aggregates (FA) up to 100%. Seven mixes were generated and examined by substituting fine aggregate with 0%, 15%, 30%, 45%, 60%, 80%, and 100% DLSW. The workability criteria were fulfilled by varying the dose of SP (Superplasticizer), and all the modified SCC series were developed as per the guidelines of EFNARC 2005. The compressive strength was improved up to 45% replacement. The optimum workability, mechanical, and permeability parameters were found at 30% replacement of DLSW.