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 7401 - 7420 of 7581
Results 7401 - 7420 of 7581
TSEA3237742
TSEA3237742 - Almayate, Costa Del Sol East
Beds: 10   Baths: 4   M2: 1,607   Lot Size: 32,000   Region: Andalucía   
The Cortijo de la Finca "El Recreo" is a house more than 100 years old, in which all the elements of the typical Andalusian Cortijo-Houses have been preserved. It has a central Andalusian (...)
Villa Finca
TSEA3508726
TSEA3508726 - Estepona, Costa Del Sol, Estepona
Beds: 5   Baths: 5   M2: 387   Lot Size: 5,520   Area: Estepona   Region: Andalucía   
Beautiful and elegant villa in an idyllic and quiet location close to laguna beach and Estepona. Nearby you will find restaurants and supermarkets. The property has a large landscaped garden with (...)
Villa Detached
TSEA3504772
TSEA3504772 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 4   Baths: 4   M2: 285   Area: Fuengirola   Region: Andalucía   
Is your dream living in your own Andalucian home with lots of privacy but still again walking distance from all the services? This duplex townhouse is located in center of Fuengirols one of the most (...)
Townhouse Terraced
TSEA3501181
TSEA3501181 - Elviria, Costa Del Sol, Marbella East
Beds: 5   Baths: 4   M2: 200   Area: Marbella East   Region: Andalucía   
Winter Rental 11.11.2025 - 31.3.2026 FOR INVESTORS! Exceptional Rental Income Opportunity! Breathtaking 360° Panoramic Sea & Mountain Views Earn immediate returns! This stunning penthouse (...)
Apartment Penthouse
TSEA3500422
TSEA3500422 - Algodonales, Costa de la Luz
Beds: 4   Baths: 2   M2: 170   Lot Size: 10,000   Region: Andalucía   
Nice town house with 160m2 built and a plot of land in the back of approximately 10,000m2, ideal families and an ecological garden in the field, rural tourism, holiday home, etc ... has many (...)
Townhouse Terraced
Fabulous Renovated Beachfront Apartment, Puerto Banus
Fabulous Renovated Beachfront Apartment, Puerto Banus - Puerto Banús, Costa Del Sol, Marbella West
Beds: 3   Baths: 4   M2: 352   Area: Marbella West   Region: Andalucía   
PRESTIGIOUS BEACHFRONT APARTMENT IN PUERTO BANUS!!! This elegant apartment is amongst one of the most stylish and best situated on the Costa del Sol. An apartment which feels like a villa with (...)
Apartment Ground Floor
TSEA3472072
TSEA3472072 - Benajarafe, Costa Del Sol East
Beds: 1   Baths: 1   M2: 918   Lot Size: 918   Region: Andalucía   
Fantastic urban plot of 918 m2, located in Benajarafe. Five minutes from the beach and the shops of the town. 15 minutes from Málaga and 25 from the airport. It has views to the sea and nothing else (...)
Plot Residential
TSEA3468730
Database Updated
TSEA3468730 - New Golden Mile, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 160   Lot Size: 200   Area: Estepona   Region: Andalucía   
Wonderfulll 3 bedroom 2 bath penthouse with massive solarium with 360 views. Property is centrally located on the New Golden Mile with great access to the A7 and all shopping and beach.
Apartment Penthouse
TSEA3467848
TSEA3467848 - Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 4   Baths: 3   M2: 160   Lot Size: 8,000   Area: Nerja and Malaga East   Region: Andalucía   
8,000 m2 irrigated farm with mango production. The villa has 160 m2 with a 60 m2 solarium, 4 bedrooms all with two windows or balconies (2 on the ground floor and another 2 bedrooms on the upper (...)
Villa Finca
TSEA3465778
TSEA3465778 - Las Zorrillas, Costa Del Sol East
Beds: 4   Baths: 1   M2: 300   Region: Andalucía   
Beautiful detached house in quiet area with many original features. In earlier days this was a bodega, in the basement the old wine barrels and the antique grape press are still kept and can still be (...)
Villa Detached
TSEA3461908
TSEA3461908 - Puerto Banús, Costa Del Sol, Marbella West
Beds: 2   Baths: 2   M2: 152   Lot Size: 13   Area: Marbella West   Region: Andalucía   
Fantastic ground floor 2 bedroom en suite apartment located within the exclusive 24 hour guard gated community, Malibu. The community boasts two swimming pools (one heated lap pool and one free (...)
Apartment Ground Floor
Oasis of tranquility close to beaches
Oasis of tranquility close to beaches - San Roque, Costa Del Sol, San Roque
Beds: 3   Baths: 2   M2: 115   Area: San Roque   Region: Andalucía   
OASIS OF TRANQUILITY CLOSE TO BEACHES. New release! A great opportunity to buy an off plan apartment at an UNBEATABLE PRICE. The apartment style is light and bright with large open plan living (...)
Apartment Middle Floor
TSEA3455860
Database Updated
TSEA3455860 - Tolox, Costa Del Sol, Yunquera
Beds: 6   Baths: 2   M2: 153   Area: Yunquera   Region: Andalucía   
Nice town house on the edge of the village in a fantastic location, with views of the mountain, and in a very quiet street but only a few steps from the town centre. The house has four floors and has (...)
Townhouse Terraced
TSEA3454348
TSEA3454348 - Puerto Banús, Costa Del Sol, Marbella West
Beds: 7   Baths: 7   M2: 1,592   Lot Size: 2,559   Area: Marbella West   Region: Andalucía   
Built in 2002, is undoubtedly one of the most desirable homes in the area. With an image of luxury and ostentation in true Marbella style, it is characterized by the high quality used in its (...)
Villa Detached
TSEA3455071
TSEA3455071 - Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 6   Baths: 5   M2: 528   Area: Benalmadena   Region: Andalucía   
This private spacious villa offers stunning open views across the Mediterranean Sea. A solid high quality build villa in the traditional hacienda style boasting ample entertaining space, set over (...)
Villa Detached
TSEA3426682
TSEA3426682 - Canillas de Aceituno, Costa Del Sol East
Beds: 3   Baths: 1   M2: 120   Lot Size: 8,000   Region: Andalucía   
Beautiful 8000 sq. mts. farmhouse near the town of Rubite. The house has a covered terrace, three bedrooms, one bathroom, a lounge with fireplace, kitchen and a garage. Outside, on the upper part of (...)
Villa Finca
TSEA3441994
TSEA3441994 - Ojén, Costa Del Sol, Ojen
Beds: 4   Baths: 3   M2: 195   Lot Size: 659   Area: Ojen   Region: Andalucía   
Fantastic rustic finca, located at the entrance to Ojen, a few minutes from Marbella. The main house consists of a living room with two fireplaces, a dining room and kitchen, three bedrooms, a main (...)
Villa Detached
TSEA3437890
TSEA3437890 - Elviria, Costa Del Sol, Marbella East
Beds: 4   Baths: 5   M2: 404   Lot Size: 1,063   Area: Marbella East   Region: Andalucía   
This beautifully decorated villa is comprised of a grand hallway, fully equipped kitchen with a breakfast area, a spacious dining room / lounge with a fireplace and access to the terrace and garden, (...)
Villa Detached
Move straight in today, beach life is waiting for you
Move straight in today, beach life is waiting for you - Manilva, Costa Del Sol, Manilva
Beds: 2   Baths: 2   M2: 71   Area: Manilva   Region: Andalucía   
BEACH LIFE IS WAITING FOR YOU!!! Sea, sun and nature merge in this residential complex close to the beach. In this oasis, cool off in one of the two large SWIMMING POOLS, perfect when there are more (...)
Apartment Middle Floor
Spacious and contemporary apartments
Spacious and contemporary apartments - Sotogrande, Costa Del Sol, Sotogrande
Beds: 3   Baths: 3   M2: 194   Lot Size: 60   Area: Sotogrande   Region: Andalucía   
STUNNING NEW HOMES IN VILLAGE COMMUNITY SETTING. Exclusive Village Community in prestigious Sotogrande area. SPACIOUS AND CONTEMPORARY apartments have been created around an exclusive Village (...)
Apartment Ground Floor