Cosmological exact solutions of Petrov type D: singularities, double singularities of a non-lineal fluid state and final dark energy