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 381 - 400 of 7575
Results 381 - 400 of 7575
TSEA5148199
New
TSEA5148199 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4   Baths: 4   M2: 142   Lot Size: 91   Area: Marbella West   Region: Andalucía   
Elegant 4-Bedroom Semi-Detached House with Garden, Jacuzzi, Garage & Laundry Room in Marbella Just 3 km from Puerto Banús and 1.5 km from the beach, this stylish, renovated semi-detached house (...)
Villa Semi Detached
TSEA5148193
New
TSEA5148193 - Marbella, Costa Del Sol, Marbella
Beds: 3   Baths: 3   M2: 92   Area: Marbella   Region: Andalucía   
Magnificent apartment for sale in one of the best areas of San Pedro de Alcantara (Marbella). Nueva Alcantara, on the beachfront and of course with wonderful sea views and a pool. This magnificent (...)
Apartment Middle Floor
TSEA5148178
New
TSEA5148178 - Los Flamingos, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 85   Area: Estepona   Region: Andalucía   
This beautifully furnished 2-bedroom apartment is located in the prestigious complex of Hoyo 19, within the exclusive Los Flamingos Golf Resort in Benahavis. The apartment offers a perfect blend of (...)
Apartment Middle Floor
TSEA5148001
New
TSEA5148001 - El Paraiso, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 92   Lot Size: 30   Area: Estepona   Region: Andalucía   
Bright and Modern Ground-Floor Apartment in El Paraíso – New Golden Mile This beautifully renovated ground-floor apartment is located in the sought-after El Paraíso district, on the New Golden (...)
Apartment Ground Floor
TSEA5147983
New
TSEA5147983 - Casares, Costa Del Sol, Casares
Beds: 3   Baths: 2   M2: 86   Area: Casares   Region: Andalucía   
This new development is set in an exceptional location between the highly sought-after towns of Casares and Estepona, two of the most treasured enclaves on the Costa del Sol. Comprising ten (...)
Apartment Middle Floor
TSEA5147980
New
TSEA5147980 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 2   Baths: 2   M2: 82   Area: Fuengirola   Region: Andalucía   
Panoramic Seafront Living: Modern Apartment in the Heart of Fuengirola For sale: a unique two-bedroom apartment in the prestigious Los Brothers Fuengirola complex, located directly opposite the (...)
Apartment Penthouse
TSEA5147953
New
TSEA5147953 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 3   Baths: 3   M2: 294   Area: Benalmadena   Region: Andalucía   
The most exclusive penthouses in Reserva del Higuerón. One of the best sales opportunities on the Costa del Sol! The owner will enjoy the unique experience of floating above the Mediterranean, (...)
Apartment Penthouse
TSEA5147947
New
TSEA5147947 - New Golden Mile, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 130   Area: Estepona   Region: Andalucía   
Exceptional Frontline Beach Corner Apartment with Spectacular Views Experience coastal living at its finest in this stunning frontline beach corner apartment, which offers breathtaking views of the (...)
Apartment Middle Floor
TSEA5147944
New
TSEA5147944 - Los Boliches, Costa Del Sol, Fuengirola
Beds: 1   Baths: 1   M2: 62   Area: Fuengirola   Region: Andalucía   
Well-Presented 1-Bedroom Apartment in Los Boliches, Fuengirola This charming ground-floor apartment offers a fantastic opportunity to enjoy the vibrant lifestyle of Los Boliches, with all amenities (...)
Apartment Ground Floor
TSEA5147932
New
TSEA5147932 - Marbella, Costa Del Sol, Marbella
Beds: 4   Baths: 4   M2: 138   Area: Marbella   Region: Andalucía   
FIRST LINE BEACH APARTMENT! Magnificent duplex penthouse for sale in one of the best areas of San Pedro de Alcantara (Marbella). Nueva Alcantara, on the beachfront and of course with wonderful sea (...)
Apartment Penthouse Duplex
TSEA5147926
New
TSEA5147926 - Costalita, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 127   Area: Estepona   Region: Andalucía   
3-Bedroom Penthouse in Prime Beachside Location This spacious three-bedroom penthouse is located in Costalita in Estepona East. Upon entering, you are welcomed by a modern kitchen that flows into (...)
Apartment Penthouse
TSEA5147920
New
TSEA5147920 - Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 127   Area: Mijas and Mijas Costa   Region: Andalucía   
Live the Mediterranean Dream: Your Beachside Oasis in Calahonda Awaits Discover the pinnacle of coastal living in this impeccable, ground-floor two-bedroom apartment, situated in a secure beachfront (...)
Apartment Ground Floor
TSEA5147905
New
TSEA5147905 - La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 3   M2: 200   Area: Mijas and Mijas Costa   Region: Andalucía   
Why wait for a new build when you can enjoy this unique living experience right away? This exceptional townhouse gives you the feeling of being the first owner, even though you would be the second. (...)
Townhouse Terraced
TSEA5147887
New
TSEA5147887 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3   Baths: 2   M2: 130   Lot Size: 50   Area: Marbella West   Region: Andalucía   
Ground Floor Apartment, Nueva Andalucía, Costa del Sol. 3 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 26 m², Garden/Plot 50 m². Setting : Close To Schools, Urbanisation. Orientation : East, (...)
Apartment Ground Floor
TSEA5147875
New
TSEA5147875 - Torreblanca, Costa Del Sol, Fuengirola
Beds: 3   Baths: 2   M2: 93   Lot Size: 250   Area: Fuengirola   Region: Andalucía   
Discover your new home in Torreblanca! This impressive detached house is an excellent investment opportunity, as it has a tourist license and is ready to move into. Located in the upper part of (...)
Villa Detached
TSEA5147836
New
TSEA5147836 - Hacienda del Sol, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 104   Area: Estepona   Region: Andalucía   
A beautifully located first-floor apartment in the highly sought-after Hacienda del Sol development. The apartment features a spacious master bedroom with an en-suite bathroom, a second bedroom, and (...)
Apartment Middle Floor
TSEA5147815
New
TSEA5147815 - Valtocado, Costa Del Sol, Mijas and Mijas Costa
Beds: 4   Baths: 6   M2: 556   Lot Size: 1,800   Area: Mijas and Mijas Costa   Region: Andalucía   
Luxury Detached Villa in Valtocado – Panoramic Sea & Mountain Views This magnificent villa, set within the prestigious urbanisation of Valtocado, offers the perfect balance of elegance, space, (...)
Villa Detached
TSEA5147812
New
TSEA5147812 - Benahavís, Costa Del Sol, Benahavis
Beds: 2   Baths: 2   M2: 103   Area: Benahavis   Region: Andalucía   
** Experience one of Marbella's most breathtaking panoramic Sea Views from this fully renovated apartment ** This spacious 103m² apartment has been completely renovated with high-quality finishes. (...)
Apartment Middle Floor
TSEA5147809
New
TSEA5147809 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 3   Baths: 2   M2: 93   Lot Size: 139   Area: Fuengirola   Region: Andalucía   
Experience Contemporary Luxury in El Higuerón, Fuengirola Discover this exclusive ground-floor apartment with a spacious private garden, designed in a modern and minimalist style in one of the most (...)
Apartment Ground Floor
TSEA5147797
New
TSEA5147797 - Estepona, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 85   Area: Estepona   Region: Andalucía   
Fantastic 85m2 apartment with terrace. Spacious and bright, fully furnished and equipped with 2 bedrooms, 2 bathrooms, one en suite, on the beachfront in one of the most sought-after areas of the (...)
Apartment Middle Floor