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 (70,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 (70,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 (70,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 461 - 480 of 4559
€469,000
TSEA5140846
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 121 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 121 Area: Marbella East Region: Andalucía
This exquisite first-floor apartment, ideally situated adjacent to Artola golf and within walking distance of the charming Cabopino port, offers a perfect blend of luxury and convenience. The (...)
€5,750,000
TSEA5140834
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 5 M2: 341 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 5 M2: 341 Area: Marbella East Region: Andalucía
This extraordinary apartment, boasting 400 m2 built all on one level including 63 m2 of private terraces, is a true rarity not only within the exclusive La Trinidad complex but across the entire (...)
€398,000
TSEA5140831
- Campo Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Partially renovated townhouse in Campo Mijas with panoramic views. Spread over 3 floors, it features 3 bedrooms, terraces on every level, a solarium, modern kitchen, and BBQ terrace. Community pool (...)
€399,000
TSEA5140819
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 89 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Mijas and Mijas Costa Region: Andalucía
Top Floor Apartment for Sale in Calahonda – Prime Location on the Costa del Sol
This bright and spacious top floor apartment offers the perfect combination of comfort, convenience, and coastal (...)
€186,000
TSEA5140801
- Guadiaro, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 114 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Sotogrande Region: Andalucía
Apartment for Sale in the Heart of Guadiaro
Magnificent property located right in the center of the village, surrounded by all amenities: restaurants, schools, playground, medical center, post (...)
€850,000
TSEA5140756
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
✨Exclusive penthouse in Estepona with dreamy sea views✨
???? Panoramic sea views from the living room, kitchen, and master bedroom.
???? From the 50m² terrace, you can enjoy the entire (...)
€390,000
TSEA5140744
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 112 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Area: Marbella East Region: Andalucía
Discover your dream lifestyle in this immaculate two-bedroom penthouse, perfectly positioned to offer breathtaking views over the Mediterranean. With a desirable south-west orientation, you can bask (...)
€420,000
TSEA5140726
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 87 Lot Size: 148 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Lot Size: 148 Area: Casares Region: Andalucía
Fantastic corner ground-floor apartment in an elevated position, in perfect condition, with a spacious, open-plan modern kitchen. The living-dining room is very bright and luminous thanks to its (...)
€420,000
TSEA5140723
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 107 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 107 Area: Marbella West Region: Andalucía
Investment opportunity with sea views in prime location of Nueva Andalucia.
This apartment offers excellent investment potential and can easily be converted into a two-bedroom apartment. With its (...)
€699,000
TSEA5140534
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 123 Lot Size: 149 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 123 Lot Size: 149 Area: Benalmadena Region: Andalucía
Townhouse for sale at La Capellanía - El Higuerón, Benalmádena
Discover this exclusive semi-detached house located in the prestigious Reserva El Higuerón complex, a privileged enclave on the (...)
€559,000
TSEA5140528
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 270 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 270 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular Luxury Penthouse with Large Terraces in the Heart of the City
Discover this beautiful penthouse that redefines comfort and elegance. With a generous layout, this property features three (...)
€1,150,000
TSEA5140171
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 142 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 142 Area: San Pedro Region: Andalucía
Located in the exclusive TERRA residential development, just a short walk from the beach and the vibrant center of San Pedro de Alcántara, this brand-new apartment offers the perfect combination of (...)
€2,395,000
TSEA5140108
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 276 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 276 Area: Marbella East Region: Andalucía
Luxurious three-bedroom duplex Penthouse with en-suite bathrooms for sale in Las Lomas del Rey, a secure and prestigious urbanisation ideally located on Marbella's exclusive Golden Mile. Built in (...)
€795,000
TSEA5140105
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 348 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 348 Area: Sotogrande Region: Andalucía
Mirador del Golf is a prestigious and very private development, composed of 20 exclusive apartments surrounded by native vegetation and beautifully landscaped gardens. Designed for those who value (...)
€410,000
TSEA5140060
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 172 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 172 Area: San Pedro Region: Andalucía
It is the perfect opportunity in a privileged environment next to the golf course, to design the home of your dreams. Located in a gated community with all amenities, it offers security, exclusivity, (...)
€825,000
TSEA5139946
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
Located in the sought-after Cataleya Phase 2, this rare 2-bedroom first-floor apartment combines modern luxury, expansive outdoor living, and a prime Costa del Sol address. With only three apartments (...)
€425,000
TSEA5139925
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 119 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 119 Area: Estepona Region: Andalucía
Available for viewings starting from 23rd of September.
✨ A rare opportunity to own a modern 3-bedroom, 2-bathroom apartment with exceptional lifestyle amenities and unbeatable investment (...)
€500,000
TSEA5139916
- La Campana, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
NEW!!!!!!
Absolutely new apartment delivered few month a go .
3 bedrooms and 2 bathrooms
Kitchen appliances included in price
Perfect location for both personal accommodation and for renting out!
All (...)
€525,000
TSEA5139910
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 95 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Fuengirola Region: Andalucía
Great opportunity within the most famous complex in Fuengirola, Puebla Lucia. This two bedroom, two bathroom apartment is in perfect condition and sold fully furnished. The apartment is spacious and (...)
€769,000
TSEA5139889
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Discover this inviting top-floor apartment in the heart of La Cala de Mijas on the Costa del Sol, offering the perfect blend of space, comfort, and location. Just a 2-minute stroll to the beach and (...)
Current Featured Properties
€559,950
TSEA4450111
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 188 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 188 Area: Fuengirola Region: Andalucía
This new development is located in the north of Fuengirola, in the Los Pacos neighborhood: a residential, multicultural and multilingual area with a cosmopolitan atmosphere, close to the beach and (...)
€1,950,000
TSEA4943089
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 126 Lot Size: 186 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 126 Lot Size: 186 Area: Malaga Region: Andalucía
This residential complex is where the contemporary and the traditional come together. For this reason, we will find renovated buildings, alongside newly built buildings or buildings protected as (...)
€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 (...)
