Espectacular casa señorial junto plaza de la alfalfa con vistas hacia la giralda!!!

Sevilla (Sevilla)

espectacular casa señorial junto plaza de la alfalfa con vistas hacia la giralda!!! foto grande (1)
espectacular casa señorial junto plaza de la alfalfa con vistas hacia la giralda!!! foto grande (2)
espectacular casa señorial junto plaza de la alfalfa con vistas hacia la giralda!!! foto grande (3)
1.490.900
  • 475 m²
  • 4 Habitaciones
  • 5 Baños
anuncio

Espectacular casa señorial junto Plaza de La Alfalfa con vistas hacia La
Gran oportunidad de tener una magnífica vivienda en pleno centro, junto Plaza de la Alfalfa!!!La vivienda dispone de 475m2 construidos distribuidos en tres plantas. De elegante diseño y estilo señorial, características de las típicas casas SevillanasAccedemos a través de un portalón de madera de doble hoja y desde aquí accedemos a un amplio y luminoso patio sevillano con un gran tragaluz cubierto.En el zaguán se disponen a derecha e izquierda dos pequeños apartamentos independientes a doble altura. Primer apartamento, situado en la parte derecha: En el nivel inferior hay un salón-comedor con gran ventanal a la calle y con cocina americana y en el nivel superior, un dormitorio y baño con placa ducha.Segundo apartamento, situado en la parte izquierda: En el nivel inferior hay un salón-comedor con gran ventanal a la calle, cocina y baño con placa ducha. En el nivel superior un dormitorio. Ambos apartamentos están alquilados y el comprador puede optar por renovar el alquiler o rescindir el contrato.Pasando la puerta con reja metálica se accede a un enorme patio sevillano en una segunda altura utilizado a modo de salón y recepción de visitas.A la izquierda se encuentra una amplia habitación con chimenea, cómoda y acogedora, usada como despacho, desde la que accedemos a unas escaleras que nos llevan a un sótano con techos abovedados y dos tragaluces que permiten la entrada de luz exterior. Dispone de sótano cerrado mediante arqueta. Ideal para una bodega o para usar como almacén.Al fondo del patio, hya una pequeña habitación que puede ser usada para almacenaje, y un pequeño aseo.El hueco de la escalera está habilitado como trastero.En primera planta accedemos directamente a una amplia y luminosa cocina gracias a un tragaluz con toldo, se encuentra amueblada con muebles de madera de color blanco roto, equipada con todos los electrodomésticos, siendo los fogones de gas y la encimera de mármol blanco. Está dividida en dos ambientes para poder comer en ella.Alrededor del patio se disponen dos grandes salones muy luminosos en distintos ambientes y una gran librería. En esta planta hay dos dormitorios.El dormitorio principal es muy amplio, con gran armario empotrado de pared a pared y de suelo a techo, de unos cinco metros de altura. Muy luminoso, con gran ventanal exterior a la fachada principal. Amplísimo cuarto de baño completo con gran placa ducha.El dormitorio secundario cuenta con armario empotrado, también muy luminoso ya que dispone de gran ventanal al exterior de la fachada.En la segunda planta hay una habitación usada como lavadero, con pila, cuarto de lavadora y plancha, armario empotrado y puerta de acceso al tragaluz de la cocina.A la derecha hay gran salón, al fondo un gran baño con bañera con bonitos azulejos antiguos típicos sevillanos.A continuación hay dos amplios dormitorios con armarios empotrados y con ventanales a la calle que le aportan mucha luminosidad. A la derecha hay una gran terraza en la que se encuentra la claraboya del patio, desde ésta se sube mediante una escalera de caracol a la azotea, muy amplia y con espectaculares vistas a la Catedral, Giralda e iglesias como la Candelaria y San Ildefonso.Las ventanas son de aluminio lacado en blanco, las puertas de madera y el suelo de mármol, dispone de aire acondicionado mediante splits independientes.Exterior y muy luminosa, muy bien situada, junto Plaza de La Alfalfa y rodeada de todo tipo de servicios, comercios, colegios. No dude en solicitar visita!!!Informamos a nuestros clientes compradores que el precio de venta no incluye lo siguiente: Honorarios de la agencia inmobiliaria, Impuestos (I.T.P., I.V.A. o A.J.D., en su caso) ni otros gastos de la compraventa (gastos de Registro de la Propiedad, Notaría, Gestoría ni de posible Financiación). Documento D.I.A. a disposición del consumidor según Decreto 218/2005 Junta de Andalucía.
Habitaciones: 4
Baños: 5
Año de Construcción: 1950
Área Construida: 475.00 m2
Área Útil: 403.75 m2
Fecha de Publicación: 14/03/2025
Armarios: Sí, armarios no disponibles 1
Cuarto de Almacenamiento: Sí, cuarto de almacenamiento no disponible 1

