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 7221 - 7240 of 7581
Results 7221 - 7240 of 7581
TSEA4032328
TSEA4032328 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 2   Baths: 2   M2: 71   Area: Fuengirola   Region: Andalucía   
LUXURIOUS, HARMONIOUS, CLOSE TO BEAUTIFUL BEACHES. This is one of the most stylish beachside developments in Fuengirola, on the Costa del Sol. Only 100m FROM THE SEA! featuring 1, 2 or 3 bedroom (...)
Apartment Middle Floor
TSEA4030888
TSEA4030888 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 7   Baths: 4   M2: 750   Area: Benalmadena   Region: Andalucía   
EXCELLENT INVESTMENT. 4 renovated apartments for sale located on the beach in Edificio Malibu, Benalmadena. The Malibu building has its own restaurant and beach club, easy parking area, Trocadero (...)
Apartment Ground Floor
TSEA4027675
TSEA4027675 - Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 16   Baths: 16   M2: 1,500   Lot Size: 4,500   Area: Alhaurin el Grande   Region: Andalucía   
A uniqure hotel/ apartment complex for sale in Alhaurin el Grande the hotel complete complete with a bar, and dance floor it is split into 2 different,sections inside the main house where the bar is (...)
Commercial Hotel
TSEA4027225
TSEA4027225 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 134   Lot Size: 154   Area: Mijas and Mijas Costa   Region: Andalucía   
4 UNITS LEFT DREAM AWAY LAZY EVENINGS BY LOOKING AT A STUNNING VIEW!!! Off-plan development of contemporary semi-detached houses in Riviera del Sol, Mijas, with views over the Mediterranean. The 3 (...)
Villa Semi Detached
TSEA4023859
TSEA4023859 - Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 82   Area: Mijas and Mijas Costa   Region: Andalucía   
Would you like to live just few steps from the beach, feel the waves at your terrace and enjoy your own roof top solarium, look over the rooftops and feel the sea breeze? This exclusive penthouse (...)
Apartment Penthouse
TSEA4021621
TSEA4021621 - New Golden Mile, Costa Del Sol, Estepona
Beds: 11   Baths: 5   M2: 600   Lot Size: 1,000   Area: Estepona   Region: Andalucía   
Fantastic villa in Forest Hills with 600m built on a 1000m plot. This villa is characterized by its incredible panoramic views facing south and its large land full of fruit trees and planted with (...)
Villa Detached
TSEA4020931
TSEA4020931 - Castellar de la Frontera, Costa de la Luz
Beds: 2   Baths: 2   M2: 161   Lot Size: 281,500   Region: Andalucía   
This is very large plot of land that consists of various pieces in Cartellar bordering the lake. It also has a house and a small building next to it. Finca - Cortijo, Castellar de la Frontera, Costa (...)
Villa Finca
TSEA4020820
TSEA4020820 - Benahavís, Costa Del Sol, Benahavis
Beds: 3   Baths: 5   Lot Size: 3,473   Area: Benahavis   Region: Andalucía   
Plot+Project+License Residential Plot, Benahavís, Costa del Sol. Garden/Plot 3473 m². Setting : Close To Golf, Urbanisation. Orientation : South. Condition : Excellent. Views : Sea, Mountain, (...)
Plot Residential
TSEA4020082
TSEA4020082 - Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 5   Baths: 3   M2: 272   Lot Size: 713   Area: Mijas and Mijas Costa   Region: Andalucía   
Beautiful Villa completely renovated with high qualities in La Sierrizuela. It is distributed in 2 floors as follows: Ground floor: Entrance hall, guest bathroom, large living room with fireplace, (...)
Villa Detached
TSEA4017190
TSEA4017190 - Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 12   Baths: 5   M2: 546   Lot Size: 6,000   Area: Alhaurin el Grande   Region: Andalucía   
Finca Andaluz for sale in Alhaurín el Grande Place with charm, views of extraordinary beauty with south orientation, make this a privileged place where, sure, will enjoy the pleasures of (...)
Villa Finca
Middle Floor Apartment in Puerto Banus
Database Updated
Middle Floor Apartment in Puerto Banus - Puerto Banús, Costa Del Sol, Marbella West
Beds: 2   Baths: 2   M2: 124   Area: Marbella West   Region: Andalucía   
ON THE DOORSTEP OF PUERTO BANUS!!! Move straight into this front line beach apartment in La Herradura. On the second floor and with an orientation facing south to east. Enjoy direct views to the (...)
Apartment Middle Floor
TSEA4015246
TSEA4015246 - Guaro, Costa Del Sol, Guaro
Beds: 4   Baths: 2   M2: 160   Lot Size: 5,000   Area: Guaro   Region: Andalucía   
Country Finca with PANORAMIC Views . Wonderful vistas . Walk into the village . Spacious property . Loads of outdoor relaxation area . Outdoor kitchen This detached finca on the outskirts (...)
Villa Detached
TSEA4014763
TSEA4014763 - Puerto Banús, Costa Del Sol, Marbella West
Beds: 2   Baths: 2   M2: 124   Area: Marbella West   Region: Andalucía   
Front line beach apartment in La Herradura. Second floor, facing south to east. Direct views to the beach and sea, walking distance to Puerto Banus. Living and dining area, fitted kitchen, spacious (...)
Apartment Middle Floor
TSEA4014661
TSEA4014661 - Atalaya, Costa Del Sol, Estepona
Beds: 6   Baths: 6   M2: 412   Lot Size: 645   Area: Estepona   Region: Andalucía   
WELCOME TO THE BRAND NEW PROMOTION OF 3 LUXURY MODERN VILLAS BORDERING THE NATURE IN MONTE BIARRITZ, NUEVA ATALAYA, ESTEPONA! PLEASE, DISCOVER VILLA DUNAS! Many of the new clients who discover (...)
Villa Detached
TSEA4014655
TSEA4014655 - New Golden Mile, Costa Del Sol, Estepona
Beds: 6   Baths: 6   M2: 418   Lot Size: 645   Area: Estepona   Region: Andalucía   
WELCOME TO THE BRAND NEW PROMOTION OF 3 LUXURY MODERN VILLAS BORDERING THE NATURE IN MONTE BIARRITZ, NUEVA ATALAYA, ESTEPONA! PLEASE, DISCOVER OUR VILLA FLORES! Many of the new clients who discover (...)
Villa Detached
Townhouse in Mijas
Townhouse in Mijas - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4   Baths: 3   M2: 141   Lot Size: 24   Area: Mijas and Mijas Costa   Region: Andalucía   
TOWNHOUSES IN LA CALA DE MIJAS. Ideally located next to El Chaparral Golf Course, a few metres from the beach, very close to the lively, bustling entertainment area of La Cala de Mijas and the (...)
Townhouse Terraced
Townhouse in Mijas
Townhouse in Mijas - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 139   Lot Size: 22   Area: Mijas and Mijas Costa   Region: Andalucía   
SPACIOUS TOWNHOUSES SURROUNDED BY GOLF!!! This is a gated residential complex with three and four-bedroom townhouses featuring innovative, contemporary design that blends in with beautiful natural (...)
Townhouse Terraced
TSEA4004107
TSEA4004107 - Frigiliana, Costa Del Sol East
Beds: 2   Baths: 1   M2: 75   Lot Size: 1,700   Region: Andalucía   
Two bedroom country house located in the Tablazos area between Nerja and Frigiliana. The property has one double and one twin bedroom, a bathroom, lounge with fireplace and a fully equipped kitchen. (...)
Villa Finca
Deatched Villa Malaga
Deatched Villa Malaga - Málaga, Costa Del Sol, Malaga
Beds: 3   Baths: 2   M2: 186   Lot Size: 535   Area: Malaga   Region: Andalucía   
A unique development of 10 villas The development offers different housing solutions that adapt to the needs of each client, choose the layout from a wide variety of options. A modern and functional (...)
Villa Detached
Detached Villa in Benahavis
Detached Villa in Benahavis - Benahavís, Costa Del Sol, Benahavis
Beds: 4   Baths: 4   M2: 498   Lot Size: 2,406   Area: Benahavis   Region: Andalucía   
A PROPERTY IN A DIFFERENT LEAGUE!! 400,000€ discount if you purchase before completion! This is a sustainable luxury development of 18 individually designed villas situated in the 200-hectare (...)
Villa Detached