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 61 - 80 of 4050
€250,000
TSEA5156914
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 52 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: Marbella Region: Andalucía
OPPORTUNITY IN MARBELLA – UNBEATABLE PRICE
Fantastic property in Marbella, next to the bus station and a few minutes from the centre, surrounded by all kinds of services. The apartment, with great (...)
€410,000
TSEA5156911
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 120 Lot Size: 25 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Lot Size: 25 Area: Casares Region: Andalucía
Fantastic ground floor apartment with large private garden in Casares Costa
Wonderful corner property with golf views and partial sea views, located in one of the most privileged areas of the Costa (...)
€515,000
TSEA5156815
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 81 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Malaga Region: Andalucía
Situated on the fourth floor of a classic building, this exceptional penthouse apartment in the heart of Málaga's Centro Histórico presents a unique opportunity. The property currently offers a (...)
€2,950,000
TSEA5156527
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 662 Lot Size: 191 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 662 Lot Size: 191 Area: Benahavis Region: Andalucía
Modern ground floor 3-bedroom apartment is offered for sale in a new gated resort-style development situated in idyllic countryside of Benahavís, behind the Costa del Sol beaches.
Nestled amidst (...)
€340,000
TSEA5156371
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 73 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 73 Area: Benahavis Region: Andalucía
Apartment for sale in , Benahavis with 2 bedrooms and 2 bathrooms, with communal swimming pool and private garage (1 parking spaces). Regarding property dimensions, it has 73 m² built, 60 m² (...)
€299,000
TSEA5156344
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 116 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Benalmadena Region: Andalucía
Located in the heart of charming Benalmádena Pueblo, this beautifully maintained 2-bedroom apartment offers a blend of modern comfort, relaxed coastal living, and investment potential.
Situated in (...)
€595,000
TSEA5156320
- Hacienda del Sol, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 168 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 168 Area: Estepona Region: Andalucía
This is a remarkable opportunity to acquire a superb property situated on the second line of the beach in one of the finest urbanizations on the Costa del Sol.
It is positioned in the Atalaya Baja (...)
€499,500
TSEA5156305
- Río Real, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 122 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Marbella East Region: Andalucía
UNIQUE OPPORTUNITY: Golf-front apartment just 350 meters from the beach in Río Real
Our client recently acquired this fantastic apartment through a public auction, but now needs to resell quickly (...)
€695,000
TSEA5156257
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 101 Lot Size: 50 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Lot Size: 50 Area: Marbella East Region: Andalucía
An amazing opportunity to acquire a property in East Marbella´s most iconic complex. This luxury modern apartment is an elevated ground floor property offering the benefit of a large terrace and (...)
€595,000
TSEA5156251
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Stunning 2-bed Apartment.
Presenting a rare opportunity to own this new, modern, recently constructed 2-bed apartment in Phase 2 of Oasis325. Positioned with south orientation which gives you sun (...)
€450,000
TSEA5156191
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 66 Lot Size: 84 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 66 Lot Size: 84 Area: Estepona Region: Andalucía
For Sale – €450,000
2-Bedroom Ground Floor Apartment in Aranya, Selwo – Estepona
This brand-new, fully furnished 2-bedroom, 2-bathroom apartment is located in the highly desirable Aranya (...)
€269,000
TSEA5156131
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Los Boliches downtown. Less then 200m to the Beach.
Middle Floor Apartment, Los Boliches, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 71 m².
Setting : Town, Commercial Area, Beachside, Close To (...)
€390,000
TSEA5156089
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 96 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 96 Area: Estepona Region: Andalucía
Charming Ground-Floor Apartment in Estepona's Vibrant Calvario District – Central Location and 10 Minutes from the Beach!
Nestled in the heart of Zona Calvario, Estepona, this delightful 96 m² (...)
€556,762
TSEA5156053
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
An exceptional apartment located in the Locrimar area of Marbella.
This ground floor apartment features 3 double bedrooms with built-in wardrobes, 2 bathrooms, a separate furnished kitchen, a (...)
€2,685,000
TSEA5156050
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 136 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Marbella West Region: Andalucía
Beautiful apartment in the heart of one of the most famous ports on the Costa del Sol - Puerto Banus, with spacious terraces offering ponoramnic views to the sea, sandy beaches, port, coast of (...)
€560,000
TSEA5156041
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 111 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 111 Area: Benalmadena Region: Andalucía
Apartment with magnificent views of the sea and the communal swimming pool.
The property has 3 bedrooms with fitted wardrobes and 2 full bathrooms, one of which is en suite in the master bedroom, a (...)
€335,000
TSEA5156005
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 57 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 57 Area: Fuengirola Region: Andalucía
One-bedroom, one-bathroom apartment on the beachfront, near the boliches area, with sea views from the bedroom and living room. Terrace with sea views, air conditioning in the living room and (...)
€577,972
TSEA5155993
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 96 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 96 Area: Marbella Region: Andalucía
Duplex penthouse with panoramic sea views in Marbella
This exclusive penthouse apartment is located in the prestigious area near the Quirón Hospital, just a short walk from the beach. This bright (...)
€225,000
TSEA5155978
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Rarely available one bed apartment
Totally reformed and spacious one bedroom apartment in this ever poplar development a very short walk to the village.
200 METRES WALK TO THE BEACH
One full (...)
€380,000
TSEA5155972
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 85 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 85 Area: Torremolinos Region: Andalucía
Introducing this stunning fully renovated home, just 25 meters from the beach, located in one of the most exclusive areas of the Costa del Sol. Ideal for seaside living or as a high-return tourist (...)
Current Featured Properties
€880,000
TSEA4645150
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 77 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 77 Area: Mijas and Mijas Costa Region: Andalucía
This new development is a comfortable residential complex in a beautiful location in Mijas, Spain. There are only 36 apartments in the complex, so it will be the best guarantee of your privacy and (...)
€635,000
TSEA3948304
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 92 Lot Size: 86 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 92 Lot Size: 86 Area: Fuengirola Region: Andalucía
EVERY DETAIL HAS BEEN TAKEN CARE OF!!!
Located in the northern area of the Torreblanca del Sol Development, in the municipality of Fuengirola. An open block multi-family building with a total of 30 (...)
€2,450,000
TSEA5005555
- Los Monteros, 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
Palm Beach is a secure, gated community located on Marbella's eastern coast beachfront, just a 5-minute drive from the heart of the city and situated directly along one of the region's most beautiful (...)
