Latest (2014) Phones with QWERTY keyboards, 1GB RAM and front camera.

http://imgur.com/yMhlFea

This is a screen cap. If you want the excel sheet, leave a comment. If you upload it somewhere else, please do share the link here.

There no new QWERTY phones in the market. We are the small group who likes tactile feedback while typing.

I really hope to see a all rounder Windows phone with QWERTY.