Bro in my opinion, you should consider the following:
CNG Compatibles Sedan:
i) Lancer fits ur budget & fulfills most of ur requirements except resale (though sells but not as good as corolla or honda) + maintenance.
ii). Civic 05 eagle eyes fulfills all ur requirements but u must compromise on 4 years older car now.
CNG not supported:
iii) City Vario 08, if you can afford petrol then opt for City it fulfills most of ur requirements except CNG. BTW it has good fuel consumption as well.
Hatchbacks with CNG not supported:
a) Swift but auto tranny will be 1.2m or above, vitz.
b) There's one station wagon pretty much similar to Honda Airwave made by either Mazda Or Mitsubishi, loaded version with elegant & attractive shape & cabin. Fresh clear will cost ard 1.15 - 1.2 million. M not sure abt the cng feature but it certainly fulfills most of ur requirements even the resale as they are rare + it will probably be brand new so hopefully won't truble you at least for the first 2 years provided driven & maintained sensibly after specified intervals.