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 21 - 40 of 7581
Results 21 - 40 of 7581
TSEA5159074
New
TSEA5159074 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 123   Area: Estepona   Region: Andalucía   
Stunning, south-facing fully renovated, three bedroom beachfront apartment in the heart of Estepona's charming Old Town offering spectacular panoramic sea views. With a large usable space, the home (...)
Apartment Penthouse
TSEA5159014
New
TSEA5159014 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 230   Area: Estepona   Region: Andalucía   
Discover this magnificent townhouse located in an exclusive gated community, just a short distance from the new high-resolution hospital and frontline to a spectacular golf course, offering (...)
Townhouse Terraced
TSEA5159005
New
TSEA5159005 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 3   M2: 186   Area: Estepona   Region: Andalucía   
Apartment for sale in Los Granados del Mar, Estepona with 3 bedrooms, 3 bathrooms, 2 en suite bathrooms and with orientation south/east, with communal swimming pool, communal garage (1 parking (...)
Apartment Middle Floor
TSEA5158999
New
TSEA5158999 - San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5   Baths: 2   M2: 177   Lot Size: 222   Area: San Pedro   Region: Andalucía   
We invite you to visit this two-level, south-west facing property in the heart of San Pedro, conveniently located close to a wide range of services and infrastructure, nestled in a tranquil (...)
Villa Semi Detached
TSEA5158933
New
TSEA5158933 - La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 240   Area: Mijas and Mijas Costa   Region: Andalucía   
Apartment for sale in , Mijas Costa with 3 bedrooms, 2 bathrooms, 1 on suite bathroom, 1 toilet and with orientation west, with communal swimming pool, private garage (2 parking spaces) and communal (...)
Apartment Middle Floor
TSEA5158900
New
TSEA5158900 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 5   Baths: 3   M2: 315   Area: Benalmadena   Region: Andalucía   
Beautiful Semi-Detached Villa in Excellent Condition – 325 m² Built This stunning villa offers space, comfort, and an unbeatable location: • Ground floor: large, well-kept garden with fruit (...)
Villa Semi Detached
TSEA5158861
New
TSEA5158861 - Benahavís, Costa Del Sol, Benahavis
Beds: 2   Baths: 2   M2: 117   Area: Benahavis   Region: Andalucía   
Elegant 2-Bedroom Apartment in Capanes del Golf – Where Tranquility Meets Sophistication This beautifully appointed 2-bedroom garden apartment is located in Capanes del Golf, a prestigious gated (...)
Apartment Middle Floor
TSEA5158849
New
TSEA5158849 - Benahavís, Costa Del Sol, Benahavis
Beds: 2   Baths: 2   M2: 93   Area: Benahavis   Region: Andalucía   
A rare find! A very well presented 2 bed 2 bath duplex apartment in the heart of Benahavis. Perfect location with its own private underground parking! Secure and private property with an open plan (...)
 Apartment
TSEA5158834
New
TSEA5158834 - Casares Playa, Costa Del Sol, Casares
Beds: 3   Baths: 2   M2: 85   Area: Casares   Region: Andalucía   
We are pleased to present this magnificent duplex penthouse located in the exclusive Doña Julia area of Casares, a privileged setting that combines peace, elegance, and proximity to the sea. A (...)
Apartment Penthouse Duplex
TSEA5158828
New
TSEA5158828 - Torremolinos, Costa Del Sol, Torremolinos
Beds: 2   Baths: 2   M2: 82   Area: Torremolinos   Region: Andalucía   
This fantastic 2-bedroom apartment with sea views is ideally located in the heart of Torremolinos, offering the best of the Costa del Sol lifestyle. You're just a 10-minute walk from shops, (...)
Apartment Middle Floor
TSEA5158819
New
TSEA5158819 - Marbella, Costa Del Sol, Marbella
Beds: 2   Baths: 2   M2: 104   Area: Marbella   Region: Andalucía   
Situated in the heart of Marbella Centro, this unique first floor apartment offers a rare opportunity with its south orientation and an large private terrace that spans the entire building and (...)
Apartment Penthouse
TSEA5158807
New
TSEA5158807 - Torremolinos, Costa Del Sol, Torremolinos
Beds: 4   Baths: 2   M2: 70   Area: Torremolinos   Region: Andalucía   
This impeccably maintained home, spanning 118 square meters, offers a harmonious blend of luxurious living and serene comfort. Upon entering, you are greeted by a spacious living area, distinguished (...)
Townhouse Terraced
TSEA5158801
New
TSEA5158801 - Malagueta, Costa Del Sol
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 (...)
Apartment Middle Floor
TSEA5158789
New
TSEA5158789 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 3   Baths: 4   M2: 149   Area: Fuengirola   Region: Andalucía   
Exclusive New Development in Torreblanca del Sol – Fuengirola ✨ Just 500 metres from the beach and with excellent commuter train connections, Mirador del Limonar offers contemporary homes that (...)
Townhouse Terraced
TSEA5158783
New
TSEA5158783 - Manilva, Costa Del Sol, Manilva
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 (...)
Apartment Middle Floor
TSEA5158777
New
TSEA5158777 - Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 4   Baths: 3   M2: 134   Area: San Pedro   Region: Andalucía   
Beachside, 5 minutes from Puerto Banús Large semi-detached house with 4 bedrooms, 3 bathrooms, a spacious living-dining room with beautiful views of the pool and gardens, in a gated community. It (...)
Townhouse Terraced
TSEA5158768
New
TSEA5158768 - Mijas, Costa Del Sol, Mijas and Mijas Costa
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 (...)
Apartment Middle Floor
TSEA5158765
New
TSEA5158765 - Nueva Andalucía, Costa Del Sol, Marbella West
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 (...)
Apartment Penthouse Duplex
TSEA5158285
New
TSEA5158285 - Istán, Costa Del Sol, Istan
Beds: 3   Baths: 2   M2: 148   Lot Size: 89   Area: Istan   Region: Andalucía   
"Istan" is a town of Arabic origin, located in the Natural Park of Sierra de las Nieves and just 15 kilometres from the beaches of Marbella. This beautifully completely renovated house can (...)
Townhouse Terraced
TSEA5158276
New
TSEA5158276 - Guadalmina Baja, Costa Del Sol, San Pedro
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 (...)
Apartment Middle Floor