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 (162,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 (162,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 (162,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 2639
€419,000
TSEA5159587
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Semi-detached house with no community fees in Las Lagunas (Mijas Costa)
Cozy and bright semi-detached home located in one of the most sought-after areas of Las Lagunas, close to all amenities and (...)
€735,000
TSEA5159485
- Istán, Costa Del Sol, Istan
Beds: 2 Baths: 2 M2: 203 Area: Istan Region: Andalucía
Beds: 2 Baths: 2 M2: 203 Area: Istan Region: Andalucía
Lake and Sea View Villa for Sale in Sierra Blanca Country Club, Istan – Investment Opportunity Near Marbella
Set within the prestigious gated community of Sierra Blanca Country Club in Istan, this (...)
€7,800,000
TSEA5159374
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 5 Baths: 8 M2: 734 Lot Size: 1,000 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 8 M2: 734 Lot Size: 1,000 Area: Marbella East Region: Andalucía
This fully renovated Andalusian-style villa is set in Rocío de Nagüeles, one of the most prestigious enclaves of Marbella's Golden Mile. Positioned on a 1,965m² south-facing plot beneath the (...)
€395,000
TSEA5159308
- Cártama, Costa Del Sol, Cartama
Beds: 2 Baths: 2 M2: 155 Lot Size: 2,500 Area: Cartama Region: Andalucía
Beds: 2 Baths: 2 M2: 155 Lot Size: 2,500 Area: Cartama Region: Andalucía
Charming 2/3 Bedroom Country Finca, Orchard, Stunning Gardens, A1 Condition
A wonderful opportunity to purchase a deceptively spacious, detached country finca with stunning panoramic views, located (...)
€640,000
TSEA5158999
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 2 M2: 177 Lot Size: 222 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 2 M2: 177 Lot Size: 222 Area: San Pedro Region: Andalucía
We invite you to visit this two-level, south-west facing property in the heart of San Pedro, conveniently located close to a wide range of services and infrastructure, nestled in a tranquil (...)
€749,000
TSEA5158900
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 5 Baths: 3 M2: 315 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 3 M2: 315 Area: Benalmadena Region: Andalucía
Beautiful Semi-Detached Villa in Excellent Condition – 325 m² Built
This stunning villa offers space, comfort, and an unbeatable location:
• Ground floor: large, well-kept garden with fruit (...)
€375,000
TSEA5158255
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 1 M2: 120 Lot Size: 3,958 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 1 M2: 120 Lot Size: 3,958 Area: Alhaurin el Grande Region: Andalucía
Detached Villa with Pool and Large Plot – Fully Renovated
Discover this charming detached property, perfect for those seeking peace, privacy, and comfort. The house has been completely renovated, (...)
€719,000
TSEA5158141
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 228 Lot Size: 259 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 228 Lot Size: 259 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic semi-detached villa with private pool and two separate homes for sale on a single plot in the exclusive Capellanía residential area, Alhaurín de la Torre.
This spectacular semi-detached (...)
€399,000
TSEA5158069
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
Modern & Spacious 2-Bedroom Bungalow in Atalaya Aparta Golf Complex
Set within the prestigious Atalaya Golf Course, this modern and beautifully designed 2-bedroom bungalow combines comfort, (...)
€3,550,000
TSEA5157937
- Aloha, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 435 Lot Size: 1,038 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 435 Lot Size: 1,038 Area: Marbella West Region: Andalucía
Welcome to this exceptional modern villa located in the heart of Nueva Andalucía, offering a seamless blend of style, luxury and comfort.
Set on a generous plot of 1,038m², this beautifully (...)
€3,150,000
TSEA5157496
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 410 Lot Size: 728 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 410 Lot Size: 728 Area: Marbella West Region: Andalucía
Nestled in a quiet residential area of Nueva Andalucía and yet close to all local amenities we find this house for sale. The property has gone through an extensive refurbishment and updating (...)
€398,000
TSEA5157385
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M2: 262 Area: Coin Region: Andalucía
Beds: 4 Baths: 2 M2: 262 Area: Coin Region: Andalucía
The first time I stepped into this house, I knew it wasn't just any home.
There are places you simply visit, and others that make you pause and imagine. This was one of those.
I pictured myself (...)
€1,100,000
TSEA5157100
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 311 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 311 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,100,000 € to 1,100,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 311.00 m2 - 311.00 m2]
Luxurious and modern high tech villa with 3 bedrooms, 3 ensuite (...)
€1,380,000
TSEA5157088
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 155 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 155 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,380,000 € to 1,380,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 155.00 m2 - 155.00 m2]
Luxurious and modern high tech villa with 4 bedrooms, 4 bathrooms, (...)
€1,450,000
TSEA5157073
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 4 M2: 475 Lot Size: 979 Area: Marbella Region: Andalucía
Beds: 5 Baths: 4 M2: 475 Lot Size: 979 Area: Marbella Region: Andalucía
Spacious independent villa with a lot of character in exclusive residential area of Marbella.
This magnificent villa is built on a plot of nearly 1000 sqm and has a total built surface of 475 sqm.
It (...)
€4,114,000
TSEA5156992
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 6 M2: 572 Lot Size: 1,114 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 6 M2: 572 Lot Size: 1,114 Area: Mijas and Mijas Costa Region: Andalucía
Newly built villa in the urbanization El Faro, Mijas Costa, only 200 metres from the beach.
The property consists of three levels connected by stairs and lift, which are distributed as follows: main (...)
€1,580,000
TSEA5156974
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 340 Lot Size: 715 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 340 Lot Size: 715 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,580,000 € to 1,580,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 340.00 m2 - 340.00 m2]
Welcome to this project, a home where elegance meets everyday ease — a (...)
€17,500,000
TSEA5156455
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 6 Baths: 6 M2: 1,534 Lot Size: 2,210 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 6 M2: 1,534 Lot Size: 2,210 Area: Marbella East Region: Andalucía
This exceptional villa is the epitome of ultra-luxury living, offering not only the highest standards of elegance and comfort but also unmatched security. Nestled in one of Marbella's most (...)
€750,000
TSEA5156380
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 143 Lot Size: 500 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 143 Lot Size: 500 Area: Mijas and Mijas Costa Region: Andalucía
Discover this charming Mediterranean villa, perfectly positioned on a sought-after urbanisation just minutes from the picturesque village of Mijas Pueblo and the coast. Combining traditional style (...)
€2,300,000
TSEA5156368
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 710 Lot Size: 1,711 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 710 Lot Size: 1,711 Area: Benahavis Region: Andalucía
Set within the well-established and sought-after residential area of El Paraíso, Benahavís, this detached villa represents an excellent opportunity for investors or end-users looking to create a (...)
Current Featured Properties
€7,650,000
TSEA4570726
- Benahavís, Costa Del Sol, Benahavis
Beds: 7 Baths: 8 M2: 1,780 Lot Size: 2,500 Area: Benahavis Region: Andalucía
Beds: 7 Baths: 8 M2: 1,780 Lot Size: 2,500 Area: Benahavis Region: Andalucía
This luxury modern style 7-bedroom house for sale is set in Paraiso Alto, one of the most sought-after areas on the New Golden Mile, Benahavis, close to the golf courses, international schools, (...)
€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. (...)
€3,000,000
Detached Villa in Marbella
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 5 M2: 692 Lot Size: 4,396 Area: Marbella Region: Andalucía
Beds: 7 Baths: 5 M2: 692 Lot Size: 4,396 Area: Marbella Region: Andalucía
A charming property in a picturesque tranquil residential area above Marbella center, with the most magnificent La Concha backdrop. A fantastic investment opportunity located in a secure residential (...)
