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 (39,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 (39,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 (39,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3910), Middle Floor - (3910), Penthouse - (3910), Top Floor Apartment - (3910), Penthouse Duplex - (3910)Properties
Results 1041 - 1060 of 3899 €329,000
TSEA5110213
- New Golden Mile, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 73 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 73 Area: Estepona Region: Andalucía
Stunning One-Level Penthouse with Panoramic Sea Views
This beautifully presented one-level penthouse offers a rare combination of style, comfort, and unbeatable location. Featuring an open and (...)
€195,000
TSEA5110204
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Opportunity! Beachfront penthouse in Manilva, in the Aparthotel Don Juan.
The apartment, located on the fifth floor, has a floor area of 104 m² and a 12 m² terrace with sea views, facing (...)
€2,000,000
TSEA5109901
- Martiricos, Costa Del Sol
Beds: 3 Baths: 3 M2: 136 Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Region: Andalucía
Welcome to the highest and most exclusive penthouse in Andalusia. Direct from the developer.. This extraordinary residence offers not only an unparalleled luxury experience, but also stunning (...)
€475,000
TSEA5109898
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 144 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 144 Area: Marbella East Region: Andalucía
Las Buganvillas is a delightful urbanisation within the heart of the La Mairena development. Set within the countryside with spectacular views all around, if it's peace and quiet you're after, this (...)
€365,000
TSEA5109889
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
**Mirador del Rodeo** is a complex with exceptional location situated in the heart of Nueva Andalucía, within walking distance of amenities, the beach, and Puerto Banús. This gated community (...)
€465,000
TSEA5109757
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 5 M2: 193 Lot Size: 193 Area: Casares Region: Andalucía
Beds: 3 Baths: 5 M2: 193 Lot Size: 193 Area: Casares Region: Andalucía
Off-Market Listing – Ground Floor Luxury in Majestic Gardens, Casares, Málaga
Discover a rare off-market opportunity in the prestigious enclave of Majestic Gardens, Casares. This elegantly (...)
€349,000
TSEA5109667
- Mezquitilla, Costa Del Sol East
Beds: 2 Baths: 1 M2: 98 Lot Size: 98 Region: Andalucía
Beds: 2 Baths: 1 M2: 98 Lot Size: 98 Region: Andalucía
Welcome to this charming penthouse in the coastal village of Mezquitillaa perfect blend of comfort, functionality, and Mediterranean lifestyle. This well-designed apartment stands out with two (...)
€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 (...)
€413,595
TSEA5109625
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 124 Lot Size: 60 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 124 Lot Size: 60 Area: Marbella East Region: Andalucía
We offers MAGNIFICENT APARTMENT WITH PANORAMIC VIEWS IN MARBELLA RESERVE.
It has a 120 m² basement, which can be converted into an apartment with a separate entrance.
Located just 5 minutes drive (...)
€329,000
TSEA5109616
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Brand New to the Market – Prime Coastal Location in Calahonda !
Just a three-minute walk to the beach and the renowned Calahonda Royal Beach Restaurant, Supermarkets and shops etc..
This (...)
€375,100
TSEA5109613
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 1 Baths: 1 M2: 49 Lot Size: 62 Area: Nerja and Malaga East Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Lot Size: 62 Area: Nerja and Malaga East Region: Andalucía
Ground-Floor Apartment with Private Terrace and Natural Light – Costa del Sol
This charming ground-floor apartment is located in a prime position by the sea, in one of the most desirable areas of (...)
€474,000
TSEA5109604
- Rincón de la Victoria, Costa Del Sol East
Beds: 3 Baths: 2 M2: 125 Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Region: Andalucía
Experience the CENTURY 21 difference!
Modern, efficient and ready to move in.
We present this exclusive 2023 property, located in the sought-after La Reserva del Rincón development in Rincón de la (...)
€435,600
TSEA5109589
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 57 Lot Size: 68 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 57 Lot Size: 68 Area: Nerja and Malaga East Region: Andalucía
Ground-Floor Apartment with Private Terrace and Sea Views – Costa del Sol
This modern apartment enjoys an exceptional seafront location in one of the most sought-after areas of the Costa del (...)
€386,000
TSEA5109583
- 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
great property in the centre of Estepona very close to the beach, town hall and shopping area. very convenient to walk to all places
flat on the top floor of the building of three, has an attic area (...)
€1,200,000
TSEA5109568
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 101 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Estepona Region: Andalucía
Exclusive Beachfront Penthouses – Experience Estepona at Its Finest – Stunning Penthouses with Panoramic Sea Views
Description:
Exclusive Costa del Sol Property Listings - 5 is sold og the 7 (...)
€299,000
TSEA5109469
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 97 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 97 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to this charming two-bedroom apartment, located in a quiet and well-maintained area right in the heart of popular Calahonda. Here you live close to everything – within walking distance of (...)
€560,000
TSEA5109427
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 123 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 123 Area: Fuengirola Region: Andalucía
Welcome to our large penthouse with 4 bedrooms and 125m2 terrace with Jacuzzi, located just around the corner from the Fuengirola Castle and the enormous shoppingcenter of Miramar in Fuengirola. This (...)
€445,000
TSEA5109409
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
If you're looking for a spacious, modern, and key-ready apartment with a large private terrace perfect for entertaining, this stunning ground floor property in La Cala Golf Resort is a must-see. (...)
€359,000
TSEA5109358
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Really nicely presented 2 bedroom, 2 bathroom first floor apartment in the popular Pueblo Miraflores' development in Miraflores. Boasting fantastic views towards the immaculate gardens, This as a (...)
€575,000
TSEA5109352
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 76 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 76 Area: Marbella Region: Andalucía
This beautifully renovated and fully furnished 2-bedroom apartment offers a rare blend of modern comfortand unbeatable location. The apartment features two spacious bedrooms with brand-new (...)
Current Featured Properties
€1,700,000
TSEA4201453
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 139 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 139 Area: Fuengirola Region: Andalucía
LAST ONE!!! FANTASTIC LOCATION JUST 350 METERS FROM THE SEA!!!!
This new development in the heart of Fuengirola will comprise 33 luxury apartments and penthouses with the most modern equipment and (...)
€1,195,000
TSEA4976017
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
€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 (...)
