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 81 - 100 of 7581
Results 81 - 100 of 7581
TSEA5157100
New
TSEA5157100 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 3   M2: 311   Area: Mijas and Mijas Costa   Region: Andalucía   
New Development: Prices from 1,100,000 € to 1,100,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 311.00 m2 - 311.00 m2] Luxurious and modern high tech villa with 3 bedrooms, 3 ensuite (...)
Villa Detached
TSEA5157088
New
TSEA5157088 - La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4   Baths: 4   M2: 155   Area: Mijas and Mijas Costa   Region: Andalucía   
New Development: Prices from 1,380,000 € to 1,380,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 155.00 m2 - 155.00 m2] Luxurious and modern high tech villa with 4 bedrooms, 4 bathrooms, (...)
Villa Detached
TSEA5157073
New
TSEA5157073 - Marbella, Costa Del Sol, Marbella
Beds: 5   Baths: 4   M2: 475   Lot Size: 979   Area: Marbella   Region: Andalucía   
Spacious independent villa with a lot of character in exclusive residential area of Marbella. This magnificent villa is built on a plot of nearly 1000 sqm and has a total built surface of 475 sqm. It (...)
Villa Detached
TSEA5157067
New
TSEA5157067 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 1   Baths: 1   M2: 56   Area: Fuengirola   Region: Andalucía   
New Development: Prices from 265,000 € to 1,100,000 €. [Beds: 1 - 4] [Baths: 1 - 3] [Built size: 56.00 m2 - 188.00 m2] Boutique Sea-View Apartments in Torreblanca del Sol Features: Sea-facing (...)
Apartment Ground Floor
TSEA5157052
New
TSEA5157052 - Benahavís, Costa Del Sol, Benahavis
Beds: 3   Baths: 3   M2: 135   Lot Size: 28   Area: Benahavis   Region: Andalucía   
Elegant ground-floor apartment with a large terrace and private garden in a prestigious gated community Benatalya. The property features a spacious layout with 3 bedrooms and 3 bathrooms, a bright (...)
Apartment Ground Floor
TSEA5157049
New
TSEA5157049 - El Paraiso, Costa Del Sol, Estepona
Beds: 4   Baths: 3   M2: 192   Lot Size: 30   Area: Estepona   Region: Andalucía   
Situated in the sought-after community of Montevideo Hills, this spacious renovated 4-bedroom townhouse combines modern comfort with Mediterranean charm. Set within a private, gated development, the (...)
Townhouse Terraced
TSEA5156992
New
TSEA5156992 - El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 6   Baths: 6   M2: 572   Lot Size: 1,114   Area: Mijas and Mijas Costa   Region: Andalucía   
Newly built villa in the urbanization El Faro, Mijas Costa, only 200 metres from the beach. The property consists of three levels connected by stairs and lift, which are distributed as follows: main (...)
Villa Detached
TSEA5156986
New
TSEA5156986 - Higueron, Costa Del Sol
Beds: 2   Baths: 2   M2: 83   Region: Andalucía   
Med One, Higuerón West – Luxury 2-Bedroom Apartment with Panoramic Sea Views Located within the prestigious Med One complex in Higuerón West, this elegant two-bedroom, two-bathroom apartment (...)
Apartment Middle Floor
TSEA5156980
New
TSEA5156980 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 3   Baths: 2   M2: 103   Area: Fuengirola   Region: Andalucía   
Stunning 3-Bedroom Penthouse with Private Pool, Panoramic Views & Luxury Outdoor Living Experience elevated coastal living in this one-of-a-kind penthouse, perfectly positioned just moments from (...)
Apartment Penthouse
TSEA5156974
New
TSEA5156974 - La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4   Baths: 4   M2: 340   Lot Size: 715   Area: Mijas and Mijas Costa   Region: Andalucía   
New Development: Prices from 1,580,000 € to 1,580,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 340.00 m2 - 340.00 m2] Welcome to this project, a home where elegance meets everyday ease — a (...)
Villa Detached
TSEA5156938
New
TSEA5156938 - La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 1   M2: 55   Area: Mijas and Mijas Costa   Region: Andalucía   
Modern 2-Bedroom Apartment in the Heart of La Cala de Mijas – Steps from the Beach ✨ Discover your ideal coastal home with this beautifully presented 2 bed, 1 bath apartment located just a few (...)
Apartment Ground Floor
TSEA5156926
New
TSEA5156926 - Marbella, Costa Del Sol, Marbella
Beds: 3   Baths: 2   M2: 162   Area: Marbella   Region: Andalucía   
162 m² beachfront penthouse with terrace and panoramic views – Bajadilla Beach, Marbella This exclusive 162 m² penthouse is located on the fifth floor of the renowned La Zambomba Building, (...)
Apartment Penthouse
TSEA5156914
New
TSEA5156914 - Marbella, Costa Del Sol, Marbella
Beds: 2   Baths: 1   M2: 52   Area: Marbella   Region: Andalucía   
OPPORTUNITY IN MARBELLA – UNBEATABLE PRICE Fantastic property in Marbella, next to the bus station and a few minutes from the centre, surrounded by all kinds of services. The apartment, with great (...)
Apartment Middle Floor
TSEA5156911
New
TSEA5156911 - Casares Playa, Costa Del Sol, Casares
Beds: 2   Baths: 2   M2: 120   Lot Size: 25   Area: Casares   Region: Andalucía   
Fantastic ground floor apartment with large private garden in Casares Costa Wonderful corner property with golf views and partial sea views, located in one of the most privileged areas of the Costa (...)
Apartment Ground Floor
TSEA5156815
New
TSEA5156815 - Málaga, Costa Del Sol, Malaga
Beds: 2   Baths: 2   M2: 81   Area: Malaga   Region: Andalucía   
Situated on the fourth floor of a classic building, this exceptional penthouse apartment in the heart of Málaga's Centro Histórico presents a unique opportunity. The property currently offers a (...)
Apartment Penthouse
TSEA5156797
New
TSEA5156797 - Cabopino, Costa Del Sol, Marbella East
Beds: 3   Baths: 2   M2: 175   Area: Marbella East   Region: Andalucía   
Elegant South-Facing Duplex with Private Pool in Artola Alta Tucked within an exclusive gated community in Artola Alta, this sophisticated south-facing duplex blends modern luxury with the (...)
 Apartment
