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 (48,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 (48,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 (48,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (2652), Middle Floor - (2652), Penthouse - (2652), Top Floor Apartment - (2652), Penthouse Duplex - (2652)Properties
Results 281 - 300 of 3916
€268,000
TSEA5145979
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 62 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 62 Area: Marbella Region: Andalucía
Discover your new home in the heart of Marbella! ✨
This charming apartment of 71 m² is located on the fourth floor of a building with an elevator, offering both comfort and accessibility. In (...)
€180,000
TSEA5145976
- Guaro, Costa Del Sol, Guaro
Beds: 2 Baths: 2 M2: 77 Area: Guaro Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Guaro Region: Andalucía
Middle Floor Apartment, Guaro, Inland Malaga
2 Bedrooms, 2 Bathrooms, Built 77 m².
Magnificent two-bedroom, two-bathroom apartment for sale, one en suite.
Like new. Fully furnished. Built-in (...)
€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, (...)
Current Featured Properties
€729,000
TSEA5116945
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 2 M2: 186 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 2 M2: 186 Area: San Pedro Region: Andalucía
The origin of a new way of living in Marbella
The first residential project in a new district set to transform the lifestyle in Marbella.
More than just a new development, this development is the (...)
€611,000
TSEA5138941
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
This is not simply a place to live. It's a lifestyle ecosystem. From sunrise swims in your private pool to sunset walks along the coastal path, this is more than just a home — it's a (...)
€534,450
TSEA4581373
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 105 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: San Pedro Region: Andalucía
The development in San Pedro de Alcantara is made up of 35 homes with 2 and 3 bedrooms, with duplexes with terraces-solariums. Garages in the basement and commercial premises on the ground floor, in (...)
