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 (61,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 (61,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 (61,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (2652), Middle Floor - (2652), Penthouse - (2652), Top Floor Apartment - (2652), Penthouse Duplex - (2652)Properties
Results 221 - 240 of 3913
€459,000
TSEA5148505
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 114 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Fuengirola Region: Andalucía
Fantastic Apartment with Sea Views on the Second Line of the Beach
In the Torreblanca area.
Spacious and bright apartment in a high-quality building of approximately 130 m2, just steps from the (...)
€238,000
TSEA5148484
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 1 M2: 60 Area: Ojen Region: Andalucía
Beds: 2 Baths: 1 M2: 60 Area: Ojen Region: Andalucía
Middle Floor Apartment, Ojén, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 60 m².
Setting : Town, Close To Schools.
Orientation : South West.
Condition : Good.
Climate Control : Air Conditioning, (...)
€743,000
TSEA5148427
- Los Alamos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 102 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 102 Area: Torremolinos Region: Andalucía
Looking to live by the sea in a prime location?
Close proximity to parks, schools, supermarkets, restaurants, and bars.
Easy access to the highway, with quick connections along the coast.
Just a (...)
€344,900
TSEA5148319
- Torre del Mar, Costa Del Sol East
Beds: 3 Baths: 2 M2: 96 Lot Size: 96 Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Lot Size: 96 Region: Andalucía
This modern apartment in the center of Torre del Mar combines comfort, brightness, and an unbeatable location. The property offers 3 bedrooms, one of them currently used as a laundry room, adding (...)
€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, (...)
€389,000
TSEA5148280
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 99 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: Casares Region: Andalucía
This fantastic ground floor apartment is set in the sought-after gated community of Casares Green, offering the perfect balance between modern living and the beauty of the Andalusian (...)
€779,900
TSEA5148277
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 143 Lot Size: 55 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 143 Lot Size: 55 Area: San Pedro Region: Andalucía
Luxury Beachside Golf Retreat in Guadalmina Baja
Just 5 minutes from Puerto Banús, discover the epitome of Mediterranean elegance in this spacious 5-bedroom, 4-bathroom retreat, perfectly (...)
€249,000
TSEA5148268
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 90 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Casares Region: Andalucía
Breathtaking 2-Bedroom Apartment in Casares del Sol – 800m from the Beach
Experience the ultimate Costa del Sol lifestyle in this stunning apartment, perfectly situated in the exclusive gated (...)
€495,000
TSEA5148265
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Elegant 3-Bedroom Apartment in Sunny Golf, Estepona
Welcome to this stylish middle-floor apartment in Sunny Golf, Estepona. Delivered in 2024 and upgraded with care, it offers a modern living (...)
€298,000
TSEA5148250
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 1 M2: 124 Area: Ojen Region: Andalucía
Beds: 2 Baths: 1 M2: 124 Area: Ojen Region: Andalucía
Duplex penthouse in the heart of the charming village of Ojen, very close to shops, supermarkets, and the school.
This spacious and bright duplex penthouse features a large living room with a (...)
€565,000
TSEA5148193
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 92 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 92 Area: Marbella Region: Andalucía
Magnificent apartment for sale in one of the best areas of San Pedro de Alcantara (Marbella). Nueva Alcantara, on the beachfront and of course with wonderful sea views and a pool.
This magnificent (...)
€475,000
TSEA5148178
- Los Flamingos, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
This beautifully furnished 2-bedroom apartment is located in the prestigious complex of Hoyo 19, within the exclusive Los Flamingos Golf Resort in Benahavis. The apartment offers a perfect blend of (...)
€445,000
TSEA5148001
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 92 Lot Size: 30 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Lot Size: 30 Area: Estepona Region: Andalucía
Bright and Modern Ground-Floor Apartment in El Paraíso – New Golden Mile
This beautifully renovated ground-floor apartment is located in the sought-after El Paraíso district, on the New Golden (...)
€423,000
TSEA5147983
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 86 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 86 Area: Casares Region: Andalucía
This new development is set in an exceptional location between the highly sought-after towns of Casares and Estepona, two of the most treasured enclaves on the Costa del Sol.
Comprising ten (...)
€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, (...)
€2,175,000
TSEA5147947
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Exceptional Frontline Beach Corner Apartment with Spectacular Views
Experience coastal living at its finest in this stunning frontline beach corner apartment, which offers breathtaking views of the (...)
€250,000
TSEA5147944
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
Well-Presented 1-Bedroom Apartment in Los Boliches, Fuengirola
This charming ground-floor apartment offers a fantastic opportunity to enjoy the vibrant lifestyle of Los Boliches, with all amenities (...)
€725,000
TSEA5147932
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 138 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 138 Area: Marbella Region: Andalucía
FIRST LINE BEACH APARTMENT!
Magnificent duplex penthouse for sale in one of the best areas of San Pedro de Alcantara (Marbella). Nueva Alcantara, on the beachfront and of course with wonderful sea (...)
€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 (...)
Current Featured Properties
€534,450
TSEA4581373
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 105 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: San Pedro Region: Andalucía
The development in San Pedro de Alcantara is made up of 35 homes with 2 and 3 bedrooms, with duplexes with terraces-solariums. Garages in the basement and commercial premises on the ground floor, in (...)
€370,000
TSEA5149840
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€2,400,000
TSEA4657528
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 189 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 189 Area: Benahavis Region: Andalucía
The construction is proposed in two phases, corresponding to the 2 distinct levels of the prime hillside position thereby taking full advantage of the privileged position on which will sit our finest (...)
