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,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 (41,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 (41,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 101 - 120 of 792
€690,000
TSEA5133538
- Atalaya, 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
Stunning 2-Bedroom Penthouse in Terrazas de Atalaya, Estepona
Built in 2018, this stylish 2-bedroom, 2-bathroom apartment offers a modern, light-filled living experience. The standout feature is the (...)
€449,000
TSEA5133442
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 84 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 84 Area: Mijas and Mijas Costa Region: Andalucía
FOR SALE – PENTHOUSE WITH PRIVATE SOLARIUM AND PANORAMIC VIEWS IN UPPER CALAHONDA – MIJAS
Discover this stunning 2-bedroom penthouse, fully renovated and located in a peaceful (...)
€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 (...)
€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 (...)
€269,000
TSEA5132665
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 56 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 56 Area: Benahavis Region: Andalucía
Penthouse for sale in , Benahavis with 2 bedrooms, 2 bathrooms and with orientation east, with communal swimming pool, private garage and communal garden. Regarding property dimensions, it has 56.59 (...)
€475,000
TSEA5132521
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 2 Baths: 2 M2: 193 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 2 M2: 193 Area: Sotogrande Region: Andalucía
Beautiful 2-bedroom, 2-bathroom penthouse, perfectly situated in the prestigious area of Sotogrande Alto. Offering breathtaking panoramic views over the Almenara Golf Course and its peaceful lake, (...)
€475,000
TSEA5132308
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Stunning Penthouse for Sale – Luxury Living with Spectacular Views
Discover your dream home on the Costa del Sol – a rare opportunity to own an elegant and spacious penthouse in one of the (...)
€525,000
TSEA5131972
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Bright two-bedroom, two-bathroom penthouse located in La Dama de Noche, one of the most exclusive and sought-after residential complexes in the area. Just one kilometre from the beach and Puerto (...)
€1,750,000
TSEA5131831
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 206 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 206 Area: Marbella West Region: Andalucía
Stunning 3-Bedroom Penthouse for Sale in the Heart of Nueva Andalucía
Discover your dream home in this exquisite 3-bedroom penthouse, perfectly situated in the vibrant heart of Nueva Andalucía. (...)
€549,000
TSEA5131708
- La Heredia, Costa Del Sol, Benahavis
Beds: 2 Baths: 3 M2: 130 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 3 M2: 130 Area: Benahavis Region: Andalucía
Discover paradise in this stunning penthouse for sale in the prestigious La Heredia residential complex! With 360-degree panoramic sea views, this home is a perfect retreat for those seeking (...)
€695,000
TSEA5131369
- El Pinillo, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 139 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 139 Area: Torremolinos Region: Andalucía
Introducing this spectacular property: a penthouse of 139 m² in a fifth floor with lift, located in one of the most peaceful and sought-after areas of Torremolinos. With two stunning terraces of 110 (...)
€515,000
TSEA5130988
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 78 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Malaga Region: Andalucía
Discover a modern, vibrant living experience in Malaga with this spectacular project, blending urban sophistication with natural tranquility. This development is one of Andalusia's tallest buildings, (...)
€249,000
TSEA5130946
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 56 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 56 Area: Fuengirola Region: Andalucía
Great investment opportunity in a newly refurbished penthouse in the centre of Fuengirola. This 2 bedroom flat, one of them double, has an excellent location in one of the closest streets to the (...)
€795,000
TSEA5129992
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 119 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 119 Area: Benahavis Region: Andalucía
This luxurious single-level penthouse offers stunning panoramic views of the sea and mountains. The property features an entrance hall leading to a spacious living and dining area, which opens onto (...)
€880,000
TSEA5129779
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 218 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 218 Area: Estepona Region: Andalucía
Exclusive corner duplex penthouse in The New Golden Mile, Estepona
Spectacular duplex penthouse with refined design and exceptional attention to detail, creating a sophisticated yet welcoming (...)
€525,000
TSEA5129686
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Discover this exceptional penthouse located in the heart of Calahonda on the beautiful Costa del Sol, perfectly positioned just 20 minutes from Marbella, 10 minutes from the charming town of La Cala (...)
€229,000
TSEA5129653
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 1 M2: 85 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 1 M2: 85 Area: San Pedro Region: Andalucía
Apartment for Sale in San Pedro – Your Renovation Opportunity!
Discover this charming apartment located in the peaceful and sought-after area of San Pedro. Situated on an upper floor, this (...)
€525,000
TSEA5129191
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 113 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 113 Area: Marbella West Region: Andalucía
Spacious triplex apartment for sale in Los Pinos de Aloha, ideally located just steps away from the prestigious Aloha Golf Club and within walking distance to renowned schools. This fully gated (...)
€485,000
TSEA5129074
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 93 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Marbella East Region: Andalucía
Spectacular 2-bedroom, 2-bathroom penthouse, completely renovated in the exclusive area of La Mairena, Ojén, surrounded by nature and with unparalleled views of the sea, the golf course, and the (...)
Current Featured Properties
€680,000
TSEA4955554
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
This development is part of a perfectly established community with fully operational common areas. This project has a total of 82 houses to be developed in 2 phases. Phase I corresponds to blocks 1 (...)
€1,190,000
TSEA4648012
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 89 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Fuengirola Region: Andalucía
This new development is an ambitious project consisting of 164 homes surrounded by the natural landscape of El Higueron. The properties are made up of 70 deluxe apartments, 49 garden villas, 25 sky (...)
€720,000
TSEA4502350
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 107 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 107 Area: Estepona Region: Andalucía
New residential project of 2 and 3 bedroom apartments located in Estepona where you will enjoy stunning sea views.
With its cobbled streets, whitewashed buildings with flowers Estepona has a unique (...)
