query=
-- _c_empresa.php inicializar()
SELECT *
FROM empresa
WHERE 1=1
AND web = 100
AND estado = 'A'
num_tuplas=
95
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=
15740
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=
977
query=
-- _c_propiedad.php inic_empresa_captadora()
SELECT web, cod_empresa
FROM propiedad
WHERE -- web = 100 -- Con MLS multi web no procede
cod_propiedad = 490739
-- 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=
-- Funcion: recuperar_de_bbdd | Fichero: /var/www/clients/client1/web8/web/_proc/propiedad/_c_propiedad.php
SELECT *
FROM propiedad
WHERE (
web = 100
AND cod_empresa = 265
AND cod_oficina = 0
AND cod_propiedad = 490739
) 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 = 490739 -- [20170919a] Para enlaces amigables a propiedades de MLS
AND TRUE
)
-- [20171128b]
ORDER BY
CASE WHEN web = 100 AND cod_empresa = 265 THEN 1
ELSE 9
END
num_tuplas=
1
query=
SELECT id_grupo
FROM propiedades_agrupadas
WHERE web = 100
AND cod_empresa = 265
AND cod_propiedad = 490739
num_tuplas=
0
query=
-- _c_propiedad.php / cargar_portales_externos_publicacion_propiedad()
SELECT *
FROM propiedad_portal_ext
WHERE web = 100
AND cod_empresa = 265
AND cod_propiedad = 490739
num_tuplas=
0
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 = 265
AND cod_propiedad = 490739
num_tuplas=
0
query=
-- _c_empresa.php inicializar()
SELECT *
FROM empresa
WHERE 1=1
AND web = 100
AND cod_empresa = 265
AND estado = 'A'
num_tuplas=
1
query=
-- Función: recuperar_distribuidores_y_comerciales | Fichero /var/www/clients/client1/web8/web/_proc/per_emp/_c_per_emp.php
SELECT per_emp.cod_per_emp,
per_emp.cod_relacion,
per_emp.nombre,
per_emp.email,
num_telefono
FROM per_emp
LEFT JOIN per_emp_telefono ON (
per_emp.web = per_emp_telefono.web
AND per_emp.cod_empresa = per_emp_telefono.cod_empresa
AND per_emp.cod_per_emp = per_emp_telefono.cod_per_emp
)
WHERE per_emp.web = 100
AND per_emp.cod_empresa = 265
AND per_emp.cod_oficina = 0
AND per_emp.estado = 'A'
AND per_emp.cod_relacion IN ('E', 'V', 'X')
GROUP BY per_emp.cod_per_emp
num_tuplas=
4
MM Estates Spain Cluster house for sale [490739]
Cluster house
2.790.000€ (£ 2.448.227 approx.) Ref.THOR-490739
Elegant symmetry, high ceilings and generous proportions are what define this beautiful property in Villa Padierna. A classically Andalusian home that was designed to sit perfectly under the Mediterranean skies, and providing comfort, space and security for it´s owners.
This elegant villa in Los Flamingos is new to the market and is available now. Built buy it´s current owners, the very well-built property in one of the best locations in the Costa del Sol has been their family home since it was built in 2003, sitting elegantly on it´s elevated plot next to Villa Padierna and allowing for wonderful views across the residential community of Benahavis and across to the Mediterranean Sea.
The viila has a gated entrance into the gardens on foot, as well as an automated one for arrival by car. The front of the villa is very pretty with the mature gardens and foliage that have grown over the years presenting a very picturesque entrance, with decorative iron gates and a stone pathway. Large wooden doors open into the hallway of this Los Flamingos villa, and as they open, the eye is pulled directly through the hallway, through the spacious open plan living room, out to the elevated terrace and straight to the views of the sea which are available to see from every room in this gorgeous Benahavis home.
The heart of this home is the large wide living room area which dominates the ground floor. It´s full width faces south and it´s facadw is fitted with floor to ceiling patio doors, which of course allow for the maximum appreciation of the stunning views that are seen on the horizon. Within this large salon are several seating areas. One for comfort, one more formal for afternoon tea, and with a centrally located fireplace that can be navigated around 360 degrees.
Wonderful villa in los Flamingos with incredible views to the sea and huge potential for reform.
Size:571m² :1.641m² Bedroom/s:4 Baths:5
Reference:
490739
Size:
571m²
Plot size:
1.641m²
Bedrooms:
4
Bathrooms:
5
Terraces:
(100.00m²)
Orientation:
South
No. of floors:
3
Condition:
Good
MM Estates Spain, Tirreno, 4., 29620Torremolinos.+34.670.955.108https://www.mmestatesspain.com/
Documento elaborado por MM Estates Spain con información de la propiedad para su
compraventa, arrendamiento o traspaso. Con su aceptación, el destinatario se compromete a no copiarlo,
reproducirlo o distribuirlo a terceros, ni total ni parcialmente, sin el consentimiento escrito de MM Estates Spain,
que declina expresamente toda la responsabilidad por las
manifestaciones, expresas o implícitas, u omisiones, o por cualesquiera otras
comunicaciones orales o escritas hechas a cualquier parte interesada. Esta información no constituye un valor contractual.