I need a CPE with a wireless mode that supports Access point and Station mode on a single unit.

All Mikrotik devices with wireless interfaces running the latest ROS should be able to do this. You only have to create virtual interfaces and place the interfaces on the modes you desire. But note that all the virtual interfaces run on the same Band, Channel width, and Frequency.

Is there any other vendor you can recommend? i want to have an alternative.

Because this is a Mikrotik forum, we are talking about Mikrotik products.

Is there any other vendor you can recommend? i want to have an alternative.

Mikrotik will not just give you the best performance but also at the best price. What do you want to achieve?

I want to setup hotspot at various locations, so instead of using two CPEs one as station and the other as access point, I would like to use 1 CPE that can do the functions of using two CPEs.

http://i.mt.lv/routerboard/files/NetBox ... 134946.pdf
http://i.mt.lv/routerboard/files/NetMet ... 140608.pdf
Is a start.

Thanks..... could you please upload a diagram or details on how to set this up?

Thanks..... could you please upload a diagram or details on how to set this up?

I suggest you first send a diagram of what you want to achieve so that we can guide you through on how to achieve it if possible.