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 221 - 240 of 7581
Results 221 - 240 of 7581
TSEA5153017
New
TSEA5153017 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 98   Area: Estepona   Region: Andalucía   
In the heart of the Costa del Sol, we present this spacious flat located in the quiet area of Seghers, in Estepona. Strategically located just a few steps from the marina, the beach and the charming (...)
Apartment Middle Floor
TSEA5153011
New
TSEA5153011 - Marbella, Costa Del Sol, Marbella
Beds: 1   Baths: 1   M2: 53   Area: Marbella   Region: Andalucía   
Unique 1-Bedroom Apartment in the Heart of Marbella – Steps from the Beach and Iconic Landmarks! Seize this exceptional opportunity to own a charming 1-bedroom apartment on Avenida Antonio Belón, (...)
Apartment Middle Floor
TSEA5152990
New
TSEA5152990 - Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 4   Baths: 3   M2: 413   Lot Size: 1,167   Area: Sotogrande   Region: Andalucía   
Elegant Villa in Sotogrande Alto with Mediterranean Charm and Open Views Located in one of the most peaceful and established areas of Sotogrande Alto, this villa combines traditional Mediterranean (...)
Villa Detached
TSEA5152978
New
TSEA5152978 - San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4   Baths: 5   M2: 420   Lot Size: 395   Area: San Pedro   Region: Andalucía   
Welcome to this spectacular corner semi-detached house, located just 250 meters from the promenade and the vibrant San Pedro boulevard! This area is renowned for being one of the most sought-after on (...)
Villa Semi Detached
TSEA5152948
New
TSEA5152948 - Pelayo, Costa de la Luz
Beds: 7   Baths: 3   M2: 500   Lot Size: 11,711   Region: Andalucía   
Exclusive urban estate set on three plots totaling 11,000 m², located in Pelayo just 5 minutes from Algeciras and 15 minutes from Tarifa, bordering Los Alcornocales Natural Park and offering an (...)
Villa Finca
TSEA5152945
New
TSEA5152945 - Antequera, Costa Del Sol, Antequera
Beds: 1   Baths: 1   M2: 51   Area: Antequera   Region: Andalucía   
Modern 1-Bedroom Apartment in the Historic Heart of Antequera, Atico Located right in the centre of Antequera, this modern apartment offers the perfect combination of style, comfort, and (...)
Apartment Penthouse
TSEA5152930
New
TSEA5152930 - Torreblanca, Costa Del Sol, Fuengirola
Beds: 4   Baths: 4   M2: 224   Area: Fuengirola   Region: Andalucía   
Modern Townhouse with Panoramic Sea Views – Torreblanca, Fuengirola Wake up every morning to the sparkle of the Mediterranean, the warmth of the sun, and the privilege of calling this modern (...)
Townhouse Terraced
TSEA5152927
New
TSEA5152927 - Antequera, Costa Del Sol, Antequera
Beds: 1   Baths: 1   M2: 51   Area: Antequera   Region: Andalucía   
Modern 1-Bedroom Apartment in the Historic Heart of Antequera, second floor Located right in the centre of Antequera, this modern apartment offers the perfect combination of style, comfort, and (...)
Apartment Middle Floor
TSEA5152921
New
TSEA5152921 - Málaga Centro, Costa Del Sol, Malaga
Beds: 2   Baths: 1   M2: 108   Area: Malaga   Region: Andalucía   
Unique opportunity in Capuchinos – Your new home or perfect investment awaits! Spacious and bright apartment with enormous potential, in one of the most sought-after areas of the city, less than a (...)
Apartment Middle Floor
TSEA5152912
New
TSEA5152912 - Puerto Banús, Costa Del Sol, Marbella West
Beds: 3   Baths: 2   M2: 125   Area: Marbella West   Region: Andalucía   
Magnificent 3-bedroom apartment for sale located in the Los Naranjos development, just 5 minutes from Puerto Banús, in a privileged area with golf courses surrounding the complex, and practically (...)
Apartment Middle Floor
TSEA5152867
New
TSEA5152867 - Los Boliches, Costa Del Sol, Fuengirola
Beds: 5   Baths: 3   M2: 160   Area: Fuengirola   Region: Andalucía   
Your Dream Space with Potential in Los Boliches Discover the perfect home in the quiet and exclusive upper area of Los Boliches. This spacious three-storey townhouse with 5 bedrooms and 3 bathrooms (...)
Townhouse Terraced
TSEA5152852
New
TSEA5152852 - Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 1   Baths: 1   M2: 65   Area: Benalmadena   Region: Andalucía   
Charming One-Bedroom Apartment in Torrequebrada in a Peaceful Area Spacious living room with plenty of room for a dining table as well. A compact kitchen that still includes everything you need for (...)
Apartment Ground Floor
TSEA5152840
New
TSEA5152840 - Higueron, Costa Del Sol
Beds: 3   Baths: 2   M2: 152   Lot Size: 62   Region: Andalucía   
For Sale: Ground Floor 3-Bedroom Apartment with Garden & Terrace in Las Lomas del Higuerón Discover a beautifully designed ground floor apartment located in the prestigious Las Lomas del (...)
Apartment Ground Floor
TSEA5152753
New
TSEA5152753 - La Alcaidesa, Costa Del Sol, Algeciras
Beds: 2   Baths: 2   M2: 104   Area: Algeciras   Region: Andalucía   
Links 2 Golf & Beach Heaven! So you want modern, you want sea views, you want walk to the beach, and you want easy golf access. You want it all dont you?! ???? Well you can have it all, here at (...)
Apartment Middle Floor
TSEA5152729
New
TSEA5152729 - Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 1   M2: 65   Area: Mijas and Mijas Costa   Region: Andalucía   
Charming Two-Bedroom Apartment with Excellent Location This bright and comfortable two-bedroom apartment is situated on the first floor of a well-maintained building. It features a spacious living (...)
Apartment Middle Floor
TSEA5152720
New
TSEA5152720 - Estepona, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 77   Area: Estepona   Region: Andalucía   
Brand New Fully Furnished 2-Bedroom Apartment in Puerto de Estepona – Just One Minute from the Beach! Step into modern coastal luxury with this stunning, brand-new apartment in a 2025-designed (...)
Apartment Middle Floor
TSEA5152705
New
TSEA5152705 - Antequera, Costa Del Sol, Antequera
Beds: 1   Baths: 1   M2: 51   Area: Antequera   Region: Andalucía   
Modern 1-Bedroom Apartment in the Historic Heart of Antequera Located right in the centre of Antequera, this modern apartment offers the perfect combination of style, comfort, and (...)
Apartment Middle Floor
TSEA5152696
New
TSEA5152696 - Los Boliches, Costa Del Sol, Fuengirola
Beds: 3   Baths: 2   M2: 117   Area: Fuengirola   Region: Andalucía   
Location, Location! Bright Renovated Apartment Just Steps from Fuengirola's Stunning Seafront** Welcome to this beautifully renovated home in the heart of Los Boliches – a place where everything (...)
Apartment Middle Floor
TSEA5152693
New
TSEA5152693 - Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 90   Area: Mijas and Mijas Costa   Region: Andalucía   
Modern 2-bedroom apartment with golf & mountain Views Beautiful new build 2-bedroom, 2-bathroom apartment in the prestigious Calanova Golf area. Enjoy stunning panoramic views of the golf course (...)
Apartment Middle Floor
TSEA5152687
New
TSEA5152687 - Marbella, Costa Del Sol, Marbella
Beds: 3   Baths: 2   M2: 139   Area: Marbella   Region: Andalucía   
LARGE PROPERTY IN MARBELLA CENTER, 300 METERS FROM THE PROMENADE AND THE BEACH Fantastic property with a prime location in the center of Marbella, surrounded by all kinds of amenities and just 300 (...)
Apartment Middle Floor