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 (42,68,69,70)
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 (42,68,69,70)
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 (42,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 361 - 380 of 2740 €935,000
TSEA5125999
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 458 Lot Size: 246 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 458 Lot Size: 246 Area: Benalmadena Region: Andalucía
Experience Mediterranean living at its finest in this exceptional 4-bedroom, 5-bathroom luxury detached house located in the prestigious BigBlue residential complex in Torremuelle, Benalmádena. (...)
€1,418,000
TSEA5125873
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 180 Lot Size: 638 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Lot Size: 638 Area: San Pedro Region: Andalucía
Exclusive villa for sale in San Pedro Alcántara
Elegance, comfort, and privacy come together in this spectacular villa located in one of the most desirable areas of the Costa del Sol. With 220 m² (...)
€78,900
TSEA5125402
- Periana, Costa Del Sol East
Beds: 4 Baths: 2 M2: 81 Region: Andalucía
Beds: 4 Baths: 2 M2: 81 Region: Andalucía
Attention investors and project lovers!
Townhouse for sale to finish renovating in Periana, Málaga. A property with incredible potential and, most importantly, already done.
✅ 3 FLOORS + PRIVATE (...)
€15,000,000
TSEA5125372
- Estepona, Costa Del Sol, Estepona
Beds: 9 Baths: 6 M2: 1,098 Lot Size: 7,962 Area: Estepona Region: Andalucía
Beds: 9 Baths: 6 M2: 1,098 Lot Size: 7,962 Area: Estepona Region: Andalucía
Situated on an extraordinary frontline beach plot of over 7,600 m², this magnificent estate offers a rare opportunity to own one of the largest and most private properties on the New Golden Mile. (...)
€350,000
TSEA5125291
- Alcaucín, Costa Del Sol East
Beds: 10 Baths: 4 M2: 274 Lot Size: 1,277 Region: Andalucía
Beds: 10 Baths: 4 M2: 274 Lot Size: 1,277 Region: Andalucía
We present you this fantastic investment opportunity near Alcaucin. It is perfect to open a charming B&B or simply rent out the four residential units, either on a long-term basis or for (...)
€1,395,000
TSEA5125186
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 196 Lot Size: 533 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 196 Lot Size: 533 Area: Manilva Region: Andalucía
FANTASTIC OPPORTUNITY ON A GREAT LOCATION !!!
Brand new luxurious built villa in La Duquesa Valley , Manilva . Just a footstep to the beautiful beaches and the port of La Duquesa.
This property (...)
€649,000
TSEA5125180
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M2: 185 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 4 M2: 185 Area: San Pedro Region: Andalucía
Discover this charming three-storey townhouse, offering the perfect balance of comfort, style, and functionality, nestled within a peaceful and well-maintained residential community — ideal for (...)
€750,000
TSEA5125129
- Torrox Costa, Costa Del Sol East
Beds: 3 Baths: 2 M2: 145 Lot Size: 540 Region: Andalucía
Beds: 3 Baths: 2 M2: 145 Lot Size: 540 Region: Andalucía
Elegant Sea-View Villa with Private Pool in Torrox Costa
This stylish single-level villa with basement space is set on a 540 m² plot and offers 145 m² of beautifully designed living space. The (...)
€1,260,000
TSEA5125072
- Pedregalejo, Costa Del Sol
Beds: 5 Baths: 2 M2: 196 Region: Andalucía
Beds: 5 Baths: 2 M2: 196 Region: Andalucía
Are you looking for a property to fully renovate in a privileged setting? This is a rare opportunity. Located right on the beachfront promenade of Pedregalejo, in Málaga East, this charming (...)
€555,000
TSEA5125012
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 251 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 251 Area: Fuengirola Region: Andalucía
In the heart of the quiet and listed area of Los Pacos, in Fuengirola, you will find this unique one-storey villa, where serenity and comfort combine perfectly. More than a house, it is a place to (...)
€499,000
TSEA5125000
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 132 Lot Size: 30 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 132 Lot Size: 30 Area: Marbella East Region: Andalucía
STUNNING TOWNHOUSE in Cabopino/Artola Alta!
This beautiful well maintained townhouse over 3 levels is located next to the Cabopino Golf Marbella golf course and when entering it gives you the (...)
€188,000
TSEA5124985
- Castellar de la Frontera, Costa de la Luz
Beds: 3 Baths: 1 M2: 91 Region: Andalucía
Beds: 3 Baths: 1 M2: 91 Region: Andalucía
A BEAUTIFUL HOUSE FOR SALE IN CASTELLAR DE LA FRONTERA. Castellar de la Frontera is a beautiful village located in the campo of Gibraltar, surrounded by nature with the charm of the White Villages (...)
€495,000
TSEA5124307
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 2 M2: 204 Lot Size: 249 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 2 M2: 204 Lot Size: 249 Area: Benalmadena Region: Andalucía
SEMI-DETACHED VILLA FOR SALE IN BENALMÁDENA!
We offer this spacious and bright semi-detached villa for sale in Benalmádena Pueblo, in the province of Málaga. Nestled on a 249 m² plot, it is (...)
€1,299,000
TSEA5124235
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 242 Lot Size: 902 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 242 Lot Size: 902 Area: Marbella West Region: Andalucía
This villa for sale in the prestigious Los Naranjos Hill Club, Marbella, presents an excellent investment opportunity for those looking to undertake a renovation project. Located in a highly (...)
€4,000,000
TSEA5124232
- Churriana, Costa Del Sol, Malaga
Beds: 5 Baths: 7 M2: 361 Lot Size: 1,710 Area: Malaga Region: Andalucía
Beds: 5 Baths: 7 M2: 361 Lot Size: 1,710 Area: Malaga Region: Andalucía
Casa Lux is a striking modern villa that embodies contemporary sophistication and luxury living, ideally located in the prestigious El Olivar neighborhood of Churriana, Malaga. Offered for sale at 4 (...)
€870,000
TSEA5124097
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 4 M2: 113 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 4 M2: 113 Area: Nerja and Malaga East Region: Andalucía
New Development in Fuente del Badén, Nerja
Prices from €870,000 to €990,000
[Beds: 3] [Baths: 4] [Built size: 112 m²]
We're pleased to introduce a fantastic new development in the sought-after (...)
€995,000
TSEA5124043
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 3 M2: 286 Lot Size: 545 Area: Estepona Region: Andalucía
Beds: 6 Baths: 3 M2: 286 Lot Size: 545 Area: Estepona Region: Andalucía
Spacious 6-Bedroom Villa with Sea & Mountain Views in Estepona – €995,000
Located in the peaceful residential area of La Gaspara in Estepona, this charming villa on Calle Tierra 50 offers a (...)
€1,285,000
TSEA5124019
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 4 Baths: 4 M2: 249 Lot Size: 380 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 4 M2: 249 Lot Size: 380 Area: Fuengirola Region: Andalucía
Exclusive Villa with Panoramic Views in Torreblanca!
Discover this stunning, recently renovated villa in the sought-after area of Torreblanca (Fuengirola), originally built in 2003 and completely (...)
€650,000
TSEA5123890
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 210 Lot Size: 25 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 210 Lot Size: 25 Area: Marbella West Region: Andalucía
Townhouse Nueva Andalucía
Gated community – Condes de Iza, Nueva Andalucía
Spacious and bright 4-bedroom, 3-bathroom townhouse, ideal for families or professionals seeking comfort, security, (...)
€3,950,000
TSEA5123887
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 5 M2: 478 Lot Size: 1,016 Area: Marbella Region: Andalucía
Beds: 5 Baths: 5 M2: 478 Lot Size: 1,016 Area: Marbella Region: Andalucía
REDUCED TO 3.950.000 €
Discover the epitome of luxury living with this stunning semi-detached villa, perfectly situated by the beach in Marbella. Boasting five spacious bedrooms and 5.5 bathrooms, (...)
Current Featured Properties
€3,485,000
TSEA5156128
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 573 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 573 Area: Benahavis Region: Andalucía
A top quality, new built contemporaty villa (2024), located in the sought after residential area of La Alqueria, Benahavís. South to west facing with views to mountains and some seaviews from the (...)
€4,500,000
TSEA4780684
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 370 Lot Size: 884 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 370 Lot Size: 884 Area: Estepona Region: Andalucía
AWARD WINNING DESIGN BRINGS YOU BEACHFRONT PERFECTION. The exclusive urbanisation is a unique village development on the famous New Golden Mile, only 7 minutes from Puerto Banus. All properties in (...)
€730,000
TSEA4890979
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 182 Lot Size: 605 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 182 Lot Size: 605 Area: Manilva Region: Andalucía
DETACHED VILLA WITH POOL 500m FROM THE BEACH!!!
If there is better value than this on Costa del Sol, we'd like to know about it! In a STYLISH, CONTEMPORARY DESIGN (very sought after!), this villa (...)
