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 181 - 200 of 7581
Results 181 - 200 of 7581
TSEA5154823
New
TSEA5154823 - Gaucín, Costa Del Sol, Gaucin
Beds: 4   Baths: 5   M2: 525   Lot Size: 40,000   Area: Gaucin   Region: Andalucía   
Stunning Rural Villa in Gaucín with Panoramic Views Nestled in the picturesque Andalusian countryside, this impressive villa built in 2008 offers a perfect blend of rustic charm and modern comfort. (...)
Villa Detached
TSEA5154808
New
TSEA5154808 - Marbella, Costa Del Sol, Marbella
Beds: 3   Baths: 2   M2: 101   Area: Marbella   Region: Andalucía   
We are pleased to present a nicely maintained 3-bedroom, 2-bathroom apartment located in the prestigious La Reserva de Marbella. This property perfectly blends comfort, style, and Mediterranean (...)
Apartment Ground Floor
TSEA5154787
New
TSEA5154787 - San Roque, Costa Del Sol, San Roque
Beds: 3   Baths: 1   M2: 95   Area: San Roque   Region: Andalucía   
Detached house in Carteya (San Roque Pueblo, Costa del Sol) In the heart of the historic center of San Roque, next to the Church and the Mirador Poeta Domingo de Mena, lies this detached house that (...)
Villa Semi Detached
TSEA5154769
New
TSEA5154769 - El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 3   M2: 139   Area: Mijas and Mijas Costa   Region: Andalucía   
Welcome to a prestigious gated community in the heart of the Costa del Sol, located in the sought-after area of El Chaparral, just minutes from La Cala de Mijas and Fuengirola. This modern complex is (...)
Townhouse Terraced
TSEA5154760
New
TSEA5154760 - Marbella, Costa Del Sol, Marbella
Beds: 1   Baths: 1   M2: 78   Area: Marbella   Region: Andalucía   
Apartment in the centre of Marbella, on the second line of the beach. Privileged location, just a few metres from the Marina and the Real Club Marítimo de Marbella. Ideal option for investors, with (...)
Apartment Middle Floor
TSEA5154649
New
TSEA5154649 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 159   Area: Estepona   Region: Andalucía   
Beachfront apartment in a modern luxury residential complex in Estepona. Located 5 minutes drive from Estepona city center. Avant-garde design complex of almost 10,000 m2, with large garden areas, 2 (...)
Apartment Middle Floor
TSEA5153797
New
TSEA5153797 - Arenas, Costa Del Sol East
Beds: 3   Baths: 3   M2: 183   Lot Size: 4,284   Region: Andalucía   
Are you dreaming of a life under the Spanish sun, surrounded by peace, space and ultimate comfort? This bright and elegant villa, located between Vélez-Málaga and the charming village of Arenas, (...)
Villa Detached
TSEA5153794
New
TSEA5153794 - Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 3   M2: 132   Area: Mijas and Mijas Costa   Region: Andalucía   
Spacious Fully Renovated 3-Bedroom Apartment – Mijas Costa / Fuengirola Border This bright apartment has been fully reformed and offers generous living space in a convenient location just 100 (...)
Apartment Middle Floor
TSEA5153719
New
TSEA5153719 - Málaga, Costa Del Sol, Malaga
Beds: 4   Baths: 3   M2: 257   Lot Size: 215   Area: Malaga   Region: Andalucía   
Exclusive home in Pedregalejo, beautifully designed and recently built. Quality, design and location come together in this property to create one of the most desirable houses for sale in the area. (...)
Townhouse Terraced
TSEA5153692
New
TSEA5153692 - Marbella, Costa Del Sol, Marbella
Beds: 2   Baths: 2   M2: 212   Area: Marbella   Region: Andalucía   
New Development: Prices from 740,000 € to 1,020,000 €. [Beds: 2 - 3] [Baths: 2 - 3] [Built size: 212.00 m2 - 271.00 m2] This development is an exclusive residential complex comprised of 88 (...)
Apartment Ground Floor
TSEA5153683
New
TSEA5153683 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 2   Baths: 2   M2: 59   Area: Fuengirola   Region: Andalucía   
Brand New Apartment (2024) with Tourist License – Just 200m from the Beach & 2 Minutes from the Train Station Beautiful 2-bedroom, 2-bathroom apartment in a newly built building from 2024, (...)
Apartment Ground Floor
TSEA5153674
New
TSEA5153674 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5   Baths: 3   M2: 222   Lot Size: 721   Area: Marbella West   Region: Andalucía   
Detached Andalusian-Style Villa in Nueva Andalucía — Walk to Puerto Banús & the Beach Tucked away in a quiet cul-de-sac, this charming Andalusian-style villa offers privacy, stunning views (...)
Villa Detached
TSEA5153662
New
TSEA5153662 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 3   Baths: 1   M2: 94   Area: Fuengirola   Region: Andalucía   
Unique Opportunity in the Heart of Fuengirola! Welcome to this bright and spacious apartment with an unbeatable location in the very center of Fuengirola – right next to the bus station yet (...)
Apartment Middle Floor
TSEA5153656
New
TSEA5153656 - Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 130   Area: Mijas and Mijas Costa   Region: Andalucía   
Impressive terraces with views of the sea and the mountains. More than 60 square meters of terraces, covered and uncovered. Immaculate penthouse with two floors. Interior brick staircase to access (...)
Apartment Penthouse Duplex
TSEA5153653
New
TSEA5153653 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 3   Baths: 2   M2: 96   Area: Fuengirola   Region: Andalucía   
✨ Ideal Apartment for Sale in Fuengirola – Close to the Beach and Train Station! Discover this bright and spacious 3-bedroom apartment located in one of the most convenient and well-connected (...)
Apartment Middle Floor
TSEA5153647
New
TSEA5153647 - Estepona, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 90   Area: Estepona   Region: Andalucía   
Stylish Renovated Apartment by the Beach in Estepona Discover this beautifully renovated apartment, perfectly located in a sought-after beachfront urbanization in the very heart of Estepona. Just (...)
Apartment Penthouse
TSEA5153557
New
TSEA5153557 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2   Baths: 2   M2: 128   Area: Marbella West   Region: Andalucía   
We are pleased to present this impeccably designed, Scandinavian-style ground-floor apartment, located in the prestigious and highly sought-after urbanisation of Aldea Blanca. This property offers an (...)
Apartment Ground Floor
TSEA5153545
New
TSEA5153545 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2   Baths: 2   M2: 88   Area: Marbella West   Region: Andalucía   
Superb penthouse in the Nueva Andalucía area. Comprising 2 bedrooms, 2 bathrooms, and a living/dining room with access to a spacious 25 m² terrace. The gated and well-maintained community offers a (...)
Apartment Penthouse
TSEA5153542
New
TSEA5153542 - Los Pacos, Costa Del Sol, Mijas and Mijas Costa
Beds: 4   Baths: 3   M2: 349   Lot Size: 250   Area: Mijas and Mijas Costa   Region: Andalucía   
Appointments for viewing is in January 2026 -The property is rented until end of June 2026. Contact us for more informacion. Amazing independent villa for sale in Los Pacos -beautiful seaviews, (...)
Villa Detached
TSEA5153530
New
TSEA5153530 - San Roque, Costa Del Sol, San Roque
Beds: 4   Baths: 3   M2: 270   Lot Size: 2,500   Area: San Roque   Region: Andalucía   
Spacious Independent Villa in San Roque Pueblo – Private Pool, Garden, and Special Land Offer! Discover this elegant independent house in the charming heart of San Roque Pueblo, built in 2005 and (...)
Villa Detached