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 301 - 320 of 4194
€510,000
TSEA5145946
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 70 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Marbella Region: Andalucía
Unique Opportunity on Marbella's Seafront Promenade!
We are pleased to present this charming apartment located right on Marbella's Paseo Marítimo, within one of the most sought-after beachfront (...)
€425,000
TSEA5145928
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 106 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Marbella East Region: Andalucía
Beautiful duplex Penthouse centrally located in Elviria, in the complex Parque Elviria. It needs some renovations but has great potential due to its proximity to the beach, shops, restaurants, etc., (...)
€425,000
TSEA5145922
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
Beautiful flat located in the Pino Golf community in Elviria. Spacious ground floor flat facing west, overlooking the communal gardens and swimming pool.
It has two bedrooms, one of which is en (...)
€358,000
TSEA5145916
- Bel Air, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
A stunning duplex penthouse offering an abundance of space, natural light, and privacy. Impeccably maintained, this home combines modern comfort with elegant design, creating an inviting and serene (...)
€645,000
TSEA5145910
- Malagueta, Costa Del Sol
Beds: 3 Baths: 1 M2: 303 Region: Andalucía
Beds: 3 Baths: 1 M2: 303 Region: Andalucía
OPPORTUNITY!! MAGNIFICENT MIXED-USE HOME 2 MINUTES FROM THE BEACH
The exclusively present this spectacular home, located in a prime location just a two-minute walk from the beach. It's just a (...)
€650,000
TSEA5145820
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Modern duplex apartment in Puerto Banús with stunning sea views, just steps from the beach, restaurants, luxury boutiques, and all amenities. Featuring two bedrooms (one en-suite), two (...)
€380,000
TSEA5145799
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
A lovely elevated ground floor apartment in the exclusive area of Selwo, Estepona.
Enjoy the stunning views across the sea to Africa from your covered terrace, or have a cooling dip in the communal (...)
€269,000
TSEA5145790
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 68 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 68 Area: Mijas and Mijas Costa Region: Andalucía
Unique Opportunity in Lower Riviera del Sol – Ground Floor Corner Apartment
Don't miss the chance to own this charming south-west facing ground floor corner apartment in the highly sought-after (...)
€495,495
TSEA5145751
- Campanillas, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 113 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Marbella Region: Andalucía
We present an innovative residential project that redefines the concept of living in Malaga. The development features a variety of homes, from one-bedroom apartments to four-bedroom penthouses, all (...)
€231,000
TSEA5145313
- Torremolinos Centro, Costa Del Sol, Torremolinos
Beds: 1 Baths: 1 M2: 62 Area: Torremolinos Region: Andalucía
Beds: 1 Baths: 1 M2: 62 Area: Torremolinos Region: Andalucía
Beautiful property for sale in the charming "Pueblo Blanco" of Torremolinos.
One of the best areas of the town, very attractive both for those who want to live in the centre and surrounded (...)
€1,195,000
TSEA5145271
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Apartment Jasmine is a beautifully renovated three-bedroom apartment for sale in the exclusive Palacetes Los Belvederes, an established residential community in Nueva Andalucía. Originally built in (...)
€369,000
TSEA5145232
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Apartment in Cerros del Águila with terrace, views and excellent qualities
Located in the quiet urbanization Cerros del Águila, this apartment offers a well-maintained environment with community (...)
€318,000
TSEA5145223
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 80 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Marbella East Region: Andalucía
Penthouse Duplex, Reserva de Marbella, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 80 m², Terrace 80 m².
Setting : Urbanisation.
Condition : Good.
Pool : Communal, Children`s Pool.
Climate (...)
€468,000
TSEA5145220
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Ground-Floor corner-Apartment with Panoramic Sea & Mountain Views –
The Perfect Investment,short-term rentals allowed and completely hassle-free!
Wake up to the Mediterranean, step onto (...)
€725,000
TSEA5145166
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 175 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 175 Area: Marbella Region: Andalucía
Spacious 3 Bedroom Apartment in the Heart of Marbella.
Just Steps from the Beach
New to the market, this very spacious three-bedroom, two-bathroom apartment is ideally located just one street back (...)
€449,500
TSEA5145130
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Just Listed – Exceptional 2-Bed, 2-Bath Top Apartment with Breathtaking Mediterranean Views - Tourist Licences Permitted !
Welcome to your dream coastal home – where contemporary style meets (...)
€510,000
TSEA5145076
- Sotogrande Costa, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 149 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 149 Area: Sotogrande Region: Andalucía
Exclusive Apartment with Terrace and Views of Sotogrande Marina
Located in the Ribera de Sotogrande, this apartment is just 300 meters from the beach, allowing you to enjoy a coastal lifestyle (...)
€599,000
TSEA5145043
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 123 Lot Size: 128 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Lot Size: 128 Area: Mijas and Mijas Costa Region: Andalucía
Brand new fully furnished 3 bed apartment with a large sunny garden. This property has 3 spacious bedrooms and 2 bathrooms. The community offers luxury facilities that include an indoor pool, (...)
€547,500
TSEA5144950
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 173 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 173 Area: Estepona Region: Andalucía
Exclusive Frontline Beach Apartment in Marina Bay, Estepona
Situated in the sought-after Marina Bay urbanisation, perfectly positioned between the Port of Estepona and the popular Playa del Cristo, (...)
€385,000
TSEA5144932
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Do you want a pool, walking distance to the old town and the beach? Then this home is the perfect choice for you.
This bright and well-maintained apartment, completed in 2021 and never rented out, (...)
Current Featured Properties
€476,700
TSEA4289707
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 118 Lot Size: 20 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Lot Size: 20 Area: Benahavis Region: Andalucía
A HOME YOU WILL NEVER WANT TO LEAVE!!!
The homes in this development are designed to offer you everything you need. On the ground floor you will have a garden and wine cellar, and on the top floor (...)
€515,000
TSEA4814728
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 109 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 109 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 (...)
€279,000
TSEA4452184
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 77 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Manilva Region: Andalucía
This innovative real estate project consists of 60 multi-family dwellings, offering 2 and 3-bedroom apartments, all equipped with garage and storage room in the basement. The blocks are distributed (...)
