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 201 - 220 of 4565
€880,000
TSEA5151628
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 199 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 199 Area: Benahavis Region: Andalucía
Luxurious Ground-Floor Apartment in Capanes del Golf – Resort Living within El Higueral Golf course close to Marbella, Benahavis & Estepona
Discover this very spacious apartment in Capanes del (...)
€325,000
TSEA5151052
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 60 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Estepona Region: Andalucía
New Development: Prices from 325,000 € to 995,000 €. [Beds: 1 - 3] [Baths: 1 - 2] [Built size: 60.00 m2 - 147.00 m2]
This is an exclusive residential complex in the Las Mesas area, combining (...)
€495,000
TSEA5151043
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 211 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 211 Area: Mijas and Mijas Costa Region: Andalucía
Are you dreaming of a spacious home in peaceful and beautiful surroundings – close to both the coast and the mountains? Then this property is perfect for you.
3 bright bedrooms
2 bathrooms
Large (...)
€340,000
TSEA5150992
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 1 M2: 96 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 1 M2: 96 Area: Marbella East Region: Andalucía
Apartment for sale in La Reserva de Marbella, Marbella with 2 bedrooms, 1 bathroom and with orientation south, with communal swimming pool and communal garden. Regarding property dimensions, it has (...)
€349,000
TSEA5150977
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 68 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 68 Area: Benalmadena Region: Andalucía
Just a two-minute walk from the beach, this home combines a prime location with comfort. Surrounded by shops, restaurants, and all kinds of services, it's an ideal place to live year-round or to (...)
€275,000
TSEA5150956
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 56 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Benalmadena Region: Andalucía
APARTMENT IN BENALMÁDENA COSTA
We present this exclusive, newly renovated 56 m² apartment, located in the well-known building in Arroyo de la Miel, one of the most sought-after areas of (...)
€379,000
TSEA5150953
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 58 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 58 Area: Marbella Region: Andalucía
Elegant 1-Bedroom Home in "Golden Banus" – Steps from Puerto Banús
This inviting apartment is located in the sought-after Golden Banus development, offering the perfect mix of comfort (...)
€550,000
TSEA5150941
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 178 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 178 Area: Mijas and Mijas Costa Region: Andalucía
FANTASTIC PROPERTY IN A PRESTIGOUS LOCATION
We are delighted to offer this lovely duplex town house in the very convenient location of Miraflores Resort. The property comprises:- Spacious lounge with (...)
€375,000
TSEA5150938
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 123 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Marbella West Region: Andalucía
This apartment in Nueva Andalucía, in the La Campana area, is an excellent opportunity for those seeking comfort and a good location. The property has three bedrooms and two bathrooms, offering a (...)
€325,000
TSEA5150899
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 140 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 140 Area: Benahavis Region: Andalucía
We would like to offer a list of selling points for our apartment.
A top location in the village of 'Benahavis' with a stunning view from the terrace
3 minutes walk from the center of the village, (...)
€229,000
TSEA5150893
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 49 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Fuengirola Region: Andalucía
Breathe and enjoy life at your own rhythm. This brand new apartment development offers the space to be yourself, to focus on what matters, and to reconnect with a lifestyle that feels effort-less. (...)
€675,000
TSEA5150860
- Atalaya, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 212 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 212 Area: Estepona Region: Andalucía
Spacious 4-Bedroom Townhouse in Sought-After Atalaya
Located in the highly desirable residential area of Atalaya—perfectly positioned between Estepona's charming old town and glamorous (...)
€275,000
TSEA5150836
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 81 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 81 Area: Manilva Region: Andalucía
Investment Apartment for Sale
Become the owner of a stunning penthouse duplex apartment – perfect as your own holiday home or as a smart investment.
Highlights:
Just a short walk to the (...)
€1,090,000
TSEA5150803
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
HIGHLIGHTS
Exquisite apartment located in the prestigious Marbella Club Hills development. A 5-star residence set within a privileged natural environment, in collaboration with the iconic Marbella (...)
€550,000
TSEA5150794
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
HIGHLIGHTS
This apartment offers a unique investment opportunity in one of the most sought-after areas of Marbella. With its proximity to Puerto Banús and the beach, this property has enormous (...)
€395,000
TSEA5150782
- Sierrezuela, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse with Panoramic Views of Fuengirola and the Mediterranean
This spacious penthouse in Sierrezuela offers one of the most spectacular terraces you can find – a 50 m² outdoor space with sun (...)
€525,000
TSEA5150773
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Modern and spacious 3-bedroom apartment in exclusive Belaire, Estepona!
Welcome to thiS 3-bedroom apartment located in the sought-after Belaire community in Bel-Air, Estepona. With its modern (...)
€1,875,000
TSEA5150743
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 4 M2: 316 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 4 M2: 316 Area: La Duquesa Region: Andalucía
Unique Penthouse in Puerto de la Duquesa with 360° Views
• A truly unique property on the market: a 3-bedroom, 4-bathroom penthouse with a wrap-around panoramic terra
360° views of the sea, (...)
€335,000
TSEA5150740
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
This charming apartment, located on the first and top floor, perfectly combines comfort, style, and an unbeatable location. Fully renovated and tastefully furnished, it offers modern, functional (...)
€950,000
TSEA5150737
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 73 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 73 Area: Marbella East Region: Andalucía
This unique penthouse is located in a renowned and well-established beachfront urbanization, with direct access to one of the best beaches on the Costa del Sol and its promenade.
As soon as you step (...)
Current Featured Properties
€720,000
TSEA4939045
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
This new development is integrated in a privileged natural environment with views over the bay of Estepona and the mountains of Marbella, very close to the sea and very well connected. A project of (...)
€321,000
TSEA5078176
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 83 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 83 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
This development is the vision of renowned architect — an architectural masterpiece that reimagines residential living as a seamless extension of the Mediterranean.
THE ESSENCE OF THE COSTA DEL (...)
€515,000
TSEA4941421
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Discover 19 stunning homes that combine nature and sea. With elegant details, spacious terraces and fitted kitchens, you will enjoy exceptional living in the heart of Mijas. Immerse yourself in a (...)
