Notice (8): Undefined index:  immobiliere [APP/controllers/components/search.php, line 14]
Warning (512): SQL Error: 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 ') AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`ci' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 684]

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` LEFT JOIN `type` AS `Type` ON (`Property`.`type_id` = `Type`.`id`) WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0)

Query: SELECT `Property`.`id`, `Property`.`type_id`, `Property`.`reference`, `Property`.`title`, `Property`.`subtitle`, `Property`.`address`, `Property`.`city`, `Property`.`area`, `Property`.`location`, `Property`.`price`, `Property`.`description`, `Property`.`buy`, `Property`.`active`, `Property`.`created`, `Property`.`updated`, `Type`.`id`, `Type`.`name`, `Type`.`uri` FROM `property` AS `Property` LEFT JOIN `type` AS `Type` ON (`Property`.`type_id` = `Type`.`id`) WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) ORDER BY CAST(`Property`.`price` AS SIGNED) asc LIMIT 5

Notice (8): Undefined index:  immobiliere [APP/controllers/search_controller.php, line 159]
Warning (2): Invalid argument supplied for foreach() [APP/controllers/search_controller.php, line 161]
Notice (8): Undefined variable: usedFilters [APP/controllers/search_controller.php, line 171]

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price <200000

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price BETWEEN 200001 AND 500000

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price BETWEEN 500001 AND 1000000

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price BETWEEN 1000001 AND 1500000

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price BETWEEN 1500001 AND 2000000

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price >2000001

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Hivernage%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Proche Amelkis%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Majorelle%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Victor Hugo%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Targa%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Agdal%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route de Ouarzazate%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Amizmiz%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Guéliz%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Bab Atlas%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Chuiter%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route d'Amizmiz%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route de l'Ourika%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route de Sidi Abdellah Ghiat%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Proche du golf%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Palmeraie%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route de Fès%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route Sidi Abdellah Ghiat%"

Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Amelkis%"

Immobilier Marrakech - agence immobiliere maroc.php
Bien sélectionné
biens correspondent à votre recherche: agence immobiliere maroc.php
Warning (2): Invalid argument supplied for foreach() [APP/views/search/search.ctp, line 22]
<< Previous - Next Page