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 (42,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 (42,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 (42,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 281 - 300 of 5896
€4,195,000
TSEA5148511
- Las Brisas, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 341 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 341 Area: Marbella West Region: Andalucía
We're pleased to offer an off-market villa in one of the most desirable areas of Nueva Andalucía – Las Brisas – available exclusively through private introduction.
This south-facing villa, (...)
€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 (...)
€2,025,000
TSEA5148343
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 3 M2: 168 Lot Size: 984 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 3 M2: 168 Lot Size: 984 Area: Marbella West Region: Andalucía
This charming villa is tucked away in a peaceful cul-de-sac within the exclusive gated community of Marbella Country Club, one of Nueva Andalucía's most desirable residential areas. Set on a flat (...)
€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 (...)
€1,148,000
TSEA5148238
- Entrerrios, Costa Del Sol
Beds: 6 Baths: 5 M2: 425 Region: Andalucía
Beds: 6 Baths: 5 M2: 425 Region: Andalucía
Exclusive independent villa for sale with traditional Andalusian "Cortijo" style, located in one of the most peaceful and sought-after areas of Mijas, in the Entrerríos area. This unique (...)
€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 (...)
Current Featured Properties
€659,500
TSEA4032328
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
LUXURIOUS, HARMONIOUS, CLOSE TO BEAUTIFUL BEACHES.
This is one of the most stylish beachside developments in Fuengirola, on the Costa del Sol. Only 100m FROM THE SEA! featuring 1, 2 or 3 bedroom (...)
€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 (...)
€1,800,000
TSEA5063395
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 385 Lot Size: 10,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 385 Lot Size: 10,000 Area: Mijas and Mijas Costa Region: Andalucía
Immerse yourself in the captivating charm of this refined utterly peaceful country home, affording absolute privacy and breathtaking panoramic views, which unfold before you as far as the sea and the (...)
