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 (53,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 (53,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 (53,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 801 - 820 of 3900
€1,595,000
TSEA5122831
- Playamar, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 97 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Torremolinos Region: Andalucía
Penthouse, Playamar, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 100 m², Terrace 150 m².
Setting : Beachfront, Beachside, Close To Sea, Urbanisation, Front Line Beach Complex.
Orientation : (...)
€535,000
TSEA5122780
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 71 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Benalmadena Region: Andalucía
Recenlty refurbished south facing apartment located in the exclusive urbanization Reserva del Higuerón, with 2 bedrooms, 2 bathrooms, living-dining room, open plan kitchen fully furnished and (...)
€765,000
TSEA5122762
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 150 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: Marbella West Region: Andalucía
Beautiful brand new 3-bedrooms penthouse nicely furnished with spacious terraces in one of the fastest growing areas of Nueva Andalucía.
The development is located in one of the most popular areas (...)
€575,000
TSEA5122744
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 115 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Mijas and Mijas Costa Region: Andalucía
SPECTACULAR PENTHOUSE WITH SEA VIEWS
We are pleased to present this spectacular penthouse refurbished this year 2025. With a modern and contemporary concept, the property is located in a private (...)
€490,000
TSEA5122723
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 95 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 95 Area: San Pedro Region: Andalucía
NEW LISTING! Modern Apartment in the heart of San Pedro de Alcantara (ONLY UNIT IN THE COMPLEX AVAILABLE )
Stylishly converted 3-bedroom apartment for sale in the sought-after new constructed (...)
€690,000
TSEA5122720
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 109 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Area: Marbella West Region: Andalucía
Located in the exclusive urbanisation of Los Dragos, in the heart of Nueva Andalucía, you will find this recently refurbished turnkey property. With a modern and functional design, the property has (...)
€675,000
TSEA5122717
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 132 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Marbella West Region: Andalucía
Beautiful brand new 3-bedrooms penthouse nicely furnished with spacious terraces in one of the fastest growing areas of Nueva Andalucía.
The development is located in one of the most popular areas (...)
€447,000
TSEA5122714
- La Victoria, Costa Del Sol
Beds: 3 Baths: 2 M2: 81 Region: Andalucía
Beds: 3 Baths: 2 M2: 81 Region: Andalucía
Middle Floor Apartment, La Victoria, Málaga Ciudad.
3 Bedrooms, 2 Bathrooms, Built 81 m², Terrace 5 m².
Setting : Town, Close To Port, Close To Sea.
Orientation : South.
Condition : Under (...)
€1,300,000
TSEA5122711
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 165 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 165 Area: Marbella West Region: Andalucía
Modern and comfortable apartment located in luxury urbanization Las Gaviotas, with 3 double bedrooms ensuit. Large terrace with chill out area and dining.
3 swimming pools and children pools. 24 (...)
€890,000
TSEA5122708
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 144 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 144 Area: Marbella Region: Andalucía
Elite and secure 2 bedrooms, 2 bathrooms duplex penthouse located in the luxury vacation resort La Alzambra Vasari Resort.
Beautiful tropical garden with large swimming lool, waterfalls, summer (...)
€529,500
TSEA5122288
- El Rosario, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 155 Lot Size: 167 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 155 Lot Size: 167 Area: Marbella East Region: Andalucía
Tucked just 50 meters from the golden sands of the Mediterranean, this refined ground-floor apartment in the coveted Alicate Playa community offers an exceptional opportunity to embrace the very best (...)
€380,000
TSEA5122282
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Welcome to this beautiful 2-bedroom, 2-bathroom apartment, located in the highly sought-after Sunset Golf residential complex, nestled in the peaceful surroundings of La Resina Golf in Estepona.
The (...)
€435,000
TSEA5122192
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 95 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Marbella West Region: Andalucía
Albatros IV is a development situated in the Nueva Andalucia (La Campana) area of Marbella. A modern construction walking distance of all local amenities and well connected to Marbella, Puerto Banús (...)
€330,000
TSEA5122156
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 124 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Estepona Region: Andalucía
Amazing opportunity to buy a large older apartment in the centre, literally the heart of Estepona in Malaga, known as the Number 1 place to live a happy life, voted best place to live of all places (...)
€597,000
TSEA5122153
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 152 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 152 Area: Benalmadena Region: Andalucía
FRONTAL SEA VIEWS FROM THE ENTIRE HOME.
Exclusive penthouse with panoramic sea views.
Enjoy a spectacular penthouse with frontal sea views from the entire home. A light-filled space with total (...)
€1,350,000
TSEA5122141
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 3 M2: 133 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 3 M2: 133 Area: La Duquesa Region: Andalucía
We present this stunning property in an unbeatable location: a duplex penthouse in the sought-after enclave of Puerto de La Duquesa, Manilva (Málaga). With 133.51 m² of built area and a spectacular (...)
€380,000
TSEA5122105
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 90 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Marbella Region: Andalucía
Bright and modern apartment, originally with 3 bedrooms, which has been completely renovated to two bedrooms: a spacious master bedroom with ensuite bathroom, a secondary bedroom, and an additional (...)
€265,000
TSEA5122099
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 2 Baths: 1 M2: 76 Area: Manilva Region: Andalucía
Beds: 2 Baths: 1 M2: 76 Area: Manilva Region: Andalucía
Fantastic 96 m² Apartment for Sale in a Perfect Family-Friendly Area
Spacious and bright apartment with 2 bedrooms, two terraces, 1 bathroom, a private parking space, and a large storage room of (...)
€320,000
TSEA5122030
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Impressive apartment with panoramic sea views in Sitio de Calahonda
This bright 2-bedroom, 2-bathroom apartment (one of them en suite) offers an exceptional living experience, with absolutely (...)
€295,000
TSEA5122009
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 2 Baths: 2 M2: 174 Area: Algeciras Region: Andalucía
Beds: 2 Baths: 2 M2: 174 Area: Algeciras Region: Andalucía
CHARMING GROUND FLOOR HOME WITH PRIVATE GARDEN IN FRONTLINE GOLF URBANIZATION IN LA ALCAIDESA.Ideally located in La Alcaidesa, within an exclusive gated community situated on the frontline of the (...)
Current Featured Properties
€780,000
TSEA5119063
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
"Discover an exclusive community designed to offer privacy, comfort, and first-class services, located in Los Flamingos, near the prestigious Villa Padierna Palace. Our apartments and penthouses (...)
€570,000
TSEA3922510
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
LAST OPPORUNITY TO ACQUIRE!!!!
One of the last opportunities to acquire a newly built property in the centre of Estepona, seaside and just 1 minute from the beach. A dream lifestyle which can be (...)
€1,110,000
TSEA3948409
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 151 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 151 Area: Fuengirola Region: Andalucía
THE ESSENCE OF THE MEDITERRANEAN LIFESTYLE.
Located in the northern area of the Torreblanca del Sol, in the municipality of Fuengirola. An open block multi-family building with a total of 30 (...)
