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

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

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

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

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

Nueva andalucia, Málaga

Apartment for sale

RefTHOR-490744 🔗

Ref2.HRB-00284P

1.995.000€

Introducing Apartment Los Arrayanes, located in the prestigious La Cerquilla area of Nueva Andalucia. This stunning apartment offers breathtaking panoramic sea views! Designed for those who appreciate the finer things in life, it features a harmonious blend of modern and Andalusian styles, accentuated by elegant marble flooring that extends throughout the property.

This exquisite apartment boasts four well-appointed bedrooms and three luxurious bathrooms, complemented by a guest toilet, ensuring ample space and privacy for residents and their guests. The property spans a single floor, emphasising ease of access and a seamless flow between its meticulously designed spaces.

Upon entering, guests are greeted by a spacious hallway adorned with closets, leading to a versatile guest bedroom currently utilised as an office, adjacent to a convenient guest toilet. The heart of the apartment unfolds to the left, where a bright and airy living area merges seamlessly with a state-of-the-art kitchen. This open-concept space opens onto a vast terrace, featuring a dining area, barbecue, and lounge area, perfect for entertaining or simply soaking in the magnificent sea views.

The master bedroom offers an ensuite bathroom and direct access to the terrace, inviting an abundance of natural light and fresh air. The living area serves as a gateway to additional accommodations, including two generously sized bedrooms with bathrooms, connected by a hallway that hosts a practical storage room.

Residents of Apartment Los Arrayanes enjoy exclusive access to a well-equipped gym and a stunning pool area, incredible views that enhance the living experience. The property's south orientation ensures sun-drenched rooms and enjoyment of the Andalusian climate.

Situated in a location that's both serene and convenient, this apartment is a stone's throw away from a plethora of restaurants, shops, and esteemed golf courses, making it an ideal residence for those seeking the ultimate in convenience and luxury. Extra amenities include a garage space, a laundry room, and tasteful modern-classic furnishings that underscore the property's elegant ambience.

Reference:

490744 - HRB-00284P

Size:

435m²

Bedrooms:

4

Bathrooms:

4

Garage:

Comunitary

Swimming pool:

Comunitary

Garden:

Comunitary

Furnished kitchen:

Furnished with appliances

Terraces:

(163.00m²)

Orientation:

South

Air conditioning:

Cold

No. of floors:

1

Condition:

Good

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