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 1781 - 1800 of 5891 €629,900
TSEA5076349
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 200 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Area: Mijas and Mijas Costa Region: Andalucía
This is an exclusive collection of luxury homes, comprising 48 high-end apartments nestled in the heart of the Costa del Sol. This unique development offers an elevated standard of living, boasting (...)
€210,000
TSEA5076343
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 80 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 80 Area: Istan Region: Andalucía
An elegant and bright apartment in impeccable condition is offered for sale, located on the second and top floor of a building with only two apartments in total, in Istán (Málaga). A home ready to (...)
€449,900
TSEA5076319
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 129 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 129 Area: Mijas and Mijas Costa Region: Andalucía
This is an exclusive collection of luxury homes, comprising 48 high-end apartments nestled in the heart of the Costa del Sol. This unique development offers an elevated standard of living, boasting (...)
€525,000
TSEA5076316
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 122 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 122 Area: Marbella West Region: Andalucía
Property in unbeatable location, as is the area of Aloha, with all kinds of services within walking distance.
We present a ground floor flat with 2 bedrooms and 2 bathrooms, refurbished kitchen, (...)
€435,000
TSEA5076313
- Las Chapas, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 111 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: Marbella East Region: Andalucía
MARBELLA BEACH SIDE LAS CHAPAS PLAYA. The best Beach in the Marbella area. Quality large Apartment. 2 large bedrooms and 2 bathrooms showers. INCLUDED 1 private parking spaces and 1 Storage room. (...)
€2,495,000
TSEA5076256
- Los Flamingos, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 720 Lot Size: 1,490 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 720 Lot Size: 1,490 Area: Estepona Region: Andalucía
Nestled directly on the front line of the renowned Los Flamingos Golf Resort, this spectacular villa represents the perfect blend of classic and modern styling in one of Benahavis´ most prestigious (...)
€345,000
TSEA5076235
- Tarifa, Costa de la Luz
Beds: 2 Baths: 1 M2: 77 Region: Andalucía
Beds: 2 Baths: 1 M2: 77 Region: Andalucía
Ground Floor Apartment for Sale in Tarifa – Second Line from Los Lances Beach
Charming ground floor apartment ideally located just a short walk from the popular Los Lances beach.
The property (...)
€349,000
TSEA5076205
- Calahonda, 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
Exceptional property with panoramic sea and mountain views – Spacious, bright, and full of potential
We present this magnificent 130 m² property, located in one of the most peaceful and (...)
€895,000
TSEA5076202
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 130 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Fuengirola Region: Andalucía
Luxury south facing apartment, in the exclusive urbanization of Higuerón West, with 3 bedrooms, 2 bathrooms and guest toilet, spacious living-dining room, open plan kitchen fully furnished and (...)
€196,000
TSEA5076199
- Las Lagunas, 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
Opportunity in Las Lagunas de Mijas, Doña Hermita area!
This property is located in a quiet residential area, very close to all services and amenities: schools, a health center, sports facilities, (...)
€339,900
TSEA5076178
- El Paraiso, 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
Nestled in the sought-after area of El Paraíso Alto on the prestigious New Golden Mile, ideally located between Marbella and Estepona, this beautifully refurbished second-floor apartment offers (...)
€340,000
TSEA5076166
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 114 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Area: Mijas and Mijas Costa Region: Andalucía
ATTENTION INVESTORS
Fantastic flat for sale in Riviera del Sol, 15 mn drive to Marbella and 30mn to Malaga airport. The beach is 3 minutes drive away, close to supermarkets. Ideally located at 5mn (...)
€690,000
TSEA5076154
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 2 M2: 196 Lot Size: 37,000 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 2 M2: 196 Lot Size: 37,000 Area: Alhaurin el Grande Region: Andalucía
Impressive property in a prime location with views of the countryside and mountains on a plot of over 37,000 m² in Alhaurin El Grande !
Are you looking for a retreat surrounded by nature, privacy, (...)
€549,500
TSEA5076127
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 127 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 127 Area: Benahavis Region: Andalucía
Capanes del Golf is a luxury development located between the coast and the village of Benahavis and only 15 minutes to the famous Puerto Banus and Marbella. The living room has direct access to the (...)
€425,000
TSEA5075812
- La Cala Hills, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 180 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 180 Area: Mijas and Mijas Costa Region: Andalucía
MOTIVATED SELLER. 3 BED 2 BATH. LA CALA HILLS € 425,000. ELEVATED GROUND FLOOR CORNER. AMAZING VIEWS.
Introducing this exquisite corner unit in the highly sought-after La Cala Hill, offering a (...)
€299,000
TSEA5075806
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 3 Baths: 1 M2: 73 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 1 M2: 73 Area: Fuengirola Region: Andalucía
Prime location within walking distance to all amenities, shops, restaurants, and the beach.
This Scandinavian style renovated apartment is in excellent condition and offers 3 bedrooms and 1 (...)
€4,500,000
TSEA5075737
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 443 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 443 Area: Marbella East Region: Andalucía
Discover your dream home in the prestigious Epic Phase 3, located in the heart of the Marbella Golden Mile. This spacious ground floor apartment features four elegantly designed bedrooms, offering (...)
€280,000
TSEA5075686
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 66 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 66 Area: Estepona Region: Andalucía
Ideally located in a beachfront urbanization, this fully renovated apartment (2023) is a turnkey opportunity — just bring your suitcases. Sold fully furnished, it offers a comfortable and modern (...)
€750,000
TSEA5075614
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 263 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 263 Area: Marbella West Region: Andalucía
Discover this elegant two-bedroom elevated ground floor apartment for sale in the sought-after Albatross Hill complex, nestled in the scenic hills of Nueva Andalucía. This exclusive gated community (...)
€529,000
TSEA5075542
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Modern Ground Floor Apartment with Garden Terrace in Casa Banderas – La Cala de Mijas
3 Bedrooms | 2 Bathrooms | 108 m² Build | 28 m² Terrace
Welcome to your dream coastal retreat in the heart (...)
Current Featured Properties
€732,000
TSEA4853869
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 87 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 87 Area: Estepona Region: Andalucía
This development offers 36 beautiful single-storey homes with large rooms, the option of 2 or 3 bedrooms, 2 bathrooms and large terraces with beautiful panoramic views. They have a fully equipped (...)
€430,000
TSEA4175497
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 103 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: Estepona Region: Andalucía
AMAZING GOLF DEVELOPMENT!!!
This is the new residential development in Estepona Golf, at the heart of the Costa del Sol, a privileged location close to wonderful beaches such as Bahía Dorada, or (...)
€995,000
Luxury Beach-Side Apartments with Fantastic Sea Views, Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 92 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Estepona Region: Andalucía
BOUTIQUE BEACHFRONT DEVELOPMENT IN ESTEPONA.
Amazing new development of ONLY 14 APARTMENTS right on the beachfront on the edge of Estepona town. This premium development will boast FABULOUS SEA AND (...)
