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,36,37,38)
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,36,37,38)
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,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 181 - 200 of 792 €1,195,000
TSEA5116420
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 134 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Benahavis Region: Andalucía
DESCRIPTION
Discover this exceptional 280 m² apartment (including terraces) on the top floor of the sought-after Cataleya Phase I residential complex, located in the prestigious New Golden Mile of (...)
€1,495,000
TSEA5116210
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 220 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 220 Area: Marbella East Region: Andalucía
Exclusive Apartment 260 m² (186m2 inside en 75m2 outside) MarbellaGolden Beach, Marbella, with Stunning Rooftop Terrace and Pool
Just a 2-minute walk from the beach, this fully renovated luxury (...)
€675,000
TSEA5115592
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 2 M2: 175 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 2 M2: 175 Area: Marbella West Region: Andalucía
BEAUTIFUL BRAND-NEW APARTMENT IN NUEVA ANDALUCÍA - READY TO MOVE IN
Welcome to your dream home in the heart of Nueva Andalucía, nestled in the highly sought-after Albatros XV development and just (...)
€495,000
TSEA5115484
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 135 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: Marbella East Region: Andalucía
Spacious and luminous corner Penthouse Apartment in Elviria, Urb. Pino Golf. (Marbella East)
This urbanisation is walking distance to all shops, bus stop, Bars and Restaurants as well as the (...)
€320,000
TSEA5115409
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Located in the quiet and well-established area of Riviera del Sol, this apartment offers a clean, modern living space with easy access to the coast and everyday amenities.
The interior is bright and (...)
€700,000
TSEA5115373
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 144 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 144 Area: Estepona Region: Andalucía
Luxurious 3-Bedroom Penthouse in Benahavís – Benatalaya
This elegant penthouse is located in the exclusive gated community of Benatalaya, in the Atalaya-Capanes Sur area of Benahavís, at the (...)
€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 : (...)
€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 (...)
€330,000
TSEA5111269
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 2 M2: 92 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Alhaurin el Grande Region: Andalucía
Fantastic corner penthouse apartment with 3 balconies for sale in Las Brisas, Alhaurín Golf, Alhaurín el Grande.
Magnificent penthouse with superb views accessed by a lift or stairs. You enter (...)
€1,150,000
TSEA5110819
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 120 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 120 Area: Benahavis Region: Andalucía
Luxurious Penthouse in Marbella Club Hills
Welcome to your new dream home, an unparalleled penthouse with 3 bedrooms and 3 bathrooms, located in the prestigious Marbella Club Hills. This exceptional (...)
€285,000
TSEA5110684
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
PENTHOUSE WITH SEA VIEWS NEXT TO THE BEACH
Fantastic penthouse located in the Torrequbrada area (Benalmadena costa) just a few minutes walk from the beach close to all kinds of services.
Apartment (...)
€329,000
TSEA5110213
- New Golden Mile, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 73 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 73 Area: Estepona Region: Andalucía
Stunning One-Level Penthouse with Panoramic Sea Views
This beautifully presented one-level penthouse offers a rare combination of style, comfort, and unbeatable location. Featuring an open and (...)
€179,800
TSEA5110210
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 40 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 40 Area: Fuengirola Region: Andalucía
Your Sweet Seaside Retreat! Ideal Studio in a Prime Location Between Miramar and the Center of Fuengirola, walking distance to the beach
Discover this charming 40 m² studio, perfectly located (...)
€195,000
TSEA5110204
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Opportunity! Beachfront penthouse in Manilva, in the Aparthotel Don Juan.
The apartment, located on the fifth floor, has a floor area of 104 m² and a 12 m² terrace with sea views, facing (...)
€2,000,000
TSEA5109901
- Martiricos, Costa Del Sol
Beds: 3 Baths: 3 M2: 136 Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Region: Andalucía
Welcome to the highest and most exclusive penthouse in Andalusia. Direct from the developer.. This extraordinary residence offers not only an unparalleled luxury experience, but also stunning (...)
€349,000
TSEA5109667
- Mezquitilla, Costa Del Sol East
Beds: 2 Baths: 1 M2: 98 Lot Size: 98 Region: Andalucía
Beds: 2 Baths: 1 M2: 98 Lot Size: 98 Region: Andalucía
Welcome to this charming penthouse in the coastal village of Mezquitillaa perfect blend of comfort, functionality, and Mediterranean lifestyle. This well-designed apartment stands out with two (...)
€329,000
TSEA5109616
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Brand New to the Market – Prime Coastal Location in Calahonda !
Just a three-minute walk to the beach and the renowned Calahonda Royal Beach Restaurant, Supermarkets and shops etc..
This (...)
€386,000
TSEA5109583
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
great property in the centre of Estepona very close to the beach, town hall and shopping area. very convenient to walk to all places
flat on the top floor of the building of three, has an attic area (...)
€1,200,000
TSEA5109568
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 101 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Estepona Region: Andalucía
Exclusive Beachfront Penthouses – Experience Estepona at Its Finest – Stunning Penthouses with Panoramic Sea Views
Description:
Exclusive Costa del Sol Property Listings - 5 is sold og the 7 (...)
€560,000
TSEA5109427
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 123 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 123 Area: Fuengirola Region: Andalucía
Welcome to our large penthouse with 4 bedrooms and 125m2 terrace with Jacuzzi, located just around the corner from the Fuengirola Castle and the enormous shoppingcenter of Miramar in Fuengirola. This (...)
Current Featured Properties
€1,150,000
TSEA4742692
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 153 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 153 Area: Estepona Region: Andalucía
Located on the Costa del Sol, this boutique complex of 24 homes overlooks the Mediterranean and offers a wonderful spectacle of light and tranquility. Live the lifestyle you deserve in this dreamlike (...)
€900,000
TSEA5037085
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
The exclusive residential complex invites you to a modern lifestyle infused with traditional Andalusian charm, all within a community designed for those who appreciate quality and natural beauty. At (...)
€720,000
TSEA4502350
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 107 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 107 Area: Estepona Region: Andalucía
New residential project of 2 and 3 bedroom apartments located in Estepona where you will enjoy stunning sea views.
With its cobbled streets, whitewashed buildings with flowers Estepona has a unique (...)
