Luxury Houses for sale in San Bernardo, Seville

Located between the Buhaira and the Old Town, the neighborhood of San Bernardo, the cradle of bullfighters, tradition transmitted on all four sides. Narrow streets of Seville populated typical houses, is full of nooks and historic buildings such as the parish of San Bernardo, Arms Factory or the Bridge of San Bernardo.

  • Location
  • Area
  • ERROR:

    Archivo /furanet/sites/buhairaconsulting.com/web/htdocs/plantilla.php
    Lnea 118

    Archivo /furanet/sites/buhairaconsulting.com/web/htdocs/plantillas/inmuebles.php
    Lnea 627 ->

    Archivo /furanet/sites/buhairaconsulting.com/web/htdocs/clases/BaseDeDatos.php
    Lnea 72 ->

    Error MySQL:

    Unknown column 'bc_inmuebles_tipos.web' in 'order clause'

    Consulta SQL:

    SELECT bc_inmuebles_tipos_en.* FROM bc_inmuebles_tipos_en , bc_inmuebles WHERE visible = 1 AND vendido = 0 AND bc_inmuebles.zona = '1' AND bc_inmuebles.tipo < 1000 AND bc_inmuebles.tipo = bc_inmuebles_tipos_en.id AND bc_inmuebles.localidad = 8676 AND bc_inmuebles.servicio_0 = 1 GROUP BY bc_inmuebles_tipos_en.id ORDER BY bc_inmuebles_tipos.web, bc_inmuebles_tipos_en.nombre