{has_color} {/has_color} {is_rtl} {/is_rtl} {settings_tracking}
{has_color_picker}
{/has_color_picker}
{is_logged_user}
Mis reservas Mis propiedades Mis favoritas Mis consultas Mi perfil
{/is_logged_user} {is_logged_other}
Administracion
{/is_logged_other}
Belgium {settings_phone} {settings_email}
{is_logged_other} {/is_logged_other}
es spanish
EUR €

Invisible

The Villas Cap Cana

Punta Cana

Agregar a los favoritos

Descripcion

NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT

Detalle

  • Tipo:

    Casa

  • Pais:

    € MYMEMORY WARNING: AVAILABLE MT QUOTA IS OVER. NEXT AVAILABLE IN 06 HOURS 51 MINUTES 37 SECONDS

  • Ciudad :

    € Punta Cana

  • Superficie:

    mas de 100m2

  • Titularidad :

    Agente

Distancia

Planos

Planta baja

Ubicacion de la propiedad

Comentarios de Facebook

QUERY: SELECT `property`.*, `property_lang`.* FROM (`property` FORCE INDEX(is_featured)) JOIN `property_lang` ON `property`.`id` = `property_lang`.`property_id` WHERE `language_id` = '3' AND `is_activated` = 1 AND `property`.`id` != '100' ORDER BY RAND() LIMIT 4
ERROR: Out of sort memory, consider increasing server sort buffer size