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 321 - 340 of 2924 €9,750,000
TSEA5128849
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 867 Lot Size: 1,458 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 867 Lot Size: 1,458 Area: Marbella West Region: Andalucía
New Development: Prices from 9,750,000 € to 9,750,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 867.00 m2 - 867.00 m2]
PROJECT IN THE HEART OF NUEVA ANDALUCÍA
This is a luxury villa located (...)
€5,950,000
TSEA5128846
- La Quinta, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 577 Lot Size: 1,160 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 577 Lot Size: 1,160 Area: Benahavis Region: Andalucía
New Development: Prices from 5,950,000 € to 5,950,000 €. [Beds: 5 - 5] [Baths: 6 - 6] [Built size: 577.00 m2 - 577.00 m2]
An exclusive residential development in La Quinta is a 24-hour gated (...)
€465,000
TSEA5128834
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 172 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 172 Area: Mijas and Mijas Costa Region: Andalucía
Luxurious South-Facing Duplex Penthouse in Mijas Golf – Panoramic Views & Elegant Design
We are delighted to present this exceptional 3-bedroom, 2-bathroom Duplex Penthouse located in the (...)
€5,750,000
TSEA5128819
- La Quinta, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 605 Lot Size: 1,210 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 605 Lot Size: 1,210 Area: Benahavis Region: Andalucía
New Development: Prices from 5,750,000 € to 5,750,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 605.00 m2 - 605.00 m2]
Now finished. READY TO VISIT TODAY.
An exclusive residential (...)
€435,000
TSEA5128711
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 275 Lot Size: 137 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 275 Lot Size: 137 Area: Mijas and Mijas Costa Region: Andalucía
DETACHED HOUSE IN THE CENTER OF PICTURESQUE MIJAS PUEBLO.
Detached house in Mijas Pueblo, close to all amenities, in a quiet area outside the town's commercial area.
The property is in need of (...)
€2,500,000
TSEA5128684
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 8 M2: 573 Lot Size: 2,500 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 8 M2: 573 Lot Size: 2,500 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful Villa for sale in La Cala de Mijas
2500m2 plot
Over 500m 2 built
4 beds
4 baths
€780,000
TSEA5127550
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 2 M2: 300 Lot Size: 2,554 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 2 M2: 300 Lot Size: 2,554 Area: Mijas and Mijas Costa Region: Andalucía
3547-V For sale spectacular villa of more than 300 meters on a plot of 2500 meters, consists on the ground floor of a living room with fireplace, an independent fitted kitchen with utility room, two (...)
€5,500,000
TSEA5127520
- Aloha, Costa Del Sol, Marbella West
Beds: 7 Baths: 8 M2: 710 Lot Size: 1,291 Area: Marbella West Region: Andalucía
Beds: 7 Baths: 8 M2: 710 Lot Size: 1,291 Area: Marbella West Region: Andalucía
Stunning frontline golf villa with panoramic mountain views to La Concha as well as overlooking the beautiful Aloha Golf course.
The Villa is situated on a quiet cul-de-sac, just a short distance to (...)
€395,000
TSEA5127508
- Cómpeta, Costa Del Sol East
Beds: 5 Baths: 2 M2: 287 Lot Size: 8,008 Region: Andalucía
Beds: 5 Baths: 2 M2: 287 Lot Size: 8,008 Region: Andalucía
For Sale: Beautiful Villa with separate guesthouse, Between Cómpeta and Torrox, Andalusia
Discover a peaceful Andalusian retreat nestled between the whitewashed villages of Cómpeta and Torrox. (...)
€565,000
TSEA5127385
- Churriana, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 300 Lot Size: 1,000 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 300 Lot Size: 1,000 Area: Malaga Region: Andalucía
LOCATION – CHURRIANA, MÁLAGA.
This independent villa sits in the peaceful residential area of Cortijo Maza, one of the most sought-after urbanisations in Churriana, Málaga.
You're just 5 minutes (...)
€565,000
TSEA5127343
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 4 Baths: 4 M2: 235 Lot Size: 861 Area: Alhaurin el Grande Region: Andalucía
Beds: 4 Baths: 4 M2: 235 Lot Size: 861 Area: Alhaurin el Grande Region: Andalucía
Welcome to your dream home in Alhaurín el Grande, provincia de Málaga! This detached independent villa is ready to move in and boasts of everything you need for a comfortable living. With 4 (...)
€1,100,000
TSEA5127334
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 81 Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Region: Andalucía
This magnificent brand-new penthouse, located in one of the most exclusive areas of the prestigious El Higuerón residential development.
The property is part of an exclusive residential complex (...)
€895,000
TSEA5127301
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 3 M2: 325 Lot Size: 530 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 3 M2: 325 Lot Size: 530 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive detached villa for sale in Alhaurín de la Torre (Málaga)
Built in 2021, this elegant 325 m² property stands on a generous 530 m² plot, offering a modern, comfortable, and private (...)
€595,000
TSEA5127184
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 210 Lot Size: 715 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 210 Lot Size: 715 Area: Mijas and Mijas Costa Region: Andalucía
� Unique Opportunity on the Costa del Sol! Villa with Panoramic Sea Views Just Steps from the Beach �
Looking to invest in a property with a privileged location, breathtaking sea views, and (...)
€1,260,000
TSEA5127163
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 276 Lot Size: 770 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 276 Lot Size: 770 Area: Marbella Region: Andalucía
Investment Opportunity – Distinctive Villa Within Walking Distance to the Beach | Marbella East
This is your chance to acquire a truly unique villa in the desirable area of Marbella East, just a (...)
€598,000
TSEA5127148
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 5 Baths: 6 M2: 250 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 6 M2: 250 Area: Benalmadena Region: Andalucía
For sale: A wonderful detached house located in a quiet area of Benalmádena Pueblo, with stunning sea views. It is divided into three completely independent units, one of which is currently rented, (...)
€5,900,000
TSEA5127067
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 7 M2: 1,904 Lot Size: 36,498 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 7 M2: 1,904 Lot Size: 36,498 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic opportunity to adquire a villa located within 3 plots in Cerro del Aguila.
Villa with Islamic architecture, this wonderful property will surprise you! On the first floor we can find a (...)
€4,000,000
TSEA5127016
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 621 Lot Size: 1,600 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 621 Lot Size: 1,600 Area: Marbella West Region: Andalucía
Detached Villa, Nueva Andalucía, Costa del Sol.
6 Bedrooms, 6 Bathrooms, Built 621 m², Garden/Plot 1600 m².
Setting : Town, Commercial Area, Village, Close To Golf, Close To Shops, Close To Sea, (...)
€2,466,000
TSEA5126986
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 6 Baths: 7 M2: 995 Lot Size: 2,552 Area: Sotogrande Region: Andalucía
Beds: 6 Baths: 7 M2: 995 Lot Size: 2,552 Area: Sotogrande Region: Andalucía
Modern Villa in La Reserva de Sotogrande
Located in La Reserva, one of the most exclusive areas of Sotogrande, this spectacular detached villa offers elegance, comfort, and contemporary style in a (...)
€2,500,000
TSEA5126911
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 6 M2: 516 Lot Size: 1,316 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 6 M2: 516 Lot Size: 1,316 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular 7-Bedroom Designer Villa in La Finca de La Cala
Welcome to one of the most exquisite villas in La Finca de La Cala — a truly unique, fully furnished 7-bedroom residence that blends (...)
Current Featured Properties
€2,950,000
EMPTY
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 5 M2: 450 Lot Size: 610 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 5 M2: 450 Lot Size: 610 Area: San Pedro Region: Andalucía
We are thrilled to present this modern south facing villa, just 250m from the Mediterranean Sea near San Pedro town. The property is built over two floors plus basement and rooftop terrace with views (...)
€1,250,000
TSEA5020213
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 225 Lot Size: 354 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 225 Lot Size: 354 Area: Estepona Region: Andalucía
DESIGN AND FUNCTIONALITY, This new construction offers a two-story home and office with spacious rooms, access to a sun terrace and private garden on the ground floor, It is fully equipped with a (...)
€2,750,000
TSEA4446295
- Manilva, Costa Del Sol, Manilva
Beds: 5 Baths: 7 M2: 480 Lot Size: 1,400 Area: Manilva Region: Andalucía
Beds: 5 Baths: 7 M2: 480 Lot Size: 1,400 Area: Manilva Region: Andalucía
SEIZE THE OPPORTUNITY: SPECTACULAR HOME WITH MODERN AMENITIES AWAITS!!
With 5 bedrooms and 7 bathrooms, it is perfect for a large family or for those who love to entertain guests. The property (...)
