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,39,40,41,162,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 (41,39,40,41,162,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 (41,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 1021 - 1040 of 3894 €1,395,000
TSEA5110753
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 307 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 307 Area: Marbella East Region: Andalucía
**Exclusive Duplex Penthouse Just 500 Meters from the Beach, in Marbella's Golden Mile**
Located in the sought-after area of Nagüeles, in the iconic Golden Mile of Marbella, this stunning 307 m² (...)
€3,200,000
TSEA5110738
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 205 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 205 Area: Marbella East Region: Andalucía
Luxury Duplex Penthouse for Sale in Bahia de Marbella – Exceptional Space, Luxury Fittings, and Unbeatable Location.
Walking distance to the beach 500 m.
Idealf or residential living or as well for (...)
€1,195,000
TSEA5110723
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 123 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Marbella West Region: Andalucía
Modern Duplex Penthouse with Sea Views near Puerto Banús
A light-filled, Scandinavian-style 3-bedroom duplex penthouse located in a new development, just a short walk from the lively harbour of (...)
€399,000
TSEA5110687
- 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
Unique Opportunity on a Main Street in the Center of Estepona – Just Steps from the Sea.
Discover this charming apartment located on Estepona's iconic central street, in the heart of the town and (...)
€285,000
TSEA5110684
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
PENTHOUSE WITH SEA VIEWS NEXT TO THE BEACH
Fantastic penthouse located in the Torrequbrada area (Benalmadena costa) just a few minutes walk from the beach close to all kinds of services.
Apartment (...)
€425,000
TSEA5110681
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 92 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 92 Area: Fuengirola Region: Andalucía
This brand-new, fully refurbished residence is finished to the highest standards and ideally located less than 100 meters from the beach in Los Boliches, and within easy reach of Fuengirola town (...)
€228,000
TSEA5110648
- Algeciras, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 100 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Algeciras Region: Andalucía
Ground Floor Apartment with Private Patio in Algeciras, Cádiz
This cozy three-bedroom ground-floor apartment offers a prime location near the center of Algeciras, in a quiet, well-connected private (...)
€279,000
TSEA5110606
- 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
FOR SALE: Bright 3-Bedroom Apartment in Estepona – 10 Minutes Walk to the Beach!
Discover this charming and fully renovated 3-bedroom apartment, located just a 10-minute walk from the beautiful (...)
€825,000
TSEA5110600
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 102 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Estepona Region: Andalucía
Modern Living on the New Golden Mile – 2-Bedroom Apartment with Large Private Terrace
This stylish, ground-floor apartment is part of a cutting-edge residential complex in one of Estepona's most (...)
€379,500
TSEA5110576
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 61 Lot Size: 78 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 61 Lot Size: 78 Area: Nerja and Malaga East Region: Andalucía
Apartment with Terrace and Partial Sea Views – Costa Blanca
Modern 2-bedroom, 2-bathroom apartment located in a quiet residential area, just minutes from the sea and with excellent access to (...)
€417,450
TSEA5110552
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 57 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 57 Area: Nerja and Malaga East Region: Andalucía
First-Floor Apartment with Terrace and Sea Views
Modern 2-bedroom, 2-bathroom apartment located in a quiet residential area, just minutes from the sea and with excellent access to local amenities (...)
€429,550
TSEA5110519
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 55 Lot Size: 57 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 55 Lot Size: 57 Area: Nerja and Malaga East Region: Andalucía
Modern Apartment with Terrace and Partial Sea Views – Costa Blanca
This charming first-floor apartment offers a comfortable Mediterranean lifestyle in one of the most sought-after areas of the (...)
€429,550
TSEA5110432
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 53 Lot Size: 56 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 53 Lot Size: 56 Area: Nerja and Malaga East Region: Andalucía
Modern Apartment with Terrace and Partial Sea Views – Costa Blanca
This charming first-floor apartment offers a comfortable Mediterranean lifestyle in one of the most sought-after areas of the (...)
€660,000
TSEA5110402
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 120 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Benahavis Region: Andalucía
Discover this sophisticated 3-bedroom, 2-bathroom apartment, located in an exclusive development with 24-hour security. The property has been carefully refurbished, highlighting a contemporary design (...)
€330,000
TSEA5110336
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 59 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 59 Area: Benahavis Region: Andalucía
New Development: Prices from 330,000 € to 890,000 €. [Beds: 1 - 3] [Baths: 1 - 2] [Built size: 59.00 m2 - 128.00 m2]
Located in the heart of Benahavís, a new residential development is being (...)
€239,000
TSEA5110246
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 90 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: La Duquesa Region: Andalucía
Stunning Apartment for Sale – La Colina, Princesa Kristina, Manilva!
Dreaming of owning a Costa del Sol property?
This 2-bedroom, 2-bathroom apartment in the exclusive La Colina, Princesa Kristina (...)
€1,380,000
TSEA5110237
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 220 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 220 Area: Marbella West Region: Andalucía
this is an exceptional property for those who wish to enjoy a stay in a privileged location in the center of Puerto Banús, a step away from the Marina, exclusive shops and the best restaurants.
The (...)
€329,000
TSEA5110213
- New Golden Mile, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 73 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 73 Area: Estepona Region: Andalucía
Stunning One-Level Penthouse with Panoramic Sea Views
This beautifully presented one-level penthouse offers a rare combination of style, comfort, and unbeatable location. Featuring an open and (...)
€195,000
TSEA5110204
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Opportunity! Beachfront penthouse in Manilva, in the Aparthotel Don Juan.
The apartment, located on the fifth floor, has a floor area of 104 m² and a 12 m² terrace with sea views, facing (...)
€2,000,000
TSEA5109901
- Martiricos, Costa Del Sol
Beds: 3 Baths: 3 M2: 136 Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Region: Andalucía
Welcome to the highest and most exclusive penthouse in Andalusia. Direct from the developer.. This extraordinary residence offers not only an unparalleled luxury experience, but also stunning (...)
Current Featured Properties
€382,000
TSEA4753921
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
New homes in Mijas!
This development is a modern residential of 75 new homes in Mijas, designed to enjoy a warm and balanced lifestyle. A project surrounded by nature, with incredible sea and (...)
€730,000
TSEA4819765
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 108 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Benahavis Region: Andalucía
The new residential is part of the renowned private urbanization "La Hacienda del Señorío de Cifuentes" with which they will share the enjoyment of its current four swimming pools with (...)
€893,000
TSEA4887208
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 175 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 175 Area: Casares Region: Andalucía
This residential complex of 36 homes with 2 and 3 bedrooms and an exceptional range of services. Each home is carefully designed using soft, organic lines that blend naturally into the surroundings, (...)
