click aquí para descargar flash
Español (spanish formal Internacional)English (United Kingdom)French (Fr)Deutsch (DE-CH-AT)Nederlands - nl-NLRussian (CIS)

¿Busca casa o parcela en la costa blanca?

Cerrar
Buscador de propiedades
Subscríbase
Subscríbase a nuestras nuevas promociones y ofertas

Nuestros agentes

Contacte con nuestros agentes comerciales:


Contacto en alemán Contacto en inglés Contacto en español
David Jiménez Esser

0034 607 221 065


Contacto en francés Contacto en inglés Contacto en alemán Contacto en español
Juan Miguel Jiménez Coronas

0034 687 526 824


Compartir

Síguenos en nuestra página:

Facebook  Twitter
No valid database connection 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 'order by rt.ordering' at line 1 SQL=SELECT rt.* FROM jos_properties_rates as rt WHERE rt.published = 1 AND rt.productid = order by rt.ordering
No valid database connection 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 'order by i.ordering' at line 1 SQL=SELECT i.* FROM jos_properties_images as i WHERE i.published = 1 AND i.parent = order by i.ordering
No valid database connection 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 'order by p.ordering' at line 1 SQL=SELECT p.*,c.name as name_category,t.name as name_type,cy.name as name_country,s.name as name_state,l.name as name_locality,pf.name as name_profile,pf.logo_image as logo_image_profile, CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as Pslug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as Cslug, CASE WHEN CHAR_LENGTH(cy.alias) THEN CONCAT_WS(":", cy.id, cy.alias) ELSE cy.id END as CYslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END as Sslug, CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(":", l.id, l.alias) ELSE l.id END as Lslug, CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(":", t.id, t.alias) ELSE t.id END as Tslug FROM jos_properties_products as p LEFT JOIN jos_properties_country AS cy ON cy.id = p.cyid LEFT JOIN jos_properties_state AS s ON s.id = p.sid LEFT JOIN jos_properties_locality AS l ON l.id = p.lid LEFT JOIN jos_properties_category AS c ON c.id = p.cid LEFT JOIN jos_properties_type AS t ON t.id = p.type LEFT JOIN jos_properties_profiles AS pf ON pf.mid = p.agent_id WHERE p.published = 1 AND p.parent = order by p.ordering
No valid database connection 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 'order by p.ordering' at line 1 SQL=SELECT p.*, CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as Pslug FROM jos_properties_pdfs AS p WHERE p.published = 1 AND p.parent = order by p.ordering

Vista detallada

Descripción del inmueble


Características principales

Galería de imágenes

Mapa de situación