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=
-- _c_propiedad.php inic_empresa_captadora()
SELECT web, cod_empresa
FROM propiedad
WHERE -- web = 100 -- Con MLS multi web no procede
cod_propiedad = 490742
-- 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=
-- Funcion: recuperar_de_bbdd | Fichero: /var/www/clients/client1/web8/web/_proc/propiedad/_c_propiedad.php
SELECT *
FROM propiedad
WHERE (
web = 100
AND cod_empresa = 265
AND cod_oficina = 0
AND cod_propiedad = 490742
) 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 = 490742 -- [20170919a] Para enlaces amigables a propiedades de MLS
AND TRUE
)
-- [20171128b]
ORDER BY
CASE WHEN web = 100 AND cod_empresa = 265 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 = 490742
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 = 490742
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 = 490742
num_tuplas=
0
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=
-- Función: recuperar_distribuidores_y_comerciales | Fichero /var/www/clients/client1/web8/web/_proc/per_emp/_c_per_emp.php
SELECT per_emp.cod_per_emp,
per_emp.cod_relacion,
per_emp.nombre,
per_emp.email,
num_telefono
FROM per_emp
LEFT JOIN per_emp_telefono ON (
per_emp.web = per_emp_telefono.web
AND per_emp.cod_empresa = per_emp_telefono.cod_empresa
AND per_emp.cod_per_emp = per_emp_telefono.cod_per_emp
)
WHERE per_emp.web = 100
AND per_emp.cod_empresa = 265
AND per_emp.cod_oficina = 0
AND per_emp.estado = 'A'
AND per_emp.cod_relacion IN ('E', 'V', 'X')
GROUP BY per_emp.cod_per_emp
num_tuplas=
4
MM Estates Spain Cluster house for sale [490742]
Cluster house
4.895.000€ (£ 4.295.366 approx.) Ref.THOR-490742
Welcome to Villa Imagine: Where Elegance Meets Luxury Amidst the Serene Hills of Benahavis
Nestled in the prestigious and tranquil hills of Monte Mayor, Benahavis, Villa Imagine represents the pinnacle of luxury living where elegance and sophistication meet unparalleled privacy and breathtaking sea and mountain views. Designed by one of Marbella's most renowned and internationally awarded architects, this villa embodies a sanctuary of peace amongst the vibrant life of the Costa Del Sol.
Location - A Confluence of Beauty and Convenience
Villa Imagine sits majestically between the charm of Marbella and the serenity of Estepona in the exclusive Monte Mayor community. This secured and gated haven offers not just a residence but a lifestyle highlighted by nature, tranquillity, and panoramic views over the Mediterranean stretching to Gibraltar and Morocco. Within a mere 5 minutes from the prestigious Marbella Club Golf Resort, 10 minutes from Villa Padierna Golf & Hotel, 18 minutes to the glamourous Puerto Banus, and 15 minutes to Estepona, Villa Imagine places you perfectly within the lap of luxury and connectivity.
Architectural and Interior Elegance
Every inch of Villa Imagine is a testament to luxury living with its sleek modern design seamlessly blending with bohemian chic touches. Expansive windows in the living areas ensure the interior is bathed in natural light while effortlessly framing the stunning vistas of the sea and the mountains. Whether it's the state-of-the-art, fully equipped kitchen or the spacious dining and living areas, each corner of Villa Imagine has been designed for an unrivalled living experience.
Outdoor Splendour
Step outside to discover the villa's crown jewel - an exquisite heated infinity pool that merges with the horizon, providing an immersive swimming experience against a backdrop of the Mediterranean. The expansive terrace, stylishly furnished with a bohemian chic flair, offers versatile outdoor living spaces, including a dining area, comforting lounge sets, TV area, and plush sun loungers for basking in the serene environment.
Thoughtfully Designed Amenities
Villa Imagine caters to every need. Beyond its serene bedrooms offering awe-inspiring views, the villa hosts a designated office space for those who blend work with pleasure, all without stepping away from the picturesque surroundings. The flexibility of the villa's design also allows the sixth bedroom to transform into a multifunctional space, be it a private gym or a secluded retreat for meditation on the terrace.
A Lifestyle Like No Other
Villa Imagine offers more than just a home; it provides an entry into a lifestyle marked by luxury, exclusivity, and tranquility. From its iconic location in Benahavis, close to some of the best golf courses and luxurious resorts, to its meticulously designed living spaces, every aspect of Villa Imagine is curated to surpass expectations.
For those who seek to dwell in the splendour of nature while enjoying the pinnacle of luxurious living, Villa Imagine beckons. Experience the epitome of elegant exclusivity—discover Villa Imagine in het exclusieve Monte Mayor - Benahavis.
Detached Villa, Benahavís, Costa del Sol.
6 Bedrooms, 5 Bathrooms, Built 478 m², Terrace 150 m², Garden/Plot 3100 m².
Setting : Country, Close To Golf, Close To Town, Close To Forest, Urbanisation.
Orientation : East, South, West.
Condition : Excellent.
Pool : Private, Heated.
Climate Control : Air Conditioning, Hot A/C, Cold A/C, U/F Heating, U/F/H Bathrooms.
Views : Sea, Mountain, Country, Panoramic, Pool, Forest.
Features : Covered Terrace, Fitted Wardrobes, Private Terrace, Solarium, Satellite TV, WiFi, Guest Apartment, Storage Room, Utility Room, Double Glazing, Domotics, Fiber Optic.
Kitchen : Fully Fitted.
Garden : Private, Landscaped.
Security : Gated Complex, Entry Phone, Alarm System, 24 Hour Security, Safe.
Parking : Covered, More Than One, Private.
Utilities : Electricity, Drinkable Water, Photovoltaic solar panels.
Category : Golf, Luxury, Contemporary.
MM Estates Spain, Tirreno, 4., 29620Torremolinos.+34.670.955.108https://www.mmestatesspain.com/
Documento elaborado por MM Estates Spain con información de la propiedad para su
compraventa, arrendamiento o traspaso. Con su aceptación, el destinatario se compromete a no copiarlo,
reproducirlo o distribuirlo a terceros, ni total ni parcialmente, sin el consentimiento escrito de MM Estates Spain,
que declina expresamente toda la responsabilidad por las
manifestaciones, expresas o implícitas, u omisiones, o por cualesquiera otras
comunicaciones orales o escritas hechas a cualquier parte interesada. Esta información no constituye un valor contractual.