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 = 490745
			) 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 = 490745	-- [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 = 490745
		

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 = 490745
		

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	= 490745
			

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	= 490745

			-- 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	= 490745
			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
			(
				 818
				,'http://www.artekasa.es//_proc/propiedad/detalle.php?web=100&web_empresa_captadora=100&cod_empresa_captadora=265&cod_propiedad=490745&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

Coín, Málaga

House for sale

RefTHOR-490745 🔗

Ref2.MRE526

489.000€

Exquisite Semi-Detached Residence in the Prestigious Los Nebrales Community

Discover unparalleled luxury within the esteemed Los Nebrales community, where this magnificent semi-detached residence stands as a testament to modern refinement intertwined with rustic allure. Just a swift 7-minute drive from vibrant Spanish towns like Coin and Alhaurin el Grande, this home promises a lifestyle of opulence and sophistication.

Crafted with meticulous attention to detail and adorned with premium materials, this home exudes enduring quality and timeless elegance. Boasting four bedrooms and three impeccably appointed bathrooms, including a sumptuous ensuite, the residence offers ample space for both comfortable living and stylish entertaining.

The luminous and expansive living room seamlessly flows into the fully equipped kitchen, which opens onto the inviting pool area—an idyllic retreat surrounded by sprawling outdoor spaces, perfect for leisurely relaxation and alfresco gatherings. Numerous terraces on each level provide captivating views and delightful opportunities to bask in the Mediterranean ambiance. There is also a garage space for the car and a utility room on this level.

Luxurious amenities including comprehensive air conditioning, electric blinds, central heating, and exquisite marble flooring enrich the living experience, while communal features such as meticulously landscaped gardens, a communal pool, and a clubhouse foster a sense of community and leisure. With its prime location just 30 minutes from Malaga airport and convenient access to essential amenities, this residence epitomizes the epitome of luxurious living in Los Nebrales.

Reference:

490745 - MRE526

Size:

247m²

Plot size:

454m²

Bedrooms:

4

Bathrooms:

3

Garage:

Private

Swimming pool:

Comunitary

Garden:

Comunitary

Furnished kitchen:

Furnished with appliances

Terraces:

(49.00m²)

Orientation:

North, Southeast, South

Heating:

Centralized

Air conditioning:

Cold

No. of floors:

2

Condition:

Excellent

Equipment:

Light, Chimney

Security measures:

Alarm

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