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 - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 2181 - 2200 of 5891 €4,700,000
TSEA5055901
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 643 Lot Size: 1,392 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 643 Lot Size: 1,392 Area: Marbella West Region: Andalucía
This exquisite 5 bedroom villa offers an idyllic setting for an unforgettable holiday experience. Immerse yourself in luxury and tranquility as you indulge in the array of amenities provided. Take (...)
€295,000
TSEA5055877
- Arriate, Costa Del Sol, Ronda
Beds: 4 Baths: 2 M2: 224 Area: Ronda Region: Andalucía
Beds: 4 Baths: 2 M2: 224 Area: Ronda Region: Andalucía
Charming rustic Andalusian-style home in the Los Arroyos residential area, Arriate. The house has 201 m² of living space spread over two floors, on a 542 m² plot with a garden and private pool.
It (...)
€826,000
TSEA5055874
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 144 Region: Andalucía
Beds: 2 Baths: 2 M2: 144 Region: Andalucía
Spacious and bright 2-bedroom apartment for sale with a large terrace and stunning sea views, located in the prestigious Higuerón West development.
The home boasts an elegant and functional layout. (...)
€183,950
TSEA5055862
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 54 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 54 Area: Mijas and Mijas Costa Region: Andalucía
New Listing – Charming 1-Bedroom Apartment in Mijas Golf!
We're excited to present this fantastic new opportunity in the ever-popular Mijas Golf community! This neat and well-maintained 1 bed, 1 (...)
€960,000
TSEA5055760
- Frigiliana, Costa Del Sol East
Beds: 4 Baths: 4 M2: 383 Lot Size: 2,962 Region: Andalucía
Beds: 4 Baths: 4 M2: 383 Lot Size: 2,962 Region: Andalucía
Charming Country Villa with Two Independent Homes, Private Pools & Stunning Views – Frigiliana
Set in the beautiful countryside near Frigiliana, this unique property offers a rare combination (...)
€379,000
TSEA5055745
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 32 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 32 Area: Fuengirola Region: Andalucía
Immaculate front line apartment for sale in Fuengirola with stunning sea and mountain views. This corner apartment is so bright and sunny and has been completely renovated.
Very well presented, this (...)
€850,000
TSEA5055730
- 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
Right in the heart of Estepona's promenade, just across the endless blue of the Mediterranean, lies a home that's not just seen — it's felt. A place where every sunrise brings a sense of peace, (...)
€3,750,000
TSEA5055703
- La Quinta, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 630 Lot Size: 1,067 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 630 Lot Size: 1,067 Area: Benahavis Region: Andalucía
Situated in the highly sought-after area of La Quinta in Benahavis, this beautifully contemporary property is perfectly suited for family living. With an unbeatable south/west-facing orientation, (...)
€665,000
TSEA5055700
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 133 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 133 Area: Mijas and Mijas Costa Region: Andalucía
Modern Luxury Apartment with Premium Amenities in the Heart of La Cala de Mijas
Sophisticated and elegant, semi-new apartment set within a prestigious 5-star residential complex in the vibrant heart (...)
€550,000
TSEA5055655
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 150 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Area: Mijas and Mijas Costa Region: Andalucía
Excellent apartment for sale in Mijas.
Very spacious and modern.
With panoramic views and a great location.
€299,000
TSEA5055358
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 2 M2: 120 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 2 M2: 120 Area: La Duquesa Region: Andalucía
Charming 4-Bedroom Semi-Detached Villa in Princessa Kristina, Manilva
Discover your dream home in this beautifully appointed 4-bedroom, 2-bathroom semi-detached villa, nestled in the serene and (...)
€535,000
TSEA5055220
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 97 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 535,000 € to 882,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 97.00 m2 - 144.00 m2]
This premium residential development is an exclusive project located in La (...)
€3,850,000
TSEA5055214
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 539 Lot Size: 2,000 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 539 Lot Size: 2,000 Area: Benahavis Region: Andalucía
New Development: Prices from 3,850,000 € to 3,850,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 539.00 m2 - 539.00 m2]
Perched atop the prestigious Monte Mayor in Benahavís, Malaga, this (...)
€4,250,000
TSEA5055208
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 496 Lot Size: 2,645 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 496 Lot Size: 2,645 Area: Benahavis Region: Andalucía
New Development: Prices from 4,250,000 € to 4,250,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 496.00 m2 - 496.00 m2]
Nestled in the exclusive Monte Mayor area of Benahavís, Malaga, this (...)
€4,250,000
TSEA5055196
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 543 Lot Size: 2,210 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 543 Lot Size: 2,210 Area: Benahavis Region: Andalucía
New Development: Prices from 4,250,000 € to 4,250,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 543.00 m2 - 543.00 m2]
Perched on an elevated position in the mountain foothills, this (...)
€110,000
TSEA5055178
- Manilva, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 79 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 79 Area: Manilva Region: Andalucía
Tourist Apartment for Sale in the PierVacanz Complex – Manilva (Málaga)
For Tourist Use Only – Not for Residential Living
Apartment for sale in the prestigious PierVacanz holiday complex, just (...)
€149,000
TSEA5055175
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 102 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Manilva Region: Andalucía
Tourist Apartment for Sale in the PierVacanz Complex – Manilva (Málaga)
For Tourist Use Only – Not for Residential Living
Apartment for sale in the prestigious PierVacanz holiday complex, just (...)
€4,695,000
TSEA5055133
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 508 Lot Size: 873 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 508 Lot Size: 873 Area: Marbella West Region: Andalucía
Welcome to Villa Rosalia — Refined Luxury with Stunning Seaviews in Nueva Andalucía, Marbella
Step into the world of refined Mediterranean living at Villa Rosalia, a stunning luxury residence (...)
€295,000
TSEA5055118
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 132 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 132 Area: Marbella East Region: Andalucía
Lovely two bedroom, south west facing apartment in La Reserva de Marbella; this gated community has well kept gardens and communal swimming pools and is close to local amenities, the beach and (...)
€575,000
TSEA5054968
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Bright brand new contemporary apartment with sea views for sale in Res. Albatros, Nueva Andalucia
Apartment and complex details
* Brand new construction (completed in 2025! ), equipped with todays (...)
Current Featured Properties
€634,000
TSEA4692997
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 140 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Area: Malaga Region: Andalucía
A luxury residential area located in Malaga, more specifically in El Limonar, This residential area will have 96 homes with 1, 2, 3 and 4 bedrooms with magnificent terraces, penthouses with a (...)
€1,400,000
TSEA4954306
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 372 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 372 Area: Estepona Region: Andalucía
An exclusive development of seventeen designer villas located in the Estepona golf course, where luxury and sustainability come together to create unique, welcoming homes with expansive open spaces (...)
€323,000
TSEA4644049
- 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 new development offers various golf courses within a radius of just 15 minutes, including the Casares Costa Golf complex, where the spectacular Finca Cortesín Golf & SPA is located, next to (...)
