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 (47,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 (47,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 (47,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3910), Middle Floor - (3910), Penthouse - (3910), Top Floor Apartment - (3910), Penthouse Duplex - (3910)Properties
Results 181 - 200 of 4050
€1,090,000
TSEA5150803
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
HIGHLIGHTS
Exquisite apartment located in the prestigious Marbella Club Hills development. A 5-star residence set within a privileged natural environment, in collaboration with the iconic Marbella (...)
€550,000
TSEA5150794
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
HIGHLIGHTS
This apartment offers a unique investment opportunity in one of the most sought-after areas of Marbella. With its proximity to Puerto Banús and the beach, this property has enormous (...)
€395,000
TSEA5150782
- Sierrezuela, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse with Panoramic Views of Fuengirola and the Mediterranean
This spacious penthouse in Sierrezuela offers one of the most spectacular terraces you can find – a 50 m² outdoor space with sun (...)
€525,000
TSEA5150773
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Modern and spacious 3-bedroom apartment in exclusive Belaire, Estepona!
Welcome to thiS 3-bedroom apartment located in the sought-after Belaire community in Bel-Air, Estepona. With its modern (...)
€1,875,000
TSEA5150743
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 4 M2: 316 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 4 M2: 316 Area: La Duquesa Region: Andalucía
Unique Penthouse in Puerto de la Duquesa with 360° Views
• A truly unique property on the market: a 3-bedroom, 4-bathroom penthouse with a wrap-around panoramic terra
360° views of the sea, (...)
€335,000
TSEA5150740
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
This charming apartment, located on the first and top floor, perfectly combines comfort, style, and an unbeatable location. Fully renovated and tastefully furnished, it offers modern, functional (...)
€950,000
TSEA5150737
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 73 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 73 Area: Marbella East Region: Andalucía
This unique penthouse is located in a renowned and well-established beachfront urbanization, with direct access to one of the best beaches on the Costa del Sol and its promenade.
As soon as you step (...)
€390,000
TSEA5150722
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Magnificent apartment with stunning views in Mijas Golf.
Discover this magnificent apartment located in a prime location for golf lovers, where tranquility and light blend perfectly.
This property (...)
€1,399,000
TSEA5150578
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 3 M2: 159 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 3 M2: 159 Area: Marbella West Region: Andalucía
In the heart of Puerto Banús Marina, this modern apartment with sea views is now available for sale. With its two-bedroom, two-bathroom en-suite (plus one guist toilet) it is prime positioned (...)
€400,000
TSEA5150557
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 91 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Benahavis Region: Andalucía
This charming ground floor apartment is located in Benahavís, one of the most exclusive areas on the Costa del Sol, renowned for its peaceful surroundings, stunning landscapes, and proximity to (...)
€380,000
TSEA5150536
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Stunning New Golden Mile middle floor apartment with panoramic views. This amazing south facing property offers La Concha views from the kitchen and partial sea views from the terrace.
The property (...)
€423,000
TSEA5150527
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 99 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 99 Area: Casares Region: Andalucía
New Development: Prices from 423,000 € to 721,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 99.00 m2 - 116.00 m2]
Set in an exceptional location between the highly sought-after towns of (...)
€551,460
TSEA5150488
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
OPPORTUNITY: Beachfront ground-floor apartment measuring 75 m² + 55 m² of private garden, with 2 large bedrooms, 2 bathrooms, a kitchen with a breakfast bar, and a spacious living-dining room with (...)
€695,000
TSEA5150473
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 101 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Marbella East Region: Andalucía
Elegant, fully renovated apartment in the exclusive Terrazas de las Lomas urbanization, located in the heart of the Golden Mile, just minutes from Marbella and Puerto Banús.
This property features (...)
€795,000
TSEA5150464
- Higueron, Costa Del Sol
Beds: 3 Baths: 2 M2: 118 Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Region: Andalucía
Welcome to this newly built 3-bedroom corner apartment on the second floor of the sought-after Lomas 2 – completed in 2025 and ready for immediate move-in. Here, spacious interiors, fantastic (...)
€500,000
TSEA5150452
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
New Development: Prices from 500,000 € to 969,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 94.00 m2 - 133.00 m2]
An exclusive residential complex: 36 apartments with 2 and 3 bedrooms, and 15 (...)
€450,000
TSEA5150431
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 95 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Marbella West Region: Andalucía
5 minutes walk to Centro Plaza in Nueva Andalucia and 20 minues to Puerto Banus this bright and spacious middle-floor apartment offers two bedrooms and two bathrooms, combining comfort with stunning (...)
€880,000
TSEA5150107
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 120 Lot Size: 30 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Lot Size: 30 Area: Marbella West Region: Andalucía
BRAND NEW TO THE MARKET!!!
This is a super Bright & Spacious 3 Bedroom Apartment in the Heart of Puerto Banús.
How can you be in the heart of it all, yet be so quiet?..
This exceptional (...)
€390,000
TSEA5150083
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 189 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 189 Area: Mijas and Mijas Costa Region: Andalucía
Exceptional 3-Bedroom Ground Floor Apartment with Expansive Terraces Surrounded by Tropical Gardens
This truly unique and one-of-a-kind property offers an extraordinary living experience. Originally (...)
€320,000
TSEA5150062
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Located in the heart of Marbella, this cozy 1-bedroom, 1-bathroom apartment is an excellent opportunity for both primary residence and investment. Facing east, it enjoys pleasant natural light and (...)
Current Featured Properties
€349,950
TSEA4335331
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 86 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Fuengirola Region: Andalucía
This new development is located in the north of Fuengirola, in the Los Pacos neighborhood: a residential, multicultural and multilingual area with a cosmopolitan atmosphere, close to the beach and (...)
€1,195,000
TSEA4976017
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
€3,995,000
TSEA5080855
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 186 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 186 Area: Estepona Region: Andalucía
Los Granados del Mar is one of the most exclusive urbanizations on the New Golden Mile with breathtaking views of the Mediterranean Sea. Its combination of beautifully maintained gardens and (...)
