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 (43,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 (43,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 (43,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 201 - 220 of 4194
€400,000
TSEA5150557
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 91 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Benahavis Region: Andalucía
This charming ground floor apartment is located in Benahavís, one of the most exclusive areas on the Costa del Sol, renowned for its peaceful surroundings, stunning landscapes, and proximity to (...)
€380,000
TSEA5150536
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Stunning New Golden Mile middle floor apartment with panoramic views. This amazing south facing property offers La Concha views from the kitchen and partial sea views from the terrace.
The property (...)
€423,000
TSEA5150527
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 99 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 99 Area: Casares Region: Andalucía
New Development: Prices from 423,000 € to 721,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 99.00 m2 - 116.00 m2]
Set in an exceptional location between the highly sought-after towns of (...)
€551,460
TSEA5150488
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
OPPORTUNITY: Beachfront ground-floor apartment measuring 75 m² + 55 m² of private garden, with 2 large bedrooms, 2 bathrooms, a kitchen with a breakfast bar, and a spacious living-dining room with (...)
€695,000
TSEA5150473
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 101 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Marbella East Region: Andalucía
Elegant, fully renovated apartment in the exclusive Terrazas de las Lomas urbanization, located in the heart of the Golden Mile, just minutes from Marbella and Puerto Banús.
This property features (...)
€795,000
TSEA5150464
- Higueron, Costa Del Sol
Beds: 3 Baths: 2 M2: 118 Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Region: Andalucía
Welcome to this newly built 3-bedroom corner apartment on the second floor of the sought-after Lomas 2 – completed in 2025 and ready for immediate move-in. Here, spacious interiors, fantastic (...)
€500,000
TSEA5150452
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
New Development: Prices from 500,000 € to 969,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 94.00 m2 - 133.00 m2]
An exclusive residential complex: 36 apartments with 2 and 3 bedrooms, and 15 (...)
€450,000
TSEA5150431
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 95 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Marbella West Region: Andalucía
5 minutes walk to Centro Plaza in Nueva Andalucia and 20 minues to Puerto Banus this bright and spacious middle-floor apartment offers two bedrooms and two bathrooms, combining comfort with stunning (...)
€780,000
TSEA5150281
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 285 Lot Size: 143 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 285 Lot Size: 143 Area: Marbella East Region: Andalucía
Located in the very heart of the Golden Mile, just 1,500 meters from the beach and surrounded by an exclusive and tranquil environment, this magnificent semi-detached house is situated in Nagüeles (...)
€880,000
TSEA5150107
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 120 Lot Size: 30 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Lot Size: 30 Area: Marbella West Region: Andalucía
BRAND NEW TO THE MARKET!!!
This is a super Bright & Spacious 3 Bedroom Apartment in the Heart of Puerto Banús.
How can you be in the heart of it all, yet be so quiet?..
This exceptional (...)
€390,000
TSEA5150083
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 189 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 189 Area: Mijas and Mijas Costa Region: Andalucía
Exceptional 3-Bedroom Ground Floor Apartment with Expansive Terraces Surrounded by Tropical Gardens
This truly unique and one-of-a-kind property offers an extraordinary living experience. Originally (...)
€600,000
TSEA5150074
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 6 Baths: 5 M2: 382 Area: San Pedro Region: Andalucía
Beds: 6 Baths: 5 M2: 382 Area: San Pedro Region: Andalucía
We offers a unique opportunity in the heart of San Pedro de Alcántara.
We present this spacious and bright semi-detached house with a floor area of 382 square meters, distributed over 4 floors (...)
€320,000
TSEA5150062
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Located in the heart of Marbella, this cozy 1-bedroom, 1-bathroom apartment is an excellent opportunity for both primary residence and investment. Facing east, it enjoys pleasant natural light and (...)
€230,000
TSEA5150041
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 40 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 40 Area: Mijas and Mijas Costa Region: Andalucía
Your perfect getaway on the Costa del Sol awaits!
We are pleased to present this fantastic brand-new apartment (built in 2023) located in Mijas, right in the heart of the Costa del Sol — one of the (...)
€770,000
TSEA5150035
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 200 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Area: Fuengirola Region: Andalucía
Welcome to your dream home on the stunning Costa del Sol! This amazing villa offers an unparalleled living experience with its 4 spacious bedrooms and 3 luxurious bathrooms. The villa is part of a (...)
€695,000
TSEA5149942
- San Roque Club, Costa Del Sol
Beds: 3 Baths: 3 M2: 193 Region: Andalucía
Beds: 3 Baths: 3 M2: 193 Region: Andalucía
This elegant penthouse, fully renovated and beautifully decorated in a modern style, offers a unique living space in the exclusive setting of San Roque Club. With stunning sea views and surrounded by (...)
€280,000
TSEA5149936
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 71 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Casares Region: Andalucía
Penthouse with Solarium and Panoramic Sea Views in Casares Playa
This exclusive penthouse with a private solarium in Casares Playa combines space, natural light, and a privileged location on the (...)
€875,000
TSEA5149927
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 147 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 147 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular 3 bedrooms apartment with panoramic views of the sea facing the Calanova Golf Course.
The property is located in the middle of the complex, it enjoys fantastic views and privacy.
It has a (...)
€540,000
TSEA5149918
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Manilva Region: Andalucía
This stunning apartment is located in Los Granados de Duquesa, Manilva, Málaga, a prime beachfront location. Thoughtfully designed and in excellent condition, this property offers a luxurious and (...)
€359,000
TSEA5149888
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
This is a very attractive modern apartment located in an elevated spot above the beaches of Elviria and East Marbella. Located in the high end enclave of La Maiirena an area occupied by luxury (...)
Current Featured Properties
€2,100,000
TSEA4453822
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 246 Lot Size: 164 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 246 Lot Size: 164 Area: Marbella East Region: Andalucía
ELITE LIVING!
This is a luxury complex made up of 8 exclusive homes in the best area of the Costa del Sol. Designed with the highest quality and avant-garde approach, it has terraces and (...)
€590,000
TSEA4777498
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 108 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Istan Region: Andalucía
COUNTRY LIVING ONLY 10 MINS FROM EVERYTHING!
This is the first phase on sale, comprising 32 exclusive apartments with stunning panoramic views, situated in the most elevated part of the Almazara (...)
€4,995,000
TSEA4445479
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 138 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Area: Marbella Region: Andalucía
This is a stunning modern apartment sporting sea views within the exclusive enclave of the Puente Romano Resort on the Marbella Golden Mile. The apartment exudes seaside sophistication, embracing its (...)
