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,39,40,41,162,163)
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,39,40,41,162,163)
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,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1761 - 1780 of 5891
€1,195,000
TSEA5077189
- El Coto, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 307 Lot Size: 892 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 307 Lot Size: 892 Area: Mijas and Mijas Costa Region: Andalucía
DREAM VILLA RENOVATED IN EL COTO (MIJAS)
We present you this spectacular villa, renovated in 2025, located in one of the most sought-after residential areas of Mijas: El Coto. The perfect spot for (...)
€549,000
TSEA5077162
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 96 Lot Size: 431 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 96 Lot Size: 431 Area: Mijas and Mijas Costa Region: Andalucía
Charming 3-Bedroom Detached Villa with Panoramic Views in Sought-After Mijas La Nueva
An exceptional opportunity to purchase a beautifully presented 3-bedroom, 3-bathroom detached villa in the (...)
€855,000
TSEA5076904
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 3 M2: 199 Lot Size: 449 Area: Coin Region: Andalucía
Beds: 4 Baths: 3 M2: 199 Lot Size: 449 Area: Coin Region: Andalucía
Modern Luxury Villa with 4 Bedrooms and 3 Bathrooms - Perfect Combination of Comfort and Location
Discover this beautiful, move-in ready villa where luxury, comfort and modern architecture come (...)
€995,000
TSEA5076871
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 112 Lot Size: 92 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Lot Size: 92 Area: Benahavis Region: Andalucía
Luxurious and spacious 2 bedroom apartment in Urbanization La Alborada in Benhavis with the name Aqualina a sprestieux apartment complex with all luxury high-quality finishes and with fantastic sea (...)
€4,500,000
TSEA5076856
- Casares, Costa Del Sol, Casares
Beds: 5 Baths: 5 M2: 675 Lot Size: 1,233 Area: Casares Region: Andalucía
Beds: 5 Baths: 5 M2: 675 Lot Size: 1,233 Area: Casares Region: Andalucía
Ibiza-style villa located within the Finca Cortesin resort. Set on a large plot with landscaped gardens, the property offers panoramic views of the golf course and surrounding mountains. The villa is (...)
€275,000
TSEA5076823
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 43 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 43 Area: Estepona Region: Andalucía
This beautifully renovated 1-bedroom apartment offers a rare opportunity to enjoy contemporary living in one of Estepona's most sought-after coastal enclaves. Situated just 200 metres from the beach (...)
€1,750,000
TSEA5076748
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 3 M2: 183 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 3 M2: 183 Area: Torremolinos Region: Andalucía
Exclusive four bedroom penthouse in Los Alamos (Torremolinos), closed with access control gate, with two parking spaces and storage room.
It has four bedrooms, two bathrooms and a toilet, a (...)
€949,000
TSEA5076703
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 108 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Malaga Region: Andalucía
Step into elevated elegance in the heart of Malaga with this exquisite three-bedroom, two-bathroom residence located on the twenty-fourth floor of the iconic AQ Urban Sky South Tower. Soaring above (...)
€595,000
TSEA5076691
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 1 Baths: 1 M2: 76 Area: Torremolinos Region: Andalucía
Beds: 1 Baths: 1 M2: 76 Area: Torremolinos Region: Andalucía
Step into the essence of refined coastal living with this exquisite one-bedroom resale property in the prestigious, an exclusive beachfront enclave in the heart of Torremolinos. Bathed in golden (...)
€595,000
TSEA5076667
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
MEDITERRANEAN ELEGANCE WITH SEA VIEWS & 24H SECURITY
2 Bedrooms | 2 Bathrooms | Private Terrace | Concierge & Security 24/7 | Pool | Parking
Discover the timeless charm of Mediterranean (...)
€255,000
TSEA5076661
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 90 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 90 Area: La Duquesa Region: Andalucía
Renovated Penthouse with Spacious Terrace and Sea Views in La Duquesa – Style, Light and an Unbeatable Location
Discover this charming penthouse located in a quiet residential area of La Duquesa, (...)
€450,000
TSEA5076643
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 115 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Marbella West Region: Andalucía
Ideally situated in the heart of Nueva Andalucía, this spacious apartment for sale offers the perfect blend of comfort, convenience, and lifestyle. Featuring 2 bedrooms and 2 bathrooms, along with a (...)
€629,000
TSEA5076619
- Coín, Costa Del Sol, Coin
Beds: 5 Baths: 3 M2: 314 Lot Size: 2,151 Area: Coin Region: Andalucía
Beds: 5 Baths: 3 M2: 314 Lot Size: 2,151 Area: Coin Region: Andalucía
Fully reformed and very spacious villa located on the edge of Coin town centre in a very private area. The location is wonderfully peaceful yet just a 10 minute walk to local shops and restaurants. (...)
€725,000
TSEA5076535
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 150 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 150 Area: Mijas and Mijas Costa Region: Andalucía
Renovated duplex penthouse, finished with exclusive luxury materials!!
The duplex penthouse enjoys a great location between Fuengirola and Marbella, offering easy access to both towns. It features (...)
€370,000
TSEA5076532
- Torremolinos Centro, Costa Del Sol, Torremolinos
Beds: 3 Baths: 1 M2: 65 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 1 M2: 65 Area: Torremolinos Region: Andalucía
An excellent opportunity to purchase a terraced house located in the heart of Torremolinos, Malaga, with the possibility of building three more floors.
This property, renovated in 2004, stands out (...)
€1,975,000
TSEA5076520
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 208 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 208 Area: Marbella East Region: Andalucía
Wonderful three bedroom, south east facing duplex penthouse in the exclusive and gated community of Monte Paraiso on the Golden Mile, with 24hr security, several outdoor swimming pools, a (...)
€449,000
TSEA5076505
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 80 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Malaga Region: Andalucía
Experience high-rise living in the heart of Malaga! This elegant 2-bedroom, 2-bathroom apartment is located on the 25th floor of the iconic Malaga Urban Sky Tower, offering breathtaking panoramic (...)
€550,000
TSEA5076412
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 114 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Mijas and Mijas Costa Region: Andalucía
Elegant 3-Bedroom Retreat in Vitta Nature, Mijas where Comfort Meets Coastal Luxury with Tourist Licence in place.
Welcome to your perfect escape on the Costa del Sol. Nestled within the exclusive (...)
€2,100,000
TSEA5076394
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 3 M2: 275 Lot Size: 650 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 3 M2: 275 Lot Size: 650 Area: San Pedro Region: Andalucía
DETACHED VILLA IN SAN PEDRO DE ALCÁNTARA
Magnificent villa located in one of the most sought-after areas of San Pedro de Alcántara, just minutes from the center, the beach, the prestigious (...)
€463,000
TSEA5076364
- Martiricos, Costa Del Sol
Beds: 2 Baths: 2 M2: 84 Region: Andalucía
Beds: 2 Baths: 2 M2: 84 Region: Andalucía
GREAT OPPORTUNITY! Just 10 minutes from the beach
Spectacular property located in one of the most impressive skyscrapers in the city of Málaga, within one of the most modern residential complexes. (...)
Current Featured Properties
€423,000
TSEA5147983
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 86 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 86 Area: Casares Region: Andalucía
This new development is set in an exceptional location between the highly sought-after towns of Casares and Estepona, two of the most treasured enclaves on the Costa del Sol.
Comprising ten (...)
€525,000
TSEA5128906
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 107 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 107 Area: Benahavis Region: Andalucía
Located in the heart of Benahavís, a new residential development is being launched featuring 28 Mediterranean-style apartments with 1, 2, or 3 bedrooms. Each home includes a private underground (...)
€1,350,000
TSEA4752841
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 119 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 119 Area: Estepona Region: Andalucía
redefining contemporary living in the Golden Triangle. A sublimely stylish development, discretely blending with its surrounding environment, the 88 units of Naya Residences offer the discerning (...)
