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)
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)
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)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 361 - 380 of 781 €549,000
TSEA5032216
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 6 Baths: 2 M2: 260 Area: San Pedro Region: Andalucía
Beds: 6 Baths: 2 M2: 260 Area: San Pedro Region: Andalucía
Strategic Investment in Marbella: Licensed Tourist Penthouse with Rooftop Terrace - constant flow of guests with over 90% occupancy - proven high profitability.
Bright Penthouse with Rooftop in the (...)
€1,149,000
TSEA5031946
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 135 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 135 Area: Estepona Region: Andalucía
Elegant Beachside Penthouse with Panoramic Sea and Mountain Views in Costalita
Just 100 metres from the golden sands of the Mediterranean, this exceptional penthouse offers a rare combination of (...)
€350,000
TSEA5027179
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 147 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 147 Area: Manilva Region: Andalucía
Superb apartment located on the top floor of a pleasant urbanization, offering an ideal living environment for families or those who enjoy bright and open spaces.
This property features 3 comfortable (...)
€450,000
TSEA5027140
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 2 M2: 365 Area: Casares Region: Andalucía
Beds: 4 Baths: 2 M2: 365 Area: Casares Region: Andalucía
Discover a luxurious and exclusive lifestyle with this stunning 365 m² penthouse, perched high above Casares. Boasting breathtaking views of the Mediterranean Sea and the surrounding golf course, (...)
€1,700,000
TSEA5027131
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 168 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 168 Area: Manilva Region: Andalucía
We present to you this charming duplex penthouse located in one of the most prestigious and elegant urbanizations in La Duquesa, offering one of the finest 180º sea views and located along the (...)
€649,000
TSEA5027092
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 135 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 135 Area: Estepona Region: Andalucía
Penthouse with Panoramic Sea & Golf Views – Estepona
Discover this spectacular south-facing penthouse in an exclusive frontline golf development in Estepona, offering abundant natural light (...)
€699,500
TSEA5026981
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
Price: €699.500 excluding VAT, buyer's costs
Includes: private storage unit and parking space
Experience elevated living in this stunning 2-bedroom penthouse located in the sought-after Isidora (...)
€1,590,000
TSEA5026867
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 159 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 159 Area: Benahavis Region: Andalucía
A spectacular one-of-a-kind luxury penthouse immaculately presented in the Quercus phase of Real de la Quinta, a brand new gated community situated hill-top in La Quinta golf. This property oozes (...)
€850,000
TSEA5026420
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 139 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 139 Area: Marbella East Region: Andalucía
Beachside recently reformed, to a very high standard, apartment that is ready to move into. This fabulous bright, spacious, airy apartment is a perfect home or investment property. The location is (...)
€640,000
TSEA5026234
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Estepona Region: Andalucía
Stylish 2-Bedroom Penthouse with Stunning Sea & Mountain Views in Estepona
Welcome to your dream escape in the sun, a luxurious and spacious 2-bedroom penthouse where style, comfort, and (...)
€299,500
TSEA5026219
- Cártama, Costa Del Sol, Cartama
Beds: 3 Baths: 2 M2: 127 Area: Cartama Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Cartama Region: Andalucía
✨ Modern Renovated Penthouse with Large Terrace and Views – Cártama
We present this spectacular, fully renovated penthouse, featuring a modern design, plenty of light, and a large private (...)
€460,000
TSEA5024872
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 95 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse, Mijas Costa, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 95 m², Terrace 140 m².
Setting : Beachfront, Beachside, Close To Golf, Close To Sea, Close To Town, Urbanisation, Front Line (...)
€295,000
TSEA5024560
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
DUPLEX PENTHOUSE WITH SEA VIEWS IN RIVIERA DEL SOL
Welcome to this bright and beautifully maintained duplex penthouse in Riviera del Sol, offering unbeatable views of the Mediterranean Sea.
On the (...)
€445,000
TSEA5024434
- La Cala Hills, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
VERY SPACIOUS AND WELL APPOINTED PENTHOUSE SITUATED IN THE POPULAR LA CALA HILLS AREA. THE PROPERTY HAS 3 BEDROOMS, 2 BATHROOMS, HUGE OPEN PLAN LIVING AREA, QUALITY KITCHEN AND OVER 100m2 OF TERRACE (...)
€499,900
TSEA5024170
- La Cala Hills, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Spacious 3-Bedroom penthouse with panoramic views and 94m² terrace
This bright and spacious penthouse is located in the popular La Cala Hills in Mijas. With an interior living area of 118 m² and a (...)
€595,000
TSEA5023852
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 66 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 66 Area: Marbella West Region: Andalucía
Welcome to this beautifully refurbished apartment located in the sought-after community of Aloha Mirasierra, within walking distance of popular restaurants, supermarkets, and essential amenities—a (...)
€1,100,000
TSEA5023807
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 220 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 220 Area: Benahavis Region: Andalucía
Located in the exclusive Buenavista urbanization, at the highest point of La Quinta, this spectacular apartment offers the perfect balance of luxury, comfort, and privacy.
With breathtaking sea (...)
€630,000
TSEA4252741
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 82 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Benalmadena Region: Andalucía
New Development: Prices from 630,000 € to 682,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 82.00 m2 - 98.00 m2]
SHOW HOME SOON AVAILABLE! ONLY 3 UNITS LEFT!
An exclusive gated new (...)
€1,600,000
TSEA5023054
- Los Flamingos, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 212 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 212 Area: Estepona Region: Andalucía
**Alanda Los Flamingos Penthouse | Villa Padierna Resort | Panoramic Sea Views**
Experience the pinnacle of luxury living in this expansive 3-bedroom, 3 en-suite bathroom penthouse, nestled within (...)
€998,000
TSEA5021962
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 95 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 95 Area: Fuengirola Region: Andalucía
Penthouse in the Paseo Marítimo of Fuengirola, 92 m2 built and 100 m2 terrace. In front of the sea, spectacular views, very close to all services, 200m from the centre of Fuengirola, Church, Plaza (...)
Current Featured Properties
€890,000
TSEA4934425
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
An exclusive promotion of 25 units (1 to 3 bedrooms) in one of the expanding areas of Estepona. Located just minutes from the best beaches and offering access to a wide range of services, this (...)
€759,650
TSEA4631314
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 86 Lot Size: 35 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Lot Size: 35 Area: Estepona Region: Andalucía
UNIQUE OPPORTUNITY IN ESTEPONA TOWN. JUST A FEW UNITSS LEFT, HURRY!
2 Beds starting from 382,000€ and 3 beds from 530,000€
This magnificent development, located 5 minutes from the center of (...)
€527,000
TSEA4671382
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 86 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Manilva Region: Andalucía
PHASE 2 NOW FOR SALE! BRAND NEW IN A FANTASTIC DEVELOPMENT!!!
This is a development with 100 apartments in a magnificent residential area and in an extraordinary location.
The two and three-bedroom (...)