Este anuncio puede encontrarse en la categoría de Viviendas en la localidad de Sevilla.

Añadir a mi lista

No te pierdas estos anuncios relacionados... Viviendas de segunda mano


    Más anuncios (Sevilla)

    Aproximadamente resultados: (1.2257 segundos)

    EL SISTEMA HA TOMADO

    url_real (301)

                        https://www.casinuevo.com/anuncio/espectacular-casa-senorial-junto-plaza-de-la-alfalfa-con-vi-sevilla-19164081205267                

    PROVINCIA

    Array
    (
        [id] => 287065
        [id_localidad] => 287065
        [id_provincia] => 24
        [url_nombre] => sevilla
        [nombre_provincia] => Sevilla
        [url_nombre_provincia] => sevilla
        [completa_nombre] =>  en Sevilla
    )
    

    LOCALIDAD

    
    

    SECCION NIVEL 1

                    Array
    (
        [id] => 2
        [nombre] => Inmobiliaria
        [url_nombre] => viviendas-y-locales
        [id_pertenece] => 0
        [title_asociado] => ++cat++ ++prov++
        [title_asociado2] => Anuncios inmobiliarios gratis ++prov++
        [title_asociado3] => 
        [h2] => 
        [orden] => 0
        [icos] => data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIyNTYiIGhlaWdodD0iMjU2IiB2aWV3Qm94PSIwIDAgMjQgMjQiPjxwYXRoIGZpbGw9IiNjZTEwMmEiIGQ9Im0xMiA1LjY5bDUgNC41VjE4aC0ydi02SDl2Nkg3di03LjgxbDUtNC41TTEyIDNMMiAxMmgzdjhoNnYtNmgydjZoNnYtOGgzIi8+PC9zdmc+
        [AV] => 
        [AV_url_nombre] => 
        [10] => Bienes Raices
        [10_url_nombre] => bienesraices
        [sinonimos] => inmueble inmuebles
        [palabra_rel] => 
        [cadena_adsense] => 
        [cat_rel_id] => 0
        [excluye_busqueda] => 0
        [seo_url] => viviendas-y-locales
        [texto_libre] => 
        [icono_app] => data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDov
        [forzado] => 0
        [icono_app_nuevo] => home
        [magicArray_key] => 
        [magicArray_value] => 
        [magicArray_prov_key] => 
        [magicArray_prov_value] => 
        [magicArray_loc_key] => 
        [magicArray_loc_value] => 
    )
                

    SECCION NIVEL 2

                    Array
    (
        [id] => 15
        [nombre] => Viviendas
        [url_nombre] => viviendas
        [id_pertenece] => 2
        [title_asociado] => ++subcat++ ++prov++
        [title_asociado2] => Anuncios de ++subcat++ ++prov++ tanto de particulares como de inmobiliarias
        [title_asociado3] => Si buscas casa encontrarás tu hogar tanto si buscas alquiler como compra
        [h2] => 
        [orden] => 0
        [icos] => 
        [AV] => Departamentos y Casas
        [AV_url_nombre] => departamentosycasas
        [10] => Departamentos y Casas
        [10_url_nombre] => departamentosycasas
        [sinonimos] => vivienda inmueble inmuebles domicilio domicilio
        [palabra_rel] => 
        [cadena_adsense] => casas en ++prov++
        [cat_rel_id] => 0
        [excluye_busqueda] => 0
        [seo_url] => viviendas-y-locales/viviendas
        [texto_libre] => 
        [icono_app] => 
        [forzado] => 0
        [icono_app_nuevo] => 
        [magicArray_key] => 
        [magicArray_value] => 
        [magicArray_prov_key] => 
        [magicArray_prov_value] => 
        [magicArray_loc_key] => 
        [magicArray_loc_value] => 
        [nombre_original] => Viviendas
        [url_nombre_original] => viviendas
    )
                

    SECCION NIVEL 3

                    Array
    (
        [nombre] => 
        [url_nombre] => 
        [id_subcategoria] => 
    )
                

    REQUEST

    Array
    (
        [id_prod] => 19164081205267
        [page_pos] => ficha
        [ficha_nombre] => anuncio/espectacular-casa-senorial-junto-plaza-de-la-alfalfa-con-vi-sevilla
        [1] => 3
        [no_cache] => 1
    )
    

    GET

    Array
    (
        [id_prod] => 19164081205267
        [page_pos] => ficha
        [ficha_nombre] => anuncio/espectacular-casa-senorial-junto-plaza-de-la-alfalfa-con-vi-sevilla
        [1] => 3
        [subsec] => 15
        [id_anuncio] => 19164081205267
    )
    

    38 MBytes usados de memoria

    Información Adicional

                    Page_pos: -ficha-
                                    id_ext: -1205267-
                    CA                            

    TIEMPOS DE EJECUCIÓN INCLUDE_ONCE

            

    Q-
    tiempo:3.0994415283203E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/anuncios.class.php

    Q-1
    tiempo:2.8610229492188E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/usuarios.class.php

    Q-2
    tiempo:6.9141387939453E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/util_lite.php

    Q-3
    tiempo:3.0994415283203E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/utils_webservice.php

    Q-4
    tiempo:1.9073486328125E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/categorias.class.php

    Q-5
    tiempo:2.1457672119141E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/provincias.class.php

    Q-6
    tiempo:4.0531158447266E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/anuncios.class.php

    Q-7
    tiempo:5.0067901611328E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/usuarios.class.php

    Q-8
    tiempo:1.0013580322266E-5
    /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/util_lite.php

    Q-9
    tiempo:3.0994415283203E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/utils_webservice.php

    Q-10
    tiempo:2.8610229492188E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/categorias.class.php

    Q-11
    tiempo:2.8610229492188E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/provincias.class.php

    Q-12
    tiempo:3.814697265625E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/anuncios.class.php

    Q-13
    tiempo:3.0994415283203E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/usuarios.class.php

    Q-14
    tiempo:6.9141387939453E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/util_lite.php

    Q-15
    tiempo:2.1457672119141E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/utils_webservice.php

    Q-16
    tiempo:1.9073486328125E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/categorias.class.php

    Q-17
    tiempo:2.8610229492188E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/provincias.class.php

    Q-18
    tiempo:5.0067901611328E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/anuncios.class.php

    Q-19
    tiempo:4.0531158447266E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/usuarios.class.php

    Q-20
    tiempo:1.0013580322266E-5
    /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/util_lite.php

    Q-21
    tiempo:4.0531158447266E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/utils_webservice.php

    Q-22
    tiempo:4.0531158447266E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/categorias.class.php

    Q-23
    tiempo:2.8610229492188E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/provincias.class.php

    Q-24
    tiempo:2.8610229492188E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/anuncios.class.php

    Q-25
    tiempo:2.1457672119141E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/usuarios.class.php

    Q-26
    tiempo:8.1062316894531E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/util_lite.php

    Q-27
    tiempo:2.8610229492188E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/utils_webservice.php

    Q-28
    tiempo:1.9073486328125E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/categorias.class.php

    Q-29
    tiempo:3.0994415283203E-6
    /var/www/vhosts/casinuevo.net/httpdocs/inc/class/provincias.class.php

    FICHEROS INCLUIDOS (208)

    Array
    (
        [0] => /var/www/vhosts/casinuevo.net/httpdocs/ficha.php
        [1] => /var/www/vhosts/casinuevo.net/httpdocs/globales.inc.php
        [2] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/autoload.php
        [3] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/composer/autoload_real.php
        [4] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/composer/ClassLoader.php
        [5] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/composer/autoload_static.php
        [6] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ralouphie/getallheaders/src/getallheaders.php
        [7] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/symfony/deprecation-contracts/function.php
        [8] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/guzzlehttp/guzzle/src/functions_include.php
        [9] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/guzzlehttp/guzzle/src/functions.php
        [10] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/react/promise/src/functions_include.php
        [11] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/react/promise/src/functions.php
        [12] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/symfony/polyfill-mbstring/bootstrap.php
        [13] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/symfony/polyfill-mbstring/bootstrap80.php
        [14] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient-services/autoload.php
        [15] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/mtdowling/jmespath.php/src/JmesPath.php
        [16] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/phpseclib/phpseclib/phpseclib/bootstrap.php
        [17] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/starkbank/ecdsa/src/ellipticcurve.php
        [18] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/starkbank/ecdsa/src/utils/file.php
        [19] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/starkbank/ecdsa/src/signature.php
        [20] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/starkbank/ecdsa/src/publickey.php
        [21] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/starkbank/ecdsa/src/privatekey.php
        [22] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/starkbank/ecdsa/src/ecdsa.php
        [23] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/aws/aws-sdk-php/src/functions.php
        [24] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/autoload.php
        [25] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Nodes/HotThreads.php
        [26] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/AbstractEndpoint.php
        [27] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Nodes/Info.php
        [28] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Nodes/ReloadSecureSettings.php
        [29] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Nodes/Stats.php
        [30] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Nodes/Usage.php
        [31] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Cluster/GetSettings.php
        [32] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Cluster/PutSettings.php
        [33] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/DeleteAlias.php
        [34] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/ExistsAlias.php
        [35] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/GetAlias.php
        [36] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/PutAlias.php
        [37] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/UpdateAliases.php
        [38] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/ClearCache.php
        [39] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/GetMapping.php
        [40] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/GetFieldMapping.php
        [41] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/PutMapping.php
        [42] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/GetSettings.php
        [43] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/PutSettings.php
        [44] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/GetTemplate.php
        [45] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/PutTemplate.php
        [46] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/ExistsTemplate.php
        [47] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/DeleteTemplate.php
        [48] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/ExistsType.php
        [49] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/GetUpgrade.php
        [50] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/Upgrade.php
        [51] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Indices/ValidateQuery.php
        [52] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Ingest/DeletePipeline.php
        [53] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Ingest/GetPipeline.php
        [54] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Ingest/PutPipeline.php
        [55] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Ingest/ProcessorGrok.php
        [56] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/GetScript.php
        [57] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/PutScript.php
        [58] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/DeleteScript.php
        [59] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Snapshot/CreateRepository.php
        [60] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Snapshot/DeleteRepository.php
        [61] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Snapshot/GetRepository.php
        [62] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Snapshot/VerifyRepository.php
        [63] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/GetSource.php
        [64] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/ExistsSource.php
        [65] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Tasks/ListTasks.php
        [66] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/aliases.php
        [67] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Client.php
        [68] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Service.php
        [69] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/AccessToken/Revoke.php
        [70] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/AccessToken/Verify.php
        [71] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Model.php
        [72] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Utils/UriTemplate.php
        [73] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/AuthHandler/Guzzle6AuthHandler.php
        [74] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/AuthHandler/Guzzle7AuthHandler.php
        [75] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/AuthHandler/AuthHandlerFactory.php
        [76] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Http/Batch.php
        [77] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Http/MediaFileUpload.php
        [78] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Http/REST.php
        [79] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Task/Retryable.php
        [80] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Task/Exception.php
        [81] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Exception.php
        [82] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Task/Runner.php
        [83] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Collection.php
        [84] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Service/Exception.php
        [85] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Service/Resource.php
        [86] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/google/apiclient/src/Task/Composer.php
        [87] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/icanboogie/inflector/lib/helpers.php
        [88] => /var/www/vhosts/casinuevo.net/httpdocs/inc/spoon.inc.php
        [89] => /var/www/vhosts/casinuevo.net/httpdocs/inc/class/mobile_detect.php
        [90] => /var/www/vhosts/casinuevo.net/httpdocs/inc/select_site.php
        [91] => /var/www/sysconf/casi.system.conf.php
        [92] => /var/www/vhosts/casinuevo.net/httpdocs/inc/pre_301.php
        [93] => /var/www/vhosts/casinuevo.net/httpdocs/inc/magic_array.php
        [94] => /var/www/vhosts/casinuevo.net/httpdocs/inc/array_ips.php
        [95] => /var/www/vhosts/casinuevo.net/httpdocs/inc/class/anuncios.class.php
        [96] => /var/www/vhosts/casinuevo.net/httpdocs/inc/class/usuarios.class.php
        [97] => /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/util_lite.php
        [98] => /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/utils_webservice.php
        [99] => /var/www/vhosts/casinuevo.net/httpdocs/inc/class/categorias.class.php
        [100] => /var/www/vhosts/casinuevo.net/httpdocs/inc/class/provincias.class.php
        [101] => /var/www/vhosts/casinuevo.net/httpdocs/webservice/ws_form.php
        [102] => /var/www/vhosts/casinuevo.net/httpdocs/inc/utils_casi.php
        [103] => /var/www/vhosts/casinuevo.net/httpdocs/inc/utils_casi_alertas.php
        [104] => /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/funciones_html.php
        [105] => /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/funciones_seo.php
        [106] => /var/www/vhosts/casinuevo.net/httpdocs/inc/utils/funciones_webservice.php
        [107] => /var/www/vhosts/casinuevo.net/httpdocs/inc/filtros_ini.php
        [108] => /var/www/vhosts/casinuevo.net/httpdocs/upload/resize_class.php
        [109] => /var/www/vhosts/casinuevo.net/httpdocs/inc/class/app/display.class.php
        [110] => /var/www/vhosts/casinuevo.net/httpdocs/inc/class/filtros.class.php
        [111] => /var/www/vhosts/casinuevo.net/httpdocs/inc/conector.php
        [112] => /var/www/vhosts/casinuevo.net/httpdocs/inc/config_db.php
        [113] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/ClientBuilder.php
        [114] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/psr/log/src/NullLogger.php
        [115] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/psr/log/src/AbstractLogger.php
        [116] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/psr/log/src/LoggerTrait.php
        [117] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/psr/log/src/LoggerInterface.php
        [118] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Client/CurlHandler.php
        [119] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Client/CurlFactory.php
        [120] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Client/CurlMultiHandler.php
        [121] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Client/Middleware.php
        [122] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Serializers/SmartSerializer.php
        [123] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Serializers/SerializerInterface.php
        [124] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/ConnectionFactory.php
        [125] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/ConnectionFactoryInterface.php
        [126] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/ConnectionPool/Selectors/RoundRobinSelector.php
        [127] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/ConnectionPool/Selectors/SelectorInterface.php
        [128] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php
        [129] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/ConnectionInterface.php
        [130] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Client.php
        [131] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/ConnectionPool/StaticNoPingConnectionPool.php
        [132] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/ConnectionPool/AbstractConnectionPool.php
        [133] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/ConnectionPool/ConnectionPoolInterface.php
        [134] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Transport.php
        [135] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/AsyncSearchNamespace.php
        [136] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/AbstractNamespace.php
        [137] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/AutoscalingNamespace.php
        [138] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/CatNamespace.php
        [139] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/CcrNamespace.php
        [140] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/ClusterNamespace.php
        [141] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/DanglingIndicesNamespace.php
        [142] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/DataFrameTransformDeprecatedNamespace.php
        [143] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/EnrichNamespace.php
        [144] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/EqlNamespace.php
        [145] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/FeaturesNamespace.php
        [146] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/FleetNamespace.php
        [147] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/GraphNamespace.php
        [148] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/IlmNamespace.php
        [149] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/IndicesNamespace.php
        [150] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/IngestNamespace.php
        [151] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/LicenseNamespace.php
        [152] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/LogstashNamespace.php
        [153] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/MigrationNamespace.php
        [154] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/MlNamespace.php
        [155] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/MonitoringNamespace.php
        [156] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/NodesNamespace.php
        [157] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/RollupNamespace.php
        [158] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/SearchableSnapshotsNamespace.php
        [159] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/SecurityNamespace.php
        [160] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/ShutdownNamespace.php
        [161] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/SlmNamespace.php
        [162] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/SnapshotNamespace.php
        [163] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/SqlNamespace.php
        [164] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/SslNamespace.php
        [165] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/TasksNamespace.php
        [166] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/TextStructureNamespace.php
        [167] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/TransformNamespace.php
        [168] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/WatcherNamespace.php
        [169] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Namespaces/XpackNamespace.php
        [170] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Info.php
        [171] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Core.php
        [172] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Future/CompletedFutureArray.php
        [173] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Future/CompletedFutureValue.php
        [174] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Future/FutureInterface.php
        [175] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/react/promise/src/PromiseInterface.php
        [176] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/react/promise/src/PromisorInterface.php
        [177] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Future/FutureArrayInterface.php
        [178] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Future/FutureArray.php
        [179] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Future/MagicFutureTrait.php
        [180] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/ezimuel/ringphp/src/Future/BaseFutureTrait.php
        [181] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/react/promise/src/FulfilledPromise.php
        [182] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/react/promise/src/ExtendedPromiseInterface.php
        [183] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/react/promise/src/CancellablePromiseInterface.php
        [184] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/psr/log/src/LogLevel.php
        [185] => /var/www/vhosts/casinuevo.net/httpdocs/inc/initpage.php
        [186] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/icanboogie/inflector/lib/Inflector.php
        [187] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/icanboogie/inflector/lib/Inflections.php
        [188] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/icanboogie/inflector/lib/Inflections/es.php
        [189] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/icanboogie/inflector/lib/InflectionsConfigurator.php
        [190] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Endpoints/Search.php
        [191] => /var/www/vhosts/casinuevo.net/httpdocs/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Utility.php
        [192] => /var/www/vhosts/casinuevo.net/httpdocs/app_verano/ficha_escritorio.php
        [193] => /var/www/vhosts/casinuevo.net/httpdocs/app/metatags.php
        [194] => /var/www/vhosts/casinuevo.net/httpdocs/css/inline_styles.php
        [195] => /var/www/vhosts/casinuevo.net/httpdocs/inc/analytics.php
        [196] => /var/www/vhosts/casinuevo.net/httpdocs/app_verano/loaders/ficha_anuncios_similares.php
        [197] => /var/www/vhosts/casinuevo.net/httpdocs/app_verano/publi_images.php
        [198] => /var/www/vhosts/casinuevo.net/httpdocs/resources/views/partials/path_ficha.php
        [199] => /var/www/vhosts/casinuevo.net/httpdocs/app_verano/loaders/formContacto.php
        [200] => /var/www/vhosts/casinuevo.net/httpdocs/resources/views/partials/path_neo.php
        [201] => /var/www/vhosts/casinuevo.net/httpdocs/resources/views/partials/path.php
        [202] => /var/www/vhosts/casinuevo.net/httpdocs/app_verano/loaders/ficha_mas_anuncios.php
        [203] => /var/www/vhosts/casinuevo.net/httpdocs/app_verano/header.php
        [204] => /var/www/vhosts/casinuevo.net/httpdocs/app_verano/buscadorHeader.php
        [205] => /var/www/vhosts/casinuevo.net/httpdocs/app/footer.php
        [206] => /var/www/vhosts/casinuevo.net/httpdocs/app/footer_js_includer.php
        [207] => /var/www/vhosts/casinuevo.net/httpdocs/js/merge_js_app/combine_js.php
    )
    

    SEO Micro Conversion

                                    :arraySeoMicroConvSubsec
    :arraySeoMicroConv
    :count_arraySeoMicroCheck

    Estado de Elastic

                    Elastic ON            

    MYSQL Log

                    

    Qx-1
    tiempo:0.00020718574523926
    SELECT * FROM `301` WHERE old_url = ?

    Qx-2
    tiempo:0.00058221817016602
    /*getCategorias*/SELECT * FROM categorias c WHERE 1 AND c.id != 157 order by orden

    Qx-3
    tiempo:0.0023651123046875
    /*getMicroCategorias*/SELECT cc.*,c.url_nombre sub_categoria_nombre FROM categorias_micro cc INNER JOIN categorias c WHERE c.id = cc.id_subcategoria order by orden,nombre

    Qx-4
    tiempo:0.00019717216491699
    SELECT id,nombre,url_nombre,id_pais FROM comunidades com WHERE id_pais = 1 order by nombre asc

    Qx-5
    tiempo:5.1021575927734E-5
    SELECT * FROM estado_tabla_busquedas

    Qx-6
    tiempo:0.15193009376526
    Elastic Anuncios Class

    Qx-7
    tiempo:0.15193510055542
    Elastic getAnuncioById

    Qx-8
    tiempo:0.00026607513427734
    SELECT id_cat_esp,valor,nombre,visualizacion,visible from categorias_datos_esp e, categorias_datos_val v WHERE e.id = v.id_cat_esp AND v.id_anuncio = 19164081205267 order by orden

    Qx-9
    tiempo:0.00012993812561035
    SELECT * FROM usuarios WHERE id = 1916408 LIMIT 1

    Qx-10
    tiempo:0.13561701774597
    Elastic anuncios_getAll_1_mas dame_mas_anuncios

    ⌚ MYSQL: (tiempo:0.44328093528748 )

    Function Log

                    




    TOTAL function
    0


    ⌚ FUNCTION TOTAL: (0)

    Host Information

    ns346924.ip-37-187-252.eu

    Server Variables ($_SERVER)

    USER: sad213asd
    HOME: /var/www/vhosts/casinuevo.net
    HTTP_COOKIE: PHPSESSID=gddno6abto1k6iud5d24gln3ed
    HTTP_CF_IPCOUNTRY: US
    HTTP_CF_CONNECTING_IP: 18.218.54.178
    HTTP_CDN_LOOP: cloudflare; loops=1
    HTTP_X_FORWARDED_PROTO: https
    HTTP_X_FORWARDED_FOR: 18.218.54.178
    HTTP_CF_RAY: 93a242953c5c616b-ORD
    HTTP_ACCEPT_ENCODING: gzip, br
    HTTP_ACCEPT: */*
    HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
    HTTP_CF_VISITOR: {"scheme":"https"}
    HTTP_HOST: www.casinuevo.com
    REDIRECT_STATUS: 200
    SERVER_NAME: www.casinuevo.com
    SERVER_PORT: 443
    SERVER_ADDR: 178.33.112.93
    REMOTE_PORT:
    REMOTE_ADDR: 18.218.54.178
    SERVER_SOFTWARE: nginx/1.26.3
    GATEWAY_INTERFACE: CGI/1.1
    HTTPS: on
    REQUEST_SCHEME: https
    SERVER_PROTOCOL: HTTP/2.0
    DOCUMENT_ROOT: /var/www/vhosts/casinuevo.net/httpdocs
    DOCUMENT_URI: /ficha.php
    REQUEST_URI: /anuncio/espectacular-casa-senorial-junto-plaza-de-la-alfalfa-con-vi-sevilla-19164081205267
    SCRIPT_NAME: /ficha.php
    CONTENT_LENGTH:
    CONTENT_TYPE:
    REQUEST_METHOD: GET
    QUERY_STRING: id_prod=19164081205267&page_pos=ficha&ficha_nombre=anuncio/espectacular-casa-senorial-junto-plaza-de-la-alfalfa-con-vi-sevilla&1=3&
    SCRIPT_FILENAME: /var/www/vhosts/casinuevo.net/httpdocs/ficha.php
    PATH_INFO:
    FCGI_ROLE: RESPONDER
    PHP_SELF: /ficha.php
    REQUEST_TIME_FLOAT: 1746301540.7346
    REQUEST_TIME: 1746301540

    Cookies ($_COOKIE)

    PHPSESSID: gddno6abto1k6iud5d24gln3ed
    elastic

    Numero: 1 Consultas ELASTICSEARCH

    Array
    (
        [0] => Array
            (
                [query] => Array
                    (
                        [bool] => Array
                            (
                                [must] => Array
                                    (
                                        [0] => Array
                                            (
                                                [match] => Array
                                                    (
                                                        [id_rel] => Array
                                                            (
                                                                [query] => 19164081205267
                                                            )
    
                                                    )
    
                                            )
    
                                    )
    
                            )
    
                    )
    
            )
    
    )
    
    [{"query":{"bool":{"must":[{"match":{"id_rel":{"query":"19164081205267"}}}]}}}]
    *****