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

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

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

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

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

Torreblanca, Fuengirola, Málaga

Cluster house for sale

RefTHOR-490902 🔗

825.000€

Welcome to this charming 4-bedroom, 2-bathroom villa located in the popular Torreblanca neighbourhood of Fuengirola. Spanning 188 square meters of living space on a spacious 812 square meter plot, this one storey property offers a great blend of comfort, luxury, and privacy.

As you enter, you'll be greeted by a beautifully landscaped garden, designed for easy maintenance, ensuring enjoyment of the garden and plot without the hassle of extensive upkeep. The garden features a private heated pool, perfect for relaxing swims, and an outdoor shower, ideal for refreshment on warm summer days.

The covered terrace provides an excellent space for outdoor dining and entertaining, allowing you to enjoy the garden views with partial sea glimpses. With double glazing and safety glass throughout, the home ensures a quiet and secure environment. The high-quality build, constructed by a Danish developer in 1985, is robust, well-insulated, and includes air conditioning to ensure comfort and cooling during the summer as well as heating during the winter. Additionally, the cozy fireplace makes the space inviting on cooler evenings, offering year-round comfort regardless of the season. The property also features fiber optic, allowing for high internet speeds.

Inside, you'll find a fully fitted kitchen equipped with modern appliances and a separate utility room, providing all the conveniences needed for comfortable living. The spacious covered parking area accommodates up to three cars, offering ample space for family and guests. Additionally, there is a large public parking lot 100m down the street from the property.

The home's location is a significant advantage, with close proximity to the sea, shops, schools, and surrounding towns. It's well-connected, with convenient transport options thanks to the nearby local bus and train services, providing easy access to surrounding areas and making commuting easy for residents. The beach is just a short 10 minute walk away, offering a quick and easy route to the sea. The existing gardener, available at €150 per month, maintains the garden's beauty, allowing owners to focus on enjoying the home.

For investment purposes, the property has an updated LPO and a tourist license, meaning owners can legally rent out the property all year round. The current owners also have a standing agreement with a cleaning service, making rental possibilities and property management optimal. The property also features an alarm security system to ensure the safety and peace of mind of residents.

Don't miss this opportunity to own a property that combines quality construction, excellent amenities, and a great location in Torreblanca. Schedule your viewing today!

Reference:

490902

Size:

188m²

Plot size:

812m²

Bedrooms:

4

Bathrooms:

2

Furnished:

Fully furnished

Swimming pool:

Private

Garden:

Comunitary

Furnished kitchen:

Furnished with appliances

Terraces:

(26.00m²)

Orientation:

South, Southwest, West

Air conditioning:

Cold

No. of floors:

1

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