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,68,69,70)
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,68,69,70)
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,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 721 - 740 of 1524 €720,000
TSEA5034313
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 99 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Penthouse with Spectacular 207 m² Wrap-Around Terrace
We present this stunning penthouse featuring 2 bedrooms and 2 bathrooms, recently furnished with top-quality brands and ready to move (...)
€2,100,000
TSEA5034295
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 204 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 204 Area: Marbella West Region: Andalucía
Exclusive, south-west facing duplex penthouse with sea views in one of the most prestigious beachfront developments in Puerto Banús (Marbella).
The resort offers security, well maintained and (...)
€395,000
TSEA5034262
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 67 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 67 Area: Estepona Region: Andalucía
One-bedroom apartment with private terrace located in one of Estepona's most promising new residential complexes, right on the up-and-coming Calle Archidona. This modern, stylish development offers (...)
€699,000
TSEA5034076
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 300 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 300 Area: Mijas and Mijas Costa Region: Andalucía
For sale: a stylish and modern townhouse with 4 spacious bedrooms and 3 well-appointed bathrooms, perfectly positioned on the sunny south side — ensuring light, warmth, and comfort, especially in (...)
€730,000
TSEA4950841
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 133 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Fuengirola Region: Andalucía
New Development: Prices from 730,000 € to 799,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 133.00 m2 - 165.00 m2]
Discover this exclusive promotion of 77 homes in Fuengirola. Apartments with (...)
€690,000
TSEA5032801
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 152 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 152 Area: Estepona Region: Andalucía
Stylish Corner Townhouse with Panoramic Mountain Views in Cancelada – New Build with Solarium, Terrace & High-End Upgrades
Welcome to this stunning corner townhouse with panoramic mountain (...)
€499,000
TSEA5032726
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 114 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Mijas and Mijas Costa Region: Andalucía
Enjoy panoramic views of the sea from this spacious top-floor apartment, ideally situated to take in the lively maritime scene.
Features of the Apartment:
- Three double bedrooms with twin beds (...)
€443,000
TSEA5032642
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 79 Lot Size: 79 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 79 Lot Size: 79 Area: Benalmadena Region: Andalucía
Rare Opportunity – A Unique Home in a Legendary Community at a Prime Location!
This stunning, fully renovated two-bedroom corner apartment offers the perfect combination of top location, (...)
€488,000
TSEA5032378
- 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
Penthouse for sale – Serenity Collection, Estepona
Modern penthouse for sale in the prestigious Serenity Collection development in Estepona. The property is like new, fully furnished, and is being (...)
€520,000
TSEA5032339
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 179 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 179 Area: Mijas and Mijas Costa Region: Andalucía
Spacious 3-Bedroom Semi-detached house in Riviera del Sol with Stunning Sea, Golf & Lake Views
Discover this beautifully maintained 3-bedroom semi-detached house nestled in a small, exclusive (...)
€395,000
TSEA5032315
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 117 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Marbella East Region: Andalucía
Stunning 2-Bedroom Penthouse with Breathtaking Coastal Views – For Sale in La Mairena
Located just 10 minutes above Elviria and Marbella's renowned beaches, this immaculate two-bedroom, (...)
€595,000
TSEA5032282
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
In the residential area of Calahonda,
just minutes from the beach, beach bars, the shopping center, and bars and restaurants.
Fantastic semi-detached house with 3 bedrooms, 2 en-suite (...)
€773,000
TSEA5032279
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 127 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 127 Area: Estepona Region: Andalucía
This development is placed in an excellent location.
Situated on an elevated plot that also benefits from being in front of a park and a sports area, guaranteeing sea views.
The development offers 2, (...)
€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 (...)
€450,000
TSEA5032039
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 107 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 107 Area: Fuengirola Region: Andalucía
Great Opportunity in the Heart of Los Boliches!
We are pleased to present this property with huge potential, located in one of the most sought-after areas of Fuengirola: right in the center of Los (...)
€465,000
TSEA5031964
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 128 Lot Size: 128 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Lot Size: 128 Area: Estepona Region: Andalucía
Welcome to your new spacious 3-bedroom, 2-bathroom semi-detached townhouse in the heart of Bel Air, on the prestigious New Golden Mile. This gem is in a secure, gated urbanization with just one (...)
€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 (...)
€550,000
TSEA5031904
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 167 Lot Size: 322 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 167 Lot Size: 322 Area: Mijas and Mijas Costa Region: Andalucía
Corner townhouse with a private garden, just a stone's throw from the beach and a few minutes from Cala de Mijas. This two-story townhouse needs a touch of modernity, as it is a Mediterranean-style (...)
€480,000
TSEA5031898
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 210 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 210 Area: Estepona Region: Andalucía
Beautiful townhouse, in an exclusive urbanisation, Coto de la Serena in the New Golden Mile of Estepona, between Estepona and San Pedro.
It has beautiful sea views from the upper floor.
The property (...)
€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 (...)
Current Featured Properties
€2,995,000
TSEA5143633
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Bahía del Velerín is a luxurious community between Marbella and Estepona. It has a fantastic pool area with a snack bar, tropical gardens and 24/7 security. The community is located at one of the (...)
€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 (...)
€515,000
TSEA4941421
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Discover 19 stunning homes that combine nature and sea. With elegant details, spacious terraces and fitted kitchens, you will enjoy exceptional living in the heart of Mijas. Immerse yourself in a (...)
