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 (70,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 (70,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 (70,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 401 - 420 of 4559
€325,000
TSEA5142982
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 85 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Benalmadena Region: Andalucía
Discover your new home in this spectacular, fully renovated apartment, just a 5-minute walk from the beach! With a charming terrace offering stunning sea views, this space is perfect for enjoying the (...)
€309,000
TSEA5142808
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Middle Floor, 2 Bed, 2 Bath Apartment in Mijas, Costa del Sol
Discover this charming middle-floor apartment located in the picturesque area of Mijas, Costa del Sol. This property offers an ideal (...)
€429,000
TSEA5142796
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 77 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Marbella East Region: Andalucía
This is a great apartment for sale tight in the famous port of Cabopino in East Marbella. Originally this was a very large 1 bedroom apartment, but the owner has cleverly converted it into a two (...)
€390,000
TSEA5142793
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 59 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 59 Area: Estepona Region: Andalucía
Elegant Penthouse with Rooftop Jacuzzi and Breathtaking Sea Views
This beautifully renovated penthouse is located in the sought-after Sun Gardens urbanization in Estepona East. The community offers (...)
€300,000
TSEA5142781
- 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
Fully Renovated Duplex Penthouse with Enclosed Terrace & Private Parking
Experience comfort and exclusivity in this fully renovated duplex penthouse, where the owners have added numerous extras (...)
€840,000
TSEA5142754
- El Rosario, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 213 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 213 Area: Marbella East Region: Andalucía
Incredible 3-bedroom penthouse with stunning views of the sea and Marbella Golf course! Located in the exclusive El Lagar del Rosario residential area, this property is perfect for those looking for (...)
€575,000
TSEA5142745
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
Andalusian Charm Meets Modern Comfort in the Heart of Nueva Andalucía
Welcome to La Maestranza, a unique residential complex built in the style of a traditional Spanish village, complete with (...)
€378,000
TSEA5142739
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
We are pleased to offer for sale this fabulous well-maintained 3 bedroom 2 bathroom apartment close to amenities and near the beach.
The apartment is an elevated ground floor and benefits a closed (...)
€445,000
TSEA5142721
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 109 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 109 Area: Marbella West Region: Andalucía
Beautiful garden apartment in Le Village, one of the most complete urbanisations in Nueva Andalucía, Marbella.
This apartment has two bedrooms and two bathrooms, one of which is en suite. There is (...)
€769,000
TSEA5142685
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 155 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 155 Area: Estepona Region: Andalucía
Elegant 2-Bedroom Apartment for Sale in Bahía de la Plata – Frontline Beach, Estepona
Bright Two Bedroom First-Floor Corner Apartment with Sunny Terrace, Sea Views & Privacy in Prime (...)
€510,000
TSEA5142682
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
This duplex penthouse with touristic license, comes fully furnished and beautifully decorated, and offers incredible panoramic views of La Concha Mountain, El Paraiso Golf Course, and the (...)
€360,000
TSEA5142676
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 131 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 131 Area: Estepona Region: Andalucía
2-bedroom apartment for sale with wonderful views in the centre of Estepona
Located on the highest floor of the building, offering wonderful views, in the centre of Estepona.
Built in 2006, (...)
€490,000
TSEA5142649
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
EXCLUSIVE MODERN PROPERTY IN ONE OF ESTEPONA'S MOST SOUGHT-AFTER AREAS, WITH HIGH-QUALITY FINISHES, TWO PARKING SPACES AND A STORAGE ROOM.Prime location in one of Estepona's most desirable and (...)
€450,000
TSEA5142637
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Fully renovated garden apartment in Estepona Port's boutique community – La Fragata.
Beautifully refurbished 2-bedroom garden apartment in the exclusive La Fragata community, a boutique complex (...)
€230,000
TSEA5142619
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Loveley one bedroom property , which could be good for a permenant living or a holiday home. apartment located between Mijas Pueblo ( pictures Andalusian village ) and Fuengirola (very busy sea side (...)
€359,000
TSEA5142613
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 64 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 64 Area: Benalmadena Region: Andalucía
Beautiful apartment for sale in Puerto Marina, Benalmadena
???? APARTMENT FOR SALE IN PUERTO MARINA, BENALMÁDENA! ???? Unbeatable location, next to the marina. ✨ With a holiday rental license – (...)
€400,000
TSEA5142571
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 100 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Benahavis Region: Andalucía
Discover this exclusive apartment in a quiet residential area located in Puerto del Almendro/Los Arqueros, with a large terrace, creating a unique space to enjoy the sun and the Mediterranean (...)
€320,000
TSEA5142562
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 73 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 73 Area: La Duquesa Region: Andalucía
Stylish south facing two bedroom, two bathroom apartment located within this much sought after urbanisation of Vistalmar, between Sotogrande and La Duquesa marina. Set within a secure gated and quiet (...)
€605,000
TSEA5142559
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Stunning Renovated Apartment in the Heart of Marbella!
Discover elegance and comfort in this magnificently renovated 78 m² apartment, perfectly situated in the vibrant center of Marbella. Nestled (...)
€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 (...)
Current Featured Properties
€1,549,739
TSEA4892602
- New Golden Mile, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 254 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 254 Area: Estepona Region: Andalucía
Introducing an exclusive luxury housing project located on the coveted New Golden Mile, Estepona. This stunning development offers 3, 4 and 5 bedroom apartments, with surfaces ranging from 200 to 300 (...)
€369,000
TSEA4282294
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
YOU COULD NOT ASK FOR A BETTER LOCATION!!
Exclusive multi-family homes of 2 and 3 bedrooms located in the privileged surroundings of the Golden Mile of Estepona. The homes enjoy large terraces (...)
€732,000
TSEA4853869
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 87 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 87 Area: Estepona Region: Andalucía
This development offers 36 beautiful single-storey homes with large rooms, the option of 2 or 3 bedrooms, 2 bathrooms and large terraces with beautiful panoramic views. They have a fully equipped (...)
