Shree Apartment: Who's actually living there?

My loan pre-approval is set for Ghaziabad and I'm seriously looking at Shree Apartment. Honestly, everyone talks about capital appreciation, but I'm worried about the investor-to-end-user ratio there. It feels like a lot of units are bought just for investment. Is it just me, or is there a real risk of it turning into a 'ghost society' with low occupancy? That affects everything, right? And on rentals, what's the actual ground reality? I'm seeing projections, but what can one *really* expect for a 2BHK? Are people getting decent tenants, or is it a struggle to even cover EMI? Also, the resale market. If I need to exit in 5-7 years, how liquid is it? Will there be actual buyers, or will I be stuck competing with a hundred other investors trying to sell? Change my mind if I'm wrong, but I'm feeling a bit skeptical about the long-term livability and resale potential here.