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,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 (163,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 (163,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 121 - 140 of 296 €395,000
TSEA5054785
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 143 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 143 Area: Manilva Region: Andalucía
Fantastic three bedroom duplex penthouse with splendid views of the sea and our coast. The property has two south facing terraces with unbeatable views. Three bedrooms, two bathrooms and a toilet. A (...)
€725,000
TSEA5054653
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 150 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 150 Area: Marbella Region: Andalucía
Classic Spanish Style Penthouse Duplex in the Heart of Marbella
Set in the very heart of Marbella's city centre, on the charming Plaza África, this elegant Spanish-style penthouse duplex captures (...)
€1,350,000
TSEA5051689
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 180 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: Marbella Region: Andalucía
Step into the epitome of boutique luxury living with this stunning duplex penthouse in Altos de Los Monteros, Marbella. Nestled in an exclusive residential enclave with only five residences, this (...)
€1,550,000
TSEA5051566
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 160 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 160 Area: Marbella West Region: Andalucía
Luxury Duplex Penthouse in Medina de Banús with Panoramic Sea & Mountain Views
Welcome to this stunning 3-bedroom, 3-bathroom duplex penthouse, located in the prestigious gated community of (...)
€1,895,000
TSEA5051044
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 210 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 210 Area: Marbella West Region: Andalucía
Introducing Alminar – an elegant duplex penthouse located in a gated community in Nueva Andalucía.This newly renovated home offers 4 bedrooms and 3 bathrooms, with high-end finishes throughout. (...)
€425,000
TSEA5050510
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 102 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 102 Area: Mijas and Mijas Costa Region: Andalucía
A rare opportunity to buy a 3 bedroom / 3 bathroom South West facing duplex apartment in the popular complex in lower Calahonda.
The first floor consists of a kitchen, lounge / diner, a double (...)
€399,000
TSEA5050249
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 109 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 109 Area: Benalmadena Region: Andalucía
Penthouse Duplex, Benalmadena arroyo de la miel, Costa del Sol.
2 Bedrooms, 1.5 Bathrooms, Built 109 m².
Setting : Town.
Condition : Excellent.
Climate Control : Air Conditioning.
Features : Lift, (...)
€1,349,000
TSEA5050213
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 184 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 184 Area: Benalmadena Region: Andalucía
Contact us today Duplex Penthouse with Spectacular Sea Views in Stupa Hills
Located next to the prestigious Reserva del Higuerón, this impressive 236m² duplex penthouse is the perfect opportunity (...)
€579,000
TSEA5049928
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse in Calahonda in second line beach with amazing sea views and offering on two levels two bedrooms, two bathrooms, a kitchen, bright living room with sunny terrace and a roof terrace with (...)
€325,000
TSEA5049178
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 3 M2: 128 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 3 M2: 128 Area: La Duquesa Region: Andalucía
***Fantastic 3-Bedroom Duplex Just Steps from the Beach*** This fantastic 3-bedroom, 3-bathroom duplex in the established gated community of Manilva Playa, Duquesa, is just a two-minute walk from (...)
€1,250,000
TSEA5048536
- Higueron, Costa Del Sol
Beds: 3 Baths: 3 M2: 133 Region: Andalucía
Beds: 3 Baths: 3 M2: 133 Region: Andalucía
Exclusive Duplex with Panoramic Sea Views – Seaviews Reserve, Fuengirola
Fantastic opportunity to acquire a spectacular duplex in the prestigious Seaviews Reserve development, recently completed (...)
€650,000
TSEA5046688
- San Roque Club, Costa Del Sol
Beds: 4 Baths: 4 M2: 207 Region: Andalucía
Beds: 4 Baths: 4 M2: 207 Region: Andalucía
Discover this exquisite frontline golf penthouse at San Roque Club, a premier Costa del Sol destination. This two-story gem offers four spacious bedrooms, three with terraces overlooking the 13th (...)
€1,700,000
TSEA5046625
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 209 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 209 Area: Estepona Region: Andalucía
Set within the prestigious beachfront community of Bahía del Velerín, along the New Golden Mile between Marbella and Estepona, this stunning duplex penthouse captures the essence of Mediterranean (...)
€560,000
TSEA5046409
- Bel Air, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Incredible duplex penthouse in the urbanization of Jacarandas in one of the fashionable areas on the outskirts of Estepona, Bel-Air, just a stone's throw from the neighbourhood of Cancelada with all (...)
€575,000
TSEA5046370
- Estepona, 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
Seize the Ultimate Coastal Lifestyle!
Step into paradise with this stunning 3-bedroom, 2-bathroom duplex penthouse in the prestigious Golf Hills urbanisation, perfectly perched between the rolling (...)
€485,000
TSEA5045704
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 142 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 142 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to this unique property situated in one of the most be beautiful complex on the Costa del Sol, Puebla Aida. As you walk in you will find a landing leading onto the kitchen and a large living (...)
€2,295,000
TSEA5043832
- Artola, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 156 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 156 Area: Marbella East Region: Andalucía
An exceptional penthouse in the Sunset development in Cabopino, located in the well-known Artola Alta district - one of Marbella's more sought-after locations.
The property impresses with (...)
€599,000
TSEA5043559
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 115 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 115 Area: Marbella West Region: Andalucía
A superb west-facing renovated duplex penthouse for sale in the popular El Dorado urbanisation in Nueva Andalucia, close to Puerto Banus
Enjoy the afternoon sun with stunning views towards the (...)
€1,007,050
TSEA5042083
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 97 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 97 Area: San Pedro Region: Andalucía
In an exceptional location in San Pedro Alcántara, just a short walk from the beach and with views of the sea and the impressive La Concha peak. Discover a new way of living in San Pedro Alcántara (...)
€870,000
TSEA5041645
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 113 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 113 Area: Marbella West Region: Andalucía
Discover this beautifully renovated duplex penthouse perfectly positioned in the vibrant heart of Puerto Banús, boasting spectacular views directly over the iconic marina.
Flooded with natural (...)
Current Featured Properties
€525,000
TSEA5075317
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 4 M2: 102 Area: Casares Region: Andalucía
Beds: 3 Baths: 4 M2: 102 Area: Casares Region: Andalucía
An exclusive residential development in the prime location of Doña Julia Golf, in Casares, Málaga. Designed to offer a unique lifestyle, it combines comfort, nature and luxury in an unbeatable (...)
€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 (...)
