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 (42,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 (42,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 (42,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 2261 - 2280 of 5891 €2,700,000
TSEA5050603
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 5 M2: 570 Area: Estepona Region: Andalucía
Beds: 4 Baths: 5 M2: 570 Area: Estepona Region: Andalucía
Villa Cindy – A One-of-a-Kind Luxury Residence Bathed in Natural Light in the Heart of Estepona Old Town
Villa Cindy is a truly exceptional and rare property — a Hotel Particulier-style luxury (...)
€1,795,000
TSEA5050594
- Benahavís, Costa Del Sol, Benahavis
Beds: 6 Baths: 6 M2: 680 Lot Size: 1,400 Area: Benahavis Region: Andalucía
Beds: 6 Baths: 6 M2: 680 Lot Size: 1,400 Area: Benahavis Region: Andalucía
Villa Benahavis Views is set right in the heart of the beautiful Benahavis village, walking distance to the local restaurants and bars this wonderful location has to offer.
For location this (...)
€399,000
TSEA5050561
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 88 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Benahavis Region: Andalucía
This apartment has TOP location between Puerto Banus 5 min and Estepona 5. min
Nearby different golf courses , shops and commercial strips
It has been fully renovated in 2025 and is totally ready to (...)
€399,500
TSEA5050558
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 72 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 72 Area: Estepona Region: Andalucía
2 bedroom apartment in a beachfront building in the center of Estepona, on the new pedestrian promenade.
It has 2 bedrooms, 1 bathroom, living room, kitchen, laundry and a terrace with views of the (...)
€650,000
TSEA5050516
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 104 Lot Size: 17 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Lot Size: 17 Area: Estepona Region: Andalucía
Elegant Ground Floor Apartment in Mirador de Estepona Hills with Sweeping Views
Perched at the highest point of the prestigious gated community of Mirador de Estepona Hills, this stylish ground (...)
€425,000
TSEA5050510
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 102 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 102 Area: Mijas and Mijas Costa Region: Andalucía
A rare opportunity to buy a 3 bedroom / 3 bathroom South West facing duplex apartment in the popular complex in lower Calahonda.
The first floor consists of a kitchen, lounge / diner, a double (...)
€625,000
TSEA5050504
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 123 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 123 Area: Benahavis Region: Andalucía
Stunning Renovated 2-Bedroom Apartment with Panoramic Sea & Golf Views – Hacienda Señoría de Cifuentes, Benahavís
Experience luxury living in this beautifully renovated 2-bedroom, (...)
€359,000
TSEA5050420
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 79 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 79 Area: Benahavis Region: Andalucía
The perfect front-line golf rental investment and holiday home!
This fully furnished, first floor apartment is perfect for enjoying the sun in your private terrace.
Overlooking El Paraíso Golf, (...)
€325,000
TSEA5050405
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 114 Lot Size: 20 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Lot Size: 20 Area: Marbella East Region: Andalucía
Lovely golf-front garden apartment in el Soto Golf a luxury Golf complex set in the exclusive La Mairena area on the Elviria's hill side in an area of outstanding natural beauty protected by UNESCO. (...)
€375,000
TSEA5050381
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Spectacular home on the SECOND FLOOR with an outside terrace. The property consists of 2 BEDROOMS and 2 BATHROOMS, one of them en suite. Both bedrooms have BUILT-IN WARDROBES. The AMERICAN-style (...)
€629,000
TSEA5050318
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 90 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 90 Area: Fuengirola Region: Andalucía
Dream Penthouse with Sea and Mountain Views – Ready to Move In!
Discover this stunning top-floor apartment, fully renovated just two years ago with modern finishes and attention to detail. (...)
€599,000
TSEA5050267
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 126 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 126 Area: Benahavis Region: Andalucía
Beautiful 2 bedroom apartment located in Capanes del Golf, Benahavis a popular urbanisation due to location and the size of the living space. This apartment get the sun on the terrace from morning (...)
€346,000
TSEA5050261
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 121 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 121 Area: Benalmadena Region: Andalucía
Spacious Apartment with Mountain Views in the Heart of Arroyo de la Miel (Benalmádena)
Bright 122 m² apartment for sale, ideal as a family home or a profitable investment, located in the very (...)
€399,000
TSEA5050249
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 109 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 109 Area: Benalmadena Region: Andalucía
Penthouse Duplex, Benalmadena arroyo de la miel, Costa del Sol.
2 Bedrooms, 1.5 Bathrooms, Built 109 m².
Setting : Town.
Condition : Excellent.
Climate Control : Air Conditioning.
Features : Lift, (...)
€3,750,000
TSEA5050231
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 355 Lot Size: 794 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 355 Lot Size: 794 Area: Benahavis Region: Andalucía
Modern Mediterranean Villa with Sea Views, Infinity Pool & Sauna in La Quinta
Perched in the peaceful hills of La Quinta, this stylish contemporary villa captures unobstructed views of the (...)
€1,349,000
TSEA5050213
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 184 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 184 Area: Benalmadena Region: Andalucía
Contact us today Duplex Penthouse with Spectacular Sea Views in Stupa Hills
Located next to the prestigious Reserva del Higuerón, this impressive 236m² duplex penthouse is the perfect opportunity (...)
€599,000
TSEA5050198
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 110 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Benahavis Region: Andalucía
Welcome to this exquisite sea view apartment for sale in Puerto de los Almendros, Benahavís.
Located in one of the most sought-after areas on the Costa del Sol, this property blends modern elegance (...)
€495,000
TSEA5050156
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 135 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: San Pedro Region: Andalucía
Spectacular penthouse in the privileged area of the church square in San Pedro de Alcantara with sea views.
The penthouse consists of two bedrooms, the master bedroom with en suite bathroom, and (...)
€535,000
TSEA5050144
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 112 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Area: Benahavis Region: Andalucía
A beautiful 2 bed 2 bath apartment in the prestigious Capanes del Golf development in Benahavis.
With over 50,000sqm of manicured gardens this remains one of the most sought after developments on (...)
€350,000
TSEA5050135
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 120 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Marbella East Region: Andalucía
New listing of a very spacious 2 bedroom, 2 bathroom apartment in Santa Maria, Green Hill, Elviria, Marbella.
This property is in immaculate condition, sold fully furnished, ideal for an investment (...)
Current Featured Properties
€730,000
TSEA4890979
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 182 Lot Size: 605 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 182 Lot Size: 605 Area: Manilva Region: Andalucía
DETACHED VILLA WITH POOL 500m FROM THE BEACH!!!
If there is better value than this on Costa del Sol, we'd like to know about it! In a STYLISH, CONTEMPORARY DESIGN (very sought after!), this villa (...)
€482,000
TSEA5066908
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 2 Baths: 2 M2: 78 Lot Size: 34 Area: Algeciras Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Lot Size: 34 Area: Algeciras Region: Andalucía
The project is located in La Alcaidesa.
La Alcaidesa, located between La Línea de la Concepción and San Roque, in the province of Cádiz, close to Sotogrande and the Rock of Gibraltar. It is an (...)
€525,000
TSEA5075317
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 4 M2: 102 Area: Casares Region: Andalucía
Beds: 3 Baths: 4 M2: 102 Area: Casares Region: Andalucía
An exclusive residential development in the prime location of Doña Julia Golf, in Casares, Málaga. Designed to offer a unique lifestyle, it combines comfort, nature and luxury in an unbeatable (...)
