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 161 - 180 of 296 €1,150,000
TSEA5018416
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 208 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 208 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to the UNIQUE ICONIC TOWER. This beautiful, stunning, unique, one of a kind property in Mijas Golf is for sale. The Tower, situated in the most beautiful building in Puebla Aida known as (...)
€1,150,000
TSEA5017696
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 200 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Area: Benahavis Region: Andalucía
Welcome to this elegant and contemporary duplex penthouse located in the peaceful La Quinta Hills 3 community, within the prestigious Benahavís area.
Designed with both function and style in mind, (...)
€2,100,000
TSEA5017078
- Sotogrande Marina, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 422 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 422 Area: Sotogrande Region: Andalucía
Welcome to your dream home in the heart of Andalucía! Nestled famous Sotogrande resort, you'll find this extraordinary 5-bedroom, 5-bathroom duplex penthouse.
It offers a total living space of 422 (...)
€6,900,000
TSEA5016154
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 967 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 967 Area: Marbella Region: Andalucía
Luxury Duplex Penthouse for Sale in Puerto Banús, Marbella
Discover an extraordinary investment opportunity in the heart of Puerto Banús with this unique duplex penthouse located in the (...)
€267,000
TSEA5015566
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 2 M2: 95 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 2 M2: 95 Area: Mijas and Mijas Costa Region: Andalucía
Discover the penthouse of your dreams in Mijas Golf!
HAS A TOURIST LICENCE
Stunning 95m2 duplex penthouse for sale with breathtaking views, Mijas Golf urbanization, (...)
€339,500
TSEA5015506
- Tarifa, Costa de la Luz
Beds: 1 Baths: 1 M2: 72 Region: Andalucía
Beds: 1 Baths: 1 M2: 72 Region: Andalucía
DUPLEX for SALE in TARIFA in old town !!!!
5min walking distance to the BEACH.
Discover this charming flat located in the heart of the old town of Tarifa, an unbeatable location to enjoy the (...)
€520,000
TSEA5013988
- Los Monteros, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 184 Lot Size: 1 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 184 Lot Size: 1 Area: Marbella East Region: Andalucía
Welcome to this elegant and traditional Duplex Penthouse located in the beautiful sought-after area of Altos de los Monteros, just a 10-minute drive from Marbella's golden beaches and vibrant city (...)
€390,000
TSEA5012896
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 145 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 145 Area: Estepona Region: Andalucía
Exclusive Duplex Penthouse in the Heart of Estepona
Discover this spectacular duplex penthouse of 145 m² spread across two levels, featuring an impressive 40 m² terrace where you can enjoy (...)
€895,000
TSEA5012221
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 193 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 193 Area: Marbella Region: Andalucía
Triplex penthouse in Altos de los Monteros in perfect condition, ready to move into.
Gated community in the Andalusian village style with 2 swimming pools.
It has 4 spacious bedrooms and 3 full (...)
€395,000
TSEA5012191
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
Duplex penthouse located in a rapidly expanding area between Fuengirola and Cala de Mijas (Chaparral-Calaburras golf course area), approximately 300 meters from Playamarina beach and El Charcón. It (...)
€690,000
TSEA5010862
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 262 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 262 Area: Marbella West Region: Andalucía
Spacious four-bedroom, duplex penthouse in the Los Pinos de Aloha complex, Nueva Andalucía, Marbella. This gated community offer security cameras, evening guard, access to a communal swimming pool (...)
€595,000
TSEA5010349
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 156 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 156 Area: Estepona Region: Andalucía
Stunning duplex penthouse with 4 beds and amazing views!
Welcome to this stunning duplex penthouse in the sought-after and family-friendly area of Dunas Green – a home that perfectly combines (...)
€440,000
TSEA5010223
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 115 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Estepona Region: Andalucía
Please read the description before requesting a viewing!
This is a touristic investment apartment. The owner can stay up to 60 days per year, while the resort manages and rents it short-term the (...)
€636,500
TSEA5008738
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Absolutely splendid! This exquisite 2-bedroom duplex penthouse sits nestled near the vibrant, cosmopolitan hub of La Cala de Mijas, boasting easy access to a myriad of amenities. From its vantage (...)
€2,750,000
TSEA5007400
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 157 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 157 Area: Marbella East Region: Andalucía
Situated in the exclusive and tranquil community of Monte Paraiso on Marbella's prestigious Golden Mile, Marismas 1 is an exceptional duplex apartment refurbished by the renowned Oak Estates. (...)
€1,695,000
TSEA5006833
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Nestled within the prestigious Andalucia del Mar urbanization in Puerto Banus, Marbella, this exquisite recently renovated beachfront duplex penthouse embodies luxury living on the Costa del Sol. (...)
€840,000
TSEA5005840
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 108 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Benahavis Region: Andalucía
This exclusive 2-bedroom, 2-bathroom penthouse offers an unparalleled lifestyle in one of the most prestigious communities on the Costa del Sol. Featuring a modern, bright design, high-end finishes, (...)
€485,000
TSEA5001397
- Carib Playa, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 110 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Marbella East Region: Andalucía
Stunning 3 bed-2 bath duplex penthouse that we find in Carib playa, beachside, in a very quiet and peaceful area and only a 5min walk to the beach and dunes of Cabopino and its harbour.
The (...)
€675,000
TSEA4993951
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 137 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 137 Area: Marbella West Region: Andalucía
This stylish penthouse is located in central Nueva Andalucía, within walking distance of everything – cozy cafés, restaurants, shops, and green areas. The neighborhood is known for its high (...)
€675,000
TSEA4992568
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 113 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Estepona Region: Andalucía
Stunning modern 3 Bedroom Penthouse Duplex in Bel Air Estepona. The property has a great location, just few minutes from the beautiful Costalita beach and all the amenitinies.
The spacious (...)
Current Featured Properties
€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,007,050
TSEA5042083
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 97 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 97 Area: San Pedro Region: Andalucía
In an exceptional location in San Pedro Alcántara, just a short walk from the beach and with views of the sea and the impressive La Concha peak. Discover a new way of living in San Pedro Alcántara (...)
€2,295,000
EMPTY
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
The development is located in a prime enclave, surrounded by parks and landscaped areas, close to a wide variety of sports, healthcare, commercial spaces, and universities. Just 10 minutes from the (...)
