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 (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117) 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.approved = 1 AND pm.cat_id IN (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117) GROUP BY p.id ORDER BY p.created DESC

Advanced Search

spain
Sotogrande La Duquesa Manilva Casares Gaucin Estepona Ronda San Pedro Benahavis Marbella West Marbella Marbella East Mijas and Mijas Costa Mijas and Mijas Costa Istan Ojen Monda Guaro Coin Fuengirola Benalmadena Al Haurin de el Grande Al Haurin de la Torre Malaga Torremolinos
Results 41 - 60 of 7581
Results 41 - 60 of 7581
TSEA5158270
New
TSEA5158270 - Manilva, Costa Del Sol, Manilva
Beds: 3   Baths: 2   M2: 198   Area: Manilva   Region: Andalucía   
A stunning newly built four-story townhouse, this exceptional residence offers three double bedrooms, a spacious south-facing terrace, and an expansive rooftop solarium with panoramic views of the (...)
Townhouse Terraced
TSEA5158261
New
TSEA5158261 - Marbella, Costa Del Sol, Marbella
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 (...)
Apartment Middle Floor
TSEA5158255
New
TSEA5158255 - Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 2   Baths: 1   M2: 120   Lot Size: 3,958   Area: Alhaurin el Grande   Region: Andalucía   
Detached Villa with Pool and Large Plot – Fully Renovated Discover this charming detached property, perfect for those seeking peace, privacy, and comfort. The house has been completely renovated, (...)
Villa Finca
TSEA5158237
New
TSEA5158237 - Calahonda, Costa Del Sol, Mijas and Mijas Costa
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 (...)
Apartment Middle Floor
TSEA5158228
New
TSEA5158228 - La Alcaidesa, Costa Del Sol, Algeciras
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 (...)
Apartment Ground Floor
TSEA5158216
New
TSEA5158216 - Higueron, Costa Del Sol
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 (...)
Apartment Middle Floor
TSEA5158210
New
TSEA5158210 - Benahavís, Costa Del Sol, Benahavis
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 (...)
Apartment Ground Floor
TSEA5158165
New
TSEA5158165 - Atalaya, Costa Del Sol, Estepona
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 (...)
Apartment Ground Floor
TSEA5158141
New
TSEA5158141 - Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5   Baths: 4   M2: 228   Lot Size: 259   Area: Mijas and Mijas Costa   Region: Andalucía   
Fantastic semi-detached villa with private pool and two separate homes for sale on a single plot in the exclusive Capellanía residential area, Alhaurín de la Torre. This spectacular semi-detached (...)
Villa Semi Detached
TSEA5158114
New
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   
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 (...)
Apartment Middle Floor
TSEA5158111
New
TSEA5158111 - Fuengirola, Costa Del Sol, Fuengirola
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 (...)
Apartment Middle Floor
TSEA5158102
New
TSEA5158102 - Benahavís, Costa Del Sol, Benahavis
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 (...)
Apartment Middle Floor
TSEA5158084
New
TSEA5158084 - Istán, Costa Del Sol, Istan
Beds: 3   Baths: 2   M2: 125   Area: Istan   Region: Andalucía   
This beautiful townhouse has been TOTALLY RENOVATED to a high standard and is located in Zahara de Istan, just an 8-minute drive from Marbella's Golden Mile. The property features a spacious living (...)
Townhouse Terraced
TSEA5158069
New
TSEA5158069 - Atalaya, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 78   Area: Estepona   Region: Andalucía   
Modern & Spacious 2-Bedroom Bungalow in Atalaya Aparta Golf Complex Set within the prestigious Atalaya Golf Course, this modern and beautifully designed 2-bedroom bungalow combines comfort, (...)
Villa Detached
TSEA5158051
New
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   
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 (...)
Apartment Middle Floor
TSEA5158048
New
TSEA5158048 - Sotogrande Marina, Costa Del Sol, Sotogrande
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 (...)
Apartment Penthouse
TSEA5158045
New
TSEA5158045 - Estepona, Costa Del Sol, Estepona
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 (...)
Apartment Ground Floor
TSEA5157937
New
TSEA5157937 - Aloha, Costa Del Sol, Marbella West
Beds: 4   Baths: 4   M2: 435   Lot Size: 1,038   Area: Marbella West   Region: Andalucía   
Welcome to this exceptional modern villa located in the heart of Nueva Andalucía, offering a seamless blend of style, luxury and comfort. Set on a generous plot of 1,038m², this beautifully (...)
Villa Detached
TSEA5157919
New
TSEA5157919 - Estepona, Costa Del Sol, Estepona
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 (...)
Apartment Middle Floor
TSEA5157901
New
TSEA5157901 - Estepona, Costa Del Sol, Estepona
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. (...)
Apartment Ground Floor