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 2741 - 2760 of 5891
€6,400,000
TSEA4907779
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 6 Baths: 6 M2: 647 Lot Size: 1,441 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 6 M2: 647 Lot Size: 1,441 Area: Marbella East Region: Andalucía
New Development: Prices from 6,400,000 € to 6,500,000 €. [Beds: 6 - 6] [Baths: 6 - 6] [Built size: 647.00 m2 - 647.00 m2]
Located in Lomas de Marbella Club, a prestigious urbanization on the (...)
€699,500
TSEA5026981
- 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
Price: €699.500 excluding VAT, buyer's costs
Includes: private storage unit and parking space
Experience elevated living in this stunning 2-bedroom penthouse located in the sought-after Isidora (...)
€319,950
TSEA5026975
- La Cala Hills, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
NEW TO THE MARKET. LUXURY FULLY FURNISHED 2 BED 2 BATH APARTMENT. MOTIVATED SELLERS
Exclusive Middle-Floor Apartment for Sale in La Cala Hills
Discover the perfect blend of luxury and investment (...)
€1,195,000
TSEA5026963
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 131 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 131 Area: Marbella Region: Andalucía
Spacious four bedroom apartment located in a prestigious urbanization of Marbella / Golden Mile, just a few minutes walk from the beach and the promenade, next to the renowned Trocadero beach bar and (...)
€429,000
TSEA5026942
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 99 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: Fuengirola Region: Andalucía
Wonderfull and Well-Maintained Apartment with Sea and Mountain Views in Monte Paraiso, Torreblanca
Welcome to this apartment located in the Monte Paraiso complex in the peaceful and scenic area of (...)
€345,000
TSEA5026897
- Canillas de Aceituno, Costa Del Sol East
Beds: 5 Baths: 4 M2: 298 Lot Size: 5,133 Region: Andalucía
Beds: 5 Baths: 4 M2: 298 Lot Size: 5,133 Region: Andalucía
Nestled in the gentle hills of Canillas de Aceituno, this inviting chalet is a true retreat for nature lovers, those seeking peace, and families alike. Surrounded by approximately 5,000 m2 of private (...)
€2,640,000
TSEA5026882
- La Mairena, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 392 Lot Size: 3,719 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 392 Lot Size: 3,719 Area: Marbella East Region: Andalucía
Set within the lush, green hills of La Mairena just 7 minutes from Marbella's finest beaches, this stunning detached villa is the perfect blend of modern design, peaceful surroundings, and panoramic (...)
€1,590,000
TSEA5026867
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 159 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 159 Area: Benahavis Region: Andalucía
A spectacular one-of-a-kind luxury penthouse immaculately presented in the Quercus phase of Real de la Quinta, a brand new gated community situated hill-top in La Quinta golf. This property oozes (...)
€580,000
TSEA5026783
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 102 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Estepona Region: Andalucía
IMPORTANT: This is a RESALE UNIT. In one of the best new complexes in Estepona Town.
Brand new Estepona apartment, which is under construction but can be reserved now. The current owner will complete (...)
€360,000
TSEA5026492
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 125 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 125 Area: Estepona Region: Andalucía
This exclusive apartment is located in the prestigious La Resina Golf resort, located in Estepona East, Malaga.
It is a modern and spacious apartment with a total built area of 125 m2, of which 85 (...)
€850,000
TSEA5026420
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 139 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 139 Area: Marbella East Region: Andalucía
Beachside recently reformed, to a very high standard, apartment that is ready to move into. This fabulous bright, spacious, airy apartment is a perfect home or investment property. The location is (...)
€166,000
TSEA5026351
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 55 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: Fuengirola Region: Andalucía
RENTED PROPERTY. OPPORTUNITY FOR INVESTORS.
What does a profitable property mean? Having a profitable property means that the owner is obtaining economic benefits from their property through its (...)
€420,000
TSEA5026345
- La Campana, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Three-Bedroom Apartment with Mountain Views
Spacious 3-bedroom, 2-bathroom apartment located on the third floor, featuring a large terrace with open views of the surrounding area and the (...)
€2,285,000
TSEA5026243
- Las Chapas, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 598 Lot Size: 1,700 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 598 Lot Size: 1,700 Area: Marbella East Region: Andalucía
This villa is a must see for families who like privacy and security.
The location of this mansion is on top of Hacienda Las Chapas where the main road ends to a private road until the entrance of the (...)
€640,000
TSEA5026234
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Estepona Region: Andalucía
Stylish 2-Bedroom Penthouse with Stunning Sea & Mountain Views in Estepona
Welcome to your dream escape in the sun, a luxurious and spacious 2-bedroom penthouse where style, comfort, and (...)
€299,500
TSEA5026219
- Cártama, Costa Del Sol, Cartama
Beds: 3 Baths: 2 M2: 127 Area: Cartama Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Cartama Region: Andalucía
✨ Modern Renovated Penthouse with Large Terrace and Views – Cártama
We present this spectacular, fully renovated penthouse, featuring a modern design, plenty of light, and a large private (...)
€1,995,000
TSEA5026186
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 362 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 362 Area: Mijas and Mijas Costa Region: Andalucía
MODERN SEA VIEW VILLA IN EL CHAPARRAL | MIJAS COSTA
Sea View Villa for Sale in El Chaparral, Mijas Costa: Modern Design Just Steps from the Sea
Are you looking for a modern sea view villa in El (...)
€2,995,000
TSEA5026135
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 280 Lot Size: 1,163 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 280 Lot Size: 1,163 Area: Marbella West Region: Andalucía
Rare opportunity to aquire a classic villa in perfect condition frontline to Royal Las Brisas Golf. As you enter you immediately feel that the house was built to very high standards where details and (...)
€670,000
TSEA5026123
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
We present this extraordinary property located in the prestigious Costalita Urbanization, in the heart of the New Golden Mile of Estepona, one of the most sought-after destinations on the Costa del (...)
€345,000
TSEA5026105
- Almogía, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 100 Lot Size: 3,029 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 100 Lot Size: 3,029 Area: Malaga Region: Andalucía
Beautifully Maintained Country House with Stunning Views – Almogía
Discover this charming and well-kept country home – 131m2, located in the peaceful urbanisation Fuente Amarga in Almogía. Set (...)
Current Featured Properties
€598,000
TSEA4901344
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 130 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Torremolinos Region: Andalucía
LOCATED IN ONE OF THE BEST AREAS OF TORREMOLINOS!!!
Bringing to life a new residential concept in Torremolinos. Designed to enjoy the Mediterranean and the endless light of the Costa del Sol. A (...)
€3,495,000
TSEA4366912
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 508 Lot Size: 1,302 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 508 Lot Size: 1,302 Area: Marbella West Region: Andalucía
THIS STUNNING PROPERTY IS LOCATED IN THE HIGHLY SOUGHT AFTER ARE OF NUEVA ANDALUCIA.
Property boasts of 4 bedrooms and 5 bathrooms, making it ideal for larger families or those who enjoy having (...)
€940,000
TSEA4753036
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 4 M2: 265 Area: Manilva Region: Andalucía
Beds: 4 Baths: 4 M2: 265 Area: Manilva Region: Andalucía
9 magnificent independent modern villas of high quality on plots of approx. 600m2. with 4 bedrooms all en suite, toilet, large living room-kitchen, private pool, private natural garden and private (...)
