Is the Rav4 still a good buy? Planning to replace my flooded but casa restored 2008 Mazda 3 to a 2004 Rav4 4x4 A/T. Do you think this is a good idea?

Rav4 is still priced at 570k. Well, my Mazda 3 has lost its value big time.