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= 
-- 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 = 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  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_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= 
-- _c_propiedad.php recuperar_videos_propiedad()
			SELECT *
			FROM propiedad_video
			WHERE web			= 100
			  AND cod_empresa	= 265
			  AND cod_propiedad	= 490941
			ORDER BY fecha_sis_alta ASC -- DESC
			
		

num_tuplas= 
0

Home

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= 
-- _c_enlace.php url_corta()
			INSERT INTO enlace
			(
				 cod_control
				,url_larga
			)
			VALUES
			(
				 155
				,'http://www.artekasa.es//_proc/propiedad/detalle.php?web=100&web_empresa_captadora=100&cod_empresa_captadora=265&cod_propiedad=490941&idioma=en&modiframe=1&modportal=1'
			);

num_tuplas= 
1

query= 

			-- _c_empresa.php inicializar()
			SELECT *
			FROM empresa
			WHERE 1=1
			  AND web 			= 100
			
			AND estado = 'A'
		

num_tuplas= 
95

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 	= 265
			AND estado = 'A'
		

num_tuplas= 
1

Tweet

Campo de Mijas, Málaga

Cluster house for sale

RefTHOR-490941 🔗

Ref2.SI1802

1.325.000€

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.

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)

Contact us

Information on property

Please, complete the information in this form to send your request

For

Subject

Message

Name

Phone number

Email

Reference

I wish to receive information on new properties

I wish to receive news

Security code

Accept Privacy policy

MM Estates Spain
https://www.mmestatesspain.com/
+34.670.955.108