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 421 - 440 of 7575
Results 421 - 440 of 7575
TSEA5147152
New
TSEA5147152 - San Roque, Costa Del Sol, San Roque
Beds: 4   Baths: 3   M2: 270   Lot Size: 458   Area: San Roque   Region: Andalucía   
Finca - Cortijo, San Roque, Costa del Sol. 4 Bedrooms, 3 Bathrooms, Built 270 m², Terrace 40 m², Garden/Plot 458 m². Setting : Country, Close To Town. Orientation : South. Condition : Good. Pool (...)
Villa Finca
TSEA5147149
New
TSEA5147149 - Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 5   Baths: 3   M2: 277   Lot Size: 1,440   Area: Benalmadena   Region: Andalucía   
Nestled in an exceptional location that perfectly marries tranquil countryside living with the convenience of village life, this charming Andalusian-style villa is a true gem. Situated on a raised (...)
Villa Detached
TSEA5147146
New
TSEA5147146 - Elviria, Costa Del Sol, Marbella East
Beds: 2   Baths: 2   M2: 102   Area: Marbella East   Region: Andalucía   
Master en-suite with full bathroom, dressing room, and direct access to the terrace through double-glazed sliding doors. Second double bedroom with built-in wardrobe, access to the terrace, and (...)
Apartment Penthouse
TSEA5147128
New
TSEA5147128 - Humilladero, Costa Del Sol, Antequera
Beds: 5   Baths: 1   M2: 333   Area: Antequera   Region: Andalucía   
Investment Opportunity in Humilladero This 1975 townhouse presents a rare opportunity to create a spacious family home or a highly attractive investment in one of inland Málaga's most accessible (...)
Townhouse Terraced
TSEA5147125
New
TSEA5147125 - Marbella, Costa Del Sol, Marbella
Beds: 1   Baths: 1   M2: 66   Area: Marbella   Region: Andalucía   
BEACHSIDE GROUND FLOOR APARTMENT – REFORM OPPORTUNITY IN MARBELLA DEL MAR Fantastic opportunity in the sought-after Marbella del Mar complex, set directly on the beachfront and only 10 minutes' (...)
Apartment Ground Floor
TSEA5147110
New
TSEA5147110 - Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 4   Baths: 2   M2: 140   Area: Benalmadena   Region: Andalucía   
This magnificent townhouse in Oasis Benalmar is the perfect opportunity for those seeking a move-in ready home in one of the most attractive and family-friendly areas of Benalmádena. The development (...)
Townhouse Terraced
TSEA5147071
New
TSEA5147071 - El Paraiso, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 103   Area: Estepona   Region: Andalucía   
Located in the prestigious Hacienda Señorio de Cifuentes, this stunning apartment offers the perfect balance between luxury, comfort, and nature. Surrounded by renowned golf courses and boasting (...)
Apartment Middle Floor
TSEA5147068
New
TSEA5147068 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1   Baths: 1   M2: 50   Area: Mijas and Mijas Costa   Region: Andalucía   
Investment Opportunity Just 200 Meters from the Beach! Beautiful renovated apartment for sale, ideal as a vacation rental or second home. Located in a quiet area with stunning sea views, this bright (...)
Apartment Middle Floor
TSEA5147062
New
TSEA5147062 - Marbella, Costa Del Sol, Marbella
Beds: 2   Baths: 1   M2: 104   Area: Marbella   Region: Andalucía   
Charming penthouse in the heart of Marbella, 400 metres from the city's best beaches, the Paseo Marítimo and a minute's walk from Marbella's Old Town. This duplex penthouse consists of two very (...)
Apartment Penthouse
TSEA5147056
New
TSEA5147056 - Puerto Banús, Costa Del Sol, Marbella West
Beds: 3   Baths: 3   M2: 221   Area: Marbella West   Region: Andalucía   
In the heart of Puerto Banús, within the prestigious residential complex Los Granados, stands this spectacular duplex penthouse, an exceptional property that redefines seafront luxury. From its (...)
Apartment Penthouse
TSEA5147050
New
TSEA5147050 - Manilva, Costa Del Sol, Manilva
Beds: 1   Baths: 1   M2: 44   Area: Manilva   Region: Andalucía   
Tourist Apartment for Sale in the PierVacanz Complex – Manilva (Málaga) For Tourist Use Only – Not for Residential Living Apartment for sale in the prestigious PierVacanz holiday complex, just (...)
Apartment Ground Floor
TSEA5147011
New
TSEA5147011 - La Quinta, Costa Del Sol, Benahavis
Beds: 5   Baths: 5   M2: 386   Lot Size: 765   Area: Benahavis   Region: Andalucía   
Nestled in the prestigious La Quinta area of Benahavis, this stunning 303-square-meter villa (386 sqm including terraces) sits on an expansive 765-square-meter plot, offering an unparalleled blend of (...)
Villa Detached
TSEA5146996
New
TSEA5146996 - La Quinta, Costa Del Sol, Benahavis
Beds: 4   Baths: 3   M2: 210   Area: Benahavis   Region: Andalucía   
This elegant duplex, set in the prestigious La Quinta area of Benahavís, offers a rare blend of modern comfort and Mediterranean charm. Recently renovated and in excellent condition, the home spans (...)
 Apartment
