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 241 - 260 of 7581
Results 241 - 260 of 7581
TSEA5152669
New
TSEA5152669 - La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 130   Area: Mijas and Mijas Costa   Region: Andalucía   
FANTASTIC APARTMENT WITHIN WALKING DISTANCE OF LA CALA DE MIJAS! This beautiful apartment in Jardinana Lotus is the ideal (holiday) apartment! The apartment features 3 bedrooms, 2 bathrooms, a (...)
Apartment Ground Floor
TSEA5152636
New
TSEA5152636 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 5   Baths: 4   M2: 187   Lot Size: 1   Area: Fuengirola   Region: Andalucía   
Discover this spacious 5-bedroom, 4-bathroom townhouse in Fuengirola, located right next to Higuerón and designed for those who want to enjoy the Mediterranean lifestyle to the fullest. This home is (...)
Townhouse Terraced
TSEA5152627
New
TSEA5152627 - Estepona, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 90   Area: Estepona   Region: Andalucía   
Beautiful 90 m2 apartment with 2 bedrooms and 2 bathrooms, a terrace with garden views, and direct access to the beach in an exclusive Estepona development. This ground-floor apartment with two (...)
Apartment Ground Floor
TSEA5152303
New
TSEA5152303 - Marbella, Costa Del Sol, Marbella
Beds: 2   Baths: 1   M2: 85   Area: Marbella   Region: Andalucía   
Newly refurbished 2-bedroom apartment in the heart of Marbella Centre. This property features one en-suite bedroom and a smaller second bedroom, ideally located close to all amenities and just a (...)
Apartment Middle Floor
TSEA5152285
New
TSEA5152285 - Hacienda del Sol, Costa Del Sol, Estepona
Beds: 2   Baths: 3   M2: 152   Area: Estepona   Region: Andalucía   
Two bedroom ground floor apartment in the luxurious urbanisation Hacienda del Sol. Layout: - living room, dining room - kitchen - 2 bedrooms, 1 with bathroom en suite - 2 bathrooms On the (...)
Apartment Ground Floor
TSEA5152282
New
TSEA5152282 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2   Baths: 2   M2: 178   Area: Marbella West   Region: Andalucía   
Discover this charming 2-bedroom, 2-bathroom corner apartment, perfectly located within walking distance to both the beach and a selection of the area's most popular restaurants. Surrounded by (...)
Apartment Middle Floor
TSEA5152213
New
TSEA5152213 - Coín, Costa Del Sol, Coin
Beds: 5   Baths: 2   M2: 159   Lot Size: 78   Area: Coin   Region: Andalucía   
Unique opportunity in the heart of Coín! This spacious 3-story townhouse combines Andalusian style with practicality. Featuring 5 bedrooms and 2 full bathrooms—one with a shower and the other with (...)
Townhouse Terraced
TSEA5152210
New
TSEA5152210 - Marbella, Costa Del Sol, Marbella
Beds: 3   Baths: 2   M2: 76   Area: Marbella   Region: Andalucía   
Here's a charming apartment located in the Golden Beach Urbanization, just 50 meters from the beach. This community features fantastic shared areas, including two large swimming pools surrounded by a (...)
Apartment Middle Floor
TSEA5152207
New
TSEA5152207 - Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 3   M2: 140   Area: Mijas and Mijas Costa   Region: Andalucía   
This is an opportunity not to be missed: a spectacular, fully furnished property located in a secure gated community with all kinds of services and infrastructure nearby. The property is just a few (...)
Apartment Penthouse Duplex
TSEA5152159
New
TSEA5152159 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6   Baths: 6   M2: 346   Lot Size: 534   Area: Marbella West   Region: Andalucía   
Modern beautiful newly renovated 3 floor villa located in the heart of Nueva Andalucia very close to famous padelclub Real Club Padel. The villa has a private pool beautiful garden and parking. (...)
Villa Detached
TSEA5152114
New
TSEA5152114 - Casares Playa, Costa Del Sol, Casares
Beds: 3   Baths: 2   M2: 130   Area: Casares   Region: Andalucía   
Exquisite Penthouse in Majestic, Casares del Sol – Casares Golf: Panoramic Sea and Mountain Views, Just 5 Minutes Walk to the Beach! Elevate your lifestyle with this stunning penthouse in the (...)
Apartment Penthouse
TSEA5152111
New
TSEA5152111 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 2   Baths: 1   M2: 77   Area: Benalmadena   Region: Andalucía   
APARTMENT CLOSE TO PALOMA PARK, BENALMADENA: Nice 2 bedrooms, 1 bathroom apartment ideally located just a short stroll from the lush green haven of Parque de la Paloma and the vibrant heart of Arroyo (...)
Apartment Middle Floor
TSEA5152096
New
TSEA5152096 - Casares, Costa Del Sol, Casares
Beds: 2   Baths: 2   M2: 61   Area: Casares   Region: Andalucía   
Discover this modern Mediterranean 2 bedroom apartment in brand-new gated community in Casares. Ideally located just minutes from the prestigious Finca Cortesín Hotel & Golf Resort and a short (...)
Apartment Ground Floor
TSEA5152084
New
TSEA5152084 - Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 110   Area: Mijas and Mijas Costa   Region: Andalucía   
Exclusive Listings: Two Duplexes in Riviera, Costa del Sol We are offering two attractive duplexes for sale in Riviera, each with: - 2 bedrooms - 2 bathrooms - Spacious terraces with exceptional (...)
 Apartment
TSEA5152081
New
TSEA5152081 - Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3   Baths: 1   M2: 220   Lot Size: 113   Area: Nerja and Malaga East   Region: Andalucía   
In El Condal, Nerja, this spacious townhouse with a private pool offers comfortable and practical living, with well-planned spaces and several areas to enjoy both indoors and outdoors. The property (...)
Townhouse Semi Detached
TSEA5152069
New
TSEA5152069 - Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 111   Area: Mijas and Mijas Costa   Region: Andalucía   
Exclusive Listings: Two Duplexes in Riviera, Costa del Sol We are offering two attractive duplexes for sale in Riviera, each with: - 2 bedrooms - 2 bathrooms - Spacious terraces with exceptional (...)
 Apartment
TSEA5152066
New
TSEA5152066 - Estepona, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 150   Area: Estepona   Region: Andalucía   
In the heart of Estepona's New Golden Mile, where the Costa del Sol shows off its most sophisticated side, lies a unique opportunity for those looking to live or invest on the seafront. The Mar Azul (...)
Apartment Middle Floor
TSEA5152036
New
TSEA5152036 - San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4   Baths: 3   M2: 382   Lot Size: 609   Area: San Pedro   Region: Andalucía   
Welcome to this charming beachside villa with private pool in San Pedro! Just 300 meters from the golden sands of the Mediterranean, this stunning 4-bedroom villa offers the perfect blend of coastal (...)
Villa Detached
TSEA5152033
New
TSEA5152033 - Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 85   Area: Mijas and Mijas Costa   Region: Andalucía   
Stunning 2-Bedroom Beachfront Apartment in Sitio de Calahonda. Discover coastal living at its finest with this beautiful 2-bedroom, 2-bathroom modern apartment located in an the sought-after (...)
Apartment Middle Floor
TSEA5152030
New
TSEA5152030 - Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 6   Baths: 4   M2: 418   Lot Size: 4,905   Area: Alhaurin el Grande   Region: Andalucía   
Exclusively with us! Attention investors and large families! This could be your opportunity! This is a very large country house with a built area of ​​368m2, a 50m2 pool, and a 4905m2 plot (...)
Villa Detached