After youve been through the R&Rs, in 500k it depends what youre looking for. If a used car is okay, your best is either:
-97/98 Honda Civic
-02/03 Toyota Vitz
Both run well on CNG, are nice cars and are much better than other competitors such as 04/5 Cultus, Alto or even a brand new AC & CNGed Mehran.