Lady in the Water is a 2006 thriller/fantasy film written, produced, and directed by M. Night Shyamalan and also produced by Sam Mercer and Jose L. Rodriguez. It was released in the United States on July 21, 2006, distributed by Warner Bros., and rated PG-13 by the MPAA for some frightening sequences. It was listed by Variety as one of the ten "biggest (financial) losers" of 2006.
The movie was originally planned for Disney. Shyamalan left the studio after production president Nina Jacobson and others became highly critical of his script, and brought it to Warner Bros.
Shyamalan, who shoots in and around his hometown of Philadelphia, established a production facility at the Jacobson Logistics warehouse site in nearby Levittown, Pennsylvania, where sets for the apartment complex and a half city block of row houses were built. Occasional footage was shot inside the overflow area of the warehouse. Most of the filming was completed after work hours.
In its opening weekend (21-23 July 2006), the film grossed a total of $18.2 million, placing third in the United States box office results for that weekend. It was M. Night's lowest opening for any of his five major films. Due to negative reviews and poor word-of-mouth, its second week fell sharply to $7.1 million, pushing its total to only $32.2 million. Its third weekend was no better, falling another 62.1% to $2.7 million. As of September 14, 2006, its total was $42.285 million. In addition, the film only made $30.5 million in the foreign box office, pulling its tally to approximately $72.785 million internationally. The movie had an estimated budget of $70 million for production and a further $70 million in advertising costs.Wikipedia