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 281 - 300 of 7581
Results 281 - 300 of 7581
TSEA5151637
New
TSEA5151637 - San Roque, Costa Del Sol, San Roque
Beds: 3   Baths: 3   M2: 175   Area: San Roque   Region: Andalucía   
Townhouse in La Pólvora (San Roque, Costa del Sol) In a quiet residential area of ​​San Roque, well connected and with all amenities close at hand, lies this spacious townhouse, ideal for (...)
Townhouse Terraced
TSEA5151628
New
TSEA5151628 - Benahavís, Costa Del Sol, Benahavis
Beds: 3   Baths: 2   M2: 199   Area: Benahavis   Region: Andalucía   
Luxurious Ground-Floor Apartment in Capanes del Golf – Resort Living within El Higueral Golf course close to Marbella, Benahavis & Estepona Discover this very spacious apartment in Capanes del (...)
Apartment Ground Floor
TSEA5151490
New
TSEA5151490 - Entrerrios, Costa Del Sol
Beds: 2   Baths: 1   M2: 96   Lot Size: 11,576   Region: Andalucía   
Charming country property in Entrerríos, ideal for those seeking peace, nature, and good access. With an irrigated plot of 11,576 m² and three water points, this property offers multiple (...)
Villa Finca
TSEA5151160
New
TSEA5151160 - Marbesa, Costa Del Sol, Marbella East
Beds: 4   Baths: 3   M2: 295   Lot Size: 630   Area: Marbella East   Region: Andalucía   
This fully renovated villa is located in the sought-after residential area of Marbesa, Marbella East. Offering both privacy and convenience, the property is just minutes away from the beach, Marbella (...)
Villa Detached
TSEA5151052
New
TSEA5151052 - Estepona, Costa Del Sol, Estepona
Beds: 1   Baths: 1   M2: 60   Area: Estepona   Region: Andalucía   
New Development: Prices from 325,000 € to 995,000 €. [Beds: 1 - 3] [Baths: 1 - 2] [Built size: 60.00 m2 - 147.00 m2] This is an exclusive residential complex in the Las Mesas area, combining (...)
Apartment Ground Floor
TSEA5151043
New
TSEA5151043 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 211   Area: Mijas and Mijas Costa   Region: Andalucía   
Are you dreaming of a spacious home in peaceful and beautiful surroundings – close to both the coast and the mountains? Then this property is perfect for you. 3 bright bedrooms 2 bathrooms Large (...)
Townhouse Terraced
TSEA5150992
New
TSEA5150992 - Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2   Baths: 1   M2: 96   Area: Marbella East   Region: Andalucía   
Apartment for sale in La Reserva de Marbella, Marbella with 2 bedrooms, 1 bathroom and with orientation south, with communal swimming pool and communal garden. Regarding property dimensions, it has (...)
Apartment Middle Floor
TSEA5150977
New
TSEA5150977 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 1   Baths: 1   M2: 68   Area: Benalmadena   Region: Andalucía   
Just a two-minute walk from the beach, this home combines a prime location with comfort. Surrounded by shops, restaurants, and all kinds of services, it's an ideal place to live year-round or to (...)
Apartment Middle Floor
TSEA5150956
New
TSEA5150956 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 1   Baths: 1   M2: 56   Area: Benalmadena   Region: Andalucía   
APARTMENT IN BENALMÁDENA COSTA We present this exclusive, newly renovated 56 m² apartment, located in the well-known building in Arroyo de la Miel, one of the most sought-after areas of (...)
Apartment Middle Floor
TSEA5150953
New
TSEA5150953 - Marbella, Costa Del Sol, Marbella
Beds: 1   Baths: 1   M2: 58   Area: Marbella   Region: Andalucía   
Elegant 1-Bedroom Home in "Golden Banus" – Steps from Puerto Banús This inviting apartment is located in the sought-after Golden Banus development, offering the perfect mix of comfort (...)
Apartment Middle Floor
TSEA5150941
New
TSEA5150941 - Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 178   Area: Mijas and Mijas Costa   Region: Andalucía   
FANTASTIC PROPERTY IN A PRESTIGOUS LOCATION We are delighted to offer this lovely duplex town house in the very convenient location of Miraflores Resort. The property comprises:- Spacious lounge with (...)
Townhouse Terraced
TSEA5150938
New
TSEA5150938 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3   Baths: 2   M2: 123   Area: Marbella West   Region: Andalucía   
This apartment in Nueva Andalucía, in the La Campana area, is an excellent opportunity for those seeking comfort and a good location. The property has three bedrooms and two bathrooms, offering a (...)
Apartment Middle Floor
TSEA5150923
New
TSEA5150923 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6   Baths: 4   M2: 292   Lot Size: 432   Area: Marbella West   Region: Andalucía   
Rare Investment Opportunity – Nueva Andalucía Luxury Villa A bargain with panoramic views, 5 min from Puerto Banús This independent villa is a unique opportunity in Nueva Andalucía, one of (...)
Villa Detached
TSEA5150914
New
TSEA5150914 - Torremolinos, Costa Del Sol, Torremolinos
Beds: 4   Baths: 2   M2: 132   Area: Torremolinos   Region: Andalucía   
Charming semi-detached house of 228 m², ideal for comfortable family living and conducting business. Located in a convenient place, it combines privacy, spaciousness, and functionality. The (...)
Villa Semi Detached
TSEA5150911
New
TSEA5150911 - Marbella, Costa Del Sol, Marbella
Beds: 2   Baths: 2   M2: 82   Area: Marbella   Region: Andalucía   
This beautiful, fully exterior apartment stands out for its excellent location and natural brightness throughout. Located in a peaceful residential area of Marbella, it is just 400 meters from the (...)
Studio Middle Floor
TSEA5150899
New
TSEA5150899 - Benahavís, Costa Del Sol, Benahavis
Beds: 2   Baths: 2   M2: 140   Area: Benahavis   Region: Andalucía   
We would like to offer a list of selling points for our apartment. A top location in the village of 'Benahavis' with a stunning view from the terrace 3 minutes walk from the center of the village, (...)
Apartment Middle Floor
TSEA5150893
New
TSEA5150893 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 1   Baths: 1   M2: 49   Area: Fuengirola   Region: Andalucía   
Breathe and enjoy life at your own rhythm. This brand new apartment development offers the space to be yourself, to focus on what matters, and to reconnect with a lifestyle that feels effort-less. (...)
Apartment Ground Floor
TSEA5150860
New
TSEA5150860 - Atalaya, Costa Del Sol, Estepona
Beds: 4   Baths: 3   M2: 212   Area: Estepona   Region: Andalucía   
Spacious 4-Bedroom Townhouse in Sought-After Atalaya Located in the highly desirable residential area of Atalaya—perfectly positioned between Estepona's charming old town and glamorous (...)
Townhouse Terraced
TSEA5150857
New
TSEA5150857 - Arriate, Costa Del Sol, Ronda
Beds: 6   Baths: 3   M2: 220   Lot Size: 594   Area: Ronda   Region: Andalucía   
-Newly built property with 3 apartments in Arriate, ready to move into and with a valid tourist license. In the quiet family development of Los Arroyos de Arriate, this unique, recently built (...)
Villa Detached
TSEA5150836
New
TSEA5150836 - Manilva, Costa Del Sol, Manilva
Beds: 3   Baths: 2   M2: 81   Area: Manilva   Region: Andalucía   
Investment Apartment for Sale Become the owner of a stunning penthouse duplex apartment – perfect as your own holiday home or as a smart investment. Highlights: Just a short walk to the (...)
Apartment Penthouse Duplex