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 21 - 40 of 792
€359,000
TSEA5153647
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Stylish Renovated Apartment by the Beach in Estepona
Discover this beautifully renovated apartment, perfectly located in a sought-after beachfront urbanization in the very heart of Estepona. Just (...)
€410,000
TSEA5153545
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 88 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Marbella West Region: Andalucía
Superb penthouse in the Nueva Andalucía area. Comprising 2 bedrooms, 2 bathrooms, and a living/dining room with access to a spacious 25 m² terrace.
The gated and well-maintained community offers a (...)
€1,850,000
TSEA5153413
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 202 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 202 Area: Benalmadena Region: Andalucía
Luxury duplex penthouse located on the beachfront in the famous Puerto Marina marina. A very quiet area with all amenities, including restaurants and several shops, right on the doorstep.
The (...)
€138,500
TSEA5152945
- Antequera, Costa Del Sol, Antequera
Beds: 1 Baths: 1 M2: 51 Area: Antequera Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Antequera Region: Andalucía
Modern 1-Bedroom Apartment in the Historic Heart of Antequera, Atico
Located right in the centre of Antequera, this modern apartment offers the perfect combination of style, comfort, and (...)
€450,000
TSEA5152114
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 130 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Casares Region: Andalucía
Exquisite Penthouse in Majestic, Casares del Sol – Casares Golf: Panoramic Sea and Mountain Views, Just 5 Minutes Walk to the Beach!
Elevate your lifestyle with this stunning penthouse in the (...)
€525,000
TSEA5151970
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 135 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: Benahavis Region: Andalucía
Stunning Two-Bedroom Penthouse Apartment in Gazules del Sol
This bright and elegant two-bedroom penthouse is located in the sought-after urbanisation Gazules del Sol.
Upon entering, you are (...)
€495,000
TSEA5150911
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
This beautiful, fully exterior apartment stands out for its excellent location and natural brightness throughout. Located in a peaceful residential area of Marbella, it is just 400 meters from the (...)
€395,000
TSEA5150782
- Sierrezuela, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse with Panoramic Views of Fuengirola and the Mediterranean
This spacious penthouse in Sierrezuela offers one of the most spectacular terraces you can find – a 50 m² outdoor space with sun (...)
€1,875,000
TSEA5150743
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 4 M2: 316 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 4 M2: 316 Area: La Duquesa Region: Andalucía
Unique Penthouse in Puerto de la Duquesa with 360° Views
• A truly unique property on the market: a 3-bedroom, 4-bathroom penthouse with a wrap-around panoramic terra
360° views of the sea, (...)
€335,000
TSEA5150740
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
This charming apartment, located on the first and top floor, perfectly combines comfort, style, and an unbeatable location. Fully renovated and tastefully furnished, it offers modern, functional (...)
€950,000
TSEA5150737
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 73 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 73 Area: Marbella East Region: Andalucía
This unique penthouse is located in a renowned and well-established beachfront urbanization, with direct access to one of the best beaches on the Costa del Sol and its promenade.
As soon as you step (...)
€222,900
TSEA5150437
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
**64 m² Studio Apartment for Sale – Riviera del Sol, Costa del Sol (Spain)**
This attractive ground floor studio is located in a gated and secure community, just 400 meters from the beach, (...)
€280,000
TSEA5149936
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 71 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Casares Region: Andalucía
Penthouse with Solarium and Panoramic Sea Views in Casares Playa
This exclusive penthouse with a private solarium in Casares Playa combines space, natural light, and a privileged location on the (...)
€425,000
TSEA5148742
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
ELVIRIA. LOVELY APARTMENT WITH GREAT POTENTIAL SITUATED ON THE TOP FLOOR IN THE CENTRAL URBANIZATION OF PARQUE ELVIRIA. THE APARTMENT IS 105 m2 INCLUDING TERRACES. THE APARTMENT HAS 3 BEDROOMS AND 2 (...)
€995,000
TSEA5148298
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 323 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 323 Area: San Pedro Region: Andalucía
Located in a recently built development, in a prime position just steps from the center of San Pedro de Alcántara, this elegant penthouse combines modern design, comfort, and an unbeatable location, (...)
€535,000
TSEA5147980
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 82 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Fuengirola Region: Andalucía
Panoramic Seafront Living: Modern Apartment in the Heart of Fuengirola
For sale: a unique two-bedroom apartment in the prestigious Los Brothers Fuengirola complex, located directly opposite the (...)
€3,700,000
TSEA5147953
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 294 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 294 Area: Benalmadena Region: Andalucía
The most exclusive penthouses in Reserva del Higuerón.
One of the best sales opportunities on the Costa del Sol!
The owner will enjoy the unique experience of floating above the Mediterranean, (...)
€550,000
TSEA5147926
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
3-Bedroom Penthouse in Prime Beachside Location
This spacious three-bedroom penthouse is located in Costalita in Estepona East. Upon entering, you are welcomed by a modern kitchen that flows into (...)
€199,000
TSEA5147791
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 26 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 26 Area: Benalmadena Region: Andalucía
Renovated Studio with Sea Views on the Top Floor – Puerto Marina, Benalmádena
Located on the seventh and top floor of a well-maintained building, this bright, renovated studio offers stunning (...)
€5,390,000
TSEA5147437
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 588 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 588 Area: Marbella East Region: Andalucía
This exceptional duplex penthouse is located within Epic Marbella on the Golden Mile, one of the most prestigious addresses in Marbella. Designed to impress, the property spans 586 m², including 351 (...)
Current Featured Properties
€893,000
TSEA4887208
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 175 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 175 Area: Casares Region: Andalucía
This residential complex of 36 homes with 2 and 3 bedrooms and an exceptional range of services. Each home is carefully designed using soft, organic lines that blend naturally into the surroundings, (...)
€670,000
TSEA4686511
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 119 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 119 Area: Casares Region: Andalucía
Located in the area of Doña Julia Golf, this new development emerges as an oasis of elegance and tranquility on the Costa del Sol, much more than a simple residential area. A refuge for lovers (...)
€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 (...)
