recherche terrain recherche terrain

Plus de critères
de critères
Budget
Surface

0 terrain à vendre disponible sur BERRE L ETANG ()

0 terrains en Lotissements &
0 terrains en Individuels

Terrains constructibles à 15km de Berre L Etang :

    Erreur SQL !
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ( ( Type != 'TerrainMaison' AND NbDispo > 0 AND D' at line 4
    SELECT * FROM ( SELECT Terrains.Ville, Terrains.CodePostal, SUM(Terrains.NbDispo) AS TotalLots FROM Terrains WHERE Disponible = 'OUI' AND 1 AND (Dpt = '94') AND Id IN () AND ( ( Type != 'TerrainMaison' AND NbDispo > 0 AND DateModif > (CURDATE() - INTERVAL 29 WEEK) OR ( Type = 'TerrainMaison' AND Paye = 'OUI' AND DateDebut <= CURDATE() AND DateFin >= CURDATE() ) ) ) GROUP BY Ville ORDER BY TotalLots DESC LIMIT 0,36 ) AS Principal ORDER BY Principal.Ville ASC