7 avenue du Maréchal de Lattre de Tassigny
44400 Rezé
Tél. 02 40 75 75 50
Fax 02 40 75 14 30
atoutsud.immobilier@wanadoo.fr
44400 Rezé
Tél. 02 40 75 75 50
Fax 02 40 75 14 30
atoutsud.immobilier@wanadoo.fr
DB function failed with error number 1064
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 'order by LoyerNet, Charges asc limit 0, 1' at line 1 SQL=select b.CodeBien, b.CodeAgence, b.CodePostal, b.VillePublique as Villes, b.NombrePieces, b.Ville, b.Secteur, b.Quartier, b.Type, b.Style, b.PrixAnnonce, b.PasDePorte, b.MemoLibre, b.MemoLibre1, b.MemoLibre2, b.MemoLibre3, b.MemoLibre4, b.MemoLibre5, b.MemoLibre6, b.MemoLibre7, b.ListeDesPieces, b.ListeDesPieces1, b.ListeDesPieces2, b.ListeDesPieces3, b.ListeDesPieces4, b.ListeDesPieces5, b.ListeDesPieces6, b.ListeDesPieces7, b.Reference, b.DatePublication, b.Surface, b.Modele, b.NombrePieces, b.Saison, b.NombreChambres, b.Reception, b.NombreEtages, b.Etage, b.Ascenseur, b.Interphone, b.Exposition, b.Chauffage, b.Terrasse, b.SurfaceTerrasse, b.Garage, b.Places, b.Cave, b.Terrain, b.Jardin, b.Facade, b.Retrait, b.Cos, b.Environnement, b.Eau, b.Gaz, b.Electricite, b.Assainissement, b.Disponibilite, b.CodeNego, b.PositionVente, b.Mandat, b.TexteLibre1, b.TexteLibre2, b.TexteLibre3, b.TexteLibre4, b.BaisseDePrix, b.DateBaisseDePrix, b.DatePublication, b.Annee, b.Mitoyennete, b.DPE, b.DPEconsommation, b.DPEemissionGaz, b.DPEconsommationValeur, b.DPEemissionGazValeur, b.Description, b.Toiture, b.TaxeFonciere, b.LoyerNet, b.Charges, b.HonorairesLocation, b.MD5Image1, b.MD5Image2, b.MD5Image3, b.MD5Image4, b.MD5Image5, b.MD5Image6, b.MD5Image7, b.MD5Image8, b.MD5Image9, b.MD5Image10, b.MD5Image11, b.MD5Image12, b.MD5Image13, b.MD5Image14, b.MD5Image15, b.MD5Image16, b.MD5Image17, b.MD5Image18, b.MD5Image19, b.MD5Image20, b.TransfertInternetImage1, b.TransfertInternetImage2, b.TransfertInternetImage3, b.TransfertInternetImage4, b.TransfertInternetImage5, b.TransfertInternetImage6, b.TransfertInternetImage7, b.TransfertInternetImage8, b.TransfertInternetImage9, b.TransfertInternetImage10, b.TransfertInternetImage11, b.TransfertInternetImage12, b.TransfertInternetImage13, b.TransfertInternetImage14, b.TransfertInternetImage15, b.TransfertInternetImage16, b.TransfertInternetImage17, b.TransfertInternetImage18, b.TransfertInternetImage19, b.TransfertInternetImage20, a.Nom, a.Adresse1, a.Adresse2, a.CodePostal as CpAg, a.Ville as VilleAg, a.LigneTelFax, a.SiteWeb from agence a, bien b where b.CodeAgence=a.CodeAgence and a.BiensAfficherSurImmoStore=1 and a.Bloquee=0 and a.SiteTest=0 and b.PublicationSurImmoStore=1 and b.VillePublique is not null and b.MemoLibre is not null and b.Type is not null and (b.VillePublique <>'') and( b.MemoLibre <>'') and (b.Type <>'') and b.CodeAgence like '44ASIM%' and ((b.PositionLocation='Libre') and Location=1) and Modele < 5 order by order by LoyerNet, Charges asc limit 0, 1
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 'order by LoyerNet, Charges asc limit 0, 1' at line 1 SQL=select b.CodeBien, b.CodeAgence, b.CodePostal, b.VillePublique as Villes, b.NombrePieces, b.Ville, b.Secteur, b.Quartier, b.Type, b.Style, b.PrixAnnonce, b.PasDePorte, b.MemoLibre, b.MemoLibre1, b.MemoLibre2, b.MemoLibre3, b.MemoLibre4, b.MemoLibre5, b.MemoLibre6, b.MemoLibre7, b.ListeDesPieces, b.ListeDesPieces1, b.ListeDesPieces2, b.ListeDesPieces3, b.ListeDesPieces4, b.ListeDesPieces5, b.ListeDesPieces6, b.ListeDesPieces7, b.Reference, b.DatePublication, b.Surface, b.Modele, b.NombrePieces, b.Saison, b.NombreChambres, b.Reception, b.NombreEtages, b.Etage, b.Ascenseur, b.Interphone, b.Exposition, b.Chauffage, b.Terrasse, b.SurfaceTerrasse, b.Garage, b.Places, b.Cave, b.Terrain, b.Jardin, b.Facade, b.Retrait, b.Cos, b.Environnement, b.Eau, b.Gaz, b.Electricite, b.Assainissement, b.Disponibilite, b.CodeNego, b.PositionVente, b.Mandat, b.TexteLibre1, b.TexteLibre2, b.TexteLibre3, b.TexteLibre4, b.BaisseDePrix, b.DateBaisseDePrix, b.DatePublication, b.Annee, b.Mitoyennete, b.DPE, b.DPEconsommation, b.DPEemissionGaz, b.DPEconsommationValeur, b.DPEemissionGazValeur, b.Description, b.Toiture, b.TaxeFonciere, b.LoyerNet, b.Charges, b.HonorairesLocation, b.MD5Image1, b.MD5Image2, b.MD5Image3, b.MD5Image4, b.MD5Image5, b.MD5Image6, b.MD5Image7, b.MD5Image8, b.MD5Image9, b.MD5Image10, b.MD5Image11, b.MD5Image12, b.MD5Image13, b.MD5Image14, b.MD5Image15, b.MD5Image16, b.MD5Image17, b.MD5Image18, b.MD5Image19, b.MD5Image20, b.TransfertInternetImage1, b.TransfertInternetImage2, b.TransfertInternetImage3, b.TransfertInternetImage4, b.TransfertInternetImage5, b.TransfertInternetImage6, b.TransfertInternetImage7, b.TransfertInternetImage8, b.TransfertInternetImage9, b.TransfertInternetImage10, b.TransfertInternetImage11, b.TransfertInternetImage12, b.TransfertInternetImage13, b.TransfertInternetImage14, b.TransfertInternetImage15, b.TransfertInternetImage16, b.TransfertInternetImage17, b.TransfertInternetImage18, b.TransfertInternetImage19, b.TransfertInternetImage20, a.Nom, a.Adresse1, a.Adresse2, a.CodePostal as CpAg, a.Ville as VilleAg, a.LigneTelFax, a.SiteWeb from agence a, bien b where b.CodeAgence=a.CodeAgence and a.BiensAfficherSurImmoStore=1 and a.Bloquee=0 and a.SiteTest=0 and b.PublicationSurImmoStore=1 and b.VillePublique is not null and b.MemoLibre is not null and b.Type is not null and (b.VillePublique <>'') and( b.MemoLibre <>'') and (b.Type <>'') and b.CodeAgence like '44ASIM%' and ((b.PositionLocation='Libre') and Location=1) and Modele < 5 order by order by LoyerNet, Charges asc limit 0, 1
L'agence immobilière Atout Sud ne présente actuellement aucun bien correspondant à vos critères de recherche.
Veuillez modifier ces derniers puis effectuer une nouvelle recherche.
Veuillez modifier ces derniers puis effectuer une nouvelle recherche.
7 avenue du Maréchal de Lattre de Tassigny
-
44400 Rezé
-
Tél. 02 40 75 75 50
-
Fax 02 40 75 14 30
-
atoutsud.immobilier@wanadoo.fr
-
Mentions légales
