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 1841 - 1860 of 2740 €1,695,000
TSEA4848964
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 6 Baths: 5 M2: 467 Lot Size: 1,564 Area: Benalmadena Region: Andalucía
Beds: 6 Baths: 5 M2: 467 Lot Size: 1,564 Area: Benalmadena Region: Andalucía
Exceptional Villa for Sale in La Capellania, Benalmádena – Panoramic Sea Views & Investment Opportunity
This stunning villa offers a rare combination of luxury, space, and investment (...)
€830,000
TSEA4710976
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 154 Lot Size: 45 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 154 Lot Size: 45 Area: Marbella East Region: Andalucía
New Development: Prices from 830,000 € to 830,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 154.00 m2 - 154.00 m2]
A new development of 52 townhouses, with 3 and 4 bedrooms on two levels, (...)
€7,900,000
TSEA4764361
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 11 M2: 348 Lot Size: 814 Area: Marbella Region: Andalucía
Beds: 7 Baths: 11 M2: 348 Lot Size: 814 Area: Marbella Region: Andalucía
New Development: Prices from 7,900,000 € to 9,500,000 €. [Beds: 7 - 7] [Baths: 11 - 12] [Built size: 348.00 m2 - 388.00 m2]
Exclusive luxury villas in a urbanization, in the surroundings of (...)
€695,000
TSEA4847188
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 2 M2: 193 Lot Size: 1,036 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 2 M2: 193 Lot Size: 1,036 Area: Alhaurin el Grande Region: Andalucía
STUNNING VILLA
A must-see, detached villa, located in this exclusive and desirable golf urbanization. This stunning villa provides a desirable mix of being accessible and highly usable, is both (...)
€960,000
TSEA4846426
- Málaga, Costa Del Sol, Malaga
Beds: 6 Baths: 3 M2: 347 Area: Malaga Region: Andalucía
Beds: 6 Baths: 3 M2: 347 Area: Malaga Region: Andalucía
Unique opportunity in Malaga! Residential building for sale in one of the most exclusive areas of the city, next to El Limonar. This multifaceted property offers multiple use options: from private (...)
€1,795,000
TSEA4846132
- Marbesa, Costa Del Sol, Marbella East
Beds: 6 Baths: 5 M2: 397 Lot Size: 694 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 5 M2: 397 Lot Size: 694 Area: Marbella East Region: Andalucía
LOCATION LOCATION - BEACHSIDE VILLA MARBESA
For sale: A stunning, spacious, and sun-filled beachside villa in one of the most desirable areas of Marbella East! This impressive 405 m² property (...)
€585,000
TSEA4845850
- Algarrobo, Costa Del Sol East
Beds: 5 Baths: 3 M2: 186 Lot Size: 2,445 Region: Andalucía
Beds: 5 Baths: 3 M2: 186 Lot Size: 2,445 Region: Andalucía
Discover the epitome of Mediterranean living with this exclusive finca in Algarrobo, located on the stunning Costa del Sol. Nestled in complete privacy, this unique property offers breathtaking (...)
€3,200,000
TSEA4842025
- Los Flamingos, Costa Del Sol, Estepona
Beds: 4 Baths: 5 M2: 464 Lot Size: 1,769 Area: Estepona Region: Andalucía
Beds: 4 Baths: 5 M2: 464 Lot Size: 1,769 Area: Estepona Region: Andalucía
Located in the prestigious area of Los Flamingos, Benahavis, this luxury villa offers an unrivalled setting in the province of Malaga. With a modern and elegant architecture, the property stands out (...)
€2,630,000
TSEA4842022
- Los Flamingos, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 360 Lot Size: 1,769 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 360 Lot Size: 1,769 Area: Estepona Region: Andalucía
Located in the prestigious area of Los Flamingos, Benahavis, this luxury villa offers an unrivalled living experience on the Costa del Sol. Spanning 1,769m² of plot, the property stands out for its (...)
€10,500,000
TSEA4841641
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 548 Lot Size: 558 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 548 Lot Size: 558 Area: Marbella East Region: Andalucía
This exquisite and distinctive contemporary residence situated in Puente Romano has undergone a comprehensive renovation to meet the highest standards. Characterized by sleek, straight lines, this (...)
€725,000
TSEA4841461
- Campo Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 6 M2: 522 Lot Size: 1,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 6 M2: 522 Lot Size: 1,000 Area: Mijas and Mijas Costa Region: Andalucía
This stunning 7-bedroom villa in **Campo Mijas** offers spectacular views of both the city and the sea, and is surrounded by a charming natural setting that includes lush greenery, a garden, and a (...)
€2,990,000
TSEA4841407
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 6 M2: 647 Lot Size: 1,011 Area: Estepona Region: Andalucía
Beds: 6 Baths: 6 M2: 647 Lot Size: 1,011 Area: Estepona Region: Andalucía
Situated on a peaceful, tree-lined street in the prestigious area of Guadalmina Baja, this stunning 6-bedroom, 6-bathroom villa offers an unparalleled blend of colonial charm and modern luxury. (...)
€1,350,000
TSEA4840969
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 2 Baths: 3 M2: 204 Area: Marbella Region: Andalucía
Beds: 2 Baths: 3 M2: 204 Area: Marbella Region: Andalucía
This exceptional townhouse is located in a first-class luxury urbanisation, offering both tranquility and convenience, with all essential services just steps away.
The property features two spacious (...)
€258,000
TSEA4840831
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 162 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: La Duquesa Region: Andalucía
SQUATTED PROPERTY. OPPORTUNITY FOR INVESTORS.
The price of the property has been set considering that the property is being acquired by the buyer in an occupied state. Therefore, this price would not (...)
€1,950,000
TSEA4839979
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 538 Lot Size: 1,349 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 538 Lot Size: 1,349 Area: Mijas and Mijas Costa Region: Andalucía
This fabulous La Cala villa is available now....beautiful and key ready and coming with a huge 200m2 basement ready for it´s new owners to embellish.
Peace tranquility, luxury and (...)
€230,000
TSEA4839949
- Arenas, Costa Del Sol East
Beds: 4 Baths: 2 M2: 110 Lot Size: 5,077 Region: Andalucía
Beds: 4 Baths: 2 M2: 110 Lot Size: 5,077 Region: Andalucía
Charming Rural Property with Guest Accommodation & Garden Paradise in Arenas, Axarquía (Málaga)
Discover this beautifully maintained rural property on the edge of the picturesque village of (...)
€742,000
TSEA4839214
- Periana, Costa Del Sol East
Beds: 4 Baths: 4 M2: 580 Lot Size: 1,800 Region: Andalucía
Beds: 4 Baths: 4 M2: 580 Lot Size: 1,800 Region: Andalucía
For sale: an impressive villa in Periana with 580 square meters of built space on a 1,800 square meter plot, ideal for those seeking a spacious home with a range of amenities. The villa is spread (...)
€6,700,000
TSEA4839196
- El Candado, Costa Del Sol
Beds: 6 Baths: 7 M2: 553 Lot Size: 4,227 Region: Andalucía
Beds: 6 Baths: 7 M2: 553 Lot Size: 4,227 Region: Andalucía
This truly exceptional luxury villa, located in an exclusive area of the capital of Costa del Sol, has undergone a sensitive full and meticulous renovation that has managed to highlight the (...)
€2,450,000
TSEA4838737
- El Rosario, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 660 Lot Size: 1,060 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 660 Lot Size: 1,060 Area: Marbella East Region: Andalucía
Fabulous private villa with frontal sea views.
Located in one of the best areas of Marbella, El Rosario, just 5 minutes drive from the best beaches of Marbella East, where you will find the multitude (...)
€575,000
TSEA4838176
- Alora, Costa Del Sol, Älora
Beds: 5 Baths: 2 M2: 360 Lot Size: 5,000 Area: Älora Region: Andalucía
Beds: 5 Baths: 2 M2: 360 Lot Size: 5,000 Area: Älora Region: Andalucía
For sale very spacious house in the center of a neighborhood of Alora on 5000m2 of plot. It consists of on the ground floor of a living room, a separate kitchen, three bedrooms and 1 bathroom; on the (...)
Current Featured Properties
€370,500
TSEA4868902
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
YOU COULD NOT ASK FOR A BETTER LOCATION!!
Exclusive multi-family homes of 2 and 3 bedrooms located in the privileged surroundings of the Golden Mile of Estepona. The homes enjoy large terraces (...)
€1,795,000
TSEA5060815
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 430 Lot Size: 600 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 430 Lot Size: 600 Area: Estepona Region: Andalucía
Key-ready! Spectacular brand new detached villa on the doorstep of Estepona. Built over 2 floors plus a basement and set within a 600 sqm plot. Just finished to a very high standard, it offers 4 (...)
€1,150,000
TSEA4366900
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 330 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 330 Area: Mijas and Mijas Costa Region: Andalucía
STYLISH DESIGN, CLOSE TO THE MIJAS COAST.
An exclusive development of 15 detached Villas, 8 left, built by a leading design company specialising in SOUGHT AFTER CONTEMPORARY STYLING. The large (...)
