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 141 - 160 of 792 €252,500
TSEA5123818
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 106 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 106 Area: Manilva Region: Andalucía
Renovated apartment with front sea views, private terraces and 2 outdoor parking spaces
This 2-bedroom, 2-bathroom apartment has been recently renovated and features a main terrace with stunning (...)
€750,000
TSEA5123731
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
Surrounded by nature and drenched in light, this exquisite apartment offers a lifestyle of peace, beauty, and elevated comfort in the heart of La Quinta—one of Benahavís' most prestigious (...)
€795,000
TSEA5123236
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 251 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 251 Area: Mijas and Mijas Costa Region: Andalucía
Become the owner of a 3 bedrooms apartment with three bathroom, two of which en suite and a huge roof terrace of 155 sqm in an modern development. Offering green spaces, a gym, sauna, saltwater (...)
€845,000
TSEA5123185
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Located in one of the most exclusive areas of the city, this spectacular luxury apartment offers the best in spacious living, panoramic views, and high-end finishes.
Enjoy a private terrace, perfect (...)
€775,000
TSEA5123101
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 176 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 176 Area: Torremolinos Region: Andalucía
Penthouse, Torremolinos, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 176 m².
Setting : Town, Urbanisation.
Condition : Excellent.
Pool : Communal.
Climate Control : Air Conditioning.
Features : (...)
€349,000
TSEA5123044
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 78 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Marbella West Region: Andalucía
MARBELLA – ALOHA, NUEVA ANDALUCÍA
Top-Floor Corner Apartment with Panoramic Views
Holiday rental are allowed in the building
A rare opportunity to own a bright and spacious 2-bedroom, 2-bathroom (...)
€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 : (...)
€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 (...)
€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 (...)
€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 (...)
€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 (...)
€569,000
TSEA5122012
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 116 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Area: Malaga Region: Andalucía
This exclusive apartment is located in the beautiful area of Casares Playa, in Casares, Málaga. With a privileged location, this apartment offers a peaceful and relaxing environment. With 2 bedrooms (...)
€650,000
TSEA5121970
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Top-Floor Penthouse in Seghers with Breathtaking Panoramic Sea Views
Located in the prestigious Seghers area of Estepona, this south-facing top-floor apartment boasts unobstructed panoramic views (...)
€639,000
TSEA5121592
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
This spectacular 2-bedroom, 2-bathroom penthouse is located in the exclusive development Cortijo del Golf, in the El Paraíso area of Estepona. Situated in the heart of the New Golden Mile, this (...)
€1,250,000
TSEA5121457
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 108 Lot Size: 307 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 108 Lot Size: 307 Area: Estepona Region: Andalucía
Exclusive Penthouse in Mirador de Estepona Hills with Unmatched Panoramic Views
Introducing a truly spectacular penthouse in the prestigious Mirador de Estepona Hills residential complex. Perfectly (...)
€695,000
TSEA5121427
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 124 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Benahavis Region: Andalucía
Stunning Penthouse with Lake & Frontline Golf Views in Gated La Quinta Community – 3 Bed, 2 Bath
Discover living in this exceptional 3-bedroom, 2-bathroom penthouse ideally situated in one of (...)
€269,000
TSEA5121100
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 3 M2: 110 Lot Size: 158 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 3 M2: 110 Lot Size: 158 Area: La Duquesa Region: Andalucía
Located in the prestigious and secure urbanization of La Duquesa Village, this unique apartment, fully refurbished in June 2024, offers an exceptional living environment with one of the most stunning (...)
Current Featured Properties
€1,038,000
TSEA4965829
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 90 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Benalmadena Region: Andalucía
Nestled amidst Benalmadena's vibrant centre and situated adjacent to its picturesque port, This new development offers the perfect blend of city living and seaside luxury. A distinctive project that (...)
€720,000
TSEA4766926
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
This fantastic new development of stunning contemporary apartments and penthouses with sea views is located just a stone's throw from La Cala de Mijas. The popularity of this beautiful coastal town (...)
€1,599,900
TSEA4624528
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 103 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: Fuengirola Region: Andalucía
This brand new development stands out! An exclusive residential complex with spacious layouts and top-tier construction. The residences have been built with the highest-quality materials and feature (...)
