Ancien
Neuf
Logement étudiant
Maison
Appartement
Terrain
T1
T2
T3
T4 et +
NORD / SAINTE MARIE
Appartement T4 de 92 m²
-
941€
NORD / SAINTE MARIE
Appartement T3 de 71 m²
-
726€
(default) 5 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Ville`.`id`, `Ville`.`label`, `Ville`.`country_id`, `Country`.`id`, `Country`.`label` FROM `villes` AS `Ville` LEFT JOIN `countries` AS `Country` ON (`Ville`.`country_id` = `Country`.`id`) WHERE `Ville`.`country_id` = 1 13130
2SELECT `Ville`.`id`, `Ville`.`label`, `Ville`.`country_id`, `Country`.`id`, `Country`.`label` FROM `villes` AS `Ville` LEFT JOIN `countries` AS `Country` ON (`Ville`.`country_id` = `Country`.`id`) WHERE `Ville`.`country_id` = 1 13130
3SELECT `Bien`.`id`, `Bien`.`type_id`, `Bien`.`program_id`, `Bien`.`code`, `Bien`.`nature`, `Bien`.`prestation`, `Bien`.`commodite`, `Bien`.`prix`, `Bien`.`prix_hcc`, `Bien`.`prix_charge`, `Bien`.`toem`, `Bien`.`prix_remise`, `Bien`.`surface`, `Bien`.`photo`, `Bien`.`photo2`, `Bien`.`photo3`, `Bien`.`photo4`, `Bien`.`video`, `Bien`.`commentaire`, `Bien`.`etage`, `Bien`.`nb_piece`, `Bien`.`studio`, `Bien`.`duplex`, `Bien`.`neuf`, `Bien`.`created`, `Bien`.`modified`, `Bien`.`ville_id`, `Bien`.`num_lot`, `Bien`.`num_appart`, `Bien`.`num_batiment`, `Bien`.`num_parking`, `Bien`.`surface_defiscalisable`, `Bien`.`defisc_annuelle_girardin`, `Bien`.`montant_defiscalisable_girardin`, `Bien`.`defiscalisation_annuelle_scellier`, `Bien`.`montant_defiscalisable_scellier`, `Bien`.`status`, `Bien`.`zone`, `Bien`.`fichier1`, `Bien`.`fichier2`, `Bien`.`fichier3`, `Bien`.`visible`, `Bien`.`DateFinQuitt`, `Bien`.`DateDebTravaux`, `Bien`.`DateFinTravaux`, `Bien`.`coups_coeur`, `Bien`.`Haofferts`, `Bien`.`rue1`, `Bien`.`code_postal`, `Bien`.`lieu_cle`, `Bien`.`contact`, `Bien`.`telephone`, `Bien`.`pass`, `Bien`.`proprietaire`, `Type`.`id`, `Type`.`label`, `Program`.`id`, `Program`.`label`, `Program`.`presentation`, `Program`.`visible`, `Program`.`visuel`, `Program`.`visite3d`, `Program`.`lat`, `Program`.`lng`, `Ville`.`id`, `Ville`.`label`, `Ville`.`country_id` FROM `biens` AS `Bien` LEFT JOIN `types` AS `Type` ON (`Bien`.`type_id` = `Type`.`id`) LEFT JOIN `programs` AS `Program` ON (`Bien`.`program_id` = `Program`.`id`) LEFT JOIN `villes` AS `Ville` ON (`Bien`.`ville_id` = `Ville`.`id`) WHERE `Program`.`visible` = 1 AND `Bien`.`visible` = 1 AND `Bien`.`neuf` = 0 LIMIT 2220
4SELECT `BienSale`.`id`, `BienSale`.`bien_id`, `BienSale`.`sale_id`, `BienSale`.`created`, `BienSale`.`modified`, `BienSale`.`status`, `BienSale`.`type`, `BienSale`.`archive` FROM `bien_sales` AS `BienSale` WHERE `BienSale`.`bien_id` IN (3427, 3430) 220
5SELECT `Log`.`id`, `Log`.`prospect_id`, `Log`.`bien_id`, `Log`.`sales_id`, `Log`.`event_id`, `Log`.`date_contact`, `Log`.`created`, `Log`.`modified` FROM `logs` AS `Log` WHERE `Log`.`bien_id` IN (3427, 3430) 000