Vanzari

<< 1   2   3   4   5   6   7   8   9 >>

Contact

Adresa

Str. Stefan cel Mare Nr. 41, Bl. A3 Sc. B Ap. 4
Loc. Suceava

Telefon

0330 80 21 22
0728 21 82 12

Email



Promotii

Apartament 3 camere (George Enescu) 38000 » detalii
Apartament 4 camere (Burdujeni) 36000 » detalii
Apartament 3 camere
Apartament 3 camere (Burdujeni) 35000 » detalii
Garsoniera confort Sporit (George Enescu) 18000 » detalii
(default) 6 queries took 5 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS `count` FROM `imobile` AS `Imobil` LEFT JOIN `zone` AS `Zona` ON (`Imobil`.`zona_id` = `Zona`.`id`) WHERE `Imobil`.`tip` = 0 AND `Imobil`.`activ` = 1 112
2SELECT `Imobil`.`id`, `Imobil`.`cod`, `Imobil`.`titlu`, `Imobil`.`pret`, `Imobil`.`zona_id`, `Imobil`.`zona`, `Imobil`.`vizite`, `Zona`.`denumire`, `Zona`.`id` FROM `imobile` AS `Imobil` LEFT JOIN `zone` AS `Zona` ON (`Imobil`.`zona_id` = `Zona`.`id`) WHERE `Imobil`.`tip` = 0 AND `Imobil`.`activ` = 1 LIMIT 60, 2020200
3SELECT `Imobil`.`id`, `Imobil`.`titlu`, `Imobil`.`zona_id`, `Imobil`.`zona`, `Imobil`.`pret`, `Imobil`.`vizite`, `Zona`.`denumire`, `Zona`.`id` FROM `imobile` AS `Imobil` LEFT JOIN `zone` AS `Zona` ON (`Imobil`.`zona_id` = `Zona`.`id`) WHERE `Imobil`.`promotie` = 1 AND `Imobil`.`tip` = 0 AND `Imobil`.`activ` = 1 ORDER BY RAND() ASC LIMIT 4441
4SELECT `Imagine`.`id`, `Imagine`.`imobil_id` FROM `imagini` AS `Imagine` WHERE `Imagine`.`imobil_id` IN (2447, 1702, 1569, 1429) 331
5SELECT `ImobilTip`.`id`, `ImobilTip`.`denumire` FROM `imobil_tipuri` AS `ImobilTip` WHERE 1 = 1 551
6SELECT `Zona`.`id`, `Zona`.`denumire` FROM `zone` AS `Zona` WHERE 1 = 1 ORDER BY `denumire` ASC 15150