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 - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 1801 - 1820 of 3894
€320,000
TSEA5044555
- Benavista, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 80 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Estepona Region: Andalucía
**TOP FLOOR Apartment for Sale in Pelican/Flamingo Park - Spain**
Discover the ultimate in luxury living with this spacious top floor apartment located in the sought-after community of (...)
€395,000
TSEA5044528
- Málaga Centro, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 101 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Malaga Region: Andalucía
Unique opportunity, property in Malaga Centre, in the neighbourhood of La Victoria, one of the most historic and traditional areas of the city.
Situated on the third floor, it consists of 3 (...)
€284,000
TSEA5044522
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 62 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 62 Area: Mijas and Mijas Costa Region: Andalucía
Charming beautifully renovated apartment in Las Farolas - El Chaparral, Mijas with rental licence!! Close to the beach, yet very quiet area.
The apartment has 2 bedrooms sharing 1 bathroom and has a (...)
€3,100,000
TSEA5044456
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 212 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 212 Area: Marbella Region: Andalucía
The luxurious three-bedroom ground-floor apartment, front line beach in Los Monteros Playa, is finished to the highest of standards and taste. The property has just been beautifully refurbished (...)
€268,000
TSEA5044453
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 62 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 62 Area: Casares Region: Andalucía
PRICE REDUCED FOR A QUICK SALE!
VIEWS LIKE THIS ARE RARE— Located right next to the renowned Finca Cortesin Golf Resort, this exceptional penthouse offers a rare combination of design, views, and (...)
€295,000
TSEA5044438
- Martiricos, Costa Del Sol
Beds: 1 Baths: 1 M2: 58 Region: Andalucía
Beds: 1 Baths: 1 M2: 58 Region: Andalucía
New Construction
Welcome to Martiricos, truly luxury apartments. There are still a few left. The apartments and flats come with every luxury detail, fully equipped kitchens with appliances.
The homes (...)
€328,000
TSEA5044336
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 97 Lot Size: 27 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Lot Size: 27 Area: Estepona Region: Andalucía
Modern apartment located in the desirable Cancelada area, just a short walk to all essential services and a short drive to the beach and Los Flamingos, this apartment offers both convenience and (...)
€749,000
TSEA5044117
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 247 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 247 Area: Mijas and Mijas Costa Region: Andalucía
Elegant apartment with incredible sea views.
Upon entering this charming luxury apartment, you are greeted by a welcoming hall space, already showing seaview, that invites you to explore. To your (...)
€480,000
TSEA5043967
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 95 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 95 Area: Benahavis Region: Andalucía
✨ Exclusive Penthouse Apartment in Los Arqueros, Benahavís – Costa del Sol ✨
We present this stunning 3-bedroom, 2-bathroom property, located in one of the most sought-after areas of the (...)
€695,000
TSEA5043964
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 108 Lot Size: 32 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Lot Size: 32 Area: Marbella Region: Andalucía
Luxury apartment for sale in Hacienda El Palmeral, an exclusive gated complex of elegant apartments. Residents will enjoy beautifully landscaped communal gardens, with two large swimming pools and a (...)
€1,500,000
TSEA5043907
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 198 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 198 Area: Marbella West Region: Andalucía
This charming duplex penthouse to be refurbished, located in the exclusive community of El Embrujo, combines elegance, security and an unbeatable location: just 400 metres from the beach and a (...)
€690,000
TSEA5043841
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 142 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 142 Area: Estepona Region: Andalucía
Stunning 3-Bedroom Apartment for Rent or Sale in Estepona, Malaga
Discover luxury living in this brand-new 3-bedroom apartment located in a modern urbanization MESAS HOMES II, Estepona, completed in (...)
€2,295,000
TSEA5043832
- Artola, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 156 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 156 Area: Marbella East Region: Andalucía
An exceptional penthouse in the Sunset development in Cabopino, located in the well-known Artola Alta district - one of Marbella's more sought-after locations.
The property impresses with (...)
€397,400
TSEA5043700
- Río Real, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 134 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Marbella East Region: Andalucía
RENTED PROPERTY. OPPORTUNITY FOR INVESTORS.
What does a profitable property mean? Having a profitable property means that the owner is obtaining economic benefits from their property through its (...)
€535,000
TSEA5043688
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 129 Lot Size: 42 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 129 Lot Size: 42 Area: Benalmadena Region: Andalucía
RESIDENCE NOT ACCEPTING TOURIST RENTALS
Tastefully decorated, it has an equipped kitchen, a living room, a terrace of more than 50m2 with a magnificent view of the sea. The first bedroom has a 140 (...)
€450,000
TSEA5043685
- Estepona, 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
Stylish Ground Floor Apartment with Spacious Garden in Aranya Estepona!
Discover this beautiful 2-bedroom ground floor apartment in the new development Aranya Estepona, ideally located on the (...)
€280,000
TSEA5043652
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 89 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Mijas and Mijas Costa Region: Andalucía
Located in a secure gated community in the heart of Calahonda, Mijas, this lovely 2-bedroom, 2-bathroom apartment is the perfect blend of comfort, charm, and Mediterranean lifestyle. The property (...)
€799,000
TSEA5043619
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
The apartment is located in Estepona East, in the Cataleya urbanization — a modern and tranquil gated community nestled in one of the greenest and most convenient areas along the coast. Within (...)
€299,000
TSEA5043565
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 82 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 82 Area: Fuengirola Region: Andalucía
SECOND LINE BEACH PROPERTY! INVESTMENT OPPORTUNITY PRICED TO SELL!
Beautifully presented middle floor apartment located in the centre of Fuengirola, only a few steps away from the beach. Recently (...)
€599,000
TSEA5043559
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 115 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 115 Area: Marbella West Region: Andalucía
A superb west-facing renovated duplex penthouse for sale in the popular El Dorado urbanisation in Nueva Andalucia, close to Puerto Banus
Enjoy the afternoon sun with stunning views towards the (...)
Current Featured Properties
€2,400,000
TSEA4657528
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 189 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 189 Area: Benahavis Region: Andalucía
The construction is proposed in two phases, corresponding to the 2 distinct levels of the prime hillside position thereby taking full advantage of the privileged position on which will sit our finest (...)
€478,000
TSEA4678096
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 102 Lot Size: 158 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Lot Size: 158 Area: Mijas and Mijas Costa Region: Andalucía
This development offers one and two bedroom apartments in different sizes. All of them share the modern design, open spaces flooded with natural light and private terraces. We have ground floor (...)
€577,500
TSEA3923743
- 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
GREAT LOCATION CLOSE TO CHARMING ESTEPONA.
The apartments are specially designed to fully enjoy the charm of the Mediterranean lifestyle. A well thought out floor plan, bathrooms with lovely (...)
