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 (41,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 (41,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 (41,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 981 - 1000 of 3894 €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 (...)
€240,000
TSEA5112277
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 1 M2: 93 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 1 M2: 93 Area: Benahavis Region: Andalucía
Apartment for sale. Benahavis
Property located in one of the most popular areas of the Costa del Sol, just minutes from all kinds of services: supermarkets, schools, restaurants and green areas. An (...)
€198,000
TSEA5112223
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 1 Baths: 1 M2: 81 Area: La Duquesa Region: Andalucía
Beds: 1 Baths: 1 M2: 81 Area: La Duquesa Region: Andalucía
Your seaside oasis awaits you in Manilva, Málaga!
This charming tourist apartment, with an area of 81 m², offers a carefully planned layout. With 1 bedroom, a bright living-dining room integrated (...)
Current Featured Properties
€318,250
TSEA4930297
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 54 Lot Size: 39 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 54 Lot Size: 39 Area: Mijas and Mijas Costa Region: Andalucía
We welcome you to this new development in Mijas a large multi-family building that offers 76 homes distributed over five floors plus an attic. The residential complex has common areas that include a (...)
€398,530
TSEA5019436
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 82 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Benahavis Region: Andalucía
A HOME YOU WILL NEVER WANT TO LEAVE!!!
The homes in this development are designed to offer you everything you need. On the ground floor you will have a garden and wine cellar, and on the top floor (...)
€720,000
TSEA4766926
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
This fantastic new development of stunning contemporary apartments and penthouses with sea views is located just a stone's throw from La Cala de Mijas. The popularity of this beautiful coastal town (...)
