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 161 - 180 of 792
€1,230,000
TSEA5120707
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 156 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 156 Area: Benahavis Region: Andalucía
Penthouse in Flamingos Resort with the Best View
Thanks to Its Highest Position in the Complex and Unobstructed Front View!
Upon entering this luxurious penthouse, you are immediately welcomed by (...)
€1,595,000
TSEA5120656
- Playamar, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
Luxury penthouse on the beachfront in Playamar, Torremolinos – Exclusive living by the sea
Are you looking for a unique home to enjoy true beachfront luxury?
This spectacular penthouse in Habitat (...)
€575,000
TSEA5120617
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 91 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 91 Area: Marbella Region: Andalucía
Charming duplex penthouse with private terrace located in the heart of the old town. Just 1 minute walk from Plaza de Los Naranjos.
This apartment is part of a small building with only 6 neighbors, 2 (...)
€535,000
TSEA5119978
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
This bright and modern apartment, recently renovated, is located in a quiet and well-maintained residential area in the El Paraíso district, between Marbella and Estepona.
With a contemporary and (...)
€229,000
TSEA5119810
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 64 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 64 Area: Benalmadena Region: Andalucía
Welcome to this cozy and well-planned apartment located in Benalmadena. The property consists of one bedroom, one bathroom, and a spacious living room with direct access to the balcony.
This gated (...)
€635,000
TSEA5119780
- Río Real, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 90 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Marbella East Region: Andalucía
This spacious top floor apartment is perfect both as a vacation home and as a permanent residence due to its proximity to the beach, schools, and just a few minutes from the center of Marbella and (...)
€415,000
TSEA5119675
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 124 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Estepona Region: Andalucía
3-Bedroom Penthouse in Bel-Air, Estepona – Totally Refurbished!
Please note: located on the second floor, and the building has no lift.
This beautifully renovated penthouse is located in the (...)
€375,000
TSEA5119603
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 140 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Area: Benalmadena Region: Andalucía
Discover this spectacular penthouse with sea views that will make every day feel like a vacation! Located in a peaceful, natural setting, this home offers a perfect combination of comfort and beauty. (...)
€410,000
TSEA5119162
- Diana Park, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
REFORMED HOUSE WITH VIEWS AL MAR
Fantastic property, located in the area of Diana (Atalaya), next to Guadalmina, with all types of services and one minute drive from the beach.
Totally renovated (...)
€430,000
TSEA5119156
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 86 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Area: Fuengirola Region: Andalucía
"Penthouse in the heart of Fuengirola, just steps from the beach
Discover this charming penthouse located right in the center of Fuengirola, just one block from the beach, offering breathtaking (...)
€918,000
TSEA5118937
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 149 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 149 Area: Marbella East Region: Andalucía
This 3-bedroom, 2-bathroom duplex penthouse offers expansive windows and two large terraces with incredible frontline golf and sea views. It includes a private jacuzzi perfect for relaxing while (...)
€299,000
TSEA5118922
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 78 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: La Duquesa Region: Andalucía
Stunning penthouse for sale just 250 meters from the picturesque Puerto de la Duquesa, located in the highly desirable Los Flamencos urbanisation on the Costa del Sol. This beautifully renovated (...)
€649,000
TSEA5118202
- Higueron, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 95 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 95 Area: Fuengirola Region: Andalucía
Stunning Brand New Apartment in the Prestigious Higuerón Resort – Lomas II
Welcome to this beautiful brand new second-floor apartment located in the highly sought-after Higuerón Resort – Lomas (...)
€695,000
TSEA5118145
- La Mairena, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 219 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 219 Area: Marbella East Region: Andalucía
Rarely does the opportunity to purchase such a large duplex corner penthouse with four bedrooms and four bathrooms.This is basically larger than the average villas for sale on the coast but with the (...)
€680,000
TSEA5118118
- Limonar, Costa Del Sol
Beds: 2 Baths: 1 M2: 76 Region: Andalucía
Beds: 2 Baths: 1 M2: 76 Region: Andalucía
Imagine waking up every morning in this cozy penthouse, full of light, charm, and warmth. Built in 1989 with care, it's a home made to be felt.
As you open the reinforced glass doors to the living (...)
€223,000
TSEA5117980
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 1 M2: 67 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 1 M2: 67 Area: Torremolinos Region: Andalucía
We present a stunning apartment located in a prime area, surrounded by services and shops that meet all your daily needs. Just steps from the local outpatient clinic, this property stands out for its (...)
€960,000
TSEA5117926
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Stunning 3-Bedroom Penthouse with Private Pool & Panoramic Views in the Heart of La Cala de Mijas
Welcome to your dream coastal escape this exquisite 3-bedroom, 2-bathroom penthouse apartment in (...)
€410,000
TSEA5117806
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 94 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Benalmadena Region: Andalucía
Located in the sought-after area of Montealto, Benalmádena, this spacious 2-bedroom, 2-bathroom penthouse offers stunning sea and mountain views, a private rooftop terrace, and excellent outdoor (...)
€545,000
TSEA5117773
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
This unique and beautifully partitioned 2-bedroom, 2-bathroom penthouse is cleverly configured as two separate apartments in one—each with its own fully equipped kitchen, living area, and bathroom. (...)
€707,850
TSEA5117677
- Campanillas, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
We present an innovative residential project that redefines the concept of living in Malaga. The development features a variety of homes, from one-bedroom apartments to four-bedroom penthouses, all (...)
Current Featured Properties
€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 (...)
€368,400
TSEA5063941
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 58 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 58 Area: Mijas and Mijas Costa Region: Andalucía
A modern apartment complex is an innovative development of 116 one-bedroom loft-style apartments, designed for those seeking style, functionality, and excellent value for money. At this residential (...)
€1,700,000
TSEA4201453
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 139 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 139 Area: Fuengirola Region: Andalucía
LAST ONE!!! FANTASTIC LOCATION JUST 350 METERS FROM THE SEA!!!!
This new development in the heart of Fuengirola will comprise 33 luxury apartments and penthouses with the most modern equipment and (...)
