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 (70,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 (70,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 (70,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 261 - 280 of 4565
€743,000
TSEA5148427
- Los Alamos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 102 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 102 Area: Torremolinos Region: Andalucía
Looking to live by the sea in a prime location?
Close proximity to parks, schools, supermarkets, restaurants, and bars.
Easy access to the highway, with quick connections along the coast.
Just a (...)
€344,900
TSEA5148319
- Torre del Mar, Costa Del Sol East
Beds: 3 Baths: 2 M2: 96 Lot Size: 96 Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Lot Size: 96 Region: Andalucía
This modern apartment in the center of Torre del Mar combines comfort, brightness, and an unbeatable location. The property offers 3 bedrooms, one of them currently used as a laundry room, adding (...)
€995,000
TSEA5148298
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 323 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 323 Area: San Pedro Region: Andalucía
Located in a recently built development, in a prime position just steps from the center of San Pedro de Alcántara, this elegant penthouse combines modern design, comfort, and an unbeatable location, (...)
€916,000
TSEA5148295
- Gaucín, Costa Del Sol, Gaucin
Beds: 4 Baths: 3 M2: 569 Lot Size: 377 Area: Gaucin Region: Andalucía
Beds: 4 Baths: 3 M2: 569 Lot Size: 377 Area: Gaucin Region: Andalucía
Large charming townhouse with swimming pool for sale in Gaucín, Málaga, Andalusia. At the very entrance of the enchanting white village of Gaucín lies this four-story townhouse, full of character (...)
€360,000
TSEA5148286
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 164 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 164 Area: La Duquesa Region: Andalucía
This charming 3-bedroom, 2-bathroom semi-detached home offers the perfect balance of comfort and lifestyle in the sought-after Duquesa area.
On entering the property, you find a guest toilet and (...)
€389,000
TSEA5148280
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 99 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: Casares Region: Andalucía
This fantastic ground floor apartment is set in the sought-after gated community of Casares Green, offering the perfect balance between modern living and the beauty of the Andalusian (...)
€779,900
TSEA5148277
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 143 Lot Size: 55 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 143 Lot Size: 55 Area: San Pedro Region: Andalucía
Luxury Beachside Golf Retreat in Guadalmina Baja
Just 5 minutes from Puerto Banús, discover the epitome of Mediterranean elegance in this spacious 5-bedroom, 4-bathroom retreat, perfectly (...)
€1,170,000
TSEA5148274
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 240 Lot Size: 100 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 240 Lot Size: 100 Area: San Pedro Region: Andalucía
This beautifully renovated 5-bedroom townhouse is perfect for golf lovers and anyone who enjoys peace, privacy, and open green spaces. The bright and modern interior offers comfortable living (...)
€249,000
TSEA5148268
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 90 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Casares Region: Andalucía
Breathtaking 2-Bedroom Apartment in Casares del Sol – 800m from the Beach
Experience the ultimate Costa del Sol lifestyle in this stunning apartment, perfectly situated in the exclusive gated (...)
€495,000
TSEA5148265
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Elegant 3-Bedroom Apartment in Sunny Golf, Estepona
Welcome to this stylish middle-floor apartment in Sunny Golf, Estepona. Delivered in 2024 and upgraded with care, it offers a modern living (...)
€298,000
TSEA5148250
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 1 M2: 124 Area: Ojen Region: Andalucía
Beds: 2 Baths: 1 M2: 124 Area: Ojen Region: Andalucía
Duplex penthouse in the heart of the charming village of Ojen, very close to shops, supermarkets, and the school.
This spacious and bright duplex penthouse features a large living room with a (...)
€849,000
TSEA5148235
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 214 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 214 Area: Fuengirola Region: Andalucía
Exclusive Townhouse in Fuengirola – Close to Everything!
Welcome to a charming and family-friendly community with only ten homes, where it is easy to feel at home. This townhouse is located in one (...)
€565,000
TSEA5148193
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 92 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 92 Area: Marbella Region: Andalucía
Magnificent apartment for sale in one of the best areas of San Pedro de Alcantara (Marbella). Nueva Alcantara, on the beachfront and of course with wonderful sea views and a pool.
This magnificent (...)
€475,000
TSEA5148178
- Los Flamingos, 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
This beautifully furnished 2-bedroom apartment is located in the prestigious complex of Hoyo 19, within the exclusive Los Flamingos Golf Resort in Benahavis. The apartment offers a perfect blend of (...)
€445,000
TSEA5148001
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 92 Lot Size: 30 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Lot Size: 30 Area: Estepona Region: Andalucía
Bright and Modern Ground-Floor Apartment in El Paraíso – New Golden Mile
This beautifully renovated ground-floor apartment is located in the sought-after El Paraíso district, on the New Golden (...)
€423,000
TSEA5147983
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 86 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 86 Area: Casares Region: Andalucía
This new development is set in an exceptional location between the highly sought-after towns of Casares and Estepona, two of the most treasured enclaves on the Costa del Sol.
Comprising ten (...)
€535,000
TSEA5147980
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 82 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Fuengirola Region: Andalucía
Panoramic Seafront Living: Modern Apartment in the Heart of Fuengirola
For sale: a unique two-bedroom apartment in the prestigious Los Brothers Fuengirola complex, located directly opposite the (...)
€3,700,000
TSEA5147953
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 294 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 294 Area: Benalmadena Region: Andalucía
The most exclusive penthouses in Reserva del Higuerón.
One of the best sales opportunities on the Costa del Sol!
The owner will enjoy the unique experience of floating above the Mediterranean, (...)
€2,175,000
TSEA5147947
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Exceptional Frontline Beach Corner Apartment with Spectacular Views
Experience coastal living at its finest in this stunning frontline beach corner apartment, which offers breathtaking views of the (...)
€250,000
TSEA5147944
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
Well-Presented 1-Bedroom Apartment in Los Boliches, Fuengirola
This charming ground-floor apartment offers a fantastic opportunity to enjoy the vibrant lifestyle of Los Boliches, with all amenities (...)
Current Featured Properties
€330,000
TSEA5128870
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 59 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 59 Area: Benahavis Region: Andalucía
Located in the heart of Benahavís, a new residential development is being launched featuring 28 Mediterranean-style apartments with 1, 2, or 3 bedrooms. Each home includes a private underground (...)
€560,000
TSEA4861441
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 99 Lot Size: 62 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 99 Lot Size: 62 Area: Estepona Region: Andalucía
A brand new project consisting of just 30 luxury apartments and penthouses. There are 2 and 3 bedroom options available in this exclusive community conveniently located just 5 minutes from the centre (...)
€695,000
TSEA4622989
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 78 Lot Size: 53 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Lot Size: 53 Area: Fuengirola Region: Andalucía
EMBRACE SPANISH LIFE TO THE FULLEST. Beautifully styled contemporary apartments and sky villas, extensive green areas and a PANORAMIC OVERVIEW of the Mediterranean sea is what sets this development (...)
