Unconsolidated formation sand in the near wellbore region may be uniformly consolidated using a system including a sodium silicate solution and a hardener, such as at least one dialkyl ester of a dicarboxylic acid. Subsequently, a low concentration acid, such as hydrofluoric (HF) acid, is pumped through and into the consolidated sand to create channels or passageways to connect the formation hydrocarbons with the wellbore for production of the hydrocarbons through the wellbore. Hydrofluoric acid may be generated in situ by hydrolyzing a substance to hydrofluoric acid where the substance may include ammonium bifluoride, ammonium fluoride, alkali metal fluorides, alkali metal bifluorides, transition metal fluorides, and the like, and mixtures thereof. The acid may instead or additionally include organic acids and other mineral acids.