català <   
EnglishEspañol

PROPIETATS

1425 - Fantastic villa in the heart of Sóller

1425 - Fantastic villa in the heart of Sóller

New villa totally reformed near the center of town. It has 3 floors composed of kitchen, living-dining room, 3 bathrooms, 3 bedrooms, 2 big sunny terraces and a beautiful garden with beautiful views of the mountains. It has private parking for 2 cars.

Llegir més

1422 - Modernist townhouse in the center of Soller

1422 - Modernist townhouse in the center of Soller

This wonderful modernist townhouse in the center of Soller offers 8 double bedrooms, big dresser, huge bathroom with bath, living-room with fireplace, kitchen, garden, terrace and private parking. In the basement we can find a barbecue, cellar and 19s century washers. House in very good condition with great potential. It retains the charm of the era.

Llegir més

1421 - Impressive mansion near the golf in Bendinat.

1421 - Impressive mansion near the golf in Bendinat.

This impressive mansion was built keeping a traditional mallorcan castles in mind. All vaulted, white marble floors, the impressive staircase, Italian stucco walls and ceilings of the best Majorcan sandstone, the mansion is located near Bendinat golf and exclusive areas of Son Vida, Portals Nous or Portals Vells. The property has 4 double bedrooms (all on suite and with jacuzzi baths and showers), 2 living rooms, dining area, a fully equipped kitchen, games room.... Surrounded by spacious balconies and terraces the property offers a fantastic pool and gorgeous sea views.

Llegir més

LLOGUERS

386 - Impressionant casa als afores de Sóller.

386 - Impressionant casa als afores de Sóller.

Impressionant vila en el marc incomparable de Sóller amb vistes a la Serra de Tramuntana. Consta de cuina, saló, menjador, 4 dormitoris, 4 banys, piscina i un pinar. Disposa d'aparcament privat per a cotxes 6-7.

Llegir més

_____

estic buscant...

Immobiliaria Mas
Avinguda Born 7,
07100 Sóller (Mallorca)
Localitza'ns en: google-maps

Per a més informació:

Tel.:  (34) 971 630 318 
Mòbil:         (34) 665 941 655
mas@immobiliariamas.com

Informació del perfil

Application afterLoad: 0.000 seconds, 0.24 MB
Application afterInitialise: 0.167 seconds, 3.58 MB
Application afterRoute: 0.195 seconds, 4.24 MB
Application afterDispatch: 0.299 seconds, 6.64 MB
Application afterRender: 0.517 seconds, 9.27 MB

Ús de memòria

10638092

35 consultes registrades

  1. SHOW TABLES
  2. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  3. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(1,97,98,99,100,101,74,102,63,64,66,67,71,77,78)
       
      AND jf_content.reference_table='menu'
  4. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 74)
      ORDER BY menuid DESC
      LIMIT 0, 1
  5. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  6. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-09-05 07:43:56' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-09-05 07:43:56' )
      ORDER BY  f.ordering
      LIMIT 0, 9
  7. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-09-05 07:43:56' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-09-05 07:43:56' )
      ORDER BY  f.ordering
  8. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 74 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  9. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(186,150,114,117,118,180,54,73,182,181,183,184,185)
       
      AND jf_content.reference_table='modules'
  10. SELECT t.id, t.name, t.VALUE, t.TYPE, t.
      GROUP, t.published
      FROM jos_k2_extra_fields t
      WHERE t.published =1  
      AND t.id IN (5,6,23,25,26,31)
      ORDER BY t.
      GROUP
  11. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(31,25,26,23)
       
      AND jf_content.reference_table='k2_extra_fields'
  12. SELECT DISTINCT
                                    c.id AS ID,  
                                    c.name AS name,
                                    c.alias AS alias
                           
      FROM
                                    jos_k2_categories AS c
                           
      LEFT JOIN
                                    jos_k2_items AS content
                                   
      ON
                                    c.id = content.catid
                 
                           
      WHERE
                                    (  c.id = 10 )
                                   
      AND
                                    c.published = 1;
  13. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(10)
       
      AND jf_content.reference_table='k2_categories'
  14. SELECT DISTINCT
                                    cats.name AS cat_name,
                                    cats.alias AS cat_alias,
                                    content.catid AS cat_id,
                                    users.name AS author,
                                    users.email AS author_email,
                                    users.id AS author_id,
                                    content.title AS title,
                                    content.introtext AS text,
                                    content.created AS DATE,
                                    content.publish_up AS date_publish,
                                    content.id AS ID,
                                    content.alias AS alias,
                                    content.hits AS hits,
                    content_rating.rating_sum AS rating_sum,
                    content_rating.rating_count AS rating_count,
                    content.plugins AS plugins             
                           
      FROM
                                    jos_k2_items AS content
                                   
      LEFT JOIN
                                            jos_k2_categories AS cats
                                           
      ON cats.id = content.catid
                                   
      LEFT JOIN
                                            jos_users AS users
                                           
      ON users.id = content.created_by
                           
                   
      LEFT JOIN
                        jos_k2_rating AS content_rating
                       
      ON content.id = content_rating.itemID      
                           
      WHERE
                                    content.trash = 0
                                           
      AND content.published = 1
                                           
      AND cats.published = 1  
                                           
      AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-09-05 07:43:56' )
                                           
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-09-05 07:43:56' )
                                   
      AND (  content.catid = 10 )
                                     
      AND content.featured = 1  
                                   
                           
      ORDER BY
                                     content.featured_ordering DESC
                           
      LIMIT
                                    0,3;
  15. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(58)
       
      AND jf_content.reference_table='k2_items'
  16. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(63)
       
      AND jf_content.reference_table='users'
  17. SELECT
                                    content.id AS id,
                                    COUNT(comments.itemID) AS COUNT                
                           
      FROM
                                    jos_k2_items AS content
                                   
      LEFT JOIN
                                            jos_k2_comments AS comments
                                           
      ON comments.itemID = content.id                
                           
      WHERE
                                    comments.published
                                   
      AND (  content.id = 58 )
                           
      GROUP BY
                                    comments.itemID
                            ;
  18. SELECT DISTINCT
                                    c.id AS ID,  
                                    c.name AS name,
                                    c.alias AS alias
                           
      FROM
                                    jos_k2_categories AS c
                           
      LEFT JOIN
                                    jos_k2_items AS content
                                   
      ON
                                    c.id = content.catid
                 
                           
      WHERE
                                    (  c.id = 2 OR c.id = 4 OR c.id = 6 OR c.id = 1 )
                                   
      AND
                                    c.published = 1;
  19. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(1,2,4,6)
       
      AND jf_content.reference_table='k2_categories'
  20. SELECT DISTINCT
                                    cats.name AS cat_name,
                                    cats.alias AS cat_alias,
                                    content.catid AS cat_id,
                                    users.name AS author,
                                    users.email AS author_email,
                                    users.id AS author_id,
                                    content.title AS title,
                                    content.introtext AS text,
                                    content.created AS DATE,
                                    content.publish_up AS date_publish,
                                    content.id AS ID,
                                    content.alias AS alias,
                                    content.hits AS hits,
                    content_rating.rating_sum AS rating_sum,
                    content_rating.rating_count AS rating_count,
                    content.plugins AS plugins             
                           
      FROM
                                    jos_k2_items AS content
                                   
      LEFT JOIN
                                            jos_k2_categories AS cats
                                           
      ON cats.id = content.catid
                                   
      LEFT JOIN
                                            jos_users AS users
                                           
      ON users.id = content.created_by
                           
                   
      LEFT JOIN
                        jos_k2_rating AS content_rating
                       
      ON content.id = content_rating.itemID      
                           
      WHERE
                                    content.trash = 0
                                           
      AND content.published = 1
                                           
      AND cats.published = 1  
                                           
      AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-09-05 07:43:56' )
                                           
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-09-05 07:43:56' )
                                   
      AND (  content.catid = 1 OR content.catid = 2 OR content.catid = 4 OR content.catid = 6 )
                                     
      AND content.featured = 0  
                                   
                           
      ORDER BY
                                     content.ordering DESC
                           
      LIMIT
                                    0,3;
  21. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(88,87,86)
       
      AND jf_content.reference_table='k2_items'
  22. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(63)
       
      AND jf_content.reference_table='users'
  23. SELECT
                                    content.id AS id,
                                    COUNT(comments.itemID) AS COUNT                
                           
      FROM
                                    jos_k2_items AS content
                                   
      LEFT JOIN
                                            jos_k2_comments AS comments
                                           
      ON comments.itemID = content.id                
                           
      WHERE
                                    comments.published
                                   
      AND (  content.id = 88 OR content.id = 87 OR content.id = 86 )
                           
      GROUP BY
                                    comments.itemID
                            ;
  24. SELECT DISTINCT
                                    c.id AS ID,  
                                    c.name AS name,
                                    c.alias AS alias
                           
      FROM
                                    jos_k2_categories AS c
                           
      LEFT JOIN
                                    jos_k2_items AS content
                                   
      ON
                                    c.id = content.catid
                 
                           
      WHERE
                                    (  c.id = 2 OR c.id = 4 OR c.id = 6 OR c.id = 1 )
                                   
      AND
                                    c.published = 1;
  25. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(1,2,4,6)
       
      AND jf_content.reference_table='k2_categories'
  26. SELECT DISTINCT
                                    cats.name AS cat_name,
                                    cats.alias AS cat_alias,
                                    content.catid AS cat_id,
                                    users.name AS author,
                                    users.email AS author_email,
                                    users.id AS author_id,
                                    content.title AS title,
                                    content.introtext AS text,
                                    content.created AS DATE,
                                    content.publish_up AS date_publish,
                                    content.id AS ID,
                                    content.alias AS alias,
                                    content.hits AS hits,
                    content_rating.rating_sum AS rating_sum,
                    content_rating.rating_count AS rating_count,
                    content.plugins AS plugins             
                           
      FROM
                                    jos_k2_items AS content
                                   
      LEFT JOIN
                                            jos_k2_categories AS cats
                                           
      ON cats.id = content.catid
                                   
      LEFT JOIN
                                            jos_users AS users
                                           
      ON users.id = content.created_by
                           
                   
      LEFT JOIN
                        jos_k2_rating AS content_rating
                       
      ON content.id = content_rating.itemID      
                           
      WHERE
                                    content.trash = 0
                                           
      AND content.published = 1
                                           
      AND cats.published = 1  
                                           
      AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-09-05 07:43:56' )
                                           
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-09-05 07:43:56' )
                                   
      AND (  content.catid = 1 OR content.catid = 2 OR content.catid = 4 OR content.catid = 6 )
                                     
      AND content.featured = 1  
                                   
                           
      ORDER BY
                                     content.featured_ordering DESC
                           
      LIMIT
                                    0,5;
  27. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(81,82,69,68)
       
      AND jf_content.reference_table='k2_items'
  28. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(63)
       
      AND jf_content.reference_table='users'
  29. SELECT *
      FROM jos_modules
      WHERE client_id = 0
      AND access <= 0
      AND ( title='Language Selection' )  
      AND published = 1
      ORDER BY ordering
      LIMIT 1
  30. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(114)
       
      AND jf_content.reference_table='modules'
  31. SELECT `l`.`lang_id` AS `lang_id`,`l`.`lang_code` AS `lang_code`,`l`.`title` AS `title`,`l`.`title_native` AS `title_native`,`l`.`sef` AS `sef`,`l`.`description` AS `description`,`l`.`metakey` AS `metakey`,`l`.`metadesc` AS `metadesc`,`l`.`published` AS `published`,`l`.`image` AS `image`,`lext`.`image_ext` AS `image_ext`,`lext`.`fallback_code` AS `fallback_code`,`lext`.`params` AS `params`,`lext`.`ordering` AS `ordering`
      FROM (`jos_languages` `l`
      LEFT JOIN `jos_jf_languages_ext` `lext`
      ON((`l`.`lang_id` = `lext`.`lang_id`)))
      WHERE published=1
      ORDER BY `lext`.`ordering`
  32. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1  
      ORDER BY m.sublevel, m.parent, m.ordering
  33. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(1,97,98,99,100,101,74,102,63,64,66,67,71,77,78)
       
      AND jf_content.reference_table='menu'
  34. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(74)
       
      AND jf_content.reference_table='menu'
  35. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=4
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(74)
       
      AND jf_content.reference_table='menu'

S'han carregat els fitxers d'idioma

Cadenes no traduïdes mode diagnòstic

None

Cadenes no traduïdes mode dissenyador

None