10 years of renting, finally pulling the trigger

2BHK ya 3BHK, Chandigarh mein kya lena better hai, especially for a first-time buyer like me? Fed up of renting, ab finally apna ghar lena hai. Mera budget around ₹90L-₹1.5Cr hai. Mohali, Aerocity ya Sector 49 mein dekh raha hoon. Log bolte hain 2BHK ka rental yield accha hota hai, par 3BHK ki appreciation better hogi kya? Kya aap log ka experience hai? Which option makes more sense for long-term value?