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 581 - 600 of 3894 €750,000
TSEA5132773
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 144 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 144 Area: Marbella East Region: Andalucía
Beautiful south-facing, two-bedroom apartment located in the prestigious Hacienda Playa, Elviria. Designed for comfortable coastal living and filled with natural light, the property features two (...)
€269,000
TSEA5132665
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 56 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 56 Area: Benahavis Region: Andalucía
Penthouse for sale in , Benahavis with 2 bedrooms, 2 bathrooms and with orientation east, with communal swimming pool, private garage and communal garden. Regarding property dimensions, it has 56.59 (...)
€1,795,000
TSEA5132626
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 165 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 165 Area: Marbella West Region: Andalucía
Corner Duplex Penthouse with Private Plunge Pool & Sea Views
Fully renovated and effortlessly stylish, this 3-bedroom, 3-bathroom corner penthouse blends sleek Scandinavian design with sweeping (...)
€1,450,000
TSEA5132605
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 231 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 231 Area: San Pedro Region: Andalucía
Modern beachfront apartment in prestigious gated complex, located in San Pedro de Alcantara.
This south facing apartment located on the elevated ground floor.
There is a spacious living & (...)
€369,000
TSEA5132542
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
Very large two bedroom two bathroom apartment with the most amazing views Wow !
This is a rare opportunity to purchase an apartment with such magnificent views.
Open plan kitchen with a lounge that (...)
€340,000
TSEA5132527
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 31 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 31 Area: Marbella Region: Andalucía
Second-Line Beachfront Apartment in Marbella Center
This charming 1-bedroom apartment is ideally situated in one of the most sought-after neighborhoods in Marbella Center, just steps from the beach. (...)
€475,000
TSEA5132521
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 2 Baths: 2 M2: 193 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 2 M2: 193 Area: Sotogrande Region: Andalucía
Beautiful 2-bedroom, 2-bathroom penthouse, perfectly situated in the prestigious area of Sotogrande Alto. Offering breathtaking panoramic views over the Almenara Golf Course and its peaceful lake, (...)
€659,000
TSEA5132518
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
Wake up to the sound of the waves and enjoy life on the beachfront in Los Boliches! This bright and spacious apartment with three bedrooms features an impressive terrace that wraps around the (...)
€340,000
TSEA5132512
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 119 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 119 Area: Marbella East Region: Andalucía
Outstanding large ground floor two bedroom apartment with superb panoramic views to sea and mountains.
Situated in one of the most privileged positions on this beautiful development set in manicured (...)
€480,000
TSEA5132461
- Málaga Centro, Costa Del Sol, Malaga
Beds: 4 Baths: 2 M2: 152 Area: Malaga Region: Andalucía
Beds: 4 Baths: 2 M2: 152 Area: Malaga Region: Andalucía
This spacious and welcoming 152 m² apartment, located just 5 minutes walking distance from the sea, 20 minutes from Málaga Airport, and 15 minutes from the María Zambrano high-speed train (...)
€350,000
TSEA5132416
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Apartment on 2nd Line of the Beach in Fuengirola – Only 150 Meters from the Promenade!
Located in one of the most sought-after areas of Fuengirola, this property represents an excellent (...)
€820,000
TSEA5132371
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
Lovely brand new 3 bedroom apartment in Estepona
Charming Ground Floor Apartment with Sea View – Prime Location!
Welcome to this beautifully maintained 3-bedroom, 2-bathroom ground floor (...)
€2,800,000
TSEA5132359
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 5 M2: 281 Area: Marbella Region: Andalucía
Beds: 3 Baths: 5 M2: 281 Area: Marbella Region: Andalucía
Located in the prestigious El Embrujo complex in Puerto Banús, this beautifully maintained apartment offers an exceptional blend of space, quality, and convenience just a short walk from the beach. (...)
€339,000
TSEA5132311
- Centro Histórico, Costa Del Sol
Beds: 3 Baths: 1 M2: 83 Region: Andalucía
Beds: 3 Baths: 1 M2: 83 Region: Andalucía
IN THE OLD TOWN MALAGA
3 Bed 1 bath apartment recently renovated
rented out for 1500 per month to students
two small terraces
first floor
less than 10 minuets walk to the beach
€475,000
TSEA5132308
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Stunning Penthouse for Sale – Luxury Living with Spectacular Views
Discover your dream home on the Costa del Sol – a rare opportunity to own an elegant and spacious penthouse in one of the (...)
€235,000
TSEA5132275
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 94 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Casares Region: Andalucía
Casares del Sol, Modernised (new kitchen + bathrooms) corner ground floor apartment with large terrace, Garage and large Storeroom.
Ground Floor Apartment, Casares Playa, Costa del Sol.
2 Bedrooms, (...)
€365,000
TSEA5132269
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 83 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Benahavis Region: Andalucía
This charming 2-bedroom, 2-bathroom apartment is located in a well-maintained and secure residential complex, surrounded by greenery and offering a beautiful communal pool. Its southwest orientation (...)
€739,000
TSEA5132266
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 115 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Benahavis Region: Andalucía
For Sale: Luxury Elevated Ground Floor Apartment in Botanic – Benahavís, Costa del Sol
Discover this stunning elevated ground floor apartment in the exclusive Botanic urbanisation, located in La (...)
€319,000
TSEA5132248
- Higueron, Costa Del Sol
Beds: 2 Baths: 1 M2: 72 Region: Andalucía
Beds: 2 Baths: 1 M2: 72 Region: Andalucía
Beautiful 2 bedrooms apartment with Nice terrace and views to the gardens, pools and sea.
The apartment was originally 1 single room, but it had a large living room and we did a COMPLETE RENOVATION (...)
€825,000
TSEA5132203
- Los Flamingos, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 162 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 162 Area: Estepona Region: Andalucía
Unique opportunity, discover this rare gem in the prestigious Los Flamingos Golf, a spacious 3-bedroom, 3-bathroom corner apartment. The Urbanisation has 7 blocks wit 96 homes and only six 3 bedroom (...)
Current Featured Properties
€399,000
TSEA4693576
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 86 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Torremolinos Region: Andalucía
LOCATED IN ONE OF THE BEST AREAS OF TORREMOLINOS!!!
Bringing to life a new residential concept in Torremolinos. Designed to enjoy the Mediterranean and the endless light of the Costa del Sol. A (...)
€520,000
TSEA5106760
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Discover, an incredible new development in one of Estepona's most exclusive areas. This private residential complex features apartments, including flats, penthouses, and ground-floor units with 2, 3, (...)
€1,395,000
Ground Floor Apartment in Benahavis
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 176 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 176 Area: Benahavis Region: Andalucía
BREATH TAKING VIEWS FROM THE STUNNING TERRACE!!!
From its elevated position just above Marbella's emblematic Golf Valley, you will enjoy luxurious and contemporary living in an exclusive location. (...)
