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 101 - 120 of 296 €255,000
TSEA5076661
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 90 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 90 Area: La Duquesa Region: Andalucía
Renovated Penthouse with Spacious Terrace and Sea Views in La Duquesa – Style, Light and an Unbeatable Location
Discover this charming penthouse located in a quiet residential area of La Duquesa, (...)
€725,000
TSEA5076535
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 150 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 150 Area: Mijas and Mijas Costa Region: Andalucía
Renovated duplex penthouse, finished with exclusive luxury materials!!
The duplex penthouse enjoys a great location between Fuengirola and Marbella, offering easy access to both towns. It features (...)
€1,975,000
TSEA5076520
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 208 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 208 Area: Marbella East Region: Andalucía
Wonderful three bedroom, south east facing duplex penthouse in the exclusive and gated community of Monte Paraiso on the Golden Mile, with 24hr security, several outdoor swimming pools, a (...)
€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 (...)
€205,000
TSEA5075281
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 30 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 30 Area: Fuengirola Region: Andalucía
RENOVATED STUDIO 20 METERS FROM THE BEACH IN CARBAJAL, COMPLETELY RENOVATED AND FURNISHED WITH TOURIST LICENSE, LOCATED JUST ONE STEP FROM THE BEACH, BUS AND TAXI STOP AT THE DOOR, IDEAL FOR HOLIDAYS (...)
€950,000
TSEA5074279
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 172 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 172 Area: Marbella West Region: Andalucía
Penthouse La Arabesque offers a sophisticated take on contemporary living in the secure and stylish enclave of Atalaya de Río Verde, one of Nueva Andalucía's most refined residential areas. This (...)
€399,000
TSEA5074048
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 115 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Marbella East Region: Andalucía
Elegant Two-Bedroom Penthouse with Breathtaking Panoramic Views in Elviria, Marbella
Perched in the uppermost block of a serene and beautifully maintained urbanisation, this bright and spacious (...)
€630,000
TSEA5073061
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 232 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 232 Area: Estepona Region: Andalucía
Stunning Duplex Penthouse in Las Olas – La Gaspara, Estepona
Welcome to this exceptional duplex penthouse in the exclusive Las Olas development, nestled in the highly sought-after area of La (...)
€419,000
TSEA5072887
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
This penthouse offers a bright and relaxed living experience on the third floor with elevator access, standing out for its fresh, summery atmosphere. Its location, just a few minutes' walk from Bombo (...)
€1,349,000
TSEA5070757
- Monte Halcones, Costa Del Sol, Benahavis
Beds: 4 Baths: 5 M2: 180 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 5 M2: 180 Area: Benahavis Region: Andalucía
This beautifully renovated 4-bedroom, 3-bathroom duplex is the perfect blend of Scandinavian design and Mediterranean living.
It's bright, spacious, and thoughtfully designed, offers a warm and (...)
€295,000
TSEA5070199
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 3 M2: 111 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 3 M2: 111 Area: La Duquesa Region: Andalucía
***Immaculate 3-Bedroom Duplex Penthouse with Stunning Coastal Views*** Located within the sought-after elevated urbanisation of Vistalmar Norte in the Hacienda Guadalupe area of Duquesa, this (...)
€695,000
TSEA5069548
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 123 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 123 Area: Mijas and Mijas Costa Region: Andalucía
DUPLEX PENTHOUSE AT THE BEST PRICE WITH AMAZING SEA VIEWS
This fantastic property has 2 terraces with great sea views, 3 bedrooms, 2 bathrooms, 1 toilet, large living room - dining room and kitchen. (...)
€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 (...)
€1,436,000
TSEA5062576
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 250 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 250 Area: Mijas and Mijas Costa Region: Andalucía
Spacious duplex penthouse located within walking distance of the golf course, just a 5-minute drive to shops and the beach, and a 20-minute walk to the nearest bus stop.
The first floor features a (...)
€525,000
TSEA5061568
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 125 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 125 Area: Estepona Region: Andalucía
Stunning Two-Story Penthouse in Cortijo del Mar, Private Collection
Presenting the most desirable penthouse in the prestigious Cortijo del Mar development – a beautifully maintained, two-story (...)
€475,000
TSEA5061481
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 110 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Fuengirola Region: Andalucía
Refurbished Duplex Penthouse in Fuengirola - 3 Bedrooms, 2 Bathrooms, 1 Toilet, Two Terraces
Discover this spectacular duplex penthouse completely refurbished, located in one of the most comfortable (...)
€2,275,000
TSEA5058682
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 192 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 192 Area: Marbella Region: Andalucía
A unique duplex penthouse situated in the lively centre of Marbella and is only a pleasant three-minute stroll from the beach. This fully furnished property, which spans 300 square meters and (...)
€325,000
TSEA5058658
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 145 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 145 Area: Mijas and Mijas Costa Region: Andalucía
"Discover this beautiful and spacious 3-bedroom, 2-bathroom penthouse nestled in one of the most desirable areas of the Costa del Sol. Enjoy two generous terraces, including a private rooftop (...)
€899,000
TSEA5056471
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 135 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 135 Area: Marbella East Region: Andalucía
Discover this magnificent property totally exterior, located in one of the most coveted areas of Marbella: the prestigious Golden Mile. Just 100 meters from the beach, this fabulous duplex penthouse (...)
€995,000
TSEA5054803
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 185 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 185 Area: Estepona Region: Andalucía
Exclusive listing in the prestigious El Campanario gated community, Welcome to your dream penthouse - a stunning home that'll take your breath away from the moment you step inside.
This newly (...)
Current Featured Properties
€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 (...)
€1,790,000
TSEA4941118
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 123 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 123 Area: Malaga Region: Andalucía
Located on the front line and occupying a corner plot that makes it unique in terms of panoramic views of the bay and the sea, within the surroundings of residential villas that tell the story of (...)
€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 (...)
