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 (46,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 (46,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 (46,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 101 - 120 of 3926
€265,000
TSEA5155075
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
Apartment with two bedrooms, one bathroom, a fully equipped kitchen, a large living area with access to a terrace facing west, for sale in Riviera del Sol, Mijas Costa. This apartment is located in (...)
€249,900
TSEA5155027
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 55 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: Manilva Region: Andalucía
Lovely beachfront 1-bedroom apartment with sea views in La Noria, in Sabinillas.
We are welcomed by the large and bright living room that leads to a private covered terrace with beautiful sea and (...)
€449,000
TSEA5154919
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 1 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
BEACHFRONT OPPORTUNITY and a Perfect rental investment.
This large 1-bedroom apartment can easily accommodate a family of 4 to 5.
There is an open room on the entrance that can be made into a small (...)
€559,000
TSEA5154883
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 138 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 138 Area: Marbella Region: Andalucía
Spacious Duplex ground floor with Renovation Potential in Xarblanca, Marbella
This charming Duplex ground floor, located in the popular residential area of Xarblanca in Marbella, offers an excellent (...)
€295,000
TSEA5154874
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Modern flat for sale in the centre of Fuengirola, just 150 metres from the beach and surrounded by all services, shops and transport links. Located in a contemporary building built in 2023, this (...)
€480,000
TSEA5154850
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Spacious corner ground floor apartment of 3 bedrooms, 2 bathrooms, big lounge and dining area with exit to a West facing terrace of 68 m2, fully fitted kitchen. Has cold and hot A/C, metallic (...)
€339,000
TSEA5154808
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 101 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Marbella Region: Andalucía
We are pleased to present a nicely maintained 3-bedroom, 2-bathroom apartment located in the prestigious La Reserva de Marbella. This property perfectly blends comfort, style, and Mediterranean (...)
€385,000
TSEA5154760
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Apartment in the centre of Marbella, on the second line of the beach. Privileged location, just a few metres from the Marina and the Real Club Marítimo de Marbella.
Ideal option for investors, with (...)
€1,360,000
TSEA5154649
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Beachfront apartment in a modern luxury residential complex in Estepona. Located 5 minutes drive from Estepona city center.
Avant-garde design complex of almost 10,000 m2, with large garden areas, 2 (...)
€315,000
TSEA5153794
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 132 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 132 Area: Mijas and Mijas Costa Region: Andalucía
Spacious Fully Renovated 3-Bedroom Apartment – Mijas Costa / Fuengirola Border
This bright apartment has been fully reformed and offers generous living space in a convenient location just 100 (...)
€740,000
TSEA5153692
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 212 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 212 Area: Marbella Region: Andalucía
New Development: Prices from 740,000 € to 1,020,000 €. [Beds: 2 - 3] [Baths: 2 - 3] [Built size: 212.00 m2 - 271.00 m2]
This development is an exclusive residential complex comprised of 88 (...)
€295,000
TSEA5153683
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 59 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 59 Area: Fuengirola Region: Andalucía
Brand New Apartment (2024) with Tourist License – Just 200m from the Beach & 2 Minutes from the Train Station
Beautiful 2-bedroom, 2-bathroom apartment in a newly built building from 2024, (...)
€349,000
TSEA5153662
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 1 M2: 94 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 1 M2: 94 Area: Fuengirola Region: Andalucía
Unique Opportunity in the Heart of Fuengirola!
Welcome to this bright and spacious apartment with an unbeatable location in the very center of Fuengirola – right next to the bus station yet (...)
€399,000
TSEA5153656
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Impressive terraces with views of the sea and the mountains. More than 60 square meters of terraces, covered and uncovered. Immaculate penthouse with two floors. Interior brick staircase to access (...)
€439,000
TSEA5153653
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 96 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Area: Fuengirola Region: Andalucía
✨ Ideal Apartment for Sale in Fuengirola – Close to the Beach and Train Station!
Discover this bright and spacious 3-bedroom apartment located in one of the most convenient and well-connected (...)
€359,000
TSEA5153647
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Stylish Renovated Apartment by the Beach in Estepona
Discover this beautifully renovated apartment, perfectly located in a sought-after beachfront urbanization in the very heart of Estepona. Just (...)
€675,000
TSEA5153557
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 128 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Area: Marbella West Region: Andalucía
We are pleased to present this impeccably designed, Scandinavian-style ground-floor apartment, located in the prestigious and highly sought-after urbanisation of Aldea Blanca. This property offers an (...)
€410,000
TSEA5153545
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 88 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Marbella West Region: Andalucía
Superb penthouse in the Nueva Andalucía area. Comprising 2 bedrooms, 2 bathrooms, and a living/dining room with access to a spacious 25 m² terrace.
The gated and well-maintained community offers a (...)
€869,999
TSEA5153473
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 132 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Marbella Region: Andalucía
We are delighted to present this bright and elegant 3-bedroom, 2-bathroom duplex penthouse, which includes 2 parking spaces and a storage room, set within one of the most peaceful and sought-after (...)
€275,000
TSEA5153434
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 88 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 88 Area: Benalmadena Region: Andalucía
Discover the comfort and charm of living in the center of Arroyo de la Miel with this completely renovated apartment. Located on the second floor of a building with no elevator, this home offers the (...)
Current Featured Properties
€410,000
TSEA4225687
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
New apartments for sale in Costa del Sol, Spain
This development is a unique project of two- and three-bedroom apartments & penthouses that include the most impressive communal gardens, an (...)
€851,414
Staff pick! We love this one, it's got everything
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 83 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Estepona Region: Andalucía
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA!
A luxury resort style apartment complex with the best in leisure facilities. This new development has been landscaped to create TOP QUALITY with (...)
€815,000
TSEA4856848
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 135 Lot Size: 72 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 135 Lot Size: 72 Area: Estepona Region: Andalucía
An imposing residential project in Estepona's New Golden Mile. Offering 72 superb 2, 3 and 4-bedroom apartments, each home boasts breathtaking sea and mountain views. Residents will indulge in a (...)
