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 7101 - 7120 of 7575
Results 7101 - 7120 of 7575
TSEA4152769
TSEA4152769 - La Viñuela, Costa Del Sol East
Beds: 6   Baths: 4   M2: 398   Lot Size: 1,403   Region: Andalucía   
Los Romanes is a quiet village located on a hill, with panoramic views of the La Viñuela reservoir. It is 25 minutes from the coast of Torre del Mar and less than an hour from Malaga and its (...)
Villa Detached
TSEA4152514
TSEA4152514 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5   Baths: 4   M2: 363   Lot Size: 950   Area: Marbella West   Region: Andalucía   
Recently renovated villa, located in a gated and guarded urbanization, in the Las Brisas Golf area, in Nueva Andalucía, Marbella, with a lot of character and personality. This villa sits on a plot (...)
Villa Detached
TSEA4149598
TSEA4149598 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 300   Lot Size: 10,000   Area: Estepona   Region: Andalucía   
sea view from the terrace of this Finca with fruit trees plantation just 1 km from the sea and the supermarket and only 5 minutes from the center of Estepona enjoy total peace while being very close (...)
Villa Detached
TSEA4149427
TSEA4149427 - Cútar, Costa Del Sol East
Beds: 3   Baths: 1   M2: 150   Lot Size: 1,467   Region: Andalucía   
This lovely semi-detached countryside house is located on the road between the villages of Benamargosa and Riogordo in a little quiet little hamlet and only around 35 minutes drive to the coast. It (...)
Villa Semi Detached
TSEA4148404
TSEA4148404 - Nagüeles, Costa Del Sol, Marbella
Beds: 5   Baths: 6   M2: 724   Lot Size: 2,525   Area: Marbella   Region: Andalucía   
This stunning luxury house for sale in the heart of the Golden Mile of Marbella is set in the well-established community of Rocio de Nagüeles, close to all amenities of the famous Golden (...)
Villa Detached
TSEA4148092
TSEA4148092 - San Roque, Costa Del Sol, San Roque
Beds: 2   Baths: 2   M2: 98   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 Ground Floor
TSEA4148059
TSEA4148059 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 3   M2: 130   Area: Estepona   Region: Andalucía   
Beachfront complex, Estepona, New Golden Mile. Fully renovated corner semidetached townhouse located in a front line beach complex that resembles a fishing village, full of character and tradition! (...)
Townhouse Semi Detached
TSEA4145560
Database Updated
TSEA4145560 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 5   Baths: 2   M2: 209   Lot Size: 1   Area: Fuengirola   Region: Andalucía   
HOUSE WITH SEA VIEWS NEXT TO THE BEACH - FUENGIROLA. Large property next to the beach with sea views, 5 bedrooms, 2 bathrooms, 2 kitchens, one on each floor, 2 living - dining rooms, several (...)
Villa Detached
TSEA4144681
TSEA4144681 - Benamara, Costa Del Sol, Estepona
Beds: 9   Baths: 9   M2: 735   Lot Size: 4,375   Area: Estepona   Region: Andalucía   
Spacious, flat plot with direct access to the sea (private gate), quiet, green area. On a plot of 2 residential 2-storey houses (the main house is 6 bedrooms, a large apartment for the servants, a (...)
Villa Detached
TSEA4142536
TSEA4142536 - Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 115   Lot Size: 42   Area: Mijas and Mijas Costa   Region: Andalucía   
Beautiful semi-detached Villa with three bedrooms in a quiet, well maintained community, in a fantastic location just two minutes from the beach and all amenities in Riviera del Sol. The property is (...)
Villa Semi Detached
TSEA4141252
TSEA4141252 - Estepona, Costa Del Sol, Estepona
Beds: 5   Baths: 3   M2: 180   Lot Size: 1,000   Area: Estepona   Region: Andalucía   
Villa of 1000 square meters, consists of two houses: the main house has four bedrooms and two bathrooms, private pool and garden, two porches, one closed with kitchen, barbecue area, appliances and (...)
Villa Detached
TSEA4141156
TSEA4141156 - Benahavís, Costa Del Sol, Benahavis
Beds: 6   Baths: 8   M2: 700   Area: Benahavis   Region: Andalucía   
Amazing house in Benahavis with panoramic views. Very spacious and bright interior. Bedrooms en suite, with fitted wardrobes. Marvellous plot of 3.200m2 with beautiful private gardens and swimming (...)
Villa Detached
TSEA4134301
TSEA4134301 - Las Chapas, Costa Del Sol, Marbella East
Beds: 3   Baths: 3   M2: 200   Area: Marbella East   Region: Andalucía   
Large Town House only 150 metres from the lovely dunes beaches in Costabella,close to shops and 10 minutes drive to Marbella Town,private garage for 3 cars. Posibility to build 1 extra bedroom in (...)
Townhouse Terraced
TSEA4133854
Database Updated
TSEA4133854 - Puerto Banús, Costa Del Sol, Marbella West
Beds: 4   Baths: 2   M2: 90   Area: Marbella West   Region: Andalucía   
This commercial premises in Cristamar shopping center, Puerto Banús, has been completely renovated and equipped, making it an ideal option to establish a massage parlor, hairdresser or other type of (...)
 Commercial
TSEA4133581
TSEA4133581 - Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 3   M2: 477   Lot Size: 1,050   Area: Mijas and Mijas Costa   Region: Andalucía   
Large villa on one floor with sea views on the first line of golf, Jardines del Aguila Urb. 1,050m2 of flat plot and 450m2, 380m2 being useful. The house has three large bedrooms, the main (...)
Villa Detached
TSEA4132522
TSEA4132522 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 97   Area: Mijas and Mijas Costa   Region: Andalucía   
New residential in Mijas Costa, Malaga. The private urbanization has 54 homes with 2 and 3 bedrooms distributed in 3 blocks, 3 stories high, including penthouses with large terraces that will enjoy (...)
Apartment Ground Floor
TSEA4132123
TSEA4132123 - Benaoján, Costa Del Sol
Beds: 4   Baths: 2   M2: 108   Region: Andalucía   
Are you ready for your own original Andalusian townhouse? This 3 storey property with huge roof terrace is located in the center of Benaojan, one of the most prettiest white villages close to (...)
Townhouse Terraced
TSEA4131982
TSEA4131982 - Almayate, Costa Del Sol East
Beds: 4   Baths: 2   M2: 132   Lot Size: 5,000   Region: Andalucía   
We present you this spectacular property in the first beach line in Almayate. The spacious 5000 m2 plot is fantastically landscaped, with paths leading through the grass and beautiful planting. Lamps (...)
Villa Detached
TSEA4131643
TSEA4131643 - Los Arqueros, Costa Del Sol, Benahavis
Beds: 3   Baths: 2   M2: 131   Area: Benahavis   Region: Andalucía   
This wonderful bright & spacious three bedroom two bathroom middle floor corner apartment situated within one of the best developments in Los Arqueros Golf and Country Club. The property further (...)
Apartment Middle Floor
TSEA4126801
TSEA4126801 - Elviria, Costa Del Sol, Marbella East
Beds: 4   Baths: 4   M2: 180   Area: Marbella East   Region: Andalucía   
Great INvestment - return holiday rental 6%-7% per year - 2 AMAZING BEACHFRONT refurbished apartments earn directly income with existing bookings. Situated on top of each other- each 2 bedrooms 2 (...)
Apartment Penthouse