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 (43,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 (43,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 (43,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 361 - 380 of 4189 €410,000
TSEA5143036
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 111 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: La Duquesa Region: Andalucía
Discover Paradise: Stunning Penthouse with Panoramic Sea Views and Direct Beach Access
Breathtaking Views and Space: Enjoy 180º panoramic sea views from a massive 110 m² terrace, complemented by (...)
€249,500
TSEA5143003
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
Middle Floor Apartment, Benalmadena, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 49 m².
Possibility of turistic licence
Setting : Town, Urbanisation.
Condition : Excellent.
Features : Covered (...)
€629,000
TSEA5142994
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Spacious Ground-Floor Apartment with Private Garden
This bright and spacious ground-floor apartment offers the perfect balance between comfort, style, and outdoor living. With 3 bedrooms and 2 (...)
€319,000
TSEA5142985
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 143 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 143 Area: Mijas and Mijas Costa Region: Andalucía
Discover this spectacular frontline golf penthouse. With a completely renovated and tastefully decorated design, this home features two spacious bedrooms and two full bathrooms, perfect for enjoying (...)
€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 – (...)
Current Featured Properties
€490,000
TSEA5058604
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
This new development in the Estepona Centre comprising 43 one, two and three bedroom apartments and penthouses, terraces and magnificent communal areas. It boasts excellent finishes, a prime location (...)
€2,390,000
Luxury development, top class views!
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 218 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 218 Area: Benahavis Region: Andalucía
LUXURY RESIDENTIAL COMPLEX BETWEEN MARBELLA & BENAHAVÍS!!!
The development enjoys breath-taking views from its huge terraces across the Mediterranean Sea towards Gibraltar and the coasts of (...)
€735,000
TSEA4677262
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 96 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 96 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 (...)
