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 (41,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 (41,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 (41,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 661 - 680 of 3420 €7,995,000
TSEA5106286
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 6 M2: 872 Lot Size: 2,068 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 6 M2: 872 Lot Size: 2,068 Area: Benahavis Region: Andalucía
Located within the exclusive gated community of Monte Mayor in Benahavís, this brand-new modern villa offers an exceptional lifestyle experience. Set on a 2,068 m² plot and boasting 872 m² of (...)
€1,950,000
TSEA5106211
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 287 Lot Size: 400 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 287 Lot Size: 400 Area: Estepona Region: Andalucía
New Development: Prices from 1,950,000 € to 3,500,000 €. [Beds: 5 - 5] [Baths: 6 - 6] [Built size: 287.00 m2 - 544.00 m2]
Located in One of the Best Areas in the Mediterranean
Set in a unique, (...)
€795,000
TSEA5106175
- Bel Air, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 190 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 190 Area: Estepona Region: Andalucía
Elegant Bel-Air Villa, Newly renovated with Private Pool & Stunning Views
Nestled in the sought-after residential enclave of Bel-Air, east of Estepona, this expansive refurbished, detached villa (...)
€1,449,000
TSEA5106082
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 324 Lot Size: 1,322 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 324 Lot Size: 1,322 Area: Marbella East Region: Andalucía
SPACIOUS 4-5 BEDROOM VILLA IN ELVIRIA-MARBELLA
This well-maintained villa, built by its original owners, offers an exceptional opportunity to live in the sought-after area of Elviria, (...)
€695,000
TSEA5106079
- Cómpeta, Costa Del Sol East
Beds: 5 Baths: 4 M2: 438 Lot Size: 2,082 Region: Andalucía
Beds: 5 Baths: 4 M2: 438 Lot Size: 2,082 Region: Andalucía
Superb Business Opportunity – Bar & Restaurant with Owner's Accommodation and Guest Apartment Between Cómpeta & Torrox
An exceptional opportunity to acquire a successful bar and (...)
€1,390,000
TSEA5105995
- Los Flamingos, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 156 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 156 Area: Estepona Region: Andalucía
Located in the sought-after Los Flamingos resort near Cancelada, this stylish and spacious penthouse offers a harmonious blend of natural light, stunning views, and comfort. Originally designed with (...)
€360,000
TSEA5105935
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 106 Lot Size: 700 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 106 Lot Size: 700 Area: Mijas and Mijas Costa Region: Andalucía
Detached Villa,In the Village of Alqueria close to Alhaurín de la Torre, and Alhaurin el Grande Inland Malaga
4 Bedrooms, 2 Bathrooms, Built 100 m², Garden/Plot 700 m².
Beautiful house for sale (...)
€1,095,000
TSEA5105917
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Stunning DUPLEX PENTHOUSE with BEAUTIFUL SEA VIEWS, on the beachfront in Carvajal (Fuengirola).
It features 2 LARGE TERRACES, both south-facing, with stunning views of the sea and the beaches of (...)
€1,500,000
TSEA5105860
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 282 Lot Size: 454 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 282 Lot Size: 454 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,500,000 € to 1,500,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 282.00 m2 - 282.00 m2]
This brand-new detached villa combines modern design, spaciousness, and (...)
€9,500,000
TSEA5105767
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 8 Baths: 7 M2: 1,202 Lot Size: 1,741 Area: Marbella East Region: Andalucía
Beds: 8 Baths: 7 M2: 1,202 Lot Size: 1,741 Area: Marbella East Region: Andalucía
Spectacular 8-Bedroom Villa in Bahia de Marbella, Los Monteros
Nestled in the exclusive and secure neighbourhood of Bahia de Marbella. This stunning 8-bedroom, 7-bathroom villa offers the ultimate (...)
€1,400,000
TSEA5105752
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 3 M2: 209 Lot Size: 452 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 3 M2: 209 Lot Size: 452 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,400,000 € to 1,400,000 €. [Beds: 2 - 2] [Baths: 3 - 3] [Built size: 209.00 m2 - 209.00 m2]
Luxury Villa in La Sierrezuela, Mijas Costa
Discover this exclusive (...)
€1,975,000
TSEA5105731
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 8 Baths: 8 M2: 762 Lot Size: 1,703 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 8 Baths: 8 M2: 762 Lot Size: 1,703 Area: Mijas and Mijas Costa Region: Andalucía
BEST BUY ALERT - (massively reduced) Spectacular 8 bed Mediterranean Villa / Mansion with incredible golf, mountain & sea views. Enormous / impressive home on a large 1703 m2 raised plot and (...)
€6,250,000
TSEA5105377
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 616 Lot Size: 1,427 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 616 Lot Size: 1,427 Area: Benahavis Region: Andalucía
Stunning contemporary villa with panoramic mountain, golf and sea views in La Alqueria, Benahavis
This exclusive masterpiece, a designer villa by Carlos Lamas, houses a total of 5 bedrooms and 6 (...)
€725,000
TSEA5105368
- Arenas, Costa Del Sol East
Beds: 4 Baths: 2 M2: 246 Lot Size: 4,750 Region: Andalucía
Beds: 4 Baths: 2 M2: 246 Lot Size: 4,750 Region: Andalucía
Exclusive Villa for Sale in Arenas, Vélez-Málaga. Escape the hustle and bustle and discover this exceptional villa, located in the quiet countryside (campo) of the white village of Arenas in the (...)
€1,190,000
TSEA5105242
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 2 M2: 277 Lot Size: 640 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 2 M2: 277 Lot Size: 640 Area: Benalmadena Region: Andalucía
Not visiting this penthouse means missing out on much more than a date with luxury. It's passing up a livable work of art—an unrepeatable life experience.
They say everything in life is (...)
€4,950,000
TSEA5105161
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 444 Lot Size: 1,950 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 444 Lot Size: 1,950 Area: Marbella West Region: Andalucía
Located in one of Marbella's most sought-after residential areas, this five-bedroom, five-bathroom villa offers panoramic, frontal views of the Mediterranean Sea, La Concha mountain, and Puerto (...)
€450,000
TSEA5105095
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 200 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 200 Area: Estepona Region: Andalucía
For Sale: Luxury Penthouse in Estepona West with Sea Views
Price: €499,000
Looking for a unique place to live or invest? This offer will meet your expectations!
Property details:
•Location: (...)
€1,450,000
TSEA5105056
- Entrerrios, Costa Del Sol
Beds: 4 Baths: 4 M2: 400 Lot Size: 19,000 Region: Andalucía
Beds: 4 Baths: 4 M2: 400 Lot Size: 19,000 Region: Andalucía
Charming Andalusian Cortijo with Lush Fruit Gardens and Large Pool in Mijas
Nestled in the serene countryside of Mijas, this beautiful Andalusian-style cortijo offers a rare combination of rustic (...)
€3,300,000
TSEA5105029
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 7 Baths: 8 M2: 720 Lot Size: 1,250 Area: Marbella West Region: Andalucía
Beds: 7 Baths: 8 M2: 720 Lot Size: 1,250 Area: Marbella West Region: Andalucía
Introducing an exclusive investment opportunity in the heart of Nueva Andalucía — Marbella's prime residential area.
This villa project is available for 3,300,000 euros, with a fully approved (...)
€529,000
TSEA5105023
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
Bright Penthouse with Spacious Glazed Terrace, Open Views to the Golf Course and Mountains; Tranquility Guaranteed.
Set in a very peaceful residential area, this spacious penthouse perfectly (...)
Current Featured Properties
€851,414
Staff pick! We love this one, it's got everything
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 83 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Estepona Region: Andalucía
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA!
A luxury resort style apartment complex with the best in leisure facilities. This new development has been landscaped to create TOP QUALITY with (...)
€2,995,000
TSEA5143633
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Bahía del Velerín is a luxurious community between Marbella and Estepona. It has a fantastic pool area with a snack bar, tropical gardens and 24/7 security. The community is located at one of the (...)
€650,000
TSEA4969432
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 103 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: San Pedro Region: Andalucía
LUXURIOUS 2,3 & 4 BEDROOM APARTMENTS IN GUADALMINA ALTA! Development of 34 amazing apartments and penthouses in a perfect location, for you to enjoy the Mediterranean lifestyle The living room is (...)
