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 (31,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 (31,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 (31,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 61 - 80 of 4003
€340,000
TSEA5156938
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 55 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 55 Area: Mijas and Mijas Costa Region: Andalucía
Modern 2-Bedroom Apartment in the Heart of La Cala de Mijas – Steps from the Beach ✨
Discover your ideal coastal home with this beautifully presented 2 bed, 1 bath apartment located just a few (...)
€1,500,000
TSEA5156926
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 162 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: Marbella Region: Andalucía
162 m² beachfront penthouse with terrace and panoramic views – Bajadilla Beach, Marbella
This exclusive 162 m² penthouse is located on the fifth floor of the renowned La Zambomba Building, (...)
€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 (...)
€995,000
TSEA5156797
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 175 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 175 Area: Marbella East Region: Andalucía
Elegant South-Facing Duplex with Private Pool in Artola Alta
Tucked within an exclusive gated community in Artola Alta, this sophisticated south-facing duplex blends modern luxury with the (...)
€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 (...)
€1,350,000
TSEA5156416
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 269 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 269 Area: Benahavis Region: Andalucía
A contemporary duplex for sale in the exclusive Las Colinas de Marbella community in Benahavís, offering three bedrooms and three bathroom. s. Designed with both style and function in mind, this (...)
€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 (...)
€399,000
TSEA5156341
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 166 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 166 Area: Benalmadena Region: Andalucía
Discover this stylish and well-maintained 2-bedroom duplex located in the prestigious Edificio Iberliving, just moments from the picturesque centre of Benalmádena Pueblo. Built only 7 years ago, (...)
€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 (...)
€269,000
TSEA5156101
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 51 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Estepona Region: Andalucía
Apartment in the urbanization on the first line of the sea - a combination of comfort and a unique location by the sea. The complex is located on the New Golden Mile, in close proximity to the beach (...)
€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 (...)
Current Featured Properties
€280,000
TSEA4944307
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 81 Lot Size: 34 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 81 Lot Size: 34 Area: Estepona Region: Andalucía
BRAND NEW DEVELOPMENT IN ESTEPONA.
Don't miss out on an opportunity to buy in this development of 90 dwellings of 1, 2 and 3 bedrooms, all of them with garage space and storage room. It is an (...)
€773,000
TSEA5032279
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 127 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 127 Area: Estepona Region: Andalucía
This development is placed in an excellent location.
Situated on an elevated plot that also benefits from being in front of a park and a sports area, guaranteeing sea views.
The development offers 2, (...)
€2,950,000
TSEA4216429
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 121 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 121 Area: Marbella West Region: Andalucía
TWO MINUTES AND YOU ARE IN THE CENTRE OF THE FAMOUS BANUS!!!
A sleek contemporary apartment located within the the famous Puerto Banus Marina, showcasing jetliner panoramic views to the Mediterranean (...)
