To achieve efficient and durable consolidation of weathered sandstone, the selection of a suitable consolidant is essential. To reasonably assess the suitability of different formulations, it is fundamental to compare their performance as a consolidant within a substrate, which reliably models the properties of deteriorated material. As a test substrate, the sandstone from quarries in Mšené in central Bohemia was selected, for its developed porosity and relatively low mechanical strength. To obtain relevant comparison of their application potential, both commercial (Remmers KSE OH and Surfapore) and self-developed consolidants were included. To test the long-term stability of each consolidant, the stone was subjected to accelerated weathering. The characterization of texture properties was based on the physical sorption of nitrogen and krypton, mercury intrusion porosimetry and water uptake. While the mechanical properties in microscale were determined by nanoindentation, the mechanical strength in macroscale before and after consolidation was measured by drilling resistance. Both commercial exhibited good mechanical performance with reasonable durability. The performance of our developed samples was comparable or, in some cases, superior. Very interesting were the consolidants containing TiO2 and ZnO nanoparticles, the former exhibiting comparable degree of consolidation and durability as commercial ones, with additional photocatalytic function, the latter unusually high increase in the mechanical strength, even after the weathering test. The diammonium hydrogen phosphate based consolidant showed exceptional durability in the weathering test, which makes it a promising product not only for carbonate but also sandstone materials.