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
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
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
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1141 - 1160 of 7575
€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. (...)
€990,000
TSEA5127502
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 320 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 320 Area: Marbella Region: Andalucía
We present this exclusive duplex property located in one of the most privileged areas of Marbella. The property has a total of 220 square meters built and also includes an additional 100 square (...)
€479,000
TSEA5127475
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Bright 2-Bed, 2-Bath Apartment Just 300m from the Beach – Torreblanca
Spacious and sunny 143m² southwest-facing apartment all on one level, featuring 2 bedrooms, 2 bathrooms, and a huge private (...)
€516,000
TSEA5127403
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 114 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Area: Casares Region: Andalucía
Fantastic 2-bedroom beachfront apartment just 75 meters from the sea, located in the prestigious gated community in Casares beach, surrounded by beautiful tropical gardens. Situated on a ground floor (...)
€349,500
TSEA5127388
- La Cala Hills, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 129 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 129 Area: Mijas and Mijas Costa Region: Andalucía
SparklingSouth- West Facing - Sunlit 2‑Bed, 2‑Bath Apartment with Uninterrupted Fuengirola Views - Freshly Painted and Refurbished !
Welcome to your serene sanctuary in La Cala Hills—a (...)
€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 (...)
€595,000
TSEA5127382
- Higueron, Costa Del Sol
Beds: 3 Baths: 2 M2: 92 Region: Andalucía
Beds: 3 Baths: 2 M2: 92 Region: Andalucía
This brand-new apartment with 3 spacious bedrooms and 2 bathrooms combines modern design with high-quality finishes. Its open-plan living room and open-plan kitchen blend with a spectacular terrace, (...)
€298,000
TSEA5127373
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 141 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Area: San Pedro Region: Andalucía
Apartment in the Center of San Pedro Alcántara – Marbella
Located on the 5th floor, (with lift and parking) this property is a great opportunity for those looking to live or invest in one of the (...)
€325,000
TSEA5127364
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 66 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 66 Area: Mijas and Mijas Costa Region: Andalucía
LOCATION LOCATION LOCATION !!!! Only a 4 minute walk to the beach; super markets; restaurants and shops of Riviera Del Sol you can find this beautifully presented 2 bedroom 1 bathroom apartment ! (...)
€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 (...)
€775,000
TSEA5127328
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 110 Lot Size: 55 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Lot Size: 55 Area: Benahavis Region: Andalucía
Located in the charming and modern Paraiso Pueblo urbanisation in Benahavís, we present this spacious ground-floor apartment with 3 bedrooms and 2 bathrooms. The property offers both a front and (...)
€845,000
TSEA5127307
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 200 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Area: Estepona Region: Andalucía
Fantastic 201m2 built,183 m2 usable ground floor south oriented apartment (elevated 2 meters above ground floor), fully furnished in a new beach side urbanization located in the heart of the (...)
€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 (...)
€625,000
TSEA5127289
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 114 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Area: Fuengirola Region: Andalucía
Wake Up to the Mediterranean – Frontline Beach Apartment in Fuengirola
Wake up every morning to the sound of the waves and breathtaking, uninterrupted views of the Mediterranean Sea. This 97 m² (...)
€690,000
TSEA5127274
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 204 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 204 Area: Marbella Region: Andalucía
Exclusive 3-Bedroom Townhouse in One of Marbella's Finest Areas
Discover this magnificent three-storey home located in a peaceful and well-maintained gated community of just 36 houses, in one of the (...)
€390,000
TSEA5127271
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 102 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Manilva Region: Andalucía
Immaculate 2-Bedroom Apartment with Stunning Sea Views near Sotogrande.
This recently updated and beautifully maintained apartment offers 2 spacious bedrooms with fitted wardrobes and 2 bathrooms (...)
€890,000
TSEA5127253
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 89 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 89 Area: Benahavis Region: Andalucía
Originally a 2-bedroom home, this elegant apartment has been completely refurbished to the highest standards, with a modern and practical layout that makes the most of every space.
The custom-made (...)
€330,000
TSEA5127244
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 103 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: Marbella East Region: Andalucía
Beautiful ground floor two bedroom luxury apartment with outstanding panoramic views.
Quality fittings throughout.
Superbly maintained ready to move in.
Extra addition of glass curtains creating more (...)
Current Featured Properties
€665,000
TSEA4358878
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 112 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Fuengirola Region: Andalucía
A DEVELOPMENT THAT YOU WILL WANT TO VIEW!!!
Spectacular new development of 60 luxury apartments in the most sought-after area of El Higuerón, in a gated exclusive community with gym, heated pool, (...)
€626,500
TSEA4557622
- Aloha, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 114 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Area: Marbella West Region: Andalucía
Private residential complex with an innovative design inspired by the architecture of the area. 70 spacious 2 and 3 bedroom flats with magnificent terraces and 24 hour security. Each flat offers an (...)
€621,000
TSEA4732852
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 118 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Area: Casares Region: Andalucía
Located within the Casares Costa Golf course it has only 74 Apartments and 17 penthouses, with 2 and 3 bedrooms, which is a low construction density oasis of serenity thanks to its. Spacious and (...)
