For Sale House Spain
Camposol, Mazarrón , Costa Cálida , Spanje WEB:https://forsalehousespain.com

Ons ontstaan is eigenlijk niet zo’n lang verhaal maar misschien wel een zetje in de juiste richting want…Onze zoektocht begon enkele jaren geleden net zo als de uwe binnenkort zal zijn,en die heeft ons gebracht tot wat wij nu zijn…een Nederlandse makelaar in Spanje.

Een aantal jaren geleden kochten wij ons droomhuis samen met een Nederlandse makelaar uit deze regio in de urbanisatie Camposol dat gelegen is in de provincie Murcia aan de Costa Calida,mede door het geweldige mooie weer en de weinige regen is het een must om hier te wonen. Het heeft zeker wel wat te weeg gebracht maar onze keuze hadden we al best snel gemaakt. We maakte een afspraak met de makelaar en kregen via het makelaarskantoor een introductiereis van 3 dagen aangeboden om in die dagen samen met hem een aantal huizen van onze wensen te gaan bezichtigen.

Het was een innoverende introductiereis maar hebben toen wel de beslissing genomen om het huis waar wij nu al een tijdje met veel plezier wonen..gekocht. Door deze zoektocht zijn we enorm geïnspireerd geraakt in het makelaars vak en wilde kosten wat het kost ook heel veel mensen blij maken met het droomhuis van hun wensen, je ontmoet verschillende en aardige mensen maar het leukste en zeker het belangrijkste van makelaar zijn in Spanje is,dat ze samen met ons vinden waar ze al een tijdje over gedroomd hebben, je creëert een band en bouwt vertrouwen op..en daar doen we het voor.

Wij bouwen aan uw toekomst van morgen …vandaag

Bent u net zo als wij geïnspireerd geraakt…neem dan vlug een kijkje bij ons aanbod op de website, of neem contact met ons op.

Accept cookies

Immo Spanje maakt gebruik van cookies om u een betere ervaring te bieden Meer info.


2020-10-22T19:08:17+02:00info2048 Kb
Database connected
2020-10-22T19:08:17+02:00info2048 Kb
Database connected
2020-10-22T19:08:17+02:00sql2048 Kb
SELECT *, clave FROM immospanje_traducciones
2020-10-22T19:08:17+02:00sql4096 Kb
SELECT clave, valor FROM immospanje_config
2020-10-22T19:08:17+02:00sql4096 Kb
	SELECT id, clave, parent_id,
					titulo_nl AS titulo,
					link_nl AS link,
					slug_nl AS slug,
					meta_key_nl AS meta_key,
					meta_descr_nl AS meta_descr,
					art_nl AS text
					FROM immospanje_articulos 
					 WHERE slug_nl = 'agent' 
					
2020-10-22T19:08:17+02:00sql4096 Kb
	SELECT id, clave, 
					titulo_nl AS title,
					link_nl AS link,
					slug_nl AS slug,
					art_nl AS text
					FROM immospanje_articulos
					WHERE parent_id = 13
					ORDER BY orden
					
2020-10-22T19:08:17+02:00sql4096 Kb
SELECT file_name FROM immospanje_images_articulos WHERE parent_id = 13 ORDER BY orden
2020-10-22T19:08:17+02:00sql4096 Kb
SELECT file_name FROM immospanje_files_articulos WHERE parent_id = 13 ORDER BY orden
2020-10-22T19:08:17+02:00sql4096 Kb
 	SELECT *, id, clave, link_nl AS link,  titulo_nl AS titulo,
					slug_nl AS slug, header_menu, footer_menu, parent_id, orden
					FROM immospanje_articulos
					ORDER BY orden
					
2020-10-22T19:08:17+02:00sql4096 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'agente'
2020-10-22T19:08:17+02:00sql4096 Kb
 	SELECT *, id, clave, link_nl AS link,  titulo_nl AS titulo,
					slug_nl AS slug, header_menu, footer_menu, parent_id, orden
					FROM immospanje_articulos
					ORDER BY orden
					
2020-10-22T19:08:17+02:00sql4096 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'agente'
2020-10-22T19:08:17+02:00sql4096 Kb
SELECT *, titulo_nl AS titulo, link_nl AS link FROM immospanje_panoramicas ORDER BY orden
2020-10-22T19:08:17+02:00sql4096 Kb
 	SELECT *, id, clave, link_nl AS link,  titulo_nl AS titulo,
					slug_nl AS slug, header_menu, footer_menu, parent_id, orden
					FROM immospanje_articulos
					ORDER BY orden
					
2020-10-22T19:08:17+02:00sql4096 Kb
SELECT slug_nl, slug_fr, slug_en FROM immospanje_articulos WHERE clave = 'agente'
2020-10-22T19:08:17+02:00sql4096 Kb
                    SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
                    sup_parcela, precio_de_venta, precio_anterior, precio_desde, main.fecha_creado AS fecha_creado,
                    main.descripcion_nl AS descripcion, agente,
                    piscina_id AS piscina,
                    main.lat, main.lon, reservado, vendido,
                    main.titulo_nl AS titulo, loc.nombre AS localidad,
                    tip.nombre_nl AS tipo, cla.id AS clase_id,
                    cla.nombre_nl AS clase,
                    cos.nombre_nl AS costa,
                    age.nombre_comercial AS agente_nombre, age.telefono AS agente_telefono, age.email AS agente_email,
                    age.logo AS agente_logo,
                    
                        (SELECT img.file_name as file_name
                        FROM immospanje_images_viviendas img
                        WHERE img.parent_id = main.id
                        ORDER BY img.orden ASC
                        LIMIT 1) AS file_name
                    FROM immospanje_viviendas main
                    LEFT JOIN immospanje_localidades loc ON main.localidad_id = loc.id
                    LEFT JOIN immospanje_tipos tip ON main.tipo_id = tip.id
                    LEFT JOIN immospanje_clases cla ON main.clase_id = cla.id
                    LEFT JOIN immospanje_costas cos ON loc.costa_id = cos.id
                    LEFT JOIN immospanje_agentes age ON main.agente_id = age.id
                    WHERE 1 = 1
         AND (main.agente = 11) ORDER BY main.score DESC
2020-10-22T19:08:17+02:00sql4096 Kb
                    SELECT main.id AS main_id, referencia, dormitorios, banos, sup_vivienda,
                    sup_parcela, precio_de_venta, precio_anterior, precio_desde, main.fecha_creado AS fecha_creado,
                    main.descripcion_nl AS descripcion, agente,
                    piscina_id AS piscina,
                    main.lat, main.lon, reservado, vendido,
                    main.titulo_nl AS titulo, loc.nombre AS localidad,
                    tip.nombre_nl AS tipo, cla.id AS clase_id,
                    cla.nombre_nl AS clase,
                    cos.nombre_nl AS costa,
                    age.nombre_comercial AS agente_nombre, age.telefono AS agente_telefono, age.email AS agente_email,
                    age.logo AS agente_logo,
                    
                        (SELECT img.file_name as file_name
                        FROM immospanje_images_viviendas img
                        WHERE img.parent_id = main.id
                        ORDER BY img.orden ASC
                        LIMIT 1) AS file_name
                    FROM immospanje_viviendas main
                    LEFT JOIN immospanje_localidades loc ON main.localidad_id = loc.id
                    LEFT JOIN immospanje_tipos tip ON main.tipo_id = tip.id
                    LEFT JOIN immospanje_clases cla ON main.clase_id = cla.id
                    LEFT JOIN immospanje_costas cos ON loc.costa_id = cos.id
                    LEFT JOIN immospanje_agentes age ON main.agente_id = age.id
                    WHERE 1 = 1
         AND (main.agente = 11) ORDER BY main.score DESC LIMIT 0, 15 
2020-10-22T19:08:17+02:00sql4096 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql4096 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 14532
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql4096 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 17034
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 17018
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 13641
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 12940
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 15181
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 14542
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 14539
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 19716
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 13648
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 12935
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 12962
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 12973
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 14545
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
                    SELECT parent_id, file_name
                    FROM immospanje_images_viviendas
                    WHERE parent_id = 17507
                    ORDER BY orden
                     LIMIT 3 
                    
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT main.*, main.descripcion_nl AS descripcion, 
                cos.nombre_nl AS costa,
                pais.nombre_nl AS pais
                FROM immospanje_agentes main
                LEFT JOIN immospanje_paises pais ON main.pais_id = pais.id
                LEFT JOIN immospanje_costas cos ON main.costa_id = cos.id
                WHERE main.id = 11
2020-10-22T19:08:17+02:00sql6144 Kb
SELECT meta_descr_nl AS field FROM immospanje_articulos WHERE clave = 'inicio'
2020-10-22T19:08:17+02:00sql6144 Kb
	SELECT file_name, art.id AS aid
					FROM immospanje_images_articulos img
					JOIN immospanje_articulos art
						ON img.parent_id = art.id
					WHERE art.clave = 'agente'