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 (42,68,69,70)
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 (42,68,69,70)
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 (42,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 321 - 340 of 2740
€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,851,000
TSEA5129251
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 441 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 441 Area: Marbella West Region: Andalucía
We offer this spacious house for sale, located in the coastal town of Marbella, province of Málaga. It has a built area of 441 m², distributed among three bedrooms, a living-dining room, a kitchen, (...)
€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 (...)
€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 (...)
€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 (...)
€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 (...)
€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 (...)
€421,000
TSEA5128690
- Ciudad Jardín, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 178 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 178 Area: Marbella Region: Andalucía
Hello! I want to offer you an excellent opportunity in a quiet area of Málaga Capital: a charming townhouse located in Monte Dorado. This property is distributed over two floors and has a small (...)
€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 (...)
Current Featured Properties
€465,000
TSEA4292032
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
LARGE GARDEN, AMAZING VIEWS AND GYM!!!
In an incomparable enclave with magnificent views, a project of 40 semi-detached and semi-detached houses with 3 and 4 bedrooms with large terraces to enjoy (...)
€570,000
TSEA4975855
- La Heredia, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
LA PERLA DE LA HEREDIA , BENAHAVIS.
This charming townhouse is located in the cozy village of La Perla de la Heredia, just off Ronda Road. It faces south to southwest, offering lovely views of the (...)
€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 (...)
