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 (39,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 (39,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 (39,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 981 - 1000 of 3899 €535,000
TSEA5114350
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 145 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 145 Area: Mijas and Mijas Costa Region: Andalucía
Stunning Ground Floor Apartment in Frontline Beach Community – Las Mimosas, La Cala de Mijas
Experience coastal living at its finest with this beautifully maintained 2-bedroom, 2-bathroom ground (...)
€845,000
TSEA5114314
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
Exclusive Ground Floor Apartment in Embrujo Playa, Between the Glamour of Puerto Banús and the Charm of San Pedro.
Welcome to a property that brings together everything that makes living in (...)
€298,000
TSEA5114308
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 92 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 92 Area: Benalmadena Region: Andalucía
We are pleased to offer you this exclusive apartment in Torrequebrada, with south-facing orientation, in an exceptional location and a quiet area. This magnificent property, with 92 m² built and 77 (...)
€750,000
TSEA5114269
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 99 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 99 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse, Riviera del Sol, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 99 m², Terrace 23 m².
Setting : Close To Sea, Close To Town, Urbanisation.
Orientation : West, North West.
Condition : (...)
€845,000
TSEA5113885
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 117 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Marbella West Region: Andalucía
Nestled in the heart of Marbella's sought-after Golf Valley in Nueva Andalucía, this completely renovated duplex penthouse corner unit offers a rare opportunity to experience refined Mediterranean (...)
€559,000
TSEA5113768
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 157 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 157 Area: Estepona Region: Andalucía
Discover this beautifully presented ground floor apartment, offering the perfect blend of space, comfort, and prime location. The property features a generous open-plan living and dining area that (...)
€190,000
TSEA5113753
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 80 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 80 Area: Manilva Region: Andalucía
Middle Floor Apartment, San Luis de Sabinillas, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 80 m², Terrace 9 m².
Setting : Beachfront, Town, Commercial Area, Beachside, Village, Close To Shops, (...)
€385,000
TSEA5113744
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 60 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 60 Area: Malaga Region: Andalucía
Located 150m from Plaza de La Constitución!
This spacious and modern 2 bed apartment with elevator is conveniently located near various transportation options, including a taxi station, train (...)
€470,000
TSEA5112667
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
With its smart and functional layout, this apartment offers two spacious bedrooms and two bathrooms — one of them en-suite — along with a separate kitchen and an independent utility room that (...)
€480,000
TSEA5112640
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 130 Lot Size: 99 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Lot Size: 99 Area: Algeciras Region: Andalucía
Ground Floor Apartment, La Alcaidesa, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 15 m², Garden/Plot 99 m².
Setting : Beachside, Close To Golf, Close To Shops, Close To Sea, (...)
€538,000
TSEA5112604
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 155 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 155 Area: Mijas and Mijas Costa Region: Andalucía
Spacious Duplex Penthouse in Benalmádena Costa – Excellent Location and Investment Potential
This four-bedroom duplex penthouse is located in one of the most desirable areas of Benalmádena (...)
€575,000
TSEA5112466
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Layout: 2 bedrooms | 2 bathrooms
Size: 90 m² interior + 50 m² terrace
This elevated ground-floor apartment is located in a brand-new development in the desirable area of Las Mesas, Estepona. (...)
€350,000
TSEA5112463
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 55 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: Marbella Region: Andalucía
Middle Floor Apartment, Marbella, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 55 m², Terrace 8 m².
Setting : Town, Commercial Area, Beachside, Port, Close To Golf, Close To Port, Close To Shops, (...)
€529,000
TSEA5112445
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
Welcome to the beautiful two-bedroom apartment at Magna Marbella.
It has a bright lounge-dining area that leads to an east-facing terrace with open views of the mountains and partial sea views, (...)
€190,000
TSEA5112382
- La Trinidad, Costa Del Sol
Beds: 1 Baths: 1 M2: 42 Region: Andalucía
Beds: 1 Baths: 1 M2: 42 Region: Andalucía
Discover your new home at Trinidad Street! This charming one-bedroom apartment is the perfect option for those looking for a first home or an investment with great potential. With 42 m² of built (...)
€403,000
TSEA5112346
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
Penthouse with Sea Views – Atalaya, Estepona
This exclusive 2-bedroom, 2-bathroom penthouse apartment, with 110 m² of built area and a 25 m² terrace, is located in a private development in (...)
€249,950
TSEA5112319
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
A lovely 2 bedroom apartment just metres from the beaches of El Faro in Mijas Costa. The sea views from the lounge, master bedroom and terrace are simply stunning. This is a first floor apartment but (...)
€299,000
TSEA5112307
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 95 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Benahavis Region: Andalucía
*** Frontline Golf ***
Modern ground floor 2 bed 2 bath apartment
A practical hassle-free investment and holiday home!
This property offers the perfect blend of resort hotel services and amenities (...)
€649,000
TSEA5112292
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
Incredible Frontline Apartment in Cabopino Port – A Rare Gem on the Costa del Sol
This is your chance to own something truly special – a frontline apartment in the iconic Puerto Cabopino, one of (...)
€349,990
TSEA5112283
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 60 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Marbella Region: Andalucía
This is a very attractively situated apartment in Marbella located second line beach and from its elevated position it enjoys great views to the sea and lots of natural light. The apartment has been (...)
Current Featured Properties
€535,000
TSEA5063977
- La Cala de 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
This development is part of a perfectly established community with fully operational common areas. This project has a total of 82 houses to be developed in 2 phases. Phase I corresponds to blocks 1 (...)
€415,000
TSEA4940641
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
IDEALLY SITUATED BETWEEN ESTEPONA AND PUERTO BANUS.
Your new home is more than just rooms and features, it must fit in with your lifestyle. We have created a floor-plan that is spacious designed to (...)
€599,000
TSEA4851742
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
This development offers 36 beautiful single-storey homes with large rooms, the option of 2 or 3 bedrooms, 2 bathrooms and large terraces with beautiful panoramic views. They have a fully equipped (...)
