Notice (8): Undefined variable: this [CORE/cake/libs/set.php, line 316]
Warning (2): Cannot modify header information - headers already sent by (output started at /home/property/website_php_code/cake/basics.php:725) [CORE/cake/libs/controller/controller.php, line 688]
Warning (2): Cannot modify header information - headers already sent by (output started at /home/property/website_php_code/cake/basics.php:725) [CORE/cake/libs/controller/controller.php, line 689]
Warning (2): Cannot modify header information - headers already sent by (output started at /home/property/website_php_code/cake/basics.php:725) [CORE/cake/libs/controller/controller.php, line 690]
Notice (8): Undefined index: url [CORE/app/controllers/components/general.php, line 126]
Notice (8): Undefined index: url [CORE/app/controllers/components/general.php, line 127]
Warning (2): array_unique() expects parameter 1 to be array, null given [CORE/cake/libs/model/datasources/dbo_source.php, line 1007]
Warning (2): join() [function.join]: Invalid arguments passed [CORE/cake/libs/model/datasources/dbo_source.php, line 1170]
Notice (8): Undefined variable: pageTitle [CORE/app/controllers/components/general.php, line 167]
Warning (2): Declaration of Owner::afterFind($results) should be compatible with Model::afterFind($results, $primary = false) [CORE/app/models/owner.php, line 34]
Warning (2): array_merge() [function.array-merge]: Argument #1 is not an array [CORE/cake/libs/model/datasources/dbo_source.php, line 1091]
Warning (2): array_unique() expects parameter 1 to be array, null given [CORE/cake/libs/model/datasources/dbo_source.php, line 1091]
Warning (2): call_user_func_array() expects parameter 2 to be array, null given [CORE/cake/dispatcher.php, line 340]
 Casa Propery | Luxury Properties, Villas, Apartments, Sea View Mansions, Country Estate, Mallorca Majorca Spain

Quick Search

To Buy To Rent
Property Type
Town
Prices €
Reference No.

Newsletter Subscription

Email
Email: info@casa-property.com

Tel: (+34) 63435 1111
Fax: (+34) 97171 9083
Notice (8): Undefined variable: page [CORE/app/views/pages/home.ctp, line 7]
Notice (8): Undefined variable: bargain [CORE/app/views/pages/home.ctp, line 9]

Latest listings

Notice (8): Undefined variable: latest_listings [CORE/app/views/pages/home.ctp, line 27]
Warning (2): Invalid argument supplied for foreach() [CORE/app/views/pages/home.ctp, line 27]
84 queries took 41 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`35353
2SELECT * FROM `pages` AS `Page` WHERE ((`Page`.`title_en` = 'home') OR (`Page`.`title_es` = 'home') OR (`Page`.`title_de` = 'home') OR (`Page`.`title_ru` = 'home') OR (`Page`.`title_ro` = 'home')) LIMIT 1111
3SELECT * FROM `pages` AS `Page` WHERE `Page`.`online`=1 and length(`Page`.`title_en`)>0 19191
4SELECT * FROM `pages` AS `Page` WHERE `Page`.`online`=1 and `Page`.`position`=0 and `Page`.`parent_id`=0 ORDER BY `Page`.`sort` ASC 551
5SELECT * FROM `pages` AS `Page` WHERE `Page`.`online`=1 and `Page`.`position`=1 and `Page`.`parent_id`=0 ORDER BY `Page`.`sort` ASC 551
6SELECT * FROM `pages` AS `Page` WHERE `Page`.`online`=1 and `Page`.`position`=2 and `Page`.`parent_id`=0 ORDER BY `Page`.`sort` ASC 441
7DESCRIBE `towns`882
8DESCRIBE `areas`12122
9SELECT * FROM `towns` AS `Town` WHERE 1 = 1 ORDER BY `Town`.`name` ASC 1041041
10SELECT * FROM `areas` AS `Area` WHERE 1 = 1 ORDER BY `Area`.`name_en` ASC 10100
11DESCRIBE `properties`53532
12DESCRIBE `propertytypes`662
13DESCRIBE `currencies`331
14DESCRIBE `owners`21212
15DESCRIBE `images`442
16SELECT `Property`.`id` FROM `properties` AS `Property` LEFT JOIN `areas` AS `Area` ON (`Property`.`area_id` = `Area`.`id`) LEFT JOIN `towns` AS `Town` ON (`Property`.`town_id` = `Town`.`id`) LEFT JOIN `propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) LEFT JOIN `currencies` AS `SellCurrency` ON (`Property`.`sell_currency_id` = `SellCurrency`.`id`) LEFT JOIN `currencies` AS `RentCurrency` ON (`Property`.`rent_currency_id` = `RentCurrency`.`id`) LEFT JOIN `owners` AS `Owner` ON (`Property`.`owner_id` = `Owner`.`id`) WHERE `Property`.`status` = 1 AND `Property`.`featured_image`!="" LIMIT 6001
17DESCRIBE `galleries`442
18SELECT * FROM `galleries` AS `Gallery` WHERE 1 = 1 LIMIT 6550
19DESCRIBE `banners`14142
20SELECT * FROM `banners` AS `Banner` WHERE 1 = 1 220
21SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 ORDER BY `name_en` ASC 550
22DESCRIBE `news`15152
23SELECT * FROM `news` AS `News` WHERE `News`.`online`=1 and length(`News`.`title_en`)>0 ORDER BY `created` DESC LIMIT 4441
24SELECT * FROM `pages` AS `Page` WHERE `Page`.`parent_id`=1 ORDER BY `Page`.`sort` ASC 001
25SELECT * FROM `pages` AS `Page` WHERE `Page`.`parent_id`=1 ORDER BY `Page`.`sort` ASC 001
26SELECT * FROM `pages` AS `Page` WHERE `Page`.`parent_id`=2 ORDER BY `Page`.`sort` ASC 551
27SELECT * FROM `pages` AS `Page` WHERE `Page`.`parent_id`=2 ORDER BY `Page`.`sort` ASC 551
28SELECT * FROM `pages` AS `Page` WHERE `Page`.`parent_id`=2 ORDER BY `Page`.`sort` ASC 551
29SELECT * FROM `pages` AS `Page` WHERE `Page`.`parent_id`=3 ORDER BY `Page`.`sort` ASC 001
30SELECT * FROM `pages` AS `Page` WHERE `Page`.`parent_id`=3 ORDER BY `Page`.`sort` ASC 001
31SELECT * FROM `pages` AS `Page` WHERE `Page`.`parent_id`=18 ORDER BY `Page`.`sort` ASC 001
32SELECT * FROM `pages` AS `Page` WHERE `Page`.`parent_id`=18 ORDER BY `Page`.`sort` ASC 001
33SELECT * FROM `pages` AS `Page` WHERE `Page`.`parent_id`=5 ORDER BY `Page`.`sort` ASC 001
34SELECT * FROM `pages` AS `Page` WHERE `Page`.`parent_id`=5 ORDER BY `Page`.`sort` ASC 001
35SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
36SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
37SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
38SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
39SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
40SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
41SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
42SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
43SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
44SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
45SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
46SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
47SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
48SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
49SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
50SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
51SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
52SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
53SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
54SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
55SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
56SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
57SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
58SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
59SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
60SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
61SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
62SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
63SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
64SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
65SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
66SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
67SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
68SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
69SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
70SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
71SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
72SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
73SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
74SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
75SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
76SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
77SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
78SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
79SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
80SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
81SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
82SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
83SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550
84SELECT * FROM `propertytypes` AS `Propertytype` WHERE 1 = 1 550