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 (51,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 (51,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 (51,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 1 - 20 of 3920
€489,000
TSEA5159650
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 80 Lot Size: 39 Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Lot Size: 39 Region: Andalucía
Exclusive Ground-Floor Apartment with Private Garden in Las Lomas del Higuerón – Fuengirola
Located in one of the most sought-after residential areas on the Costa del Sol, this spectacular (...)
€739,000
TSEA5159641
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 470 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 470 Area: Mijas and Mijas Costa Region: Andalucía
This exceptional triplex penthouse with 470 m² of floor space and 270 m² of usable space plus terraces, garages and storage rooms redefines the concept of living on the Costa del Sol. Located in a (...)
€220,000
TSEA5159560
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 46 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 46 Area: Marbella Region: Andalucía
We offers a SUPERB STUDIO IN MARBELLA.
Located 5 minutes from the beach and the hospital, just 1 minute from the Old Town.
Property located in the heart of Puerto Banús, Marbella, in one of the (...)
€869,000
TSEA5159548
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 150 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 150 Area: Estepona Region: Andalucía
Modern Corner Apartment in the Heart of Estepona!
Located right in the vibrant center of Estepona, just steps away from everything this charming coastal town has to offer and within easy reach of (...)
€459,000
TSEA5159533
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Spectacular Seafront Apartment in the Best Area of Fuengirola
Located on the ninth floor, this magnificent apartment boasts unbeatable panoramic views of the sea, the mountains, and the iconic (...)
€525,000
TSEA5159521
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 56 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 56 Area: Mijas and Mijas Costa Region: Andalucía
SECOND LINE BEACH. This is a lovely 2 bedroom penthouse apartment with fantastic pool, garden and sea views from the enclosed terrace and solarium. Situated in a great location very close to the (...)
€1,290,000
TSEA5159458
- La Capellania, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 130 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Fuengirola Region: Andalucía
Penthouse, La Capellania, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 100 m².
Setting : Close To Sea, Urbanisation.
Orientation : South, South West.
Condition : Excellent.
Pool : (...)
€279,000
TSEA5159371
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 98 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 98 Area: Fuengirola Region: Andalucía
Bright corner apartment next to Plaza Hispanidad and the market square in Fuengirola. In the area there are several grocery stores, cafes, bakery, pharmacy, etc.
The apartment has a proper entrance (...)
€359,000
TSEA5159335
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Two bedroom apartment in the popular Calazul complex central to amenities and public transport. The apartment has a sunny terrace and park views. There are two bathrooms one is ensuite with a bath (...)
€1,100,000
TSEA5159263
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 137 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 137 Area: Estepona Region: Andalucía
EXCEPTIONAL BEACHFRONT PENTHOUSE WITH PANORAMIC VIEWS OF THE SEA, MOUNTAINS, AND THE AFRICAN COASTLINE, FEATURING TWO SPACIOUS TERRACES TOTALING 100m². This exclusive property is located in the (...)
€375,000
TSEA5159209
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 2 M2: 115 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 2 M2: 115 Area: Benalmadena Region: Andalucía
In the heart of Arroyo de la Miel, just a few steps from the commuter train station and only 1.5 km from the beach, lies this magnificent 115 m² apartment an ideal home for families looking for (...)
€620,000
TSEA5159194
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 113 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Fuengirola Region: Andalucía
Located just 100 metres from the beach and close to Castillo Sohail Fuengirola this spacious three bedroom apartment offers the perfect blend of coastal living and urban convenience. Situated on the (...)
€510,000
TSEA5159173
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic opportunity to buy a Duplex penthouse in front line golf with open panoramic views
Ample 3 bedrooms and 3 bathrooms, with highest quality finishes and outstanding views to the three golf (...)
€1,250,000
TSEA5159074
- Estepona, 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
Stunning, south-facing fully renovated, three bedroom beachfront apartment in the heart of Estepona's charming Old Town offering spectacular panoramic sea views. With a large usable space, the home (...)
€1,700,000
TSEA5159005
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
Apartment for sale in Los Granados del Mar, Estepona with 3 bedrooms, 3 bathrooms, 2 en suite bathrooms and with orientation south/east, with communal swimming pool, communal garage (1 parking (...)
€435,000
TSEA5158933
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 240 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 240 Area: Mijas and Mijas Costa Region: Andalucía
Apartment for sale in , Mijas Costa with 3 bedrooms, 2 bathrooms, 1 on suite bathroom, 1 toilet and with orientation west, with communal swimming pool, private garage (2 parking spaces) and communal (...)
€559,000
TSEA5158861
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 117 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Benahavis Region: Andalucía
Elegant 2-Bedroom Apartment in Capanes del Golf – Where Tranquility Meets Sophistication
This beautifully appointed 2-bedroom garden apartment is located in Capanes del Golf, a prestigious gated (...)
€365,000
TSEA5158834
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 85 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 85 Area: Casares Region: Andalucía
We are pleased to present this magnificent duplex penthouse located in the exclusive Doña Julia area of Casares, a privileged setting that combines peace, elegance, and proximity to the sea. A (...)
€419,000
TSEA5158828
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 82 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Torremolinos Region: Andalucía
This fantastic 2-bedroom apartment with sea views is ideally located in the heart of Torremolinos, offering the best of the Costa del Sol lifestyle.
You're just a 10-minute walk from shops, (...)
€530,000
TSEA5158819
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 104 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Marbella Region: Andalucía
Situated in the heart of Marbella Centro, this unique first floor apartment offers a rare opportunity with its south orientation and an large private terrace that spans the entire building and (...)
Current Featured Properties
€630,000
TSEA4245991
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 70 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Benalmadena Region: Andalucía
BREATHTAKING VIEWS OF THE SEA!!!
This is an exclusive, private development situated in a privileged location in Benalmádena. Thanks to its elevated position, all homes boast panoramic views of the (...)
€345,000
TSEA4707298
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 78 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 78 Area: Fuengirola Region: Andalucía
New development for sale in the center of Fuengirola just 200 m to the beach, historic center, near the Fuengirola Marina. There are 6 apartments with 2 and 3 bedrooms, with 2 bathrooms, terrace and (...)
€890,000
TSEA4939027
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
This is the opportunity of living in Spain, in the best equipped residential complex in Marbella, located in a privileged spot near the golf club and with premium quality specifi cations. You will (...)
