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 (36,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 (36,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 (36,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 3861 - 3880 of 3897 €1,395,000
TSEA3520486
- Los Flamingos, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 220 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 220 Area: Estepona Region: Andalucía
Luxury 3 bedroom penthouse located within one of the best urbanizations in Los Flamingos - frontline to the prestigious 18 hole golf course Los Flamingos Golf and the 6 star Villa Padierna (...)
€1,150,000
TSEA3501181
- Elviria, Costa Del Sol, Marbella East
Beds: 5 Baths: 4 M2: 200 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 4 M2: 200 Area: Marbella East Region: Andalucía
Winter Rental 11.11.2025 - 31.3.2026
FOR INVESTORS! Exceptional Rental Income Opportunity!
Breathtaking 360° Panoramic Sea & Mountain Views
Earn immediate returns! This stunning penthouse (...)
€2,200,000
Fabulous Renovated Beachfront Apartment, Puerto Banus
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 352 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 352 Area: Marbella West Region: Andalucía
PRESTIGIOUS BEACHFRONT APARTMENT IN PUERTO BANUS!!!
This elegant apartment is amongst one of the most stylish and best situated on the Costa del Sol. An apartment which feels like a villa with (...)
€599,000
TSEA3468730
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 160 Lot Size: 200 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Lot Size: 200 Area: Estepona Region: Andalucía
Wonderfulll 3 bedroom 2 bath penthouse with massive solarium with 360 views.
Property is centrally located on the New Golden Mile with great access to the A7 and all shopping and beach.
€1,800,000
TSEA3461908
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 152 Lot Size: 13 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 152 Lot Size: 13 Area: Marbella West Region: Andalucía
Fantastic ground floor 2 bedroom en suite apartment located within the exclusive 24 hour guard gated community, Malibu. The community boasts two swimming pools (one heated lap pool and one free (...)
€470,000
Oasis of tranquility close to beaches
- San Roque, Costa Del Sol, San Roque
Beds: 3 Baths: 2 M2: 115 Area: San Roque Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: San Roque Region: Andalucía
OASIS OF TRANQUILITY CLOSE TO BEACHES.
New release! A great opportunity to buy an off plan apartment at an UNBEATABLE PRICE. The apartment style is light and bright with large open plan living (...)
€319,500
Move straight in today, beach life is waiting for you
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 71 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Manilva Region: Andalucía
BEACH LIFE IS WAITING FOR YOU!!!
Sea, sun and nature merge in this residential complex close to the beach. In this oasis, cool off in one of the two large SWIMMING POOLS, perfect when there are more (...)
€1,350,000
Spacious and contemporary apartments
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 194 Lot Size: 60 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 194 Lot Size: 60 Area: Sotogrande Region: Andalucía
STUNNING NEW HOMES IN VILLAGE COMMUNITY SETTING.
Exclusive Village Community in prestigious Sotogrande area. SPACIOUS AND CONTEMPORARY apartments have been created around an exclusive Village (...)
€1,500,000
TSEA3302287
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 170 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 170 Area: Estepona Region: Andalucía
Middle Floor Apartment, Estepona, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 170 m², Terrace 50 m².
Setting : Beachfront, Beachside, Close To Shops, Close To Sea, Close To Town, Urbanisation, (...)
€2,100,000
TSEA3262951
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 324 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 324 Area: Marbella East Region: Andalucía
Amazing front line beach penthouse in Hacienda Playa Phase 2 in Elviria, East Marbella. This stunning penthouse offers the most incredible sea views and spectacular sunsets every evening. The (...)
€244,000
TSEA3237004
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 2 Baths: 1 M2: 80 Area: Manilva Region: Andalucía
Beds: 2 Baths: 1 M2: 80 Area: Manilva Region: Andalucía
Flat in Sabinillas very bright corner, the facade overlooks three streets.
The entrance is direct from the street to a first floor, on the ground floor there is a store for sale as well.
Ideal for (...)
€949,000
TSEA3183244
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 200 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Area: Marbella East Region: Andalucía
Very spacious ground floor apartment with smaill private garden. Open plan Kitchen living/dining area with fireplace and double high ceilings. Three bedrooms ensuite and master with walk wardrobe.
€24,000,000
TSEA3182194
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 8 Baths: 5 M2: 986 Area: Marbella West Region: Andalucía
Beds: 8 Baths: 5 M2: 986 Area: Marbella West Region: Andalucía
UNIQUE AND AWESOME PENTHOUSE IN PUERTO BANUS.Luxury beach front Apartment,
The views are truly unique, the sea, coast and mountain ...VERY PRIVATE
The luxurious apartment has 5 or 6 bedrooms, with 5 (...)
€742,600
Top Floor Apartment in Mijas Costa
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
RELAX AND LET MOTHER NATURE WORK HER MAGIC.
This unique new development ideally situated between La Cala de Mijas and Fuengirola, is a NEW CONCEPT of apartments and penthouses of 2, 3 and 4 (...)
€345,000
TSEA3169777
- 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
STREET TERRAZA.Magnificent house for sale in the center of the city. On the terrace of the street with total views on holidays to Easter, and very close to a square full of restaurants where you can (...)
€907,852
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA.
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 Area: Estepona Region: Andalucía
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA.
A luxury resort style apartment complex with the best in leisure facilities. This new development has been landscaped to create TOP QUALITY with (...)
€368,300
TSEA3053995
- 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
SPACIOUS AND STYLISH, YOUR TWO FAVOURITE WORDS!
This new, OFF PLAN development is an innovative and elegant promotion of 1, 2 AND 3-BEDROOM APARTMENTS and penthouses with swimming pool, private (...)
€427,400
TSEA3053554
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 131 Lot Size: 100 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Lot Size: 100 Area: Fuengirola Region: Andalucía
EASY LIVING NEAR THE BEACHES, SHOPS AND RESTAURANTS.
This new development is an innovative and elegant promotion of APARTMENTS and penthouses with swimming pool, private parking and located in a (...)
€851,414
Staff pick! We love this one, it's got everything
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 83 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Estepona Region: Andalucía
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA!
A luxury resort style apartment complex with the best in leisure facilities. This new development has been landscaped to create TOP QUALITY with (...)
€850,000
TSEA3036251
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 392 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 392 Area: Mijas and Mijas Costa Region: Andalucía
This spacious and exclusive four bedroom penthouse apartment with the finest qualities and large terrace with own Jacuzzi bath plunge pool and BBQ area on the terrace forms part of an exclusive (...)
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 (...)
€525,000
TSEA5074066
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
This development consists of 79 luminous 2 and 3 bedroom apartments and penthouses.
Located only 3 minutes away from the picturesque village La Cala de Mijas, with an abundance of bars, shops, (...)
€678,000
TSEA4941382
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 187 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 187 Area: Estepona Region: Andalucía
PHASE II OUT NOW! ACT FAST.
An exclusive community comprising 84 luxury properties with generous indoor spaces, roomy terraces, spectacular views, community areas, swimming pool and club zone. A (...)