TSEA5146993
New
TSEA5146993 - Marbella, Costa Del Sol, Marbella
Beds: 1   Baths: 1   M2: 71   Area: Marbella   Region: Andalucía   
Nestled in the heart of Marbella's prestigious Golden Mile, this elegant ground floor apartment offers the perfect combination of modern comfort and Mediterranean charm. Just five minutes from the (...)
Apartment Middle Floor
TSEA5146972
New
TSEA5146972 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 4   Baths: 2   M2: 141   Area: Fuengirola   Region: Andalucía   
Discover a unique opportunity to live in one of Fuengirola's most sought-after residential complexes with this spacious 4-bedroom first-floor apartment, fully furnished and ready to move in. Its (...)
Apartment Middle Floor
TSEA5146948
New
TSEA5146948 - El Paraiso, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 136   Area: Estepona   Region: Andalucía   
Wonderful apartment in El Paraíso Barronal Your new home awaits you in a privileged location, right on the beach, just a three-minute walk from the sea. The apartment is located in a beautiful (...)
Apartment Middle Floor
TSEA5146921
New
TSEA5146921 - The Golden Mile, Costa Del Sol, Marbella East
Beds: 3   Baths: 3   M2: 146   Area: Marbella East   Region: Andalucía   
This magnificent ground floor apartment is located in the heart of Marbella's famous Golden Mile — one of the most prestigious and sought-after areas on the Costa del Sol. A unique blend of (...)
Apartment Ground Floor
TSEA5146912
New
TSEA5146912 - Ronda, Costa Del Sol, Ronda
Beds: 3   Baths: 2   M2: 229   Area: Ronda   Region: Andalucía   
✨ Charming country house with private pool and tourist license 10 minutes from Ronda ✨ We present a unique country house that combines nature, comfort, and versatility in a privileged setting. (...)
Villa Detached
TSEA5146837
New
TSEA5146837 - Torreblanca, Costa Del Sol, Fuengirola
Beds: 2   Baths: 2   M2: 94   Area: Fuengirola   Region: Andalucía   
Charming Renovated Apartment in the Best Area of Torreblanca – Fuengirola This beautiful apartment, located on the third floor with elevator, has been recently renovated with a romantic and cozy (...)
Apartment Middle Floor
TSEA5146741
New
TSEA5146741 - Pizarra, Costa Del Sol, Cartama
Beds: 11   Baths: 6   M2: 515   Area: Cartama   Region: Andalucía   
Exclusive estate with 5 independent homes in Pizarra – Property with valid AFO Are you looking for a large family estate or a unique investment opportunity in the heart of the Guadalhorce (...)
Villa Detached