TSEA5156527
New
TSEA5156527 - Benahavís, Costa Del Sol, Benahavis
Beds: 3   Baths: 3   M2: 662   Lot Size: 191   Area: Benahavis   Region: Andalucía   
Modern ground floor 3-bedroom apartment is offered for sale in a new gated resort-style development situated in idyllic countryside of Benahavís, behind the Costa del Sol beaches. Nestled amidst (...)
Apartment Ground Floor
TSEA5156455
New
TSEA5156455 - The Golden Mile, Costa Del Sol, Marbella East
Beds: 6   Baths: 6   M2: 1,534   Lot Size: 2,210   Area: Marbella East   Region: Andalucía   
This exceptional villa is the epitome of ultra-luxury living, offering not only the highest standards of elegance and comfort but also unmatched security. Nestled in one of Marbella's most (...)
Villa Detached
TSEA5156416
New
TSEA5156416 - Benahavís, Costa Del Sol, Benahavis
Beds: 3   Baths: 3   M2: 269   Area: Benahavis   Region: Andalucía   
A contemporary duplex for sale in the exclusive Las Colinas de Marbella community in Benahavís, offering three bedrooms and three bathroom. s. Designed with both style and function in mind, this (...)
 Apartment
TSEA5156380
New
TSEA5156380 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 143   Lot Size: 500   Area: Mijas and Mijas Costa   Region: Andalucía   
Discover this charming Mediterranean villa, perfectly positioned on a sought-after urbanisation just minutes from the picturesque village of Mijas Pueblo and the coast. Combining traditional style (...)
Villa Detached