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 (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 (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 (163)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 241 - 260 of 284 €1,195,000
TSEA4791832
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 156 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 156 Area: Marbella East Region: Andalucía
Three-bedroom duplex penthouse for sale in White Pearl Beach II, Elviria
We are very pleased to present this lovely 3-bedroom, 2,5-bathroom corner penthouse duplex in the long stablished frontline (...)
€1,975,000
TSEA4790320
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 313 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 313 Area: Benalmadena Region: Andalucía
Welcome to this one-of-a-kind magnificent front line luxurious four-bedroom Duplex Penthouse in the world-famous Puerto Marina in Benalmádena Costa.
This stunning property has been reformed to the (...)
€1,598,000
TSEA4786402
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 8 Baths: 6 M2: 300 Area: Marbella West Region: Andalucía
Beds: 8 Baths: 6 M2: 300 Area: Marbella West Region: Andalucía
8 bedroom penthouse across from Real Club Padel.
Perfect rental investment.
Stunning newly renovated 8 bedroom property, with fantastic location and facilities.
A must visit!
€995,000
TSEA4784341
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 160 Lot Size: 220 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 160 Lot Size: 220 Area: Marbella West Region: Andalucía
Brand new to the the market and completely renovated to the very highest standard. Located in a gated community within the bustling neighbourhood of Aloha. This south facing duplex penthouse has 4 (...)
€875,000
TSEA4780420
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 320 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 320 Area: Marbella West Region: Andalucía
Large duplex penthouse located in the exclusive area of River Garden in Nueva Andalucía. This property offers an exceptional life experience. With a construction of 320m2, this house has been (...)
€948,000
TSEA4770565
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 155 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 155 Area: Benahavis Region: Andalucía
Stunning Duplex Penthouse in Capanes del Golf - Your Dream Home Awaits!
Property Overview:
Welcome to your perfect oasis in Capanes del Golf, a luxurious Andalucian style development nestled within (...)
€798,000
TSEA4761040
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 185 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 185 Area: Estepona Region: Andalucía
This stunning luxury duplex penthouse is located in the beautiful area of Arroyo Vaquero, Estepona West, Estepona, Malaga. Situated in a front line beach position, this property offers breathtaking (...)
€475,000
TSEA4754338
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 176 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 176 Area: Estepona Region: Andalucía
Nestled with the confines of this superb urbanization, this 2 bedroom duplex penthouse looks proudly out across the surrounding mountain ranges that hug Estepona, and over the sublime swimming pool (...)
€650,000
TSEA4753828
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 106 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Estepona Region: Andalucía
Fabulous Penthouse with Panoramic Sea Views!
3 Bedroom Penthouse with incredible Sea Views! Perfect Condition. Must be Seen!!
This fantastic 3 Bedroom duplex Penthouse is perfect for a full time (...)
€750,000
TSEA4753348
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 2 M2: 177 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 2 M2: 177 Area: Marbella East Region: Andalucía
Introducing you this excellent duplex penthouse for sale in an ideal location, next to Manolo Santana Raquets club and a short drive from both the beach, Puerto Banus and Puente Romano. This is a (...)
€630,000
TSEA4750420
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
NEW GOLDEN MILE, ESTEPONA
Two bedroom duplex penthouse, 3rd and 4th floor, in the frontline complex . South orientation with sea views.
Entrance hallway, living and dining area, fully fitted (...)
€2,995,000
TSEA4749421
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 5 M2: 253 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 5 M2: 253 Area: Marbella East Region: Andalucía
Fully refurbished luxury 4-bedroom penthouse on The Golden Mile, Marbella – Walking distance to Puente Romano and Marbella Club hotels
Duplex penthouse located within one of the most sought-after (...)
€499,000
TSEA4747855
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 188 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 188 Area: Estepona Region: Andalucía
Park Beach Penthouse with Roof terrace € 499,000 REDUCED due to road noise - Large spacious apartment, excellent rentals.
One of the few residential property complexes with a beachside location (...)
€1,099,000
TSEA4747168
- Teatinos, Costa Del Sol
Beds: 4 Baths: 3 M2: 245 Region: Andalucía
Beds: 4 Baths: 3 M2: 245 Region: Andalucía
Super PENTHOUSE!!! EXCLUSIVE in one of the best places in Malaga.
We offer you an excellent place to live, one of the best places and best places of communication, because there are highways, (...)
€1,750,000
TSEA4745185
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 170 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 170 Area: Benahavis Region: Andalucía
4 bedroom penthouse for €1.750.000 excl. furniture worth €150,000
This spacious 4 bedroom penthouse offers breathtaking views over Benahavís. Located on a hill near Los Arqueros Golf & La (...)
€1,450,000
TSEA4743658
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 228 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 228 Area: Marbella West Region: Andalucía
Duplex Penthouse with private rooftop Pool for Sale !
Panoramic views of La Concha and the Las Brisas golf course, ideally located between four different golf courses within less than a five-minute (...)
€848,800
TSEA4739725
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 103 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: San Pedro Region: Andalucía
Welcome to Los Arqueros Beach, a modern urbanization located on the beachfront of San Pedro de Alcantara. Built in 2013, this elegant complex offers all the comforts of a luxurious stay. There is a (...)
€3,850,000
TSEA4731871
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 6 M2: 236 Area: Estepona Region: Andalucía
Beds: 6 Baths: 6 M2: 236 Area: Estepona Region: Andalucía
You can not fail to be taken a back by these 360 degree views, a unique Duplex Penthouse which is one of a kind with 6 bedroom suites and completely Frontline with 2 private pools (one heated).
If (...)
€1,824,999
TSEA4728454
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 200 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Area: Estepona Region: Andalucía
Wonderful duplex penthouse set in one of the most luxurious frontline beach complexes on the Costa del Sol. The elite beachfront development situated on Estepona's New Golden Mile. Situated in a (...)
€385,000
TSEA4727857
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 113 Lot Size: 1 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 113 Lot Size: 1 Area: Mijas and Mijas Costa Region: Andalucía
One of the few 3 bedroom duplex penthouses in the exclusive urbanisation of Puebla Aida in Mijas Golf , with its own Andalusian style, Impeccably maintained. With 4 communal swimming pools, and (...)
Current Featured Properties
€1,100,000
TSEA4433068
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M2: 188 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 4 M2: 188 Area: San Pedro Region: Andalucía
Impressive Duplex Penthouse in Nueva Alcantara only 100 meters from the beach of San Pedro
Spacious duplex penthouse in the urbanization of La Gavia in Nueva Alcántara very close to all kinds of (...)
€2,295,000
EMPTY
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
The development is located in a prime enclave, surrounded by parks and landscaped areas, close to a wide variety of sports, healthcare, commercial spaces, and universities. Just 10 minutes from the (...)
€1,060,000
TSEA5063608
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 201 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 201 Area: Benalmadena Region: Andalucía
An exclusive boutique complex of 28 apartments in the highly sought-after area of Torremuelle, Benalmádena. Each residence has been carefully designed to offer a superior living experience, with (...)
