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 (41,39,40,41,162,163)
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 (41,39,40,41,162,163)
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 (41,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 561 - 580 of 3894 €275,000
TSEA5133421
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Excellent penthouse located in the El Paraiso neighborhood, just 5 minutes from San Pedro de Alcantara, in a beautiful private development with a garden and pool. Walking distance to all amenities (...)
€199,000
TSEA5133385
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 50 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 50 Area: Estepona Region: Andalucía
A fully renovated apartment located in the heart of Estepona's charming Old Town — perfect for those who want to live close to all the main attractions or for investors looking to generate high (...)
€529,000
TSEA5133376
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 106 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Fuengirola Region: Andalucía
Welcome to this apartment in Torreblanca - situated just 200 meters from the beach!
Located just steps away from the beautiful Carvajal Beach in Fuengirola, this bright and spacious 3 bedroom offers (...)
€454,000
TSEA5133367
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 62 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 62 Area: Marbella Region: Andalucía
We offers a UNIQUE OPPORTUNITY IN THE HEART OF MARBELLA!
HIGHLIGHTS:
� Located in the very center of Marbella, just 200 meters from the beach.
* Recently renovated
Discover this charming (...)
€2,150,000
TSEA5133352
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 387 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 387 Area: Marbella Region: Andalucía
Discover this stunning duplex penthouse, one of the most exclusive properties currently available in the prestigious resort-style community of Palo Alto. This home stands out for its spacious, (...)
€450,000
TSEA5133307
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 78 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Fuengirola Region: Andalucía
✨ Your Dream Penthouse in Fuengirola Awaits ✨
Imagine waking up every morning to panoramic views of the sea and mountains, sipping your coffee on one of the three spacious terraces where you can (...)
€229,950
TSEA5133304
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 1 Baths: 1 M2: 58 Area: Nerja and Malaga East Region: Andalucía
Beds: 1 Baths: 1 M2: 58 Area: Nerja and Malaga East Region: Andalucía
New Development: Prices from 229,950 € to 379,950 €. [Beds: 1 - 3] [Baths: 1 - 2] [Built size: 58.00 m2 - 141.00 m2]
1, 2 and 3 bedrooms
Discover your new home in Vélez-Málaga!
Exclusive (...)
€1,650,000
TSEA5133286
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 3 M2: 150 Area: Marbella Region: Andalucía
Beds: 2 Baths: 3 M2: 150 Area: Marbella Region: Andalucía
Spectacular 2-Bedroom Penthouse with Private Pool and Panoramic Views | Soul Marbella – Sunlife
Discover an exceptional lifestyle in this luxurious penthouse located in the prestigious Soul (...)
€330,000
TSEA5133274
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 119 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 119 Area: Benahavis Region: Andalucía
Apartment for Sale in Benahavis, Spain -
Discover the perfect blend of comfort and style in this stunning two-bedroom apartment,located in the heart of Benahavis. this charming residence features (...)
€540,000
TSEA5133265
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 108 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Marbella Region: Andalucía
We presents a unique opportunity in the heart of Marbella!
Modern and bright property, fully furnished and equipped in an elegant minimalist style, ready to move into or rent out.
With an (...)
€252,000
TSEA5133235
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
Discover this exquisite ground floor apartment, a haven of tranquillity and style in the coveted Riviera del Sol. With 60 m² of renovated elegance, this property offers a cosy space ideal for (...)
€560,000
TSEA5133211
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 120 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Benahavis Region: Andalucía
Luxury Corner Apartment for Sale in Los Arqueros, Benahavís – Frontline Golf & Panoramic Sea Views
Looking for a luxury apartment for sale in Los Arqueros, Benahavís? This exclusive (...)
€506,000
TSEA5133202
- La Carihuela, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 95 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Torremolinos Region: Andalucía
New Development: Prices from 506,000 € to 1,145,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 95.00 m2 - 144.00 m2]
Situated in a bordering area between Benalmádena and Torremolinos, you can (...)
€490,000
TSEA5133199
- Aloha, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 99 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: Marbella West Region: Andalucía
***NOT AVAILABLE FOR VIEWING UNTIL OCTOBER 20 2025***
Fantastic elevated ground floor apartment for holidays, investment or year round living.
This luxury accommodation is able to accommodate up to (...)
€240,000
TSEA5133175
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
BRAND NEW TO MARKET! 1BED/1BATH FULLY RENOVATED APT W SEA + MOUNTAIN VIEWS IN BENALMADENA-COSTA! €240,000.
Features:
- 6th floor
- 1 Bedroom and 1 Bathroom
- Open plan living room and kitchen
- (...)
€400,000
TSEA5133166
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 400,000 € to 1,523,000 €. [Beds: 1 - 4] [Baths: 1 - 4] [Built size: 60.00 m2 - 183.00 m2]
Nestled in vibrant Mijas Costa and overlooking the prestigious Cerrado del (...)
€948,500
TSEA5133157
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
New Development: Prices from 948,500 € to 1,051,500 €. [Beds: 2 - 3] [Baths: 2 - 3] [Built size: 71.00 m2 - 92.00 m2]
An exclusive complex of 116 new build flats, completed this spring - 2024. (...)
€1,250,000
TSEA5132818
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 203 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 203 Area: Marbella Region: Andalucía
Living in Marbella, just 50 meters from the Mediterranean Sea, and opposite the Old town is a privilege like few others in this world. Panoramic views of the city and mountains, and lateral views of (...)
€349,000
TSEA5132794
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 4 M2: 115 Area: Casares Region: Andalucía
Beds: 3 Baths: 4 M2: 115 Area: Casares Region: Andalucía
Located in the "Paraíso de la Bahia" residence, this stunning duplex penthouse was completely renovated in December 2024.
It is situated 300m from Casares beach and it's Chiringuito (...)
€1,795,000
TSEA5132776
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 155 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 155 Area: Marbella West Region: Andalucía
This exceptional 3-bedroom, 2.5-bathroom duplex penthouse is located in the prestigious gated community of Las Alamandas, at the heart of Nueva Andalucía's Golf Valley. Boasting spectacular views (...)
Current Featured Properties
€625,000
TSEA4856836
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
An imposing residential project in Estepona's New Golden Mile. Offering 72 superb 2, 3 and 4-bedroom apartments, each home boasts breathtaking sea and mountain views. Residents will indulge in a (...)
€2,250,000
TSEA4943188
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 142 Lot Size: 186 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 142 Lot Size: 186 Area: Malaga Region: Andalucía
This residential complex is where the contemporary and the traditional come together. For this reason, we will find renovated buildings, alongside newly built buildings or buildings protected as (...)
€455,000
Beautiful contemporary apartments with stunning rooftop pool!
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 83 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 83 Area: Marbella West Region: Andalucía
CLOSE TO FABULOUS PUERTO BANUS AND THE BEACHES.
Offering homes from 90m2 to 150m2 with finishes of first QUALITY AND MODERN design. All have a large private terrace, garage space in the building (...)
