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 121 - 140 of 4050
€1,850,000
TSEA5153413
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 202 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 202 Area: Benalmadena Region: Andalucía
Luxury duplex penthouse located on the beachfront in the famous Puerto Marina marina. A very quiet area with all amenities, including restaurants and several shops, right on the doorstep.
The (...)
€344,900
TSEA5153257
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 85 Lot Size: 85 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 85 Area: Benahavis Region: Andalucía
????️♂️ Experience Golf, Sun, and Exclusivity in the Marbella – Benahavís Golf Valley ☀️
In the heart of the prestigious El Paraíso Golf Valley lies this modern 85 m² apartment, (...)
€480,000
TSEA5153251
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 219 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 219 Area: San Pedro Region: Andalucía
This elegant 3-bedroom, 3-bathroom duplex penthouse is located in the prestigious area of Campos de Guadalmina, Guadalmina Alta. From its spacious terraces, you can enjoy panoramic views of the (...)
€975,000
TSEA5153245
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Welcome to this brand-new, never-lived-in apartment in Mirador de Estepona Hills, one of the most prestigious residential communities in the area of Estepona. Thoughtfully designed for comfort and (...)
€2,985,000
TSEA5153197
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
This exceptional apartment is located within the world-renowned Puente Romano Resort, right in the heart of Marbella's Golden Mile – one of the most exclusive addresses in Europe. Designed for (...)
€350,000
TSEA5153194
- Bel Air, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Located in the prestigious area of Bel Air, Estepona East, this apartment offers a perfect combination of comfort, light, and accessibility. With a south-facing orientation that ensures natural (...)
€750,000
TSEA5153167
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 140 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Marbella West Region: Andalucía
Discover this beautifully renovated apartment in one of Marbella's most desirable neighborhoods, just steps from Centro Plaza and only minutes from the glamour of Puerto Banús.
Designed with (...)
€1,650,000
TSEA5153161
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 278 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 278 Area: Benahavis Region: Andalucía
Casa El Lago is a luxury apartment for sale in the prestigious Real de La Quinta urbanization, a setting that combines contemporary architecture with the natural beauty of southern Spain.
Designed (...)
€378,000
TSEA5153122
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Apartment for sale in Marbella Centro, Marbella with 2 bedrooms and 1 bathroom. Regarding property dimensions, it has 71 m² built and 17 m² terrace. Has the following facilities amenities near, (...)
€520,000
TSEA5153041
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 100 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Casares Region: Andalucía
We present to you this magnificent apartment located in the exclusive La Sabina development in Casares, a privileged enclave on the Costa del Sol that combines tranquillity, nature, and proximity to (...)
€350,000
TSEA5153017
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
In the heart of the Costa del Sol, we present this spacious flat located in the quiet area of Seghers, in Estepona. Strategically located just a few steps from the marina, the beach and the charming (...)
€380,000
TSEA5153011
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 53 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 53 Area: Marbella Region: Andalucía
Unique 1-Bedroom Apartment in the Heart of Marbella – Steps from the Beach and Iconic Landmarks!
Seize this exceptional opportunity to own a charming 1-bedroom apartment on Avenida Antonio Belón, (...)
€138,500
TSEA5152945
- Antequera, Costa Del Sol, Antequera
Beds: 1 Baths: 1 M2: 51 Area: Antequera Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Antequera Region: Andalucía
Modern 1-Bedroom Apartment in the Historic Heart of Antequera, Atico
Located right in the centre of Antequera, this modern apartment offers the perfect combination of style, comfort, and (...)
€138,500
TSEA5152927
- Antequera, Costa Del Sol, Antequera
Beds: 1 Baths: 1 M2: 51 Area: Antequera Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Antequera Region: Andalucía
Modern 1-Bedroom Apartment in the Historic Heart of Antequera, second floor
Located right in the centre of Antequera, this modern apartment offers the perfect combination of style, comfort, and (...)
€269,000
TSEA5152921
- Málaga Centro, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 108 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 108 Area: Malaga Region: Andalucía
Unique opportunity in Capuchinos – Your new home or perfect investment awaits!
Spacious and bright apartment with enormous potential, in one of the most sought-after areas of the city, less than a (...)
€499,000
TSEA5152912
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 125 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Marbella West Region: Andalucía
Magnificent 3-bedroom apartment for sale located in the Los Naranjos development, just 5 minutes from Puerto Banús, in a privileged area with golf courses surrounding the complex, and practically (...)
€230,000
TSEA5152852
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 65 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Benalmadena Region: Andalucía
Charming One-Bedroom Apartment in Torrequebrada in a Peaceful Area
Spacious living room with plenty of room for a dining table as well. A compact kitchen that still includes everything you need for (...)
€597,000
TSEA5152840
- Higueron, Costa Del Sol
Beds: 3 Baths: 2 M2: 152 Lot Size: 62 Region: Andalucía
Beds: 3 Baths: 2 M2: 152 Lot Size: 62 Region: Andalucía
For Sale: Ground Floor 3-Bedroom Apartment with Garden & Terrace in Las Lomas del Higuerón
Discover a beautifully designed ground floor apartment located in the prestigious Las Lomas del (...)
€670,000
TSEA5152753
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 2 Baths: 2 M2: 104 Area: Algeciras Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Algeciras Region: Andalucía
Links 2 Golf & Beach Heaven!
So you want modern, you want sea views, you want walk to the beach, and you want easy golf access.
You want it all dont you?! ????
Well you can have it all, here at (...)
€266,000
TSEA5152729
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 65 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 65 Area: Mijas and Mijas Costa Region: Andalucía
Charming Two-Bedroom Apartment with Excellent Location
This bright and comfortable two-bedroom apartment is situated on the first floor of a well-maintained building. It features a spacious living (...)
Current Featured Properties
€368,300
TSEA3053995
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 101 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Fuengirola Region: Andalucía
SPACIOUS AND STYLISH, YOUR TWO FAVOURITE WORDS!
This new, OFF PLAN development is an innovative and elegant promotion of 1, 2 AND 3-BEDROOM APARTMENTS and penthouses with swimming pool, private (...)
€2,350,000
TSEA5080762
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Menara Beach is a luxury beachfront community on the New Golden Mile, located between Marbella and Estepona. Designed by Melvin Villaroel, it features tropical gardens, two outdoor pools, a heated (...)
€1,028,000
TSEA4939057
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
This new development is integrated in a privileged natural environment with views over the bay of Estepona and the mountains of Marbella, very close to the sea and very well connected. A project of (...)
