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 1 - 20 of 7591
Results 1 - 20 of 7591
TSEA5159650
New
TSEA5159650 - Higueron, Costa Del Sol
Beds: 2   Baths: 2   M2: 80   Lot Size: 39   Region: Andalucía   
Exclusive Ground-Floor Apartment with Private Garden in Las Lomas del Higuerón – Fuengirola Located in one of the most sought-after residential areas on the Costa del Sol, this spectacular (...)
Apartment Ground Floor
TSEA5159641
New
TSEA5159641 - La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5   Baths: 5   M2: 470   Area: Mijas and Mijas Costa   Region: Andalucía   
This exceptional triplex penthouse with 470 m² of floor space and 270 m² of usable space plus terraces, garages and storage rooms redefines the concept of living on the Costa del Sol. Located in a (...)
Apartment Penthouse Duplex
TSEA5159593
New
TSEA5159593 - Manilva, Costa Del Sol, Manilva
Beds: 3   Baths: 2   M2: 112   Area: Manilva   Region: Andalucía   
Townhouse, Manilva, Costa del Sol. 3 Bedrooms, 2 Bathrooms, Built 112 m², Terrace 72 m². Setting : Country, Village, Close To Shops, Close To Schools, Urbanisation. Orientation : North (...)
Townhouse Terraced
TSEA5159587
New
TSEA5159587 - Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 120   Area: Mijas and Mijas Costa   Region: Andalucía   
Semi-detached house with no community fees in Las Lagunas (Mijas Costa) Cozy and bright semi-detached home located in one of the most sought-after areas of Las Lagunas, close to all amenities and (...)
Villa Semi Detached
TSEA5159569
New
TSEA5159569 - Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 1   Baths: 1   M2: 36   Area: Benalmadena   Region: Andalucía   
Middle Floor Studio, Benalmadena Costa, Costa del Sol. 1 Bedroom, 1 Bathroom, Built 36 m², Terrace 6 m². Setting : Commercial Area, Close To Golf, Close To Port, Close To Shops, Close To Sea, (...)
Studio Middle Floor
TSEA5159560
New
TSEA5159560 - Marbella, Costa Del Sol, Marbella
Beds: 1   Baths: 1   M2: 46   Area: Marbella   Region: Andalucía   
We offers a SUPERB STUDIO IN MARBELLA. Located 5 minutes from the beach and the hospital, just 1 minute from the Old Town. Property located in the heart of Puerto Banús, Marbella, in one of the (...)
Apartment Penthouse
TSEA5159548
New
TSEA5159548 - Estepona, Costa Del Sol, Estepona
Beds: 4   Baths: 3   M2: 150   Area: Estepona   Region: Andalucía   
Modern Corner Apartment in the Heart of Estepona! Located right in the vibrant center of Estepona, just steps away from everything this charming coastal town has to offer and within easy reach of (...)
Apartment Middle Floor
TSEA5159533
New
TSEA5159533 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 1   Baths: 1   M2: 60   Area: Fuengirola   Region: Andalucía   
Spectacular Seafront Apartment in the Best Area of Fuengirola Located on the ninth floor, this magnificent apartment boasts unbeatable panoramic views of the sea, the mountains, and the iconic (...)
Apartment Middle Floor
TSEA5159521
New
TSEA5159521 - La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 1   M2: 56   Area: Mijas and Mijas Costa   Region: Andalucía   
SECOND LINE BEACH. This is a lovely 2 bedroom penthouse apartment with fantastic pool, garden and sea views from the enclosed terrace and solarium. Situated in a great location very close to the (...)
Apartment Penthouse
TSEA5159485
New
TSEA5159485 - Istán, Costa Del Sol, Istan
Beds: 2   Baths: 2   M2: 203   Area: Istan   Region: Andalucía   
Lake and Sea View Villa for Sale in Sierra Blanca Country Club, Istan – Investment Opportunity Near Marbella Set within the prestigious gated community of Sierra Blanca Country Club in Istan, this (...)
Villa Detached
TSEA5159458
New
TSEA5159458 - La Capellania, Costa Del Sol, Fuengirola
Beds: 3   Baths: 2   M2: 130   Area: Fuengirola   Region: Andalucía   
Penthouse, La Capellania, Costa del Sol. 3 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 100 m². Setting : Close To Sea, Urbanisation. Orientation : South, South West. Condition : Excellent. Pool : (...)
Apartment Penthouse
TSEA5159374
New
TSEA5159374 - The Golden Mile, Costa Del Sol, Marbella East
Beds: 5   Baths: 8   M2: 734   Lot Size: 1,000   Area: Marbella East   Region: Andalucía   
This fully renovated Andalusian-style villa is set in Rocío de Nagüeles, one of the most prestigious enclaves of Marbella's Golden Mile. Positioned on a 1,965m² south-facing plot beneath the (...)
Villa Detached
TSEA5159371
New
TSEA5159371 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 2   Baths: 1   M2: 98   Area: Fuengirola   Region: Andalucía   
Bright corner apartment next to Plaza Hispanidad and the market square in Fuengirola. In the area there are several grocery stores, cafes, bakery, pharmacy, etc. The apartment has a proper entrance (...)
Apartment Middle Floor
TSEA5159335
New
TSEA5159335 - La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 76   Area: Mijas and Mijas Costa   Region: Andalucía   
Two bedroom apartment in the popular Calazul complex central to amenities and public transport. The apartment has a sunny terrace and park views. There are two bathrooms one is ensuite with a bath (...)
Apartment Middle Floor
TSEA5159308
New
TSEA5159308 - Cártama, Costa Del Sol, Cartama
Beds: 2   Baths: 2   M2: 155   Lot Size: 2,500   Area: Cartama   Region: Andalucía   
Charming 2/3 Bedroom Country Finca, Orchard, Stunning Gardens, A1 Condition A wonderful opportunity to purchase a deceptively spacious, detached country finca with stunning panoramic views, located (...)
Villa Finca
TSEA5159269
New
TSEA5159269 - Manilva, Costa Del Sol, Manilva
Beds: 3   Baths: 3   M2: 180   Area: Manilva   Region: Andalucía   
Magnificent property situated in a prime beachfront location in the coveted area of ​​Aldea Beach, just a stone's throw from the charming Puerto de La Duquesa. A unique opportunity for those (...)
Townhouse Terraced
TSEA5159263
New
TSEA5159263 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 3   M2: 137   Area: Estepona   Region: Andalucía   
EXCEPTIONAL BEACHFRONT PENTHOUSE WITH PANORAMIC VIEWS OF THE SEA, MOUNTAINS, AND THE AFRICAN COASTLINE, FEATURING TWO SPACIOUS TERRACES TOTALING 100m². This exclusive property is located in the (...)
Apartment Penthouse
TSEA5159209
New
TSEA5159209 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 4   Baths: 2   M2: 115   Area: Benalmadena   Region: Andalucía   
In the heart of Arroyo de la Miel, just a few steps from the commuter train station and only 1.5 km from the beach, lies this magnificent 115 m² apartment an ideal home for families looking for (...)
Apartment Middle Floor
TSEA5159194
New
TSEA5159194 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 3   Baths: 2   M2: 113   Area: Fuengirola   Region: Andalucía   
Located just 100 metres from the beach and close to Castillo Sohail Fuengirola this spacious three bedroom apartment offers the perfect blend of coastal living and urban convenience. Situated on the (...)
Apartment Ground Floor
TSEA5159173
New
TSEA5159173 - La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 3   M2: 149   Area: Mijas and Mijas Costa   Region: Andalucía   
Fantastic opportunity to buy a Duplex penthouse in front line golf with open panoramic views Ample 3 bedrooms and 3 bathrooms, with highest quality finishes and outstanding views to the three golf (...)
Apartment Penthouse Duplex