query: On June 2003, who was elected Mayor of Pescara and was re-confirmed in what year and left the office on what date?
answer: On June 2003, D'Alfonso was elected Mayor of Pescara and was re-confirmed in 2008 and left the office on January 2009.