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 101 - 120 of 7581
Results 101 - 120 of 7581
TSEA5156371
New
TSEA5156371 - Benahavís, Costa Del Sol, Benahavis
Beds: 2   Baths: 2   M2: 73   Area: Benahavis   Region: Andalucía   
Apartment for sale in , Benahavis with 2 bedrooms and 2 bathrooms, with communal swimming pool and private garage (1 parking spaces). Regarding property dimensions, it has 73 m² built, 60 m² (...)
Apartment Middle Floor
TSEA5156368
New
TSEA5156368 - Benahavís, Costa Del Sol, Benahavis
Beds: 5   Baths: 6   M2: 710   Lot Size: 1,711   Area: Benahavis   Region: Andalucía   
Set within the well-established and sought-after residential area of El Paraíso, Benahavís, this detached villa represents an excellent opportunity for investors or end-users looking to create a (...)
Villa Detached
TSEA5156353
New
TSEA5156353 - La Duquesa, Costa Del Sol, La Duquesa
Beds: 3   Baths: 2   M2: 189   Lot Size: 578   Area: La Duquesa   Region: Andalucía   
Semi-Detached One-Level House with Potential – Prime Location This is not a move-in ready home. It requires work, and plenty of it. But for the right buyer, the reward will be a highly desirable (...)
Villa Semi Detached
TSEA5156344
New
TSEA5156344 - Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 2   Baths: 2   M2: 116   Area: Benalmadena   Region: Andalucía   
Located in the heart of charming Benalmádena Pueblo, this beautifully maintained 2-bedroom apartment offers a blend of modern comfort, relaxed coastal living, and investment potential. Situated in (...)
Apartment Ground Floor
TSEA5156341
New
TSEA5156341 - Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 2   Baths: 2   M2: 166   Area: Benalmadena   Region: Andalucía   
Discover this stylish and well-maintained 2-bedroom duplex located in the prestigious Edificio Iberliving, just moments from the picturesque centre of Benalmádena Pueblo. Built only 7 years ago, (...)
 Apartment
TSEA5156320
New
TSEA5156320 - Hacienda del Sol, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 168   Area: Estepona   Region: Andalucía   
This is a remarkable opportunity to acquire a superb property situated on the second line of the beach in one of the finest urbanizations on the Costa del Sol. It is positioned in the Atalaya Baja (...)
Apartment Middle Floor
TSEA5156308
New
TSEA5156308 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 3   Baths: 2   M2: 140   Lot Size: 464   Area: Benalmadena   Region: Andalucía   
Exclusive detached house for sale on a sought-after residential street in Benalmádena. A unique gem, designed for maximum comfort: single storey, with everything you need at your fingertips. Enjoy (...)
Villa Detached
TSEA5156305
New
TSEA5156305 - Río Real, Costa Del Sol, Marbella East
Beds: 3   Baths: 2   M2: 122   Area: Marbella East   Region: Andalucía   
UNIQUE OPPORTUNITY: Golf-front apartment just 350 meters from the beach in Río Real Our client recently acquired this fantastic apartment through a public auction, but now needs to resell quickly (...)
Apartment Middle Floor
TSEA5156299
New
TSEA5156299 - Marbesa, Costa Del Sol, Marbella East
Beds: 5   Baths: 6   M2: 486   Lot Size: 1,871   Area: Marbella East   Region: Andalucía   
<strong>Location, Location, Location!</strong> This is a rare opportunity to acquire an <strong>absolute frontline beach villa</strong> in the highly sought-after Marbesa (...)
Villa Detached
TSEA5156281
New
TSEA5156281 - Torreguadiaro, Costa Del Sol, Sotogrande
Beds: 4   Baths: 2   M2: 450   Area: Sotogrande   Region: Andalucía   
This magnificent villa combines space, comfort, and a privileged setting. It features four spacious bedrooms and two full bathrooms, designed to offer maximum convenience. The centralized air (...)
Villa Detached
TSEA5156278
New
TSEA5156278 - Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 4   Baths: 3   M2: 144   Area: Mijas and Mijas Costa   Region: Andalucía   
For sale: a stunning 4-bedroom, 3-bathroom townhouse located in the exclusive Riviera del Sol urbanization. The property is in perfect condition, ready to move into, with spacious, bright interiors (...)
Townhouse Semi Detached
TSEA5156257
New
TSEA5156257 - Cabopino, Costa Del Sol, Marbella East
Beds: 2   Baths: 2   M2: 101   Lot Size: 50   Area: Marbella East   Region: Andalucía   
An amazing opportunity to acquire a property in East Marbella´s most iconic complex. This luxury modern apartment is an elevated ground floor property offering the benefit of a large terrace and (...)
Apartment Ground Floor
TSEA5156251
New
TSEA5156251 - Estepona, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 89   Area: Estepona   Region: Andalucía   
Stunning 2-bed Apartment. Presenting a rare opportunity to own this new, modern, recently constructed 2-bed apartment in Phase 2 of Oasis325. Positioned with south orientation which gives you sun (...)
Apartment Middle Floor
TSEA5156242
New
TSEA5156242 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 3   M2: 110   Lot Size: 835   Area: Estepona   Region: Andalucía   
Detached villa with sea views in Estepona – Don Pedro Development Living on the Costa del Sol transcends mere property ownership: it means enjoying a unique lifestyle where sun, sea, and (...)
Villa Detached
TSEA5156197
New
TSEA5156197 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 4   M2: 260   Area: Estepona   Region: Andalucía   
Exclusive luxury detached villa in Isdabe, just 6 minutes from the beach Discover this magnificent, fully renovated single-storey property that combines modern design, efficiency and functionality (...)
Villa Detached
TSEA5156191
New
TSEA5156191 - Selwo, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 66   Lot Size: 84   Area: Estepona   Region: Andalucía   
For Sale – €450,000 2-Bedroom Ground Floor Apartment in Aranya, Selwo – Estepona This brand-new, fully furnished 2-bedroom, 2-bathroom apartment is located in the highly desirable Aranya (...)
Apartment Ground Floor
TSEA5156131
New
TSEA5156131 - Los Boliches, Costa Del Sol, Fuengirola
Beds: 2   Baths: 2   M2: 71   Area: Fuengirola   Region: Andalucía   
Los Boliches downtown. Less then 200m to the Beach. Middle Floor Apartment, Los Boliches, Costa del Sol. 2 Bedrooms, 2 Bathrooms, Built 71 m². Setting : Town, Commercial Area, Beachside, Close To (...)
Apartment Middle Floor
TSEA5156128
New
TSEA5156128 - Benahavís, Costa Del Sol, Benahavis
Beds: 4   Baths: 4   M2: 573   Area: Benahavis   Region: Andalucía   
A top quality, new built contemporaty villa (2024), located in the sought after residential area of La Alqueria, Benahavís. South to west facing with views to mountains and some seaviews from the (...)
Villa Detached
TSEA5156122
New
TSEA5156122 - Estepona, Costa Del Sol, Estepona
Beds: 5   Baths: 3   M2: 190   Area: Estepona   Region: Andalucía   
Exclusive Estepona Beachfront Villa — €50,000 Price Reduction, Split-Home Flexibility Discover the rare opportunity to own a luxury beachfront villa in sought-after Villacana, Estepona, now (...)
Villa Semi Detached
TSEA5156104
New
TSEA5156104 - Marbella, Costa Del Sol, Marbella
Beds: 3   Baths: 1   M2: 143   Lot Size: 200   Area: Marbella   Region: Andalucía   
Stunning South-Facing Villa in Bello Horizonte - Lindasol: Private Pool, Garden, and Modern Comforts! Discover this impeccably maintained villa in the desirable Bello Horizonte - Lindasol (...)
Villa Detached