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 (36,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 (36,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 (36,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 3801 - 3820 of 3897 €2,390,000
Luxury development, top class views!
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 218 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 218 Area: Benahavis Region: Andalucía
LUXURY RESIDENTIAL COMPLEX BETWEEN MARBELLA & BENAHAVÍS!!!
The development enjoys breath-taking views from its huge terraces across the Mediterranean Sea towards Gibraltar and the coasts of (...)
€1,225,000
TSEA4104646
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 157 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 157 Area: Marbella West Region: Andalucía
walking to banus, very complete community, gym, indoor swimming pool, cafeteria, security 24h, sauna , beatiful gardens
Ground Floor Apartment, Puerto Banús, Costa del Sol.
2 Bedrooms, 2 (...)
€4,299,500
TSEA4104568
- El Madroñal, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 233 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 233 Area: San Pedro Region: Andalucía
Modern and luminous 3 bedrooms penthouse in El Madroñal
Located in a luxurious and unique residential complex where you can relax and enjoy life to the fullest.
Quality, style, comfort and (...)
€525,000
TSEA4101883
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 215 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 215 Area: Estepona Region: Andalucía
A stunning penthouse apartment which has been dramatically reduced in price and situated on the beachfront near to Estepona.
Built on two levels, the open plan lounge and dinning area is large, (...)
€675,000
TSEA4100143
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 118 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Area: Estepona Region: Andalucía
Situated in Las Mesas, just outside the center of Estepona, this spacious luxury apartment offers peace and tranquility but is still close to the beach, port and city center. It consists of a large (...)
€245,000
TSEA4098172
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 2 Baths: 1 M2: 84 Area: Manilva Region: Andalucía
Beds: 2 Baths: 1 M2: 84 Area: Manilva Region: Andalucía
Beachside 2-bed penthouse with terrace and sea views.
The living room is large and bright with direct access to the terrace with sea views. The terrace area is large enough to fit a dining table (...)
€700,000
TSEA4095613
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 275 Lot Size: 84 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 275 Lot Size: 84 Area: Estepona Region: Andalucía
Incredible apartment with magnificent views and location, located in the urbanization It is a gated, private urbanization with communal pool, large gardens and gym area.
This urbanization with (...)
€1,200,000
TSEA4094857
- Río Real, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 344 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 344 Area: Marbella East Region: Andalucía
Huge last floor apartment with 360 degrees panoramic sea views
This amazing property offers spacious interior spaces and absolutely amazing sea views over the whole coast. The property consists of (...)
€540,000
TSEA4087030
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 138 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 138 Area: San Pedro Region: Andalucía
In the Guadalmina Alta area, especially amongst the golf club members, this is one of the most iconic buildings. Located just behind the 18th tee box & the 8th green, this apartment is a golfers (...)
€1,050,000
TSEA4070902
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 156 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 156 Area: Estepona Region: Andalucía
Exceptional Upper floor apartment located in the private wing of suites in the prestigious Hotel Kempinski with stunning views to Africa and Gibraltar.
The owner has access to the restaurants, bars (...)
€949,000
TSEA4066786
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 5 Baths: 4 M2: 290 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 4 M2: 290 Area: Benalmadena Region: Andalucía
FRONT APARTMENT TO THE SEA WITH ITS PRIVATE BEACH!!
There is nothing on the market like this property, it is like living on a boat, since this building is built on the beach itself.
The property (...)
€1,050,000
TSEA4058563
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 170 Lot Size: 35 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 170 Lot Size: 35 Area: Marbella East Region: Andalucía
GOLEN MILE MARBELLA - LUXURY APARTMENT
Beautiful - luxurious corner apartment in stunning urbanisation ̈Lomas del Rey ̈ in The Golden Mile! This apartment consists of two large bedrooms with en (...)
€2,000,000
TSEA4056298
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 253 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 253 Area: Marbella Region: Andalucía
A unique facility on the first line in the heart of Marbella.
There is a design project and permission for the reform in process. With additional investment, the property will have a very high rental (...)
€595,000
TSEA4036594
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 113 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Marbella East Region: Andalucía
Lovely ground floor, West facing, three-bedroom apartment in the gated and well-established community Coto Real on Marbella's Golden Mile. The community boasts well-kept communal gardens and swimming (...)
€1,195,000
TSEA4033771
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 122 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Marbella West Region: Andalucía
A beautiful 3 bedroom penthouse situated walking distance to Puerto Banus available for holiday rental. This 3 bedroom 2 bathroom penthouse with huge roof terrace is a modern design with high end (...)
€659,500
TSEA4032328
- Fuengirola, 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
LUXURIOUS, HARMONIOUS, CLOSE TO BEAUTIFUL BEACHES.
This is one of the most stylish beachside developments in Fuengirola, on the Costa del Sol. Only 100m FROM THE SEA! featuring 1, 2 or 3 bedroom (...)
€1,295,000
TSEA4030888
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 7 Baths: 4 M2: 750 Area: Benalmadena Region: Andalucía
Beds: 7 Baths: 4 M2: 750 Area: Benalmadena Region: Andalucía
EXCELLENT INVESTMENT. 4 renovated apartments for sale located on the beach in Edificio Malibu, Benalmadena.
The Malibu building has its own restaurant and beach club, easy parking area, Trocadero (...)
€1,070,000
TSEA4023859
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Would you like to live just few steps from the beach, feel the waves at your terrace and enjoy your own roof top solarium, look over the rooftops and feel the sea breeze? This exclusive penthouse (...)
€1,575,000
Middle Floor Apartment in Puerto Banus
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 124 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 124 Area: Marbella West Region: Andalucía
ON THE DOORSTEP OF PUERTO BANUS!!!
Move straight into this front line beach apartment in La Herradura. On the second floor and with an orientation facing south to east. Enjoy direct views to the (...)
€1,575,000
TSEA4014763
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 124 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 124 Area: Marbella West Region: Andalucía
Front line beach apartment in La Herradura. Second floor, facing south to east. Direct views to the beach and sea, walking distance to Puerto Banus.
Living and dining area, fitted kitchen, spacious (...)
Current Featured Properties
€1,250,000
TSEA4926508
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 119 Lot Size: 6 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 119 Lot Size: 6 Area: Marbella Region: Andalucía
The development epitomizes the zenith of contemporary life in Marbella, renowned for its serene ambiance and breathtaking panoramic vistas that stretch from the lush pine canopies to the shimmering (...)
€490,000
TSEA5058604
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
This new development in the Estepona Centre comprising 43 one, two and three bedroom apartments and penthouses, terraces and magnificent communal areas. It boasts excellent finishes, a prime location (...)
€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 (...)
