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 61 - 80 of 7581
Results 61 - 80 of 7581
TSEA5157616
New
TSEA5157616 - La Duquesa, Costa Del Sol, La Duquesa
Beds: 2   Baths: 3   M2: 116   Lot Size: 100   Area: La Duquesa   Region: Andalucía   
This exceptional ground floor apartment is situated in the sought-after Duquesa Suites complex in Manilva, Malaga. The property offers a blend of comfort, security, and convenience, making it an (...)
Apartment Ground Floor
TSEA5157598
New
TSEA5157598 - San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3   Baths: 2   M2: 110   Area: San Pedro   Region: Andalucía   
This 3 bedroom apartment is located on the boulevard of San Pedro, surrounded by shops and restaurants. The apartment consists of 3 bedrooms, 2 bathrooms, kitchen, living-dining room and terrace with (...)
Apartment Middle Floor
TSEA5157586
New
TSEA5157586 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1   Baths: 1   M2: 44   Area: Marbella West   Region: Andalucía   
First floor south and east-facing apartment surrounded by golf and amenities, Torres de Aloha, Nueva Andalucía. Comprising living/dining room, small kitchen and east-facing terrace, and a bedroom (...)
Apartment Middle Floor
TSEA5157580
New
TSEA5157580 - Marbella, Costa Del Sol, Marbella
Beds: 3   Baths: 3   M2: 114   Area: Marbella   Region: Andalucía   
Situated in one of the most picturesque parts of Marbella, this newly refurbished three-bedroom, three-bathroom apartment has been finished to the very highest standards. Modern yet understatedly (...)
Apartment Middle Floor
TSEA5157496
New
TSEA5157496 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4   Baths: 4   M2: 410   Lot Size: 728   Area: Marbella West   Region: Andalucía   
Nestled in a quiet residential area of Nueva Andalucía and yet close to all local amenities we find this house for sale. The property has gone through an extensive refurbishment and updating (...)
Villa Detached
TSEA5157487
New
TSEA5157487 - Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 1   M2: 52   Area: Mijas and Mijas Costa   Region: Andalucía   
LOCATION SITIO DE CALAHONDA ! FRONTLINE FIRSTLINE BEACH APARTMENT WITH PANORAMIC SEAVIEWS Discover this beautifully newly renovated middle-floor apartment in a highly sought-after frontline beach (...)
Apartment Middle Floor
TSEA5157484
New
TSEA5157484 - El Padron, Costa Del Sol, Estepona
Beds: 1   Baths: 1   M2: 49   Area: Estepona   Region: Andalucía   
Spectacular panoramic views of the sea and mountains Brand new, fully renovated duplex penthouse with a separate bedroom on the upper level, a full bathroom with a large shower and window. Ground (...)
Apartment Penthouse
TSEA5157463
New
TSEA5157463 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3   Baths: 3   M2: 136   Area: Marbella West   Region: Andalucía   
Bright Semi-Detached Home in Los Naranjos de Marbella, Just 1.5 km from the Beach and Puerto Banús Located in the prestigious Los Naranjos de Marbella urbanization, this bright and modern (...)
Townhouse Terraced
TSEA5157445
New
TSEA5157445 - Higueron, Costa Del Sol
Beds: 2   Baths: 2   M2: 106   Region: Andalucía   
Penthouse Living at Its Best Step into a world of style and comfort with this stunning penthouse apartment. Featuring two elegant bathrooms – one with a sleek shower and the other with a luxurious (...)
Apartment Penthouse
TSEA5157442
New
TSEA5157442 - Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 3   M2: 157   Area: Mijas and Mijas Costa   Region: Andalucía   
This beautifully renovated townhouse is located in Mijas Golf within walking distance to all amenities and public transport. It is set in the tranquil gardens of a gated, secure community.There are (...)
Townhouse Terraced
TSEA5157409
New
TSEA5157409 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 3   Baths: 1   M2: 61   Area: Fuengirola   Region: Andalucía   
Middle Floor Apartment, Fuengirola centre, Costa del Sol. 2.5 Bedrooms, 1 Bathroom, Built 61 m². Setting : Town, Close To Sea. Condition : Good. Climate Control : Air Conditioning. Features : (...)
Apartment Middle Floor
TSEA5157385
New
TSEA5157385 - Coín, Costa Del Sol, Coin
Beds: 4   Baths: 2   M2: 262   Area: Coin   Region: Andalucía   
The first time I stepped into this house, I knew it wasn't just any home. There are places you simply visit, and others that make you pause and imagine. This was one of those. I pictured myself (...)
Villa Detached
TSEA5157376
New
TSEA5157376 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 3   Baths: 2   M2: 125   Area: Fuengirola   Region: Andalucía   
Exclusive newly built penthouse with 3 bedrooms and a spacious south-facing terrace offering spectacular sea and mountain views. The home comes fully furnished with high-end designer pieces created (...)
Apartment Penthouse
TSEA5157190
New
TSEA5157190 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 3   Baths: 2   M2: 124   Area: Fuengirola   Region: Andalucía   
This exclusive, brand-new penthouse with three bedrooms and a large south-facing terrace with sea and mountain views is fully furnished with high-end designer pieces by Ikonia Ilusion&Arte, which (...)
Apartment Penthouse
TSEA5157172
New
TSEA5157172 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 74   Area: Mijas and Mijas Costa   Region: Andalucía   
Investment Opportunity – New on the Market! Front line beach apartment in Calahonda with spectacular sea views. Features: • 3 bedrooms • 2 bathrooms • Complex with swimming pool • (...)
Apartment Middle Floor
TSEA5157166
New
TSEA5157166 - Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 1   M2: 73   Area: Mijas and Mijas Costa   Region: Andalucía   
This beautifully presented 2 bedroom middle floor property has a bright open lounge and generous separate fully fitted kitchen. The large main bedroom and double guest bedroom both have built-in (...)
Apartment Middle Floor
TSEA5157151
New
TSEA5157151 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 3   Baths: 2   M2: 124   Area: Fuengirola   Region: Andalucía   
New exclusive 3-bedroom penthouse for sale with panoramic sea views and a south-facing location to enjoy sunlight, privacy, and uninterrupted views all day long. Located in the exclusive residential (...)
Apartment Penthouse
TSEA5157148
New
TSEA5157148 - El Paraiso, Costa Del Sol, Estepona
Beds: 4   Baths: 3   M2: 217   Area: Estepona   Region: Andalucía   
Stylish 4-Bedroom Townhouse in Paraiso Hills, Estepona Located in the sought-after residential community of Paraiso Hills, this beautifully presented 4-bedroom, 3-story townhouse offers the perfect (...)
Townhouse Terraced
TSEA5157145
New
TSEA5157145 - The Golden Mile, Costa Del Sol, Marbella East
Beds: 4   Baths: 4   M2: 270   Area: Marbella East   Region: Andalucía   
Situated in the exclusive Puente Romano resort, this renovated south-facing corner penthouse offers a living experience that perfectly balances convenience with comfort. With stunning views from its (...)
Apartment Penthouse Duplex
TSEA5157136
New
TSEA5157136 - Casares Playa, Costa Del Sol, Casares
Beds: 2   Baths: 2   M2: 112   Lot Size: 23   Area: Casares   Region: Andalucía   
Charming ground floor apartment in Casares Costa with two bedrooms and two bathrooms, within a small, quiet urbanisation. The property stands out for its spacious, south-facing terrace and private (...)
Apartment Ground Floor