About the location (from Wiki):
Clarke Quay is a historical riverside quay in Singapore, located within the Singapore River Planning Area. The quay is situated upstream from the mouth of the Singapore River and Boat Quay. Clarke Quay was named after Sir Andrew Clarke, Singapore’s second Governor and Governor of the Straits Settlements from 1873 to 1875, who played a key role in positioning Singapore as the main port for the Malay states of Perak, Selangor and Sungei Ujong.

Presently, five blocks of restored warehouses house various restaurants and nightclubs. There are also moored Chinese junks (tongkangs) that have been refurbished into floating pubs and restaurants. The Cannery is one of the anchor tenants of the place. With over 5 different concepts in one block, you’ll be spoilt for options. Another anchor tenant, The Arena, will be home to Singapore’s First Permanent Illusion Show (starting Aug 2008) starring J C Sum and ‘Magic Babe’ Ning. The G-MAX reverse bungee, the first in Singapore, is located at the entrance which opened in November 2003. Notable restaurants and nightclubs include Hooters and Indochine. River cruises and river taxies on the Singapore River can be accessed from Clarke Quay. One of its most popular attractions is its exciting host of CQ’s signature events happening once every quarter.

Movies shot at this location:
Pyaar Impossible song from Pyaar Impossible
Mudhal Penn NeeyE song from Thambikku Indha Ooru