Country houses for sale in Seville and Andalusia

In Fincas Rusticas Buhaira we offer you a selection of the best recreational, farming and breeding country houses for sale in Seville and Andalusia

See country houses for sale in Spain

Do you want to sell your country estate?

If you have a country house and are looking to sell it you can contact us by calling to +34 954 562 939 or by email at the address
info@buhairaconsulting.com

Latest country houses for sale

ERROR:

Archivo /furanet/sites/fincasrusticasbuhaira.com/web/htdocs/plantilla.php
Lnea 77

Archivo /furanet/sites/fincasrusticasbuhaira.com/web/htdocs/plantillas/portada.php
Lnea 98 ->

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

Error MySQL:

Unknown column 'servicio' in 'where clause'

Consulta SQL:

SELECT *, (precio - descuento) AS precio_f FROM bc_inmuebles WHERE tipo = 4 AND visible = 1 AND vendido = 0 AND servicio = 0 ORDER BY id DESC LIMIT 6