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 (53,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 (53,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 (53,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 221 - 240 of 3900
€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 (...)
€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 (...)
€495,000
TSEA5147920
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Live the Mediterranean Dream: Your Beachside Oasis in Calahonda Awaits
Discover the pinnacle of coastal living in this impeccable, ground-floor two-bedroom apartment, situated in a secure beachfront (...)
Current Featured Properties
€444,200
TSEA4331449
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
YOU WILL NOT GET A BETTER VIEW!!
There is a place on the Costa del Sol where the sky meets the Mediterranean Sea. That place is this brand new development in Benalmádena.
35 apartments and (...)
€470,000
Oasis of tranquility close to beaches
- San Roque, Costa Del Sol, San Roque
Beds: 3 Baths: 2 M2: 115 Area: San Roque Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: San Roque Region: Andalucía
OASIS OF TRANQUILITY CLOSE TO BEACHES.
New release! A great opportunity to buy an off plan apartment at an UNBEATABLE PRICE. The apartment style is light and bright with large open plan living (...)
€900,000
TSEA5037085
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
The exclusive residential complex invites you to a modern lifestyle infused with traditional Andalusian charm, all within a community designed for those who appreciate quality and natural beauty. At (...)
