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 (61,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 (61,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 (61,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (11), Middle Floor - (11), Penthouse - (11), Top Floor Apartment - (11), Penthouse Duplex - (11)Properties
Results 381 - 400 of 3908
€299,000
TSEA5141659
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 94 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic raised ground-floor apartment situated in a sought-after and very well-maintained complex in the upper part of Calahonda. The property has stunning panoramic views of the coast and the (...)
€760,000
TSEA5141653
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 165 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 165 Area: Marbella East Region: Andalucía
Duplex-Penthouse in Marbella's Golden Mile
Situated in the heart of Marbella's prestigious Golden Mile, this elegant 199 m² duplex-penthouse offers spacious interiors, abundant natural light, and (...)
€325,000
TSEA5141644
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Top floor apartment in the popular complex of Nordic Royal Club. Situated on the 5th floor gives the apartment beautiful views over the well kept garden towards the sea. There are 2 well sized (...)
€479,000
TSEA5141638
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 146 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 146 Area: Mijas and Mijas Costa Region: Andalucía
Triplex apartment in Torrequebrada Golf, Benalmádena.
This elegant 3-bedroom, 3-bathroom duplex apartment has three terrace areas, communal pool, TWO parking spaces, a storage room and three (...)
€245,000
TSEA5141551
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 75 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 75 Area: Marbella Region: Andalucía
Stunning high-floor Apartment for Sale in Marbella
Tourist license for 3 rooms (up to 6 people)
Impressive sea views
Secure building with two new elevators
Prime Location:
Steps away from (...)
€315,000
TSEA5141524
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
This stunning and impeccably maintained apartment is perched in the upper part of Calahonda and boasts the most spectacular panoramic sea views in the entire development. It features two spacious (...)
€287,000
TSEA5141515
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 89 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Manilva Region: Andalucía
Renovated Apartment with Terrace and Private Garden – Manilva, Costa del Sol
This elegant 2-bedroom, 2-bathroom apartment, with approximately 89 m² built area and 80 m² usable area, plus a (...)
€900,000
TSEA5141179
- La Quinta, 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
This beautifully designed two-bedroom, two-bathroom apartment offers a harmonious blend of comfort and sophistication in one of the most sought-after areas of the Golf Valley. With 112 m² of (...)
€375,000
TSEA5141125
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 156 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 156 Area: Estepona Region: Andalucía
This beautifully presented west-facing penthouse is modern, stylish, and ready to move into, located within the secure gated community of Bel Air Gardens in Estepona. Enjoying a prime position just (...)
€335,000
TSEA5141053
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
This charming 2-bedroom, 1-bathroom property in Mijas Golf offers comfortable living in a peaceful and well-appointed community. The home features a bright and airy layout with a spacious living area (...)
€595,000
TSEA5141020
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 64 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 64 Area: Marbella West Region: Andalucía
This apartment is the perfect combination of luxury, design and technology in one of Marbella's most sought-after locations. As soon as you walk in, natural light floods every corner and the direct (...)
€1,250,000
TSEA5141002
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 241 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 241 Area: Marbella West Region: Andalucía
This is a refined duplex penthouse set within the gated community of Aloha Gardens in Nueva Andalucía. This property presents a well-balanced combination of modern design and a prime location in one (...)
€749,995
TSEA5140993
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 281 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 281 Area: Fuengirola Region: Andalucía
Another amazing property in Higueron, with a strong rental history making it an attractive investment!
This unique corner apartment is located in one of the most sought-after areas on Costa del Sol. (...)
€355,000
TSEA5140963
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 82 Area: Marbella Region: Andalucía
✨ Living next to the Artola dunes and the best beach in Marbella ✨
Located in Artola Baja (Cabopino), just 200 meters from the protected natural area of the Artola Dunes and 450 meters (...)
€1,100,000
TSEA5140939
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 112 Lot Size: 68 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Lot Size: 68 Area: Benahavis Region: Andalucía
The luxurious 3-bedroom ground floor apartment is located in Aqualina residences with a south-facing orientation and views of the swimming pool and the sea and offers the latest technology and (...)
€320,000
TSEA5140876
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Elegant Middle Floor Apartment for Sale in Riviera del Sol – Costa del Sol
This beautifully presented apartment in Riviera del Sol combines modern comfort with an unbeatable location. Just 5 (...)
€795,000
TSEA5140855
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 127 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 127 Area: Marbella West Region: Andalucía
Welcome to this spacious 2 bedroom and 2 bathroom apartment in the well-kept and perfectly situated urbanization of Royal Gardens. The apartment has an open plan kitchen connecting nicely with the (...)
€469,000
TSEA5140846
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 121 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 121 Area: Marbella East Region: Andalucía
This exquisite first-floor apartment, ideally situated adjacent to Artola golf and within walking distance of the charming Cabopino port, offers a perfect blend of luxury and convenience. The (...)
€5,750,000
TSEA5140834
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 5 M2: 341 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 5 M2: 341 Area: Marbella East Region: Andalucía
This extraordinary apartment, boasting 400 m2 built all on one level including 63 m2 of private terraces, is a true rarity not only within the exclusive La Trinidad complex but across the entire (...)
€399,000
TSEA5140819
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 89 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Mijas and Mijas Costa Region: Andalucía
Top Floor Apartment for Sale in Calahonda – Prime Location on the Costa del Sol
This bright and spacious top floor apartment offers the perfect combination of comfort, convenience, and coastal (...)
Current Featured Properties
€695,000
TSEA4769167
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 142 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 142 Area: Estepona Region: Andalucía
On the Costa del Sol real estate landscape, opportunities rarely arise with such a wealth of compelling elements. From the ideal location just a short stroll from the beautiful port of Estepona, to (...)
€585,000
TSEA4164577
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 130 Lot Size: 210 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Lot Size: 210 Area: Marbella East Region: Andalucía
BEACHFRONT HOME FOR SALE - LIVE THE BEACH LIFE YOU'VE ALWAYS WANTED!!
This middle floor apartment located in Elviria, Marbella East is a great investment opportunity for those who love the beachfront (...)
€910,000
TSEA4964749
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 94 Lot Size: 23 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Lot Size: 23 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
