All Spaniards are entitled to enjoy decent and adequate housing. The public authorities shall promote the necessary conditions and shall establish appropriate standards in order to make this right effective, regulating land use in accordance with the general interest in order to prevent speculation.
It does not mean you have the right to live in a flat en La Castellana for whatever you want pay. It means the State has to implement policies to help people access housing.
Also, article 33 give citizens the right to private property. You cannot come squat in my house because article 33 should prevent it, even when article 47 exists.
Let's avoid considering outliers to maintain a balanced discussion.
While I don't believe anyone has the right to live in Castellana or the Royal Palace, it also wouldn't be fair to require someone to move to the desert to find a home.
Article 47 of Spanish Constitution:
All Spaniards are entitled to enjoy decent and adequate housing. The public authorities shall promote the necessary conditions and shall establish appropriate standards in order to make this right effective, regulating land use in accordance with the general interest in order to prevent speculation.