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 (31,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 (31,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 (31,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 441 - 460 of 4730 €330,000
TSEA5142508
- El Padron, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Imagine waking up every morning in a spacious 110 m² duplex penthouse, meticulously designed for your maximum comfort. Enjoy two bedrooms, each with its own en-suite bathroom, ensuring the privacy (...)
€685,000
TSEA5142505
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 142 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 142 Area: Marbella Region: Andalucía
This elegant duplex in Santa Clara Golf, Marbella, is spread over two floors, offering spacious and
comfortable areas. On the ground floor, there is a large living room that connects with the (...)
€424,000
TSEA5142502
- Centro Histórico, Costa Del Sol
Beds: 1 Baths: 1 M2: 45 Region: Andalucía
Beds: 1 Baths: 1 M2: 45 Region: Andalucía
Fantastic investment opportunity in the heart of Málaga's historic center. Just 35 meters from the charming Plazuela San Juan de Dios, this first-floor apartment (no elevator) is located in a (...)
€890,000
TSEA5142223
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 120 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Marbella Region: Andalucía
Perfectly located ground floor apartment in a popular and well established urbanisation in the centre of Marbella.
The property is located on the ground floor and has a substantial terrace with (...)
€1,070,000
TSEA5142214
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Discover this exclusive third-floor apartment in a prestigious frontline beach development, ideally situated in the heart of Puerto Banús, Marbella.
The apartment offers two bedrooms, two bathrooms, (...)
€449,900
TSEA5142202
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 160 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Area: Marbella West Region: Andalucía
Spacious 3-Bedroom Apartment Just Minutes from Puerto Banús and the Beach
Only a couple of minutes from the glamour of Puerto Banús and Marbella's golden beaches, this spacious apartment (154 m² (...)
€574,000
TSEA5142196
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 137 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Mijas and Mijas Costa Region: Andalucía
Dreaming of life in idyllic Mijas Pueblo?
Welcome to your new home – an exclusive and modernly renovated 3-bedroom duplex apartment located in the heart of this charming whitewashed village.
This (...)
€430,000
TSEA5142190
- Diana Park, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 142 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 142 Area: Estepona Region: Andalucía
Cortijo del Mar, Estepona. Located within this wonderful and secure urbanisation with large lagoon swimming pool, chiringuito area, lush tropical gardens and 24 hour security. Within walking (...)
€320,000
TSEA5142181
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful 2 bedroom top floor apartment with large sunny terrace in the well-known Lew Hoad Village, located on the road towards Mijas in beautiful surroundings with views of the mountains and a (...)
€530,000
TSEA5142139
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 91 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 91 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 91 m².
Setting : Beachfront, Town, Beachside, Close To Sea.
Orientation : South.
Condition : Excellent.
Climate (...)
€530,000
TSEA5142130
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
This bright apartment combines comfort and location in an exclusive setting in the Resina/Selwo area. Located in a private residential complex surrounded by gardens and tranquility, it is perfect for (...)
€1,095,000
TSEA5141947
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 130 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Marbella East Region: Andalucía
Welcome to Sierra Club Residence, a luxurious apartment located in the exclusive gated community of Urbanization Club Sierra. Thanks to its prime location, this apartment ensures you are always in (...)
€2,499,000
TSEA5141899
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 5 M2: 375 Lot Size: 1,034 Area: Estepona Region: Andalucía
Beds: 3 Baths: 5 M2: 375 Lot Size: 1,034 Area: Estepona Region: Andalucía
Turnkey ready luxury property for sale in Valle Romano, Estepona West, designed by the prestigious Atlas Group and due for completion in early 2026. This three-story villa combines sleek contemporary (...)
€415,000
TSEA5141866
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 93 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Benalmadena Region: Andalucía
Discover your new home in the heart of the Costa del Sol! This stunning, brand-new apartment boasts 2 spacious bedrooms and 2 modern bathrooms, designed for comfort and style. Its undeniable (...)
€449,000
TSEA5141815
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 3 M2: 140 Area: Casares Region: Andalucía
Beds: 4 Baths: 3 M2: 140 Area: Casares Region: Andalucía
Penthouse Duplex, Casares, Costa del Sol.
4 Bedrooms, 3 Bathrooms, Built 140 m², Terrace 12 m².
Setting : Town, Close To Shops, Close To Schools, Close To Forest.
Orientation : South East, North (...)
€449,000
TSEA5141803
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 79 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 79 Area: Fuengirola Region: Andalucía
PROBABLY THE BEST TERRACE IN THE AREA WITH ALL DAY SUN!
This beautiful penthouse boasts a spectacular terrace with breathtaking views of the mountains, the sea, and the castle. The terrace is (...)
€395,000
TSEA5141773
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 4 M2: 195 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 4 M2: 195 Area: Benahavis Region: Andalucía
A very well presented and spacious 5 bedroom /4 bathroom apartment in the heart of beautiful Benahavis.
This large property is situated in the most perfect location for access to all amenities (...)
€795,000
TSEA5141764
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 199 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 199 Area: Fuengirola Region: Andalucía
Come and discover this stunning townhouse, designed to combine comfort, technology, and a sustainable lifestyle.
The basement features a spacious garage with room for two cars, and a multi-purpose (...)
€489,000
TSEA5141719
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 5 M2: 239 Area: Manilva Region: Andalucía
Beds: 3 Baths: 5 M2: 239 Area: Manilva Region: Andalucía
**Elegant 3-Storey Townhouse + Basement with Panoramic Sea Views and the Rock of Gibraltar – Manilva**
Discover this exceptional and spacious townhouse, perfectly located in a quiet and secluded (...)
€449,000
TSEA5141710
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 90 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 90 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 90 m², Terrace 15 m².
Setting : Town, Commercial Area, Beachside, Village, Close To Port, Close To Shops, Close To (...)
Current Featured Properties
€279,000
TSEA4452184
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 77 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Manilva Region: Andalucía
This innovative real estate project consists of 60 multi-family dwellings, offering 2 and 3-bedroom apartments, all equipped with garage and storage room in the basement. The blocks are distributed (...)
€1,960,000
TSEA4893418
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 217 Lot Size: 18 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 217 Lot Size: 18 Area: Marbella Region: Andalucía
A community of 27 opulent semidetached homes with expansive rooms, private gardens, swimming pools, and prime sea views can be found in Marbella at The List Rio Real. Because to its multi-level (...)
€825,000
TSEA4340413
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
EVERYONE IS TALKING ABOUT MOVING TO MIJAS!!!
Located in La Cala de Mijas, one of the urban centers belonging to the municipality of Mijas. Just a 5-minute drive from the residential area, you can (...)
