query=
-- _c_empresa.php inicializar()
SELECT *
FROM empresa
WHERE 1=1
AND web = 100
AND estado = 'A'
num_tuplas=
96
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 = 490941
-- 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 = 490941
) 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 = 490941 -- [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 = 490941
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 = 490941
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 = 490941
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 Campo de Mijas [490941]
Cluster house Campo de Mijas
1.325.000€ (£ 1.162.688 approx.) Ref.THOR-490941 | SI1802
Joy is felt and lived in unique places, in every sunrise feeling joy is a pleasure, feeling nature, feeling the mountains, feeling the sea, the pure air that fills your lungs perceiving the joy of being in a wonderful place.
located in campo Mijas five minutes from the mountains and the sea. It is the pleasure of being surrounded by nature and very close to the city, with excellent views of the valley, the mountains and the sea.
Distributed on three levels, starting with a large basement, a garage and a cozy multipurpose space for family enjoyment. From this level we connect with the pool through a large terrace that is partly covered and partly pergola, where you can perceive the freshness of green plants in a beautiful garden.
On the ground floor, we access a formidable open space dedicated to the kitchen and living room, here is the staircase and elevator core that connects all levels with special comfort.
The upper floor, designed with 3 bedrooms, the master bedroom en suite with a large dressing room and a beautiful terrace with beautiful views of the sea. This floor is completed with two bedrooms that have built-in wardrobes and also a common bathroom in the central area.
The location of is privileged due to its proximity to the Las Lagunas de Mijas neighborhood, where all services, shopping centers, restaurants, medical clinics and excellent access to the Costa Del Sol highway are located. Located 15 minutes from the airport and 20 minutes from the great city of Malaga, which offers abundant offers in leisure, culture and typical gastronomy of the place. For sports lovers, 5 minutes away we have Mijas Golf, Tennis Club, Soccer, Horse Racing, Athletics and much more...,
deserves to be experienced, for its wonderful design made with comfort in each space, for its connection with the sea and nature and for its elegant, contemporary and unique style.
VILLA DESIGNED ON THREE LEVELS. We take the street level as a reference for its description, which we will always call "LEVEL 0", the plants that are above this level will have a sign (+) and those that are below will have a sign (-):
- LEVEL -1 Basement, distributed in: parking area, facilities room, leisure room, toilet, multipurpose space and swimming pool.
- LEVEL 0 Main, distributed in: living room, kitchen-dining room, toilet, terraces.
- LEVEL +1 Bedrooms, is distributed in: Bedroom 1 with en-suite bathroom, dressing room and terrace; Bedroom 2 with wardrobe and terrace; Bedroom 3 with wardrobe and terrace; and common bathroom.
- GARDEN, a garden with trees and decorative plants has been designed in the area of the plot that has not been built.
OUR SYSTEM IS A LA CARTE. Being faithful to it, everything we offer is a starting point for our clients: The design of the villa will be adjusted to the client's taste; The quality elements will be chosen by the client, for which we offer three quality levels that, in ascending order, we call them: GOLD, PLATINUM and DIAMOND.
OUR MISSION. It is giving the client a wide range of options in design and quality, so that he can easily create his living space with the finishing elements that he really likes and that make him feel emotionally good.
This villa has been designed on a plot located in the Campomijas urbanization, Mijas. Malaga
The reference prices in this prototype location for the three quality levels offered are: GOLD Level Price: €1,325,000; PLATINUM Level Price: €1,523,750 and DIAMOND Level Price: €1,752,350.
The prices offered do not include taxes inherent to the sale and will be updated on the date of signing the corresponding sales contract in promotion.
OUR METHOD IS A LA CARTE. The client decides and always has the last word, because we have a deep respect for his personal wishes and privacy.
We establish 3 very simple steps:
1.- Choice of villa and location. From the collection of villas and the catalog of plots offered, the client chooses the one he really likes and best fits his needs and desires. "From this moment everything begins."
2.- Adjust the design. Once the villa and location have been chosen, the client can adjust the interior and exterior design to their personal needs, with the utmost respect for the applicable regulations and, always with the help and advice of our technical team who will inform them about the feasibility technique of the proposed changes.
3.-Choice of finishing elements. We offer a variety of options in finishing elements. Selected from the feeling of balance, harmony and well-being, always seeking maximum ease and comfort for our clients. In each of the villas in the collection we offer three levels of quality that, in ascending order, we call them: GOLD, PLATINUM and DIAMOND.
Size:586m² :500m² Bedroom/s:3 Baths:2
Reference:
490941 - SI1802
Size:
586m²
Plot size:
500m²
Bedrooms:
3
Bathrooms:
2
Garage:
Private
Swimming pool:
Private
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Orientation:
Southeast, South, Southwest
Heating:
Centralized
Air conditioning:
Cold
No. of floors:
2
Condition:
Excellent
Equipment:
Light, Floor heating (total)
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.