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 (70,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 (70,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 (70,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 521 - 540 of 3305 €1,495,000
TSEA5115499
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 261 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 261 Area: San Pedro Region: Andalucía
Spacious, bright, and just moments from the shore —a beautifully updated family home where beachside living meets everyday ease.
Just 350 metres from the sea in one of San Pedroʼs most (...)
€560,000
TSEA5115493
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 288 Lot Size: 300 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 288 Lot Size: 300 Area: Mijas and Mijas Costa Region: Andalucía
PRICE REDUCED! Stunning Contemporary Townhouse in Prime Monte Alto, La Cala Golf - Now €560,000!
Discover exceptional value in the highly sought-after Monte Alto urbanization, nestled within the (...)
€1,250,000
TSEA5115490
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
NEW DEVELOPMENT – Elegance and Exclusivity on the Costa del Sol!
Discover this new luxury project, a prestigious complex of 14 independent villas located in an exceptional setting in Estepona, (...)
€1,650,000
TSEA5115445
- Torre del Mar, Costa Del Sol East
Beds: 9 Baths: 6 M2: 610 Lot Size: 805 Region: Andalucía
Beds: 9 Baths: 6 M2: 610 Lot Size: 805 Region: Andalucía
Exquisite Andalusian Villa with Panoramic Sea Views & Guest Apartment – Torre del Mar
Nestled in the most exclusive urbanización of Torre del Mar, this beautiful Andalusian-style villa offers (...)
€1,950,000
TSEA5115433
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 380 Lot Size: 1,123 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 380 Lot Size: 1,123 Area: Estepona Region: Andalucía
Beachside villa to renovate on The New Golden Mile of Estepona Costa del Sol
Bargain charming rustic villa only meters walking distance to the beach in Paraiso Barronal near La Cancelada area. (...)
€1,485,000
TSEA5115412
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 5 Baths: 4 M2: 445 Lot Size: 450 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 4 M2: 445 Lot Size: 450 Area: Benalmadena Region: Andalucía
This 5-bedroom villa located in the charming neighborhood of Arroyo de La Miel in Benalmádena. This majestic detached villa, boasting 443 square meters spread over three elegant floors, is the (...)
€610,000
TSEA5115250
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 130 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Marbella Region: Andalucía
Renovated 3-Bedroom Townhouse in Xarblanca, Marbella
Located in the exclusive and quiet private development of Xarblanca, in the area of the Marbella bus station, this cozy, fully renovated townhouse (...)
€545,000
TSEA5115244
- Coín, Costa Del Sol, Coin
Beds: 5 Baths: 3 M2: 255 Lot Size: 3,055 Area: Coin Region: Andalucía
Beds: 5 Baths: 3 M2: 255 Lot Size: 3,055 Area: Coin Region: Andalucía
255 m² charming finca with mountains views on a 3,055 m² plot features three stables and an OCA license for five horses – ideal for those who love country living and horseback riding.
Discover (...)
€349,000
TSEA5115187
- Almogía, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 192 Lot Size: 2,000 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 192 Lot Size: 2,000 Area: Malaga Region: Andalucía
This charming property features a spacious 3-bedroom, 1-bathroom house with two levels, located in the peaceful Barranco del Sol neighborhood. only 25 min drive to Malaga
The house is (...)
€295,000
TSEA5115073
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 3 Baths: 1 M2: 113 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 1 M2: 113 Area: Benalmadena Region: Andalucía
House in the Center of Arroyo de la Miel
House in Arroyo de la Miel – Central and Quiet Location. Charming house for sale in Arroyo de la Miel, very close to the center and surrounded by all kinds (...)
€4,495,000
TSEA5114824
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 665 Lot Size: 665 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 665 Lot Size: 665 Area: Marbella West Region: Andalucía
We are proud to present an exceptional contemporary villa located in the heart of Nueva Andalucía, within an exclusive gated community renowned for having one of the most advanced security systems (...)
€199,999
TSEA5114746
- El Borge, Costa Del Sol East
Beds: 1 Baths: 1 M2: 115 Lot Size: 3,545 Region: Andalucía
Beds: 1 Baths: 1 M2: 115 Lot Size: 3,545 Region: Andalucía
Tucked away in the hills near El Borge, this rustic country house offers the charm and calm of rural Andalusia. Set on a 3,430 m2 plot planted with almond and olive trees, its a quiet retreat (...)
€650,000
TSEA5114725
- San Pablo de Buceite, Costa de la Luz
Beds: 3 Baths: 2 M2: 274 Lot Size: 1,850 Region: Andalucía
Beds: 3 Baths: 2 M2: 274 Lot Size: 1,850 Region: Andalucía
Charming 3 bed Finca with Private Pool, Solarium, BBQ and Orchard in San Pablo de Buceite.
San Pablo de Buceite is a small, charming village located in the province of Cádiz, Andalusia, in the (...)
€1,497,000
TSEA5114704
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 500 Lot Size: 946 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 500 Lot Size: 946 Area: Mijas and Mijas Costa Region: Andalucía
Discover this stunning, luxory newly listed villa located in one of the most popular residential neighborhoods El Coto in Mijas.
Set on a generous 946 m² southwest-facing plot, this meticulously (...)
€495,000
TSEA5114698
- Arenas, Costa Del Sol East
Beds: 3 Baths: 2 M2: 185 Lot Size: 2,824 Region: Andalucía
Beds: 3 Baths: 2 M2: 185 Lot Size: 2,824 Region: Andalucía
Villa for Sale in Arenas (Málaga) – Luxury Property with Swimming Pool and Panoramic Views
Are you looking for an exclusive villa for sale in Arenas, located in a quiet location in the mountains (...)
€529,000
TSEA5114656
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Semi-detached house with an apartment (separate studio, separate entrance). The house has three bedrooms and a studio.
Communal pools, paddle tennis court, and multipurpose court. Located very close (...)
€2,195,000
TSEA5114644
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 629 Lot Size: 1,480 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 629 Lot Size: 1,480 Area: Sotogrande Region: Andalucía
Elegant Five-Bedroom Mediterranean Villa Overlooking the Prestigious Valderrama Golf Course in Sotogrande Alto
Discover an exquisite blend of refined luxury and modern Mediterranean charm in this (...)
€340,000
TSEA5114362
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 86 Lot Size: 190 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Lot Size: 190 Area: Mijas and Mijas Costa Region: Andalucía
Charming End-of-Terrace Townhouse in Mijas Golf
This beautifully presented townhouse is located in a small, exclusive urbanisation of just four homes, offering a peaceful setting with a communal (...)
€765,000
TSEA5114287
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Stylish Townhouse with Scenic Views in Aloha Pueblo, Nueva Andalucía
Nestled in the heart of the prestigious Aloha Pueblo community in Nueva Andalucía, this thoughtfully refurbished townhouse (...)
€2,487,000
TSEA5114272
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 478 Lot Size: 838 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 478 Lot Size: 838 Area: Benahavis Region: Andalucía
This charming villa in the heart of the beautiful Benahavis village enjoys panoramic views from every room and is full of character. It has has complete privacy, is extremely quiet and is only a few (...)
Current Featured Properties
€4,600,000
TSEA4679626
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 5 M2: 474 Lot Size: 11 Area: Estepona Region: Andalucía
Beds: 4 Baths: 5 M2: 474 Lot Size: 11 Area: Estepona Region: Andalucía
Located in a picturesque and coveted setting amidst nature's splendour, This luxury development comprises a collection of twelve sophisticated and exclusive villas boasting contemporary aesthetics. (...)
€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 (...)
€349,000
TSEA5077342
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 116 Lot Size: 20 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Lot Size: 20 Area: Estepona Region: Andalucía
Beautifully Reformed 3-Bedroom Townhouse in Bel Air
Step into this bright and airy reformed townhouse, offering 3 spacious bedrooms and 2 modern bathrooms in the sought-after area of Bel Air. (...)
