SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND p.approved = 1 AND pm.cat_id IN (163,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND `p`.`featured` IN ('1') AND p.approved = 1 AND pm.cat_id IN (163,36,37,38)
GROUP BY p.id
ORDER BY RAND()
SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND p.approved = 1 AND pm.cat_id IN (163,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 81 - 100 of 296 €1,995,000
TSEA5109646
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 4 M2: 389 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 4 M2: 389 Area: Marbella West Region: Andalucía
Penthouse Las Lolas is a meticulously renovated duplex penthouse located in the serene residential enclave of Las Lolas in Nueva Andalucía, Marbella. Just minutes from Puerto Banús and the renowned (...)
€609,000
TSEA5108599
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 138 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 138 Area: Fuengirola Region: Andalucía
Penthouse Duplex, Torreblanca, Costa del Sol.
4 Bedrooms, 3 Bathrooms, Built 138 m², Terrace 28 m².
Setting : Suburban, Close To Town, Urbanisation.
Orientation : South.
Condition : Good.
Pool : (...)
€760,000
TSEA5108128
- Río Real, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 138 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 138 Area: Marbella East Region: Andalucía
This stunning duplex penthouse is located in the exclusive Rio Real residential area in Marbella East, offering a perfect blend of luxury and comfort. With a spacious living area of 138m² and an (...)
€975,000
TSEA5107045
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 238 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 238 Area: Marbella West Region: Andalucía
Welcome to this bright and spacious 2-bedroom penthouse in the sought-after Lorcrigolf community, perfectly positioned next to the golf course and offering spectacular views of La Concha (...)
€739,000
TSEA5106919
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 148 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 148 Area: Estepona Region: Andalucía
This elegant duplex penthouse with stunning sea views is located in one of the most promising areas of the Costa del Sol. Just minutes from the beach, it offers a strategic location that combines (...)
€940,000
TSEA5106622
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
Step into this breathtaking duplex penthouse—with amazing open views, a masterpiece meticulously crafted to merge indoor elegance with outdoor grandeur.
The main floor offers modern (...)
€530,000
TSEA5105977
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 162 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: Benahavis Region: Andalucía
MOTIVATED SELLER ! PRICE NEGOTIABLE!
Available for sale at a good price, this spacious 3-bedroom, 2-bathroom penthouse duplex is located in the tranquil and secure urbanization of Gazules del Sol, (...)
€340,000
TSEA5105845
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 94 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: La Duquesa Region: Andalucía
This beautifully presented 2-bedroom, 2.5-bathroom apartment is located in the peaceful and picturesque area of La Duquesa, just 500 meters from the beach and around 45 kilometers from the renowned (...)
€525,000
TSEA5105083
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 155 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 155 Area: Marbella Region: Andalucía
Discover this exquisite duplex penthouse nestled in a charming, white-washed Andalusian village-style urbanisation, found in the heart of Altos de Los Monteros, Marbella.
The community features (...)
€750,000
TSEA5104960
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 140 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Marbella East Region: Andalucía
Large Duplex Penthouse in Elviria, Marbella.
Apartment with 140 m2 inside and 210 m2 terrace features 3 bedrooms, the master bedroom is on the second floor and features an ensuite bathroom, a (...)
€398,000
TSEA5104891
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 160 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 160 Area: Estepona Region: Andalucía
Beautiful duplex penthouse in the prestigious Bahia Dorada urbanisation in Estepona. This urbanization very close to the marina of Estepona and the centre of the beautiful Mediterranean town, has 9 (...)
€859,000
TSEA5101012
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 82 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Fuengirola Region: Andalucía
This magnificent penthouse has a total of 239 m2 built area, distributed across 85 m2 of living space, a 34 m2 terrace, and a 120 m2 solarium. It also includes two large parking spaces and a storage (...)
€455,000
TSEA5100985
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 150 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 150 Area: Marbella Region: Andalucía
Bright and spacious duplex penthouse in Los Naranjos, Marbella, overlooking the pool and the iconic La Concha mountain.
This 145-square-meter home is located in one of Marbella's most exclusive (...)
€480,000
TSEA5085655
- Torrox Costa, Costa Del Sol East
Beds: 2 Baths: 2 M2: 80 Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Region: Andalucía
Frontline top floor duplex apartment located on the beach of El Peñoncillo in Torrox-Costa with direct access to the sea.
Only 5 minutes walk to the center of Torrox-Costa with various shops and (...)
€599,000
TSEA5084257
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 169 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 169 Area: Marbella East Region: Andalucía
Mesmerising views...up on the top of the hill above the coast of Marbella East.
A beautifully furnished and spacious home on the hills above the Marbella coast.
Presenting a lovely 3 bedroom duplex (...)
€1,275,000
TSEA5084050
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
☀️ Stunning Duplex Penthouse for Short-Term Summer Rental and for Sale!
Cataleya, Estepona | Available July & August
Welcome to this luxury 3-bedroom duplex penthouse for sale in Cataleya, (...)
€1,100,000
TSEA5083936
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 110 Area: Estepona Region: Andalucía
Stunning 3 bed duplex with private rooftop pool located in the exclusive beachfront urbanisation Bahia de la Plata.
Perfectly positioned with direct beach access and a short walk into the centre of (...)
€3,200,000
TSEA5080897
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 195 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 195 Area: Marbella West Region: Andalucía
La Alcazaba is an exclusive community that boasts a long history in Marbella. It was developed by the famous architect, Melvin Villarroel, who designed Puente Romano and many other stunning (...)
€378,000
TSEA5078845
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 125 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 125 Area: Benahavis Region: Andalucía
Super economic price for Duplex penthouse in Parque Botanico Resort & Country Club - is an exclusive residential complex in the municipality of Benahavis, located in a picturesque mountainous (...)
€495,000
TSEA5078752
- Ojén, Costa Del Sol, Ojen
Beds: 3 Baths: 2 M2: 170 Area: Ojen Region: Andalucía
Beds: 3 Baths: 2 M2: 170 Area: Ojen Region: Andalucía
Fabulous Duplex Penthouse in La Mairena, Marbella
Long terme: 2500€/mois
frais de communauté inclus
ils incluent: les 2 piscines - l'accès gratuit au golf 9 trous - la salle de fitness - sauna - (...)
Current Featured Properties
€525,000
TSEA5075317
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 4 M2: 102 Area: Casares Region: Andalucía
Beds: 3 Baths: 4 M2: 102 Area: Casares Region: Andalucía
An exclusive residential development in the prime location of Doña Julia Golf, in Casares, Málaga. Designed to offer a unique lifestyle, it combines comfort, nature and luxury in an unbeatable (...)
€795,000
TSEA4358863
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 101 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Fuengirola Region: Andalucía
ACT NOW, THESE WILL GO FAST!!!
Spectacular new development of 60 luxury apartments in the most sought-after area of El Higuerón, in a gated exclusive community with gym, heated pool, jacuzzis and (...)
€1,060,000
TSEA5063608
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 201 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 201 Area: Benalmadena Region: Andalucía
An exclusive boutique complex of 28 apartments in the highly sought-after area of Torremuelle, Benalmádena. Each residence has been carefully designed to offer a superior living experience, with (...)
