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 (163,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 (163,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 (163,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 301 - 320 of 2924 €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 (...)
€339,000
TSEA5129890
- Comares, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 2 M2: 128 Lot Size: 10,520 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Lot Size: 10,520 Area: Nerja and Malaga East Region: Andalucía
Rural property with complete privacy in Comares - Malaga - Costa del Sol - Axarquia
Discover this charming rural property in picturesque Comares, situated in a beautiful, peaceful location with (...)
€1,010,000
TSEA5129800
- El Coto, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 101 Lot Size: 506 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 101 Lot Size: 506 Area: Mijas and Mijas Costa Region: Andalucía
Magnificent detached villa in El Coto.
Discover this magnificent, fully renovated villa in the quiet residential area of El Coto in Mijas Costa.
Ideal for those looking for a turnkey home, close to (...)
€2,495,000
TSEA5129767
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 6 M2: 600 Lot Size: 2,150 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 6 M2: 600 Lot Size: 2,150 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Villa in Valtocado – Panoramic Views
Set in the prestigious and tranquil urbanisation of Valtocado, Mijas, this impressive modern villa offers the ultimate blend of privacy, comfort, and (...)
€18,000,000
TSEA5129758
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 6 Baths: 6 M2: 1,163 Lot Size: 2,048 Area: Marbella Region: Andalucía
Beds: 6 Baths: 6 M2: 1,163 Lot Size: 2,048 Area: Marbella Region: Andalucía
New Development: Prices from 18,000,000 € to 18,000,000 €. [Beds: 6 - 6] [Baths: 6 - 6] [Built size: 1,163.00 m2 - 1,163.00 m2]
This is a luxury two-storey property located in Sierra Blanca, one (...)
€350,000
TSEA5129746
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 74 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Fuengirola Region: Andalucía
Very well located Top-Floor apartment with private rooftop terrace in Torreblanca, Fuengirola. Welcome to this bright top-floor apartment located in the peaceful yet well-connected area of (...)
€595,000
TSEA5129590
- Guadacorte, Costa de la Luz
Beds: 4 Baths: 3 M2: 214 Lot Size: 1,200 Region: Andalucía
Beds: 4 Baths: 3 M2: 214 Lot Size: 1,200 Region: Andalucía
Charming Riverside Villa in Guadacorte – A Private Retreat Surrounded by Nature
Discover this cozy detached villa located in a privileged setting in Guadacorte, right by the river and surrounded (...)
€699,000
TSEA5129566
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 145 Lot Size: 354 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 145 Lot Size: 354 Area: San Pedro Region: Andalucía
Welcome to this charming and well-designed semi-detached home in the sought-after Linda Vista alta area – just a short walk from the vibrant centre of San Pedro de Alcántara, with shops, (...)
€3,800,000
TSEA5129392
- Ojén, Costa Del Sol, Ojen
Beds: 9 Baths: 9 M2: 1,688 Lot Size: 58,283 Area: Ojen Region: Andalucía
Beds: 9 Baths: 9 M2: 1,688 Lot Size: 58,283 Area: Ojen Region: Andalucía
This estate is much more than a property: it's a statement of style, refined taste, and forward-thinking vision. A place where understated luxury blends seamlessly with the serenity of the Andalusian (...)
€900,000
TSEA5129257
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 165 Lot Size: 500 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 165 Lot Size: 500 Area: Estepona Region: Andalucía
€900,000 – 3 Bedrooms | 2 Bathrooms | 165 m² Built | 500 m² Plot | Private Pool
Located just minutes from the beach on Estepona's sought-after New Golden Mile, this south-facing villa offers (...)
€1,350,000
TSEA5129245
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 220 Lot Size: 638 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 220 Lot Size: 638 Area: San Pedro Region: Andalucía
Introducing this elegant single-level villa, ideally situated in one of the most exclusive areas of San Pedro Alcántara. Designed with a perfect balance of comfort, quality and privacy, it offers (...)
€690,000
TSEA5129107
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 148 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 148 Area: Benalmadena Region: Andalucía
Discover this charming duplex penthouse in a premium residential complex located in Benalmádena, south-facing with sea views in a unique setting, a pleasure for the senses.
It consists of three (...)
€1,885,000
TSEA5129080
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 3 M2: 727 Lot Size: 1,200 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 3 M2: 727 Lot Size: 1,200 Area: Sotogrande Region: Andalucía
Grand villa with incredible sea views La Alcaidesa
Villa Casablanca is an Andalusian style white villa located in a quiet street with no drive through traffic and with the best possible views of the (...)
€850,000
TSEA5129014
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 167 Lot Size: 775 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 167 Lot Size: 775 Area: Marbella East Region: Andalucía
Mediterranean living on one level: comfort, tranquility, and proximity to the sea
This charming villa combines the Mediterranean lifestyle with maximum comfort. Situated on a spacious floor, this (...)
€2,300,000
TSEA5128981
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 241 Lot Size: 508 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 241 Lot Size: 508 Area: Marbella East Region: Andalucía
Exclusive semi-detached house with private pool, right in front of Cabopino Marina, boasting stunning sea views.
This elegant and traditional property in Spanish style features 4 bedrooms, 3 full (...)
€455,000
TSEA5128978
- Riogordo, Costa Del Sol East
Beds: 3 Baths: 2 M2: 229 Lot Size: 9,470 Region: Andalucía
Beds: 3 Baths: 2 M2: 229 Lot Size: 9,470 Region: Andalucía
Authentic finca near Riogordo (Málaga, Costa del Sol) – ready to move in with swimming pool, solar panels and beautiful views
This excellently maintained finca is located just 10 minutes from the (...)
€2,390,000
TSEA5128939
- Cancelada, Costa Del Sol, Estepona
Beds: 5 Baths: 7 M2: 441 Lot Size: 800 Area: Estepona Region: Andalucía
Beds: 5 Baths: 7 M2: 441 Lot Size: 800 Area: Estepona Region: Andalucía
Villa Kartala. Viewings possible from September. Love at first sight! Impeccable luxury detached villa in a top location. Situated between Marbella and Estepona, with the beaches of Costalita only (...)
€18,000,000
TSEA5128903
- Marbella, Costa Del Sol, Marbella
Beds: 8 Baths: 8 M2: 1,343 Lot Size: 2,374 Area: Marbella Region: Andalucía
Beds: 8 Baths: 8 M2: 1,343 Lot Size: 2,374 Area: Marbella Region: Andalucía
New Development: Prices from 18,000,000 € to 18,000,000 €. [Beds: 8 - 8] [Baths: 8 - 8] [Built size: 1,343.00 m2 - 1,343.00 m2]
This is a majestic contemporary villa in the exclusive 24hrs (...)
€10,750,000
TSEA5128873
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 986 Lot Size: 1,727 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 986 Lot Size: 1,727 Area: Marbella West Region: Andalucía
New Development: Prices from 10,750,000 € to 10,750,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 986.00 m2 - 986.00 m2]
This is an exceptional modern villa located in the heart of the Golf (...)
Current Featured Properties
€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 (...)
€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,007,050
TSEA5042083
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 97 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 97 Area: San Pedro Region: Andalucía
In an exceptional location in San Pedro Alcántara, just a short walk from the beach and with views of the sea and the impressive La Concha peak. Discover a new way of living in San Pedro Alcántara (...)
