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 1301 - 1320 of 7575 €535,000
TSEA5122780
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 71 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Benalmadena Region: Andalucía
Recenlty refurbished south facing apartment located in the exclusive urbanization Reserva del Higuerón, with 2 bedrooms, 2 bathrooms, living-dining room, open plan kitchen fully furnished and (...)
€1,750,000
TSEA5122768
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 183 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 183 Area: Benalmadena Region: Andalucía
Contemporary Coastal Luxury State-of-the-Art Villa in Exclusive Urbanization Marae, Benalmádena Costa
Welcome to this stunning fusion of cutting-edge design, breathtaking views, and luxury living, (...)
€765,000
TSEA5122762
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 150 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: Marbella West Region: Andalucía
Beautiful brand new 3-bedrooms penthouse nicely furnished with spacious terraces in one of the fastest growing areas of Nueva Andalucía.
The development is located in one of the most popular areas (...)
€365,000
TSEA5122759
- La Viñuela, Costa Del Sol East
Beds: 3 Baths: 2 M2: 113 Lot Size: 600 Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Lot Size: 600 Region: Andalucía
La Alzambra de La Viñuela
3-bedroom, 2-bathroom villas on plots over 600 m², just 15 min from the coast and 45 min from Málaga Airport.
Fully equipped kitchen, furniture and appliances, PVC (...)
€575,000
TSEA5122744
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 115 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Mijas and Mijas Costa Region: Andalucía
SPECTACULAR PENTHOUSE WITH SEA VIEWS
We are pleased to present this spectacular penthouse refurbished this year 2025. With a modern and contemporary concept, the property is located in a private (...)
€490,000
TSEA5122723
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 95 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 95 Area: San Pedro Region: Andalucía
NEW LISTING! Modern Apartment in the heart of San Pedro de Alcantara (ONLY UNIT IN THE COMPLEX AVAILABLE )
Stylishly converted 3-bedroom apartment for sale in the sought-after new constructed (...)
€690,000
TSEA5122720
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 109 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Area: Marbella West Region: Andalucía
Located in the exclusive urbanisation of Los Dragos, in the heart of Nueva Andalucía, you will find this recently refurbished turnkey property. With a modern and functional design, the property has (...)
€675,000
TSEA5122717
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 132 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Marbella West Region: Andalucía
Beautiful brand new 3-bedrooms penthouse nicely furnished with spacious terraces in one of the fastest growing areas of Nueva Andalucía.
The development is located in one of the most popular areas (...)
€447,000
TSEA5122714
- La Victoria, Costa Del Sol
Beds: 3 Baths: 2 M2: 81 Region: Andalucía
Beds: 3 Baths: 2 M2: 81 Region: Andalucía
Middle Floor Apartment, La Victoria, Málaga Ciudad.
3 Bedrooms, 2 Bathrooms, Built 81 m², Terrace 5 m².
Setting : Town, Close To Port, Close To Sea.
Orientation : South.
Condition : Under (...)
€1,300,000
TSEA5122711
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 165 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 165 Area: Marbella West Region: Andalucía
Modern and comfortable apartment located in luxury urbanization Las Gaviotas, with 3 double bedrooms ensuit. Large terrace with chill out area and dining.
3 swimming pools and children pools. 24 (...)
€890,000
TSEA5122708
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 144 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 144 Area: Marbella Region: Andalucía
Elite and secure 2 bedrooms, 2 bathrooms duplex penthouse located in the luxury vacation resort La Alzambra Vasari Resort.
Beautiful tropical garden with large swimming lool, waterfalls, summer (...)
€150,000
TSEA5122699
- Villanueva de Algaidas, Costa Del Sol, Antequera
Beds: 5 Baths: 2 M2: 350 Lot Size: 2,788 Area: Antequera Region: Andalucía
Beds: 5 Baths: 2 M2: 350 Lot Size: 2,788 Area: Antequera Region: Andalucía
Andalusian Dream: Dual Property with Scenic Views & Tourism Potential in Villanueva de Algaidas
Welcome to your next great opportunity — a charming dual-property finca located in the heart of (...)
€1,575,000
TSEA5122693
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 243 Lot Size: 602 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 243 Lot Size: 602 Area: Benalmadena Region: Andalucía
New Development: Prices from 1,575,000 € to 1,575,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 243.00 m2 - 243.00 m2]
Well-Located and Stylish Villa with Sea View in Benalmadena
This (...)
€350,000
TSEA5122687
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 110 Lot Size: 30 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Lot Size: 30 Area: Marbella East Region: Andalucía
Semi-detached house in the Marbella reserve area.
Direct access from the garage door, it is also allowed to park the car at the same door.
Large front patio with awning and a storage room.
On the (...)
€730,000
TSEA5122318
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 175 Lot Size: 875 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 175 Lot Size: 875 Area: Mijas and Mijas Costa Region: Andalucía
**Beautiful One-Level Villa with Private Pool – Fuengirola / Cerros del Águila**
Welcome to this charming and well-maintained villa located in the peaceful and sought-after urbanisation **Cerros (...)
€1,495,000
TSEA5122306
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 338 Lot Size: 500 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 338 Lot Size: 500 Area: Sotogrande Region: Andalucía
Situated within an exclusive gated enclave of the prestigious La Reserva Club, this striking villa delivers a rare combination of frontline golf views, sea vistas, and seamless indoor-outdoor living (...)
€529,500
TSEA5122288
- El Rosario, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 155 Lot Size: 167 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 155 Lot Size: 167 Area: Marbella East Region: Andalucía
Tucked just 50 meters from the golden sands of the Mediterranean, this refined ground-floor apartment in the coveted Alicate Playa community offers an exceptional opportunity to embrace the very best (...)
€380,000
TSEA5122282
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Welcome to this beautiful 2-bedroom, 2-bathroom apartment, located in the highly sought-after Sunset Golf residential complex, nestled in the peaceful surroundings of La Resina Golf in Estepona.
The (...)
€435,000
TSEA5122192
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 95 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Marbella West Region: Andalucía
Albatros IV is a development situated in the Nueva Andalucia (La Campana) area of Marbella. A modern construction walking distance of all local amenities and well connected to Marbella, Puerto Banús (...)
€990,000
TSEA5122162
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 460 Lot Size: 1,200 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 460 Lot Size: 1,200 Area: Sotogrande Region: Andalucía
Spacious 5-Bedroom Family Villa in Sotogrande – Under €1M!
1200 m2 plot and 460 m2 built
This charming 5-bedroom, 5-bathroom villa (3 ensuite) is the perfect family home, offering both comfort (...)
Current Featured Properties
€907,852
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA.
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 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 (...)
€384,000
TSEA4297042
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
NEW OFF PLAN DEVELOPMENT, ON THE EDGE OF ESTEPONA!
Consisting of seven housing blocks with a total of 132 homes with 1, 2, 3 and 4 bedrooms with a garage, storage room, community pool for adults and (...)
€900,000
TSEA5037085
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
The exclusive residential complex invites you to a modern lifestyle infused with traditional Andalusian charm, all within a community designed for those who appreciate quality and natural beauty. At (...)
