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
Results 301 - 320 of 7581
TSEA5150827
- Periana, Costa Del Sol East
Beds: 7 Baths: 9 M2: 1,133 Lot Size: 140,000 Region: Andalucía
Beds: 7 Baths: 9 M2: 1,133 Lot Size: 140,000 Region: Andalucía
HIGHLIGHTS
Casa Rosa is far more than a home: it is a captivating theatrical backdrop infused with Tuscan charm, designed to host grand family celebrations or to enjoy everyday family life. This (...)
TSEA5150824
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 6 M2: 485 Lot Size: 1,065 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 6 M2: 485 Lot Size: 1,065 Area: Marbella West Region: Andalucía
HIGHLIGHTS
Located in the prestigious Golf Valley of Nueva Andalucía, Centauro 15 is an exceptional villa that blends contemporary architecture with Balinese boho inspiration and lush tropical (...)
TSEA5150821
- Málaga Centro, Costa Del Sol, Malaga
Beds: 5 Baths: 4 M2: 271 Lot Size: 285 Area: Malaga Region: Andalucía
Beds: 5 Baths: 4 M2: 271 Lot Size: 285 Area: Malaga Region: Andalucía
HIGHLIGHTS
Ideally located to make the most of Málaga's coastal lifestyle, this semi-detached villa offers a rare combination of Andalusian charm and significant renovation potential. With 271 m² (...)
TSEA5150803
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
HIGHLIGHTS
Exquisite apartment located in the prestigious Marbella Club Hills development. A 5-star residence set within a privileged natural environment, in collaboration with the iconic Marbella (...)
TSEA5150794
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
HIGHLIGHTS
This apartment offers a unique investment opportunity in one of the most sought-after areas of Marbella. With its proximity to Puerto Banús and the beach, this property has enormous (...)
TSEA5150782
- Sierrezuela, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse with Panoramic Views of Fuengirola and the Mediterranean
This spacious penthouse in Sierrezuela offers one of the most spectacular terraces you can find – a 50 m² outdoor space with sun (...)
TSEA5150773
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Modern and spacious 3-bedroom apartment in exclusive Belaire, Estepona!
Welcome to thiS 3-bedroom apartment located in the sought-after Belaire community in Bel-Air, Estepona. With its modern (...)
TSEA5150767
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 8 M2: 475 Lot Size: 815 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 8 M2: 475 Lot Size: 815 Area: Marbella West Region: Andalucía
A Refined Retreat in Aloha / Las Brisas, Marbella
Welcome to a beautifully renovated luxury villa located in the prestigious Aloha / Las Brisas area of Marbella. This elegant home blends timeless (...)
TSEA5150743
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 4 M2: 316 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 4 M2: 316 Area: La Duquesa Region: Andalucía
Unique Penthouse in Puerto de la Duquesa with 360° Views
• A truly unique property on the market: a 3-bedroom, 4-bathroom penthouse with a wrap-around panoramic terra
360° views of the sea, (...)
TSEA5150740
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
This charming apartment, located on the first and top floor, perfectly combines comfort, style, and an unbeatable location. Fully renovated and tastefully furnished, it offers modern, functional (...)
TSEA5150737
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 73 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 73 Area: Marbella East Region: Andalucía
This unique penthouse is located in a renowned and well-established beachfront urbanization, with direct access to one of the best beaches on the Costa del Sol and its promenade.
As soon as you step (...)
TSEA5150722
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Magnificent apartment with stunning views in Mijas Golf.
Discover this magnificent apartment located in a prime location for golf lovers, where tranquility and light blend perfectly.
This property (...)
TSEA5150701
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 5 M2: 403 Lot Size: 1,250 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 5 M2: 403 Lot Size: 1,250 Area: Mijas and Mijas Costa Region: Andalucía
This large villa (400 m2) is located about 800 meters from the casino and beach, next to the Torrequebrada golf course (Benalmádena Costa).
On the main floor you will find a large living room with (...)
TSEA5150578
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 3 M2: 159 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 3 M2: 159 Area: Marbella West Region: Andalucía
In the heart of Puerto Banús Marina, this modern apartment with sea views is now available for sale. With its two-bedroom, two-bathroom en-suite (plus one guist toilet) it is prime positioned (...)
TSEA5150557
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 91 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Benahavis Region: Andalucía
This charming ground floor apartment is located in Benahavís, one of the most exclusive areas on the Costa del Sol, renowned for its peaceful surroundings, stunning landscapes, and proximity to (...)
TSEA5150536
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Stunning New Golden Mile middle floor apartment with panoramic views. This amazing south facing property offers La Concha views from the kitchen and partial sea views from the terrace.
The property (...)
TSEA5150527
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 99 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 99 Area: Casares Region: Andalucía
New Development: Prices from 423,000 € to 721,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 99.00 m2 - 116.00 m2]
Set in an exceptional location between the highly sought-after towns of (...)
TSEA5150500
- El Gastor, Costa de la Luz
Beds: 3 Baths: 2 M2: 225 Region: Andalucía
Beds: 3 Baths: 2 M2: 225 Region: Andalucía
Rustic Estate Facing the Zahara de la Sierra Reservoir – Ready to Move In
Overview
Experience Andalusian charm and absolute tranquility in this exclusive rustic estate, surrounded by nature and (...)
TSEA5150488
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
OPPORTUNITY: Beachfront ground-floor apartment measuring 75 m² + 55 m² of private garden, with 2 large bedrooms, 2 bathrooms, a kitchen with a breakfast bar, and a spacious living-dining room with (...)
TSEA5150473
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 101 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Marbella East Region: Andalucía
Elegant, fully renovated apartment in the exclusive Terrazas de las Lomas urbanization, located in the heart of the Golden Mile, just minutes from Marbella and Puerto Banús.
This property features (...)
