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 (41,36,37,38)
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 (41,36,37,38)
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 (41,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 41 - 60 of 792
€660,000
TSEA5147296
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
In the prestigious Phase I of the Residential Complex "Ipanema, by Kronos Homes", located in the municipality of Mijas, lies this exclusive penthouse, which combines modern design, (...)
€480,000
TSEA5147146
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 102 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Marbella East Region: Andalucía
Master en-suite with full bathroom, dressing room, and direct access to the terrace through double-glazed sliding doors.
Second double bedroom with built-in wardrobe, access to the terrace, and (...)
€470,000
TSEA5147062
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 104 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 104 Area: Marbella Region: Andalucía
Charming penthouse in the heart of Marbella, 400 metres from the city's best beaches, the Paseo Marítimo and a minute's walk from Marbella's Old Town.
This duplex penthouse consists of two very (...)
€5,950,000
TSEA5147056
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 221 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 221 Area: Marbella West Region: Andalucía
In the heart of Puerto Banús, within the prestigious residential complex Los Granados, stands this spectacular duplex penthouse, an exceptional property that redefines seafront luxury.
From its (...)
€750,000
TSEA5146240
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 187 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 187 Area: Estepona Region: Andalucía
Located in the very centre of Estepona, this modern duplex penthouse offers the perfect combination of urban convenience and Mediterranean charm. Its privileged setting places you within walking (...)
€435,000
TSEA5146048
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 101 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Casares Region: Andalucía
Stunning Sea View Penthouse – Just 300m from the Beach
Discover this exceptional 3-bedroom, 2-bathroom penthouse located only a short 5-minute walk (300m) from the golden sandy beaches of (...)
€449,500
TSEA5145130
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Just Listed – Exceptional 2-Bed, 2-Bath Top Apartment with Breathtaking Mediterranean Views - Tourist Licences Permitted !
Welcome to your dream coastal home – where contemporary style meets (...)
€345,000
TSEA5144836
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 124 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Casares Region: Andalucía
Stunning 3-Bedroom Penthouse in Casares Costa
This spacious and beautifully presented penthouse is ideally located in Casares Costa, just a short drive from the beach and all local amenities. (...)
€1,100,000
TSEA5143897
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 121 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 121 Area: Benahavis Region: Andalucía
This stunning top floor apartment., set within the prestigious La Quinta Golf resort, offers an elegant & sophisticated interior with breathtaking panoramic views.
Having been renovated recently (...)
€495,000
TSEA5143876
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Discover this stunning, fully furnished apartment in the heart of Estepona, offering modern luxury and comfort. Recently renovated with top-quality materials, it features a spacious three-bedroom (...)
€475,000
TSEA5143807
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Top-Floor Living close to the Sea – Penthouse For Sale
Looking for something special? This bright and modern penthouse ticks all the boxes — stunning sea views, a spacious 40 m² terrace, and a (...)
€415,000
TSEA5143774
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 92 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 92 Area: Marbella Region: Andalucía
Stunning & Spacious 2-Bedroom Apartment in the Heart of Marbella
Discover your dream home in this beautiful 85 m² apartment (90 m² built) located in the vibrant Avenida General López (...)
€415,000
TSEA5143771
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 90 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 90 Area: Estepona Region: Andalucía
Top Floor Apartment, Estepona, Costa del Sol.
3 Bedrooms, 1 Bathroom, Built 90 m², Terrace 15 m².
Setting : Town, Close To Port, Close To Shops, Close To Sea, Close To Town, Close To Schools, (...)
€675,000
TSEA5143657
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
This beautiful 3 bedroom 2 bathroom penthouse nestled in the heart of Nueva Andalucia must be seen. With an expansive terrace and solarium totally nearly 100 sqm means there is a multitude of outdoor (...)
€2,995,000
TSEA5143633
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Bahía del Velerín is a luxurious community between Marbella and Estepona. It has a fantastic pool area with a snack bar, tropical gardens and 24/7 security. The community is located at one of the (...)
€2,695,000
TSEA5143117
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Located between Marbella and Estepona, Bahía del Velerín is a prestigious community with a beautiful pool area, a snack bar, lush tropical gardens, and 24/7 security.
This fully renovated penthouse (...)
€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 (...)
€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 (...)
€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 (...)
Current Featured Properties
€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 (...)
€759,650
TSEA4631314
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 86 Lot Size: 35 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Lot Size: 35 Area: Estepona Region: Andalucía
UNIQUE OPPORTUNITY IN ESTEPONA TOWN. JUST A FEW UNITSS LEFT, HURRY!
2 Beds starting from 382,000€ and 3 beds from 530,000€
This magnificent development, located 5 minutes from the center of (...)
€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 (...)
