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 7461 - 7480 of 7581
Results 7461 - 7480 of 7581
TSEA3237004
TSEA3237004 - San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 2   Baths: 1   M2: 80   Area: Manilva   Region: Andalucía   
Flat in Sabinillas very bright corner, the facade overlooks three streets. The entrance is direct from the street to a first floor, on the ground floor there is a store for sale as well. Ideal for (...)
Apartment Middle Floor
TSEA3234529
TSEA3234529 - Antequera, Costa Del Sol, Antequera
Beds: 8   Baths: 8   M2: 1,100   Lot Size: 298,000   Area: Antequera   Region: Andalucía   
Huge finca of 298 hectares (298.000 square meters) located 21 kms West of Antequera, between Bobadilla and Campillos, destined for agricultural use. Of the 298 has, 175 has are made up with (...)
Villa Finca
TSEA3229714
TSEA3229714 - San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 6   Baths: 6   M2: 561   Lot Size: 806   Area: San Pedro   Region: Andalucía   
Spacious beachside villa in popular San Pedro, a short drive west of Marbella and Puerto Banús, and within walking distance of the beach promenade, shops and restaurants. This house is set in (...)
Villa Detached
TSEA3229033
TSEA3229033 - Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5   Baths: 4   M2: 286   Lot Size: 3,000   Area: Mijas and Mijas Costa   Region: Andalucía   
THREE PROPERTIES ON ONE PLOT . Close to the popular town of Alhaurin de la Torre . Flat Plot . Possible RENTAL INCOME . Vibrant town with many FIESTAS . Great selection of RESTAURANTS near by There (...)
Villa Detached
TSEA3224398
TSEA3224398 - Archidona, Costa Del Sol, Antequera
Beds: 6   Baths: 3   M2: 300   Area: Antequera   Region: Andalucía   
PARADISE IN SOUTHERN SPAIN In the hearttland of southern Spain, Andalucia, Malaga (Archidona, Villanueva de Tapia) is located this area of peace, thanquility, relax and a place where the olive (...)
Villa Finca
TSEA3218227
TSEA3218227 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4   Baths: 3   M2: 417   Lot Size: 605   Area: Mijas and Mijas Costa   Region: Andalucía   
Modern new construction project in Lomas de Mijas. The project, as sold here, includes a modern style house with spacious rooms, large windows and the best construction qualities. All this on a plot (...)
Villa Detached
TSEA3220219
TSEA3220219 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 7   Baths: 5   M2: 355   Lot Size: 24,000   Area: Mijas and Mijas Costa   Region: Andalucía   
NOW WITH ALL PAPERWORK LEGALISED This is a great investment opportunity in two properties near Mijas. These two villas are located in the valleys of Mijas with easy access to the main road and (...)
Villa Detached
TSEA3210646
Database Updated
TSEA3210646 - Almogía, Costa Del Sol, Malaga
Beds: 3   M2: 476   Lot Size: 37,508   Area: Malaga   Region: Andalucía   
Large plot of rustic land near to Almogía with a house, large storehouse and corral needing a complete reform. The property has great potential (It does not have a bathroom or fitted kitchen at the (...)
Villa Finca
TSEA3202114
TSEA3202114 - Málaga, Costa Del Sol, Malaga
Beds: 5   Baths: 4   M2: 968   Lot Size: 1,800   Area: Malaga   Region: Andalucía   
We present this magnificent and exclusive Villa in the prestigious urbanization of Málaga - Pinares de San Antón. Panoramic views of the sea, a unique and quiet environment to enjoy the fresh air (...)
Villa Detached
TSEA3195034
Database Updated
TSEA3195034 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5   Baths: 3   M2: 338   Lot Size: 6,020   Area: Mijas and Mijas Costa   Region: Andalucía   
Beautiful Villa in perfect condition with wonderful sea and countryside views and 100% privacy and tranquility, located in secure development, 6km from Mijas Pueblo and Fuengirola 12km.
Villa Detached
TSEA3016463
TSEA3016463 - Árchez, Costa Del Sol East
Beds: 4   Baths: 5   M2: 200   Lot Size: 200   Region: Andalucía   
Fantastic House in excellent condition in Archez. It has a large living/dining room, kitchen, four bedrooms and five bathrooms. It is recently built and sold partially furnished. It also has a large (...)
Villa Semi Detached
TSEA3183244
TSEA3183244 - The Golden Mile, Costa Del Sol, Marbella East
Beds: 3   Baths: 3   M2: 200   Area: Marbella East   Region: Andalucía   
Very spacious ground floor apartment with smaill private garden. Open plan Kitchen living/dining area with fireplace and double high ceilings. Three bedrooms ensuite and master with walk wardrobe.
Apartment Ground Floor
TSEA3182194
TSEA3182194 - Puerto Banús, Costa Del Sol, Marbella West
Beds: 8   Baths: 5   M2: 986   Area: Marbella West   Region: Andalucía   
UNIQUE AND AWESOME PENTHOUSE IN PUERTO BANUS.Luxury beach front Apartment, The views are truly unique, the sea, coast and mountain ...VERY PRIVATE The luxurious apartment has 5 or 6 bedrooms, with 5 (...)
Apartment Penthouse
Top Floor Apartment in Mijas Costa
Top Floor Apartment in Mijas Costa - Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4   Baths: 3   M2: 119   Area: Mijas and Mijas Costa   Region: Andalucía   
RELAX AND LET MOTHER NATURE WORK HER MAGIC. This unique new development ideally situated between La Cala de Mijas and Fuengirola, is a NEW CONCEPT of apartments and penthouses of 2, 3 and 4 (...)
Apartment Penthouse
TSEA3179437
TSEA3179437 - Pizarra, Costa Del Sol, Cartama
Beds: 7   Baths: 7   M2: 448   Area: Cartama   Region: Andalucía   
This large village property has been completely rebuild and converted into the most sublime rural tourism establishment. Currently boasting six en-suite letting rooms, the property has staff (...)
Commercial Hostel
TSEA3169777
TSEA3169777 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 124   Area: Estepona   Region: Andalucía   
STREET TERRAZA.Magnificent house for sale in the center of the city. On the terrace of the street with total views on holidays to Easter, and very close to a square full of restaurants where you can (...)
Apartment Penthouse
TSEA3113020
TSEA3113020 - Torremolinos, Costa Del Sol, Torremolinos
Beds: 3   Baths: 2   M2: 375   Lot Size: 438   Area: Torremolinos   Region: Andalucía   
Beatifully appointed quality built Villa. The construction was carried out by the owner´s strict supervision. Built to very high end qualtity with no costs spared. The villa has good insulation, (...)
Villa Detached
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA.
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA. - Estepona, Costa Del Sol, Estepona
Beds: 4   Baths: 3   M2: 124   Lot Size: 15   Area: Estepona   Region: Andalucía   
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA. A luxury resort style apartment complex with the best in leisure facilities. This new development has been landscaped to create TOP QUALITY with (...)
Apartment Ground Floor
TSEA3087802
TSEA3087802 - Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 5   Baths: 4   M2: 420   Lot Size: 640   Area: Mijas and Mijas Costa   Region: Andalucía   
Fantastic villa that is located in a prestigious urbanization in Fuengirola. The property enjoys privacy, tranquility and panoramic views of the sea, mountains and surroundings. Very spacious with a (...)
Villa Detached
TSEA3085945
TSEA3085945 - Casares, Costa Del Sol, Casares
Beds: 3   Baths: 2   M2: 140   Lot Size: 12,000   Area: Casares   Region: Andalucía   
Great finca with three bedrooms, two bathrooms, lots of land and private pool. Just on the entrance of Casares village, no difficult roads, easy access, great quiet location and it has the most (...)
Villa Finca