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 1741 - 1760 of 5891 €1,095,000
TSEA5077951
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 3 M2: 280 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 3 M2: 280 Area: Marbella West Region: Andalucía
Located in a peaceful residential area in Nueva Andalucía, Marbella, this detached villa sits just a short drive from the exclusive Puerto Banús and offers proximity to all essential services: town (...)
€620,000
TSEA5077903
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 104 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Marbella Region: Andalucía
Welcome to your new home just 300 meters from one of Marbella's best beaches! This lovely ground-floor apartment is set in a stylish, modern community that blends comfort, convenience, and coastal (...)
€127,000
TSEA5077756
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 61 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 61 Area: Benahavis Region: Andalucía
ATENTION INVESTORS ONLY.
If you're looking for an investment on the Costa del Sol that provides a return and allows you to enjoy it whenever you want without worrying about anything more than a few (...)
€650,000
TSEA5077753
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 165 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 165 Area: Marbella Region: Andalucía
Located in the heart of Marbella's Old Town and just 300 meters from the beach, this spacious property offers all the charm of traditional Andalusian architecture with excellent renovation (...)
€995,000
TSEA5077690
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Located in one of the most privileged areas of Estepona, this large 3-bedroom ground floor apartment is set within a gated, resort-style urbanization on the beachfront. Right next to the prestigious (...)
€765,000
TSEA5077669
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 162 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 162 Area: Mijas and Mijas Costa Region: Andalucía
For Sale: Luxurious 3-Bedroom Apartment with Breathtaking Views and Year-Round Sunrises – Calanova Golf, Mijas Costa
Discover this exceptional three-bedroom apartment located in a prestigious (...)
€590,000
TSEA5077588
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 102 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 102 Area: Marbella Region: Andalucía
Refurbished to modern standards, this inviting 3-bedroom, 2-bathroom apartment offers bright open-plan living, a contemporary kitchen, and a lovely covered terrace. Set in a small gated community (...)
€469,000
TSEA5077531
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 97 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Malaga Region: Andalucía
Apartment for Sale in Malaga - Your New Home Awaits! *
Discover this spectacular, brand-new, renovated apartment located in one of the best areas of Malaga. With a built area of 87 m² and 86 (...)
€429,000
TSEA5077528
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 108 Lot Size: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 108 Lot Size: 70 Area: Mijas and Mijas Costa Region: Andalucía
For Sale: Spacious 3-Bedroom Apartment with Terrace, Pool & Private Parking – €450,000
Welcome to this stunning 3-bedroom, 3-bathroom apartment located in a tranquil and green area of Mijas, (...)
€349,000
TSEA5077516
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 156 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 156 Area: Mijas and Mijas Costa Region: Andalucía
Deligthfull Duplex 2 bedroom penthouse, full of light and very private with lovely open views. This property has 156 m2 built inside plus over 100 m2 of terraces including a 75m2 solarium.
A short (...)
€880,000
TSEA5077492
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 5 Baths: 2 M2: 275 Lot Size: 9,000 Area: Alhaurin el Grande Region: Andalucía
Beds: 5 Baths: 2 M2: 275 Lot Size: 9,000 Area: Alhaurin el Grande Region: Andalucía
Detached Villa, Alhaurín el Grande, Costa del Sol.
5 Bedrooms, 2 Bathrooms, Built 275 m², Terrace 30 m², Garden/Plot 9000 m².
Setting : Country, Mountain Pueblo, Close To Shops, Close To (...)
€239,000
TSEA5077471
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 61 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 61 Area: Mijas and Mijas Costa Region: Andalucía
GREAT OPPORTUNITY! 2-Bedroom Apartment with Parking in Mijas Pueblo
Fantastic apartment located just a few steps from the center of charming Mijas Pueblo. The property is distributed into two (...)
€530,000
TSEA5077393
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 115 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Estepona Region: Andalucía
Nestled within the prestigious Vanian Gardens residential complex, this elegant two-bedroom apartment offers a serene lifestyle on the sought-after Costa del Sol. Ideally located just 5 minutes from (...)
€700,000
TSEA5077381
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Located on the top floor of a building constructed in 2020, surrounded by green areas and with secured access, this apartment offers a serene and safe environment, just steps away from Avenida Juan (...)
€789,000
TSEA5077366
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 215 Lot Size: 759 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 215 Lot Size: 759 Area: Estepona Region: Andalucía
3-BEDROOM DETACHED HOUSE WITH PRIVATE POOL 100M FROM THE BEACH
Located just 100 meters from the beach, in a residential area between Estepona and San Luis de Sabinillas, both just a 7-minute drive (...)
€349,500
TSEA5077345
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
Brand-New Renovated Apartment in the Center of San Pedro de Alcántara, Marbella
Fantastic opportunity to acquire a spacious and bright three-bedroom, two-bathroom apartment, fully renovated and (...)
€545,000
TSEA5077336
- Coín, Costa Del Sol, Coin
Beds: 5 Baths: 3 M2: 255 Lot Size: 3,556 Area: Coin Region: Andalucía
Beds: 5 Baths: 3 M2: 255 Lot Size: 3,556 Area: Coin Region: Andalucía
Charming Country Finca with Stables – A Horse Lover's Paradise in Coín
. Rustic Farmhouse-Style Property
. Full of Original Features
. 2 Stables, Tack Room & Hay Store
. OCA License (...)
€950,000
TSEA5077309
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 155 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 155 Area: San Pedro Region: Andalucía
New modern apartments in the prestigious MARE complex is a modern residential complex from the renowned developer Taylor Wimpey, located in San Pedro de Alcantara, just a few minutes walk from the (...)
€755,000
TSEA5077300
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 141 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 141 Area: Marbella East Region: Andalucía
Luxury apartment located in one of the most desirable locations within Elvira in Marbella. This elevated ground floor apartment comprises 3 large bedrooms and 3 bathrooms with the master bedroom and (...)
€1,994,500
TSEA5077270
- Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 6 M2: 311 Lot Size: 807 Area: Marbella Region: Andalucía
Beds: 6 Baths: 6 M2: 311 Lot Size: 807 Area: Marbella Region: Andalucía
DETACHED VILLA FOR SALE – MARBELLA AREA
Stunning 6-bedroom, 6-bathroom detached villa located in a secure, gated community just a 10-minute walk from the beach and moments from the heart of (...)
Current Featured Properties
€720,000
TSEA4766926
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
This fantastic new development of stunning contemporary apartments and penthouses with sea views is located just a stone's throw from La Cala de Mijas. The popularity of this beautiful coastal town (...)
€570,000
TSEA3922510
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
LAST OPPORUNITY TO ACQUIRE!!!!
One of the last opportunities to acquire a newly built property in the centre of Estepona, seaside and just 1 minute from the beach. A dream lifestyle which can be (...)
€478,000
TSEA4678096
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 102 Lot Size: 158 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Lot Size: 158 Area: Mijas and Mijas Costa Region: Andalucía
This development offers one and two bedroom apartments in different sizes. All of them share the modern design, open spaces flooded with natural light and private terraces. We have ground floor (...)
