Thanks guys for all the responses.
Seems like the general consensus it not to get a ceiling fan from US.

If you guys are wondering which fan I am talking about..here it is
http://www.g2art.com/prod/F803

I have searched high and low on the net and contacted the company but they dun make it for 230V50hz...
My wife loves the design and I like it alot too.

Too bad...

Thanks again for all the advice