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,42,43,44,45)
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`.`featured` IN ('1') AND p.approved = 1 AND pm.cat_id IN (31,42,43,44,45)
GROUP BY p.id
ORDER BY RAND()
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,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 261 - 280 of 6631
€1,312,700
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² (...)
€1,090,000
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 (...)
€550,000
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 (...)
€395,000
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 (...)
€525,000
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 (...)
€4,975,000
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 (...)
€1,875,000
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, (...)
€335,000
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 (...)
€950,000
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 (...)
€390,000
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 (...)
€1,750,000
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 (...)
€1,399,000
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 (...)
€400,000
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 (...)
€380,000
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 (...)
€423,000
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 (...)
€495,000
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 (...)
€551,460
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 (...)
€695,000
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 (...)
€795,000
TSEA5150464
- Higueron, Costa Del Sol
Beds: 3 Baths: 2 M2: 118 Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Region: Andalucía
Welcome to this newly built 3-bedroom corner apartment on the second floor of the sought-after Lomas 2 – completed in 2025 and ready for immediate move-in. Here, spacious interiors, fantastic (...)
€872,000
TSEA5150455
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 248 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 248 Area: Estepona Region: Andalucía
New Development: Prices from 872,000 € to 1,075,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 248.00 m2 - 259.00 m2]
An exclusive residential complex: 36 apartments with 2 and 3 bedrooms, and (...)
Current Featured Properties
€6,000,000
PALATIAL REFORMED VILLA, WALK TO THE BEACHES
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 8 Baths: 8 M2: 900 Area: San Pedro Region: Andalucía
Beds: 8 Baths: 8 M2: 900 Area: San Pedro Region: Andalucía
PALATIAL REFORMED VILLA, WALK TO THE BEACHES!!!
A totally reformed substantial palatial Arabian styled villa which offers 8 BEDROOM SUITES which incorporate 2 self-contained suites. The villa has (...)
€403,000
TSEA4686217
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 105 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Casares Region: Andalucía
Located in the area of Doña Julia Golf, this new development emerges as an oasis of elegance and tranquility on the Costa del Sol, much more than a simple residential area. A refuge for lovers (...)
€420,000
TSEA5034892
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
The exclusive residential complex invites you to a modern lifestyle infused with traditional Andalusian charm, all within a community designed for those who appreciate quality and natural beauty. At (...)
