query=
-- _c_empresa.php inicializar()
SELECT *
FROM empresa
WHERE 1=1
AND web = 100
AND estado = 'A'
num_tuplas=
99
query=
-- _c_zonas.php / cargar_metazonas_superzonas_zonas()
SELECT
metazonas.cod_metazona
-- 20131122 avv
,metazonas.cod_provincia
,metazonas.denom_metazona
,superzonas.cod_superzona
,superzonas.denom_superzona
-- 20131129 rbz [1872-1873]
,metazonas.coord_latitud
,metazonas.coord_longitud
,metazonas.area_coordenadas
,metazonas.zoom_mapa
FROM
metazonas
,superzonas
WHERE
-- 20130902 rbz [1826-1827]
-- superzonas.web = '100'
superzonas.web = 0
AND metazonas.cod_metazona = superzonas.cod_metazona
AND superzonas.cod_metazona IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61 ,99)
-- 20140116 rbz [20140116a].
-- [20180426b]
ORDER BY
metazonas.cod_metazona
,superzonas.cod_superzona
;
num_tuplas=
9229
query=
-- _c_zonas.php cargar_zonas()
SELECT
zonas.cod_metazona
,zonas.cod_superzona
,zonas.cod_maxizona
,zonas.cod_zona
,zonas.denom_zona
FROM
zonas
WHERE
-- 20130902 rbz [1826-1827]
-- web = '100'
web = 0
-- //20130425a rbz [20130425a] Cuidado! Esto podrá mejorar el rendimiento, pero al acceder al detalle de propiedad, el formulario de búsqueda avanzado queda incompleto! (le faltan todas las zonas menos la de la propiedad consultada
-- AND (zonas.cod_superzona = '' OR '' = '')
AND zonas.indicador > 0
-- 20140116 rbz [20140116a]..
-- [20180426b]
ORDER BY
zonas.cod_superzona
,zonas.cod_zona
;
num_tuplas=
15737
query=
-- _c_zonas.php cargar_subzonas()
SELECT
subzonas.cod_metazona
,subzonas.cod_superzona
,subzonas.cod_zona
,subzonas.cod_subzona
,subzonas.denom_subzona
FROM
subzonas
WHERE
web = 0
-- 20140116 rbz [20140116a]....
-- [20180426b]
ORDER BY
subzonas.cod_metazona
,subzonas.cod_superzona
,subzonas.cod_zona
;
num_tuplas=
965
query=
-- Funcion: recuperar_de_bbdd | Fichero: /var/www/clients/client1/web8/web/_proc/propiedad/_c_propiedad.php
SELECT *
FROM propiedad
WHERE (
web = 100
AND cod_oficina = 0
AND cod_propiedad = 374297
) OR (
-- Cuidado!! Se puede acceder a propiedades de otras inmos cambiando la referencia en http://www.artekasa.es/_proc/propiedad/propiedad_abmc.php?idioma=es&oper=modi&cod_propiedad=158978 Lo soluciono con inicializar_campos_privados()
cod_propiedad = 374297 -- [20170919a] Para enlaces amigables a propiedades de MLS
AND TRUE
)
-- [20171128b]
ORDER BY
CASE WHEN web = 100 THEN 1
ELSE 9
END
num_tuplas=
1
query=
SELECT id_grupo
FROM propiedades_agrupadas
WHERE web = 100
AND cod_empresa = 288
AND cod_propiedad = 374297
num_tuplas=
0
query=
-- _c_propiedad.php / cargar_portales_externos_publicacion_propiedad()
SELECT *
FROM propiedad_portal_ext
WHERE web = 100
AND cod_empresa = 288
AND cod_propiedad = 374297
num_tuplas=
17
query=
-- Función: recuperar_propiedad_mls | Fichero: /var/www/clients/client1/web8/web/_proc/propiedad/_c_propiedad_mls_privada.php
SELECT *
FROM propiedad_mls
WHERE cod_mls IN ('')
AND web_cap = 100
AND cod_empresa_cap = 288
AND cod_propiedad = 374297
num_tuplas=
0
query=
-- _c_propiedad.php inic_empresa_captadora()
SELECT web, cod_empresa
FROM propiedad
WHERE -- web = 100 -- Con MLS multi web no procede
cod_propiedad = 374297
-- 20160208a
AND
(
cod_empresa = 000 -- La propiedad es de la empresa de la web accedida
-- La propiedad es de otra empresa de la MLS (y la empresa de la web accedida publica en su web propiedades de la MLS)
OR
(
mls_1
AND '' = '1'
)
-- Caso especial de Inmonova
OR
(
000 IN (60,62,64,114,286) -- La empresa de la web es del grupo
AND cod_empresa IN (60,62,64,114,286) -- La empresa propietaria de la propiedad es del grupo
)
-- [20160216a] Caso especial de Jenafer / Inmo Sol Mobeca
-- OR
-- (
-- 000 IN (42) -- La empresa de la web es Jenafer
-- AND cod_empresa IN (42,110) -- La empresa propietaria de la propiedad es Jenafer
-- )
OR
(
000 IN (110) -- La empresa de la web es Inmo Sol Mobeca
AND cod_empresa IN (42) -- La empresa propietaria de la propiedad es Jenafer
)
)
num_tuplas=
0
query=
-- _c_propiedad.php recuperar_videos_propiedad()
SELECT *
FROM propiedad_video
WHERE web = 100
AND cod_empresa = 288
AND cod_propiedad = 374297
ORDER BY fecha_sis_alta ASC -- DESC
num_tuplas=
0
For Sale Chalet - Ferrol, La Coruña (A Coruña) [374297/51704540]
query=
-- _c_empresa.php inicializar()
SELECT *
FROM empresa
WHERE 1=1
AND web = 100
AND estado = 'A'
num_tuplas=
99
query=
-- Función: recuperar_empresa | Fichero: /var/www/clients/client1/web8/web/_proc/empresa/_c_empresa.php
SELECT *
FROM empresa
WHERE web = 100
AND cod_empresa = 000
num_tuplas=
1
query=
-- _c_empresa.php inicializar()
SELECT *
FROM empresa
WHERE 1=1
AND web = 100
AND cod_empresa = 288
AND estado = 'A'
num_tuplas=
1
Independent Chalet destined for a single-family dwelling located in Serantellos, in the municipality of Ferrol, very close is the hermitage of Chamorro, built in the 16th century, it is located on the slope of the mountain of the same name and from its atrium, 175 m from altitude, there is a magnificent panoramic view of the Ferrol region, with the Serantes valley in the foreground and the city of Ferrol in the background. The house is composed of an undistributed basement, ground floor, upper first floor and storage room. It is distributed in several and various rooms, among which it is worth highlighting a spacious living room with a fireplace, bedrooms with fitted wardrobes, an independent kitchen, different bathrooms and a garage. Its rooms are spacious and bright, perfect for making family life more comfortable, and it has a fantastic private garden with a swimming pool, where you can enjoy on hot summer days. Let yourself be carried away by its incredible surroundings, a privileged natural setting, ideal for tranquility and rest. In addition there are fabulous beaches within a radius of no more than 20 minutes by car, these beautiful beaches are frequented by surfers from all over the world for their magnificent waves, for example Doniños Beach, Pantin Beach and also peaceful beaches for share with the family like the beach of San Jorge and next to it the beach of Esmelle. The attractive gastronomic offer and spectacular landscapes make this vi
Reference:
374297 - 51704540
Size:
1.409m²
Usable size:
772m²
Bedrooms:
9
Bathrooms:
5
Furnished:
Not furnished
Swimming pool:
Private
Garden:
Private
Independent dining room:
Yes
Furnished kitchen:
Not
Kitchen type:
Independent
Orientation:
Southwest
Location:
Not far from the beach
Ceiling height:
High
Type of ceiling:
Plaster
Finishing carpentry :
Mahogany, Wood
Walls:
Cement
Floors:
Ceramic
Type of windows:
Wood
Storage room:
No
Type hot water:
Butane
Heating:
Individual
Heating type:
Propane
No. of floors:
2
Lift:
No
Style:
Modern
Facade:
Cement
Condition:
Needs some renovation
Availability:
Unoccupied
Equipment:
Water
Security measures:
Grille
Doorman:
No
Handicapped access:
Yes
location
Contact us
Information on property
Please, complete the information in this form to send your request
