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

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

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

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

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

Puerto Banús, Marbella, Málaga

Apartment for sale

RefTHOR-490901 🔗

Ref2.BI-59647

599.000€

Very spacious duplex penthouse with lots of potential for sale in the iconic El Campanario complex on the New Golden Mile, Estepona 

Location and complex details
* Iconic urbanization in beautiful Andalusian style architecture
* Peaceful and tranquil setting in manicured and landscaped subtropical gardens  
* Gated, with 24h security and concierge 
* 3 communal swimming pools with kids pool
* Great strategic location:   Right next to the El Campanario Golf and Country House which houses a sports centre and social club with plenty of facilities including restaurant, gymnasium, minigolf, (padel-) tennis courts, heated swimming pool. The club offers reduced access prices for owners of El Campanario! Very short drive to the highly appreciated El Saladillo Beach which also counts several excellent restaurants. Very short drive to local supermarkets and commercial centres. Very short drive to a plethora of golf courses. Only a 5-minute drive to San Pedro, a 10-minute drive to Puerto Banus. Close to the A7. 10-minute drive to the culinary attraction Benahavis

Penthouse highlights
* Very spacious with 321 m² built size, including 170m² interior size
* Panoramic sea, golf and mountain views 
* Duplex distribution, with extensive outdoor areas
* Entrance level with entrance hall, kitchen with utility room and all appliances, opening onto a spacious dining and living area with access to the lower floor terrace.  Access to the sleeping quarters of the lower floor with 2
double bedrooms of which one is en-suite. Staircase to the upper floor.
* Upper floor with en-suite master bedroom with high ceiling and large sliding windows and double access to the very generous upper floor terrace which holds a BBQ and outdoor dining area, jacuzzi area on a raised platform
with amazing panoramic views  
* Air conditioning for cooling and heating throughout, under floor heating in all bathrooms
* 2 Underground parking spaces +  storage room

The penthouse is in good condition and ready to live in right away but it also offers tremendous potential and opportunity for a renovation project which could easily double the price.

Reference:

490901 - BI-59647

Size:

171m²

Bedrooms:

3

Bathrooms:

3

Swimming pool:

Comunitary

Garden:

Comunitary

Furnished kitchen:

Furnished with appliances

Terraces:

(150.00m²)

Orientation:

West

Air conditioning:

Cold

No. of floors:

2

Condition:

Good

Equipment:

Water, Light

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