Our principle achievement has been to explore, characterize and summarize the effect of frustration in the correlated system using real space techniques which captures spatial correlations well. Magnetic frustration has been the common feature in all the electronic systems that we reported. The general consequence is that the stability of AF phases gets suppressed which seen in T scales, and through emergence of complex non-collinear, and frozen `spin-glass’ phases. In the Mott systems close to transition, in addition to this also see the impact of magnetic frustration in spectral features, and transport. We have been able to connect them closely to available experiments in the Mott systems.