SELECT propiedad.*, categoria_propiedad.descripcion_es AS categoria_propiedad FROM propiedad LEFT JOIN categoria_propiedad ON propiedad.id_categoria_propiedad=categoria_propiedad.id_categoria_propiedad WHERE alquiler=1 AND verweb=1 AND propiedad._idEmpresa = 1 AND id_propiedad != 1922 AND servClientesInactivos=0 ORDER BY trim(propiedad.titulo_es) ASC LIMIT 96,8

Rentals properties

Filter more
object(stdClass)#3 (17) { ["id_imagenes"]=> string(4) "8638" ["fichero"]=> string(22) "600-verdemar-16-12.jpg" ["nombre_es"]=> NULL ["description_es"]=> NULL ["nombre_en"]=> NULL ["description_en"]=> NULL ["nombre_fr"]=> NULL ["description_fr"]=> NULL ["principal"]=> NULL ["orden"]=> string(1) "1" ["id_propiedad"]=> string(3) "600" ["_fechaAlta"]=> string(19) "2021-10-08 15:11:12" ["_fechaModificacion"]=> string(19) "2021-10-08 15:11:12" ["_visible"]=> string(1) "1" ["id_anotacion"]=> NULL ["id_spain_holiday"]=> string(0) "" ["_idEmpresa"]=> string(1) "1" }
Verdemar 16
Verdemar 16
4
2
Yes
+ Info
object(stdClass)#4 (17) { ["id_imagenes"]=> string(5) "10365" ["fichero"]=> string(16) "608-_MIH1290.jpg" ["nombre_es"]=> NULL ["description_es"]=> NULL ["nombre_en"]=> NULL ["description_en"]=> NULL ["nombre_fr"]=> NULL ["description_fr"]=> NULL ["principal"]=> NULL ["orden"]=> string(1) "1" ["id_propiedad"]=> string(3) "608" ["_fechaAlta"]=> string(19) "2023-05-11 13:22:30" ["_fechaModificacion"]=> string(19) "2023-05-11 13:22:30" ["_visible"]=> string(1) "1" ["id_anotacion"]=> NULL ["id_spain_holiday"]=> string(0) "" ["_idEmpresa"]=> string(1) "1" }
Verdemar 28
Verdemar 28
4
2
Yes
+ Info
object(stdClass)#5 (17) { ["id_imagenes"]=> string(5) "11255" ["fichero"]=> string(22) "602-Verdemar-34-11.jpg" ["nombre_es"]=> NULL ["description_es"]=> NULL ["nombre_en"]=> NULL ["description_en"]=> NULL ["nombre_fr"]=> NULL ["description_fr"]=> NULL ["principal"]=> NULL ["orden"]=> string(1) "1" ["id_propiedad"]=> string(3) "602" ["_fechaAlta"]=> string(19) "2024-06-03 10:43:57" ["_fechaModificacion"]=> string(19) "2024-06-03 10:43:57" ["_visible"]=> string(1) "1" ["id_anotacion"]=> NULL ["id_spain_holiday"]=> string(0) "" ["_idEmpresa"]=> string(1) "1" }
Verdemar 34
Verdemar 34
4
2
Yes
+ Info
object(stdClass)#3 (17) { ["id_imagenes"]=> string(4) "8003" ["fichero"]=> string(25) "1093-IMG_3006sea-view.jpg" ["nombre_es"]=> NULL ["description_es"]=> NULL ["nombre_en"]=> NULL ["description_en"]=> NULL ["nombre_fr"]=> NULL ["description_fr"]=> NULL ["principal"]=> NULL ["orden"]=> string(1) "1" ["id_propiedad"]=> string(4) "1093" ["_fechaAlta"]=> string(19) "2021-02-11 12:24:04" ["_fechaModificacion"]=> string(19) "2021-02-11 12:24:04" ["_visible"]=> string(1) "1" ["id_anotacion"]=> NULL ["id_spain_holiday"]=> string(0) "" ["_idEmpresa"]=> string(1) "1" }
Verdemar 39
Verdemar 39
2
1
Yes
+ Info
object(stdClass)#4 (17) { ["id_imagenes"]=> string(4) "8846" ["fichero"]=> string(22) "2419-Verdemar-9-36.jpg" ["nombre_es"]=> NULL ["description_es"]=> NULL ["nombre_en"]=> NULL ["description_en"]=> NULL ["nombre_fr"]=> NULL ["description_fr"]=> NULL ["principal"]=> NULL ["orden"]=> string(1) "1" ["id_propiedad"]=> string(4) "2419" ["_fechaAlta"]=> string(19) "2021-11-16 15:49:42" ["_fechaModificacion"]=> string(19) "2021-11-16 15:49:42" ["_visible"]=> string(1) "1" ["id_anotacion"]=> NULL ["id_spain_holiday"]=> string(0) "" ["_idEmpresa"]=> string(1) "1" }
VERDEMAR 9
VERDEMAR 9
2
1
Yes
+ Info
object(stdClass)#5 (17) { ["id_imagenes"]=> string(5) "10225" ["fichero"]=> string(17) "2685-Porche-4.jpg" ["nombre_es"]=> NULL ["description_es"]=> NULL ["nombre_en"]=> NULL ["description_en"]=> NULL ["nombre_fr"]=> NULL ["description_fr"]=> NULL ["principal"]=> NULL ["orden"]=> string(1) "1" ["id_propiedad"]=> string(4) "2685" ["_fechaAlta"]=> string(19) "2023-03-08 14:55:20" ["_fechaModificacion"]=> string(19) "2023-03-08 14:55:20" ["_visible"]=> string(1) "1" ["id_anotacion"]=> NULL ["id_spain_holiday"]=> string(0) "" ["_idEmpresa"]=> string(1) "1" }
VILLA CARMEN
VILLA CARMEN
8
4
Yes
+ Info
object(stdClass)#3 (17) { ["id_imagenes"]=> string(5) "11339" ["fichero"]=> string(62) "2910-Imagen-de-WhatsApp-2024-06-18-a-las-12.45.17_6e1bf350.jpg" ["nombre_es"]=> NULL ["description_es"]=> NULL ["nombre_en"]=> NULL ["description_en"]=> NULL ["nombre_fr"]=> NULL ["description_fr"]=> NULL ["principal"]=> NULL ["orden"]=> string(1) "2" ["id_propiedad"]=> string(4) "2910" ["_fechaAlta"]=> string(19) "2024-06-25 13:55:39" ["_fechaModificacion"]=> string(19) "2024-06-25 13:55:39" ["_visible"]=> string(1) "1" ["id_anotacion"]=> NULL ["id_spain_holiday"]=> string(0) "" ["_idEmpresa"]=> string(1) "1" }
VISTA BAHIA 36
VISTA BAHIA 36
4
2
No
+ Info