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 (47,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 (47,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 (47,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3910), Middle Floor - (3910), Penthouse - (3910), Top Floor Apartment - (3910), Penthouse Duplex - (3910)Properties
Results 41 - 60 of 4050
€450,000
TSEA5157598
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 110 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: San Pedro Region: Andalucía
This 3 bedroom apartment is located on the boulevard of San Pedro, surrounded by shops and restaurants. The apartment consists of 3 bedrooms, 2 bathrooms, kitchen, living-dining room and terrace with (...)
€295,000
TSEA5157586
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 44 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 44 Area: Marbella West Region: Andalucía
First floor south and east-facing apartment surrounded by golf and amenities, Torres de Aloha, Nueva Andalucía. Comprising living/dining room, small kitchen and east-facing terrace, and a bedroom (...)
€795,000
TSEA5157580
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 114 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 114 Area: Marbella Region: Andalucía
Situated in one of the most picturesque parts of Marbella, this newly refurbished three-bedroom, three-bathroom apartment has been finished to the very highest standards. Modern yet understatedly (...)
€355,000
TSEA5157487
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 52 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: Mijas and Mijas Costa Region: Andalucía
LOCATION SITIO DE CALAHONDA ! FRONTLINE FIRSTLINE BEACH APARTMENT WITH PANORAMIC SEAVIEWS
Discover this beautifully newly renovated middle-floor apartment in a highly sought-after frontline beach (...)
€160,000
TSEA5157484
- El Padron, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 49 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Estepona Region: Andalucía
Spectacular panoramic views of the sea and mountains
Brand new, fully renovated duplex penthouse with a separate bedroom on the upper level, a full bathroom with a large shower and window.
Ground (...)
€620,000
TSEA5157445
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 106 Region: Andalucía
Beds: 2 Baths: 2 M2: 106 Region: Andalucía
Penthouse Living at Its Best
Step into a world of style and comfort with this stunning penthouse apartment. Featuring two elegant bathrooms – one with a sleek shower and the other with a luxurious (...)
€308,500
TSEA5157409
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola centre, Costa del Sol.
2.5 Bedrooms, 1 Bathroom, Built 61 m².
Setting : Town, Close To Sea.
Condition : Good.
Climate Control : Air Conditioning.
Features : (...)
€1,095,000
TSEA5157376
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 125 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Fuengirola Region: Andalucía
Exclusive newly built penthouse with 3 bedrooms and a spacious south-facing terrace offering spectacular sea and mountain views.
The home comes fully furnished with high-end designer pieces created (...)
€1,090,000
TSEA5157190
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
This exclusive, brand-new penthouse with three bedrooms and a large south-facing terrace with sea and mountain views is fully furnished with high-end designer pieces by Ikonia Ilusion&Arte, which (...)
€385,000
TSEA5157172
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Investment Opportunity – New on the Market!
Front line beach apartment in Calahonda with spectacular sea views.
Features:
• 3 bedrooms
• 2 bathrooms
• Complex with swimming pool
• (...)
€249,999
TSEA5157166
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
This beautifully presented 2 bedroom middle floor property has a bright open lounge and generous separate fully fitted kitchen. The large main bedroom and double guest bedroom both have built-in (...)
€1,190,000
TSEA5157151
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
New exclusive 3-bedroom penthouse for sale with panoramic sea views and a south-facing location to enjoy sunlight, privacy, and uninterrupted views all day long.
Located in the exclusive residential (...)
€5,395,000
TSEA5157145
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 270 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 270 Area: Marbella East Region: Andalucía
Situated in the exclusive Puente Romano resort, this renovated south-facing corner penthouse offers a living experience that perfectly balances convenience with comfort. With stunning views from its (...)
€269,000
TSEA5157136
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 112 Lot Size: 23 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Lot Size: 23 Area: Casares Region: Andalucía
Charming ground floor apartment in Casares Costa with two bedrooms and two bathrooms, within a small, quiet urbanisation. The property stands out for its spacious, south-facing terrace and private (...)
€265,000
TSEA5157067
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 56 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Fuengirola Region: Andalucía
New Development: Prices from 265,000 € to 1,100,000 €. [Beds: 1 - 4] [Baths: 1 - 3] [Built size: 56.00 m2 - 188.00 m2]
Boutique Sea-View Apartments in Torreblanca del Sol
Features:
Sea-facing (...)
€660,000
TSEA5157052
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 135 Lot Size: 28 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 135 Lot Size: 28 Area: Benahavis Region: Andalucía
Elegant ground-floor apartment with a large terrace and private garden in a prestigious gated community Benatalya.
The property features a spacious layout with 3 bedrooms and 3 bathrooms, a bright (...)
€699,000
TSEA5156986
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 83 Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Region: Andalucía
Med One, Higuerón West – Luxury 2-Bedroom Apartment with Panoramic Sea Views
Located within the prestigious Med One complex in Higuerón West, this elegant two-bedroom, two-bathroom apartment (...)
€899,000
TSEA5156980
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 103 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: Fuengirola Region: Andalucía
Stunning 3-Bedroom Penthouse with Private Pool, Panoramic Views & Luxury Outdoor Living
Experience elevated coastal living in this one-of-a-kind penthouse, perfectly positioned just moments from (...)
€340,000
TSEA5156938
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 55 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 55 Area: Mijas and Mijas Costa Region: Andalucía
Modern 2-Bedroom Apartment in the Heart of La Cala de Mijas – Steps from the Beach ✨
Discover your ideal coastal home with this beautifully presented 2 bed, 1 bath apartment located just a few (...)
€1,500,000
TSEA5156926
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 162 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: Marbella Region: Andalucía
162 m² beachfront penthouse with terrace and panoramic views – Bajadilla Beach, Marbella
This exclusive 162 m² penthouse is located on the fifth floor of the renowned La Zambomba Building, (...)
Current Featured Properties
€829,900
TSEA5083897
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 140 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Area: Fuengirola Region: Andalucía
This brand new development stands out! An exclusive residential complex with spacious layouts and top-tier construction. The residences have been built with the highest-quality materials and feature (...)
€608,000
TSEA4766254
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Apartments and penthouse apartments with 2, 3 and 4 bedrooms in Selwo, Estepona this is a place where the sea and nature become one, with stunning Mediterranean sea views.
Located in an exceptional (...)
€381,000
TSEA4436188
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 97 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Malaga Region: Andalucía
New luxury development in the heart of Málaga. As a special recipient of this email, you have the unique opportunity to be among the first to secure your place in this exciting community.
This (...)
