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 (48,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 (48,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 (48,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 21 - 40 of 3916
€1,299,000
TSEA5158801
- Malagueta, Costa Del Sol
Beds: 3 Baths: 2 M2: 174 Region: Andalucía
Beds: 3 Baths: 2 M2: 174 Region: Andalucía
Luxury flat 100 metres from the sea for sale in La Malagueta - Monte Sancha
Welcome to paradise on the coast of Malaga!
We present this exclusive luxury property on Paseo de Sancha, combining (...)
€249,500
TSEA5158783
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 121 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 121 Area: Manilva Region: Andalucía
Beautiful 2-bedroom, 2-bathroom apartment in a private urbanization in Sabinillas, offering 121 m² of living space, a large south-facing terrace with pool, gardens, garage, and storage—just (...)
€229,500
TSEA5158768
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 51 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Mijas and Mijas Costa Region: Andalucía
Charming 1-Bedroom Apartment for Sale in Mijas – Ideal Location Near Beach & Shopping center
This well-maintained 1-bedroom, 1-bathroom apartment is a fantastic opportunity to own a (...)
€849,000
TSEA5158765
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 137 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 137 Area: Marbella West Region: Andalucía
Exclusive Duplex Penthouse in El Dorado – Nueva Andalucía
Discover this unique and fully renovated duplex penthouse in the sought-after El Dorado, a charming complex within walking distance to (...)
€468,000
TSEA5158276
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 105 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: San Pedro Region: Andalucía
FANTASTIC CORNER APARTMENT, SPACIOUS AND BRIGHT NEXT TO THE GOLF AND THE BEACH IN GUADALMINA BAJA!!
In the heart of Guadalmina Baja, one of the most exclusive areas on the Costa del Sol, lies this (...)
€875,000
TSEA5158261
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 120 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 120 Area: Marbella Region: Andalucía
Unique opportunity to purchase two apartments which were united into one big apartment in the famous Torre Real in Marbella. Offering a total of 120m2 living and 98m2 terraces all around. Due to the (...)
€315,000
TSEA5158237
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 91 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Mijas and Mijas Costa Region: Andalucía
This apartment is situated in a secure, gated complex, just a stone's throw from shops, the sea only a 10 minute walk, and the vibrant town center, making it an ideal choice for holiday homes or (...)
€495,000
TSEA5158228
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 127 Lot Size: 28 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 28 Area: Algeciras Region: Andalucía
Everyone wants outside space.
Everyone wants walk to beach, shops, a few restaurants.
And every wants a sea view. These are our common requests.
What if you can get all of the above, a little sea (...)
€1,100,000
TSEA5158216
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 86 Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Region: Andalucía
Carat, Higuerón West – Unparalleled Luxury 2-Bedroom Apartment with Private Spa & Panoramic Sea Views
Introducing Carat, Higuerón West's most iconic and prestigious development to date – a (...)
€750,000
TSEA5158210
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 227 Lot Size: 270 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 227 Lot Size: 270 Area: Benahavis Region: Andalucía
Spectacular ground floor duplex flat located in the exclusive gated community of Riverside, in the village of Benahavís, a secure environment where residents enjoy peace and privacy. One of the most (...)
€745,000
TSEA5158165
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 106 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 106 Area: Estepona Region: Andalucía
Apartment for sale – Benatalaya Urbanization
Discover this spacious and bright ground floor apartment, ideal for enjoying life on the coast. With 250 m² built and 206 m² useful, this property (...)
€335,000
TSEA5158114
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Stunning newly renovated 2 bedroom/ 2 bathroom apartment in low Riviera del Sol with sea views from the living room, balcony and the master bedroom. Unbeatable location, right in the centre of (...)
€239,000
TSEA5158111
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 43 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 43 Area: Fuengirola Region: Andalucía
???? Apartment for Sale in Los Boliches – Fuengirola ????
A unique opportunity to acquire an apartment in the exclusive area of Los Boliches, just a few steps from the beach and surrounded by all (...)
€310,000
TSEA5158102
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 73 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 73 Area: Benahavis Region: Andalucía
Elegant Renovated 1-Bedroom Apartment in Parque Botánico, Estepona – Resort-Style Living with Premium Amenities!
Discover this impeccably renovated apartment in pristine condition, boasting modern (...)
€219,950
TSEA5158051
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 94 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Nerja and Malaga East Region: Andalucía
New Development: Prices from 219,950 € to 399,950 €. [Beds: 2 - 4] [Baths: 2 - 2] [Built size: 94.00 m2 - 225.00 m2]
A place designed for enjoyment, relaxation, and living with all the (...)
€750,000
TSEA5158048
- Sotogrande Marina, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 137 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Sotogrande Region: Andalucía
???? Duplex Apartment with Solarium and Marina Views in Sotogrande
Located in one of the most exclusive areas of the Costa del Sol, this stunning apartment in the Sotogrande Marina offers generous (...)
€299,000
TSEA5158045
- Estepona, 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
Beautiful 2 bedroom ground floor apartment in the old town of Estepona, The property has a large living room with semi open plan kitchen, two double bedrooms, large bathroom and courtyard patio,
It (...)
€955,000
TSEA5157919
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 161 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 161 Area: Estepona Region: Andalucía
Luxury Seafront Residence in the Exclusive Bahía de la Plata Complex, Estepona
Exclusive seafront residence located in the prestigious Bahía de la Plata complex in Estepona. The complex enjoys an (...)
€965,000
TSEA5157901
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Nestled in a prestigious beachfront urbanization in Estepona, walking distance to the port, this luxurious fully renovated apartment offers an unparalleled living experience on the Costa del Sol. (...)
€399,800
TSEA5157616
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 3 M2: 116 Lot Size: 100 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 3 M2: 116 Lot Size: 100 Area: La Duquesa Region: Andalucía
This exceptional ground floor apartment is situated in the sought-after Duquesa Suites complex in Manilva, Malaga. The property offers a blend of comfort, security, and convenience, making it an (...)
Current Featured Properties
€525,000
TSEA4502323
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 92 Lot Size: 81 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 92 Lot Size: 81 Area: Estepona Region: Andalucía
New residential project of 2 and 3 bedroom apartments located in Estepona where you will enjoy stunning sea views.
With its cobbled streets, whitewashed buildings with flowers Estepona has a unique (...)
€799,500
Amazing panoramic views of the Mediterranean
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 2 M2: 92 Lot Size: 21 Area: Ojen Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Lot Size: 21 Area: Ojen Region: Andalucía
EXCEPTIONAL LIVING ON THE COSTA DEL SOL!!!
These exciting new off-plan apartments are being built with the highest quality materials to ensure the best standard of completion. The apartments feature (...)
€250,000
TSEA4973002
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
SPACIOUS 3-BEDROOM APARTMENT WITH SEA VIEWS IN FOREST HILLS – GREAT VALUE & INVESTMENT POTENTIAL
This bright and generously sized 3-bedroom apartment in the popular Forest Hills area offers (...)
