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,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 (41,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 (41,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 501 - 520 of 3894 €480,000
TSEA5135872
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 78 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Mijas and Mijas Costa Region: Andalucía
**Modern apartment with sea and mountain views in the heart of Calanova Golf **
A modern apartment completed in 2025 is available for sale, located in Calanova Golf on the Costa del Sol. The (...)
€699,000
TSEA5135842
- 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
A Coastal Masterpiece in La Concha – 2 Bed, 2 Bath Renovated Luxury on Fuengirola's First Line
Welcome to one of Fuengirola's most exceptional frontline apartments, a meticulously renovated (...)
€339,000
TSEA5135836
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 339,000 € to 576,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 75.00 m2 - 117.00 m2]
NEW APARTMENTS WITH GREAT VIEWS FOR SALE IN MIJAS, MÁLAGA, COSTA DEL (...)
€260,000
TSEA5135827
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 52 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: Mijas and Mijas Costa Region: Andalucía
.Beachfront Apartment in Calahonda – Mijas Costa
Discover this unique opportunity to own your very own seaside retreat on the Costa del Sol. This charming 2-bedroom, 1-bathroom apartment has (...)
€565,000
TSEA5135818
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 105 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: Mijas and Mijas Costa Region: Andalucía
Prime Location
This modern 3-bedroom, 2-bathroom apartment is located in the most privileged position within one of the most know complexes within La cala de Mijas — in the front row, on the lower (...)
€1,199,000
TSEA5135581
- Montemar, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 414 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 414 Area: Torremolinos Region: Andalucía
Located in one of the best urbanizations of Torremolinos
This stunning penthouse is built on one floor with a large surface very difficult to find in other buildings, enjoys 414 m2 with 4 bedrooms, (...)
€1,495,000
TSEA5135473
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 120 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Fuengirola Region: Andalucía
Experience the pinnacle of coastal living in this exceptional 3-bedroom, 2.5-bathroom penthouse, perfectly positioned in the exclusive El Higuerón community. Designed for those who demand the very (...)
€259,000
TSEA5135461
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 100 Lot Size: 65 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Lot Size: 65 Area: Mijas and Mijas Costa Region: Andalucía
Superb south east facing garden apartment in secure Urbanization in Riviera del Sol, just a few minutes driving to the beach, next to the Golf Course, 2 bedrooms, 2 bathrooms, fully fitted kitchen. (...)
€445,000
TSEA5135443
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 148 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 148 Area: Marbella Region: Andalucía
Middle Floor Apartment, Marbella, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 148 m², Terrace 30 m².
Setting : Town, Suburban, Commercial Area, Close To Shops, Close To Town, Close To (...)
€265,000
TSEA5135437
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 88 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Manilva Region: Andalucía
Discover this stunning 88m² with2 bedroom , just steps from the golden sands of Aldea beach!
✨ Highlights:
• Spacious & modern with a 14m² south-facing terrace boasting breathtaking views (...)
€495,000
TSEA5135380
- San Roque Club, Costa Del Sol
Beds: 3 Baths: 3 M2: 180 Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Region: Andalucía
Large 3 bedroom 3 bathroom middle floor apartment with south facing views to sea
Discover this elegant and spacious apartment located in the exclusive surroundings of San Roque Club, ideal for golf (...)
€948,000
TSEA5135356
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Discover a modern and luxurious lifestyle in this stunning apartment located in the sought-after area of Atalaya on the Costa del Sol. Situated within a gated community with 24-hour security, this (...)
€560,000
TSEA5135326
- La Carihuela, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
Spacious 4-Bedroom Apartment Near the Beach
This bright and spacious 4-bedroom apartment is located on the 1st floor of a quiet residential urbanization, offering both comfort and convenience.
The (...)
€235,000
TSEA5135320
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 1 M2: 52 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: San Pedro Region: Andalucía
No viewings before September 8
Ground floor apartment for sale, recently completely renovated. Located in the central area, very quiet and family-friendly. All kinds of businesses at street level (...)
€337,000
TSEA5135293
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 50 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 50 Area: Marbella Region: Andalucía
Viewings as of 8th of September
Wonderful, fully renovated apartment on the Golden Mile with one bedroom, one laundry and storage room, one bathroom, an open-plan kitchen, and a terrace. It was fully (...)
€2,500,000
TSEA5135290
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 178 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 178 Area: Marbella East Region: Andalucía
Mirador del Príncipe – Corner Apartment in Marbella's Golden Mile
In the heart of the prestigious Golden Mile, just a short walk from Puente Romano, lies this exclusive development of only 14 (...)
€275,000
TSEA5135242
- Benamara, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 40 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 40 Area: Estepona Region: Andalucía
Benamara, Estepona – Charming One-Bedroom Apartment
This inviting ground-floor apartment is set within a well-established residential community, surrounded by beautifully maintained, mature (...)
€1,250,000
TSEA5135230
- Higueron, Costa Del Sol
Beds: 3 Baths: 3 M2: 130 Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Region: Andalucía
Exclusive newly built penthouse with 3 bedrooms and 3 bathrooms located in a modern two-storey building with an impressive 16-metre-long façade. The property has a bright living-dining room with a (...)
€650,000
TSEA5135224
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 92 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Marbella West Region: Andalucía
Ideally located apartment with sea views in Puerto Banus.
This 2 bedrooms - 2 bathrooms apartment is situated in a popular complex in the heart of Puerto Banus, therefore walking distance to all the (...)
€775,000
TSEA5135212
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 151 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 151 Area: Estepona Region: Andalucía
This stunning duplex penthouse is located in Mirador de Estepona Golf, Estepona. Just a few minutes drive to all the amenities and walking distance to the clubhouse of Estepona Golf.
Featuring 3 (...)
Current Featured Properties
€2,995,000
TSEA4458478
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 210 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 210 Area: Estepona Region: Andalucía
BOUTIQUE BEACHFRONT DEVELOPMENT IN ESTEPONA.
Amazing new development of ONLY 14 APARTMENTS right on the beachfront on the edge of Estepona town. This premium development will boast FABULOUS SEA AND (...)
€634,000
TSEA4692997
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 140 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Area: Malaga Region: Andalucía
A luxury residential area located in Malaga, more specifically in El Limonar, This residential area will have 96 homes with 1, 2, 3 and 4 bedrooms with magnificent terraces, penthouses with a (...)
€2,250,000
TSEA4943188
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 142 Lot Size: 186 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 142 Lot Size: 186 Area: Malaga Region: Andalucía
This residential complex is where the contemporary and the traditional come together. For this reason, we will find renovated buildings, alongside newly built buildings or buildings protected as (...)
