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 (57,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 (57,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 (57,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 3906
€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
€369,000
TSEA4282294
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
YOU COULD NOT ASK FOR A BETTER LOCATION!!
Exclusive multi-family homes of 2 and 3 bedrooms located in the privileged surroundings of the Golden Mile of Estepona. The homes enjoy large terraces (...)
€370,000
TSEA4420309
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 87 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Manilva Region: Andalucía
This new development of two and three-bedroom apartments in a magnificent urbanisation in an extraordinary location. The project combines modern design architecture with perfectly studied landscaping (...)
€780,000
TSEA5119063
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
"Discover an exclusive community designed to offer privacy, comfort, and first-class services, located in Los Flamingos, near the prestigious Villa Padierna Palace. Our apartments and penthouses (...)
