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 24,8
object(stdClass)#3 (17) {
["id_imagenes"]=>
string(4) "9752"
["fichero"]=>
string(29) "1783-RONDA-15-SEPT-22-018.jpg"
["nombre_es"]=>
NULL
["description_es"]=>
NULL
["nombre_en"]=>
NULL
["description_en"]=>
NULL
["nombre_fr"]=>
NULL
["description_fr"]=>
NULL
["principal"]=>
NULL
["orden"]=>
string(1) "0"
["id_propiedad"]=>
string(4) "1783"
["_fechaAlta"]=>
string(19) "2022-09-20 15:53:15"
["_fechaModificacion"]=>
string(19) "2022-09-20 15:53:15"
["_visible"]=>
string(1) "1"
["id_anotacion"]=>
NULL
["id_spain_holiday"]=>
string(0) ""
["_idEmpresa"]=>
string(1) "1"
}
Capistrano Village 15
+ Info
object(stdClass)#4 (17) {
["id_imagenes"]=>
string(4) "9312"
["fichero"]=>
string(19) "2562-COMEDOR_01.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) "2562"
["_fechaAlta"]=>
string(19) "2022-05-11 09:36:18"
["_fechaModificacion"]=>
string(19) "2022-05-11 09:36:18"
["_visible"]=>
string(1) "1"
["id_anotacion"]=>
NULL
["id_spain_holiday"]=>
string(0) ""
["_idEmpresa"]=>
string(1) "1"
}
CAPRI 32
+ Info
object(stdClass)#5 (17) {
["id_imagenes"]=>
string(4) "4698"
["fichero"]=>
string(45) "517-_mg_2240-fileminimizer-20180404094107.jpg"
["nombre_es"]=>
NULL
["description_es"]=>
NULL
["nombre_en"]=>
NULL
["description_en"]=>
NULL
["nombre_fr"]=>
NULL
["description_fr"]=>
NULL
["principal"]=>
NULL
["orden"]=>
string(1) "0"
["id_propiedad"]=>
string(3) "517"
["_fechaAlta"]=>
NULL
["_fechaModificacion"]=>
string(19) "2018-04-04 09:41:07"
["_visible"]=>
string(1) "1"
["id_anotacion"]=>
NULL
["id_spain_holiday"]=>
string(0) ""
["_idEmpresa"]=>
string(1) "1"
}
Carabeo 60 1C
+ Info
object(stdClass)#3 (17) {
["id_imagenes"]=>
string(4) "5653"
["fichero"]=>
string(31) "519-mih09372-20180712083059.jpg"
["nombre_es"]=>
NULL
["description_es"]=>
NULL
["nombre_en"]=>
NULL
["description_en"]=>
NULL
["nombre_fr"]=>
NULL
["description_fr"]=>
NULL
["principal"]=>
NULL
["orden"]=>
string(1) "0"
["id_propiedad"]=>
string(3) "519"
["_fechaAlta"]=>
NULL
["_fechaModificacion"]=>
string(19) "2018-07-12 08:31:00"
["_visible"]=>
string(1) "1"
["id_anotacion"]=>
NULL
["id_spain_holiday"]=>
string(0) ""
["_idEmpresa"]=>
string(1) "1"
}
Carabeo 60 2B
+ Info
object(stdClass)#4 (17) {
["id_imagenes"]=>
string(4) "8087"
["fichero"]=>
string(31) "2316-_MG_2646-FILEminimizer.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) "2316"
["_fechaAlta"]=>
string(19) "2021-04-29 15:03:47"
["_fechaModificacion"]=>
string(19) "2021-04-29 15:03:47"
["_visible"]=>
string(1) "1"
["id_anotacion"]=>
NULL
["id_spain_holiday"]=>
string(0) ""
["_idEmpresa"]=>
string(1) "1"
}
CARABEO 70
+ Info
object(stdClass)#5 (17) {
["id_imagenes"]=>
string(4) "9327"
["fichero"]=>
string(31) "2317-_MG_1393-FILEminimizer.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) "2317"
["_fechaAlta"]=>
string(19) "2022-05-12 10:39:57"
["_fechaModificacion"]=>
string(19) "2022-05-12 10:39:57"
["_visible"]=>
string(1) "1"
["id_anotacion"]=>
NULL
["id_spain_holiday"]=>
string(0) ""
["_idEmpresa"]=>
string(1) "1"
}
CARABEO 72
+ Info
object(stdClass)#3 (17) {
["id_imagenes"]=>
string(4) "3158"
["fichero"]=>
string(35) "524-sam_1419-jpg-20170615153542.jpg"
["nombre_es"]=>
NULL
["description_es"]=>
NULL
["nombre_en"]=>
NULL
["description_en"]=>
NULL
["nombre_fr"]=>
NULL
["description_fr"]=>
NULL
["principal"]=>
NULL
["orden"]=>
string(1) "0"
["id_propiedad"]=>
string(3) "524"
["_fechaAlta"]=>
NULL
["_fechaModificacion"]=>
string(19) "2017-06-15 15:35:46"
["_visible"]=>
string(1) "1"
["id_anotacion"]=>
NULL
["id_spain_holiday"]=>
string(0) ""
["_idEmpresa"]=>
string(1) "1"
}
Carabeo I 18
+ Info
object(stdClass)#4 (17) {
["id_imagenes"]=>
string(3) "518"
["fichero"]=>
string(15) "525-piscina.jpg"
["nombre_es"]=>
NULL
["description_es"]=>
NULL
["nombre_en"]=>
NULL
["description_en"]=>
NULL
["nombre_fr"]=>
NULL
["description_fr"]=>
NULL
["principal"]=>
NULL
["orden"]=>
string(1) "0"
["id_propiedad"]=>
string(3) "525"
["_fechaAlta"]=>
NULL
["_fechaModificacion"]=>
string(19) "2017-03-03 11:00:15"
["_visible"]=>
string(1) "1"
["id_anotacion"]=>
NULL
["id_spain_holiday"]=>
string(0) ""
["_idEmpresa"]=>
string(1) "1"
}
Casa Conles
+ Info