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 (63,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 (63,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 (63,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 241 - 260 of 2642
€3,800,000
TSEA5131675
- Santa Clara, Costa Del Sol, Marbella East
Beds: 5 Baths: 3 M2: 592 Lot Size: 1,450 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 3 M2: 592 Lot Size: 1,450 Area: Marbella East Region: Andalucía
Icon Signature – Santa Clara Golf, Marbella
This unique property, located in the prestigious Santa Clara Golf urbanisation, offers spectacular views of the Mediterranean Sea, La Concha Mountain (...)
€1,200,000
TSEA5131642
- Torremuelle, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 126 Lot Size: 831 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 126 Lot Size: 831 Area: Mijas and Mijas Costa Region: Andalucía
Villa in La Perla de Torremuelle, perfect for renovation, located on a plot of 831 square meters with great development potential. The property offers the possibility of building a second floor, (...)
€1,150,000
TSEA5131582
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 336 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 336 Area: Benalmadena Region: Andalucía
The villa with panoramic views of the Mediterranean from its peaceful and perfect location.
Situated very close to the town of Benalmádena, in an exclusive complex of detached villas, it is (...)
€1,990,000
TSEA5131495
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 533 Lot Size: 660 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 533 Lot Size: 660 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,990,000 € to 1,990,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 533.00 m2 - 533.00 m2]
Welcome to an exclusive enclave of three impressive residences located (...)
€1,945,000
TSEA5131489
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 551 Lot Size: 718 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 551 Lot Size: 718 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,945,000 € to 1,945,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 551.00 m2 - 551.00 m2]
Welcome to an exclusive enclave of three impressive residences located (...)
€1,970,000
TSEA5131474
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 551 Lot Size: 720 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 551 Lot Size: 720 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,970,000 € to 1,970,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 551.00 m2 - 551.00 m2]
Welcome to an exclusive enclave of three impressive residences located (...)
€22,490,000
TSEA5131117
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 7 Baths: 10 M2: 1,953 Lot Size: 2,013 Area: Marbella Region: Andalucía
Beds: 7 Baths: 10 M2: 1,953 Lot Size: 2,013 Area: Marbella Region: Andalucía
An architecturally unique, south-facing property located in the exclusive gated community of Sierra Blanca on Marbella's prestigious Golden Mile. This brand-new mansion offers exceptional design, (...)
€325,000
TSEA5131069
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M2: 327 Lot Size: 2,994 Area: Coin Region: Andalucía
Beds: 4 Baths: 2 M2: 327 Lot Size: 2,994 Area: Coin Region: Andalucía
Nestled in the peaceful countryside northwest of Coín, just a 12-minute drive (6.5 km) from the village, this versatile country property offers a fantastic opportunity for those seeking privacy, (...)
€145,000
TSEA5131066
- Arenas, Costa Del Sol East
Beds: 3 Baths: 1 M2: 90 Lot Size: 63 Region: Andalucía
Beds: 3 Baths: 1 M2: 90 Lot Size: 63 Region: Andalucía
In the picturesque mountain village of Arenas, just a short drive from the coast, you'll find this delightful village house full of character and comfort. The property offers three spacious bedrooms, (...)
€530,000
TSEA5131033
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 290 Lot Size: 1,500 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 290 Lot Size: 1,500 Area: Mijas and Mijas Costa Region: Andalucía
✅ Great Opportunity in Los Pinos, Alhaurín de la Torre!
???? Spacious Home with Endless Possibilities on a 1,500 m² Plot
For sale: excellent detached house located in one of the most peaceful (...)
€1,549,000
TSEA5130982
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 290 Lot Size: 643 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 290 Lot Size: 643 Area: Estepona Region: Andalucía
Panoramic Views of the Mountains, Gibraltar, and Even Africa!
Discover your dream home in the heart of Estepona — a truly stunning villa offering luxury, comfort, and unforgettable views that (...)
€780,000
TSEA5130973
- Villanueva De La Concepcion, Costa Del Sol, Malaga
Beds: 5 Baths: 3 M2: 450 Area: Malaga Region: Andalucía
Beds: 5 Baths: 3 M2: 450 Area: Malaga Region: Andalucía
SPECTACULAR ESTATE WITH THREE INDEPENDENT HOUSES AND A STUDIO ON MORE THAN 6,000 m² OF FENCED LAND
A unique opportunity on the market.
A versatile, modern property ready to move in, ideal for those (...)
€4,450,000
TSEA5130820
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 7 Baths: 8 M2: 954 Lot Size: 2,175 Area: Benalmadena Region: Andalucía
Beds: 7 Baths: 8 M2: 954 Lot Size: 2,175 Area: Benalmadena Region: Andalucía
This spectacular detached villa, located in the exclusive area of Benalmádena Costa, is an architectural gem that combines luxury, comfort, and design in a privileged setting. With an impressive (...)
€495,000
TSEA5130715
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 2 M2: 237 Lot Size: 5,200 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 2 M2: 237 Lot Size: 5,200 Area: Alhaurin el Grande Region: Andalucía
Discover this charming rustic finca with swimming pool in Alhaurín el Grande. The finca is located 5 minutes' drive from the charming village of Alhaurín el Grande and close to the main road to (...)
€349,000
TSEA5130643
- Antequera, Costa Del Sol, Antequera
Beds: 3 Baths: 2 M2: 162 Area: Antequera Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: Antequera Region: Andalucía
New Development: Prices from 349,000 € to 349,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 162.00 m2 - 169.00 m2]
Already under construction, this exclusive development consists of just 6 (...)
€4,350,000
TSEA5130103
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 241 Lot Size: 855 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 241 Lot Size: 855 Area: Marbella West Region: Andalucía
Welcome to a beautifully reimagined single-level villa nestled in the heart of Nueva Andalucía, just minutes from the renowned Los Naranjos Golf Course. Designed and developed by Casas Fintech, this (...)
€6,995,000
TSEA5130058
- Benahavís, Costa Del Sol, Benahavis
Beds: 6 Baths: 7 M2: 631 Lot Size: 1,398 Area: Benahavis Region: Andalucía
Beds: 6 Baths: 7 M2: 631 Lot Size: 1,398 Area: Benahavis Region: Andalucía
Discover an extraordinary contemporary villa in the exclusive gated community of Lomas de La Quinta, designed by the renowned architect Carlos Lamas and with interiors by La Albaida. This (...)
€8,700,000
TSEA5130049
- Casares, Costa Del Sol, Casares
Beds: 6 Baths: 8 M2: 795 Lot Size: 2,520 Area: Casares Region: Andalucía
Beds: 6 Baths: 8 M2: 795 Lot Size: 2,520 Area: Casares Region: Andalucía
This exceptional residence, exclusive to the Finca Cortesin resort, exudes a captivating blend of luxury and elegance. Designed by the renowned Jose Maria Sierra architects, this architectural (...)
€7,350,000
TSEA5130034
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 7 M2: 789 Lot Size: 1,431 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 7 M2: 789 Lot Size: 1,431 Area: Marbella West Region: Andalucía
Boasting of unparalleled architecture and unrivalled construction quality, the villa offers sophisticated and contemporary living, sitting on a private plot within a secure community with (...)
€1,595,000
TSEA5129893
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 6 Baths: 6 M2: 831 Lot Size: 2,506 Area: Sotogrande Region: Andalucía
Beds: 6 Baths: 6 M2: 831 Lot Size: 2,506 Area: Sotogrande Region: Andalucía
This traditional-style villa is located between Valderrama and the Almenara golf course, surrounded by mature woodlands and landscaped gardens. Spread over three floors, it features rustic elements (...)
Current Featured Properties
€4,500,000
TSEA4218301
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 300 Lot Size: 92 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 300 Lot Size: 92 Area: Marbella West Region: Andalucía
The "central courtyard" of each "Vila", is undoubtedly the main axis, everything happens around this unique space, open to both, the inside and the outside. Everything in the (...)
€4,200,000
TSEA4450924
- Benahavís, Costa Del Sol, Benahavis
Beds: 7 Baths: 5 M2: 462 Lot Size: 1,034 Area: Benahavis Region: Andalucía
Beds: 7 Baths: 5 M2: 462 Lot Size: 1,034 Area: Benahavis Region: Andalucía
Monte Mayor offers an exclusive gated community with 24 hour security in a fantastic natural environment with beautiful surroundings and excellent sea views. It is just a 15 minute drive to the coast (...)
€2,300,240
Detached Villa in Mijas
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
NO MORE NEED TO DREAM ABOUT THE PERFECT VIEW!!!
This upscale development with the best views in Fuengirola and Mijas consists of thirteen individual villas, each offering no less than four en-suite (...)
