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 (51,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 (51,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 (51,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 2721 - 2740 of 3915
€288,000
TSEA4956442
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Discover your ideal coastal retreat in this 2-bedroom duplex flat in Torrequebrada. Enjoy partial sea views from your private roof terrace, perfect for relaxation and entertaining. The flat features (...)
€290,000
TSEA4956136
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 2 M2: 144 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 2 M2: 144 Area: Alhaurin el Grande Region: Andalucía
We present this fantastic opportunity in one of the most exclusive and peaceful areas of Alhaurín el Grande. Located in a secure, gated community, this property offers everything you need to enjoy a (...)
€560,000
TSEA4956106
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 110 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Marbella West Region: Andalucía
Discover this delightful two-bedroom, two-bathroom apartment located in a sought-after urbanisation. Perfectly situated in Marbella, this residence offers a blend of modern comfort and Mediterranean (...)
€720,000
TSEA4955935
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 108 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Fuengirola Region: Andalucía
Exclusive Beachfront Apartment in Fuengirola – Spectacular Sea Views
Discover this stunning 3-bedroom, 2-bathroom apartment located on the first line of the beach in Fuengirola, offering (...)
€275,000
TSEA4955896
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 61 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 61 Area: Estepona Region: Andalucía
This apartment, located in the heart of Estepona, offers a unique opportunity to enjoy coastal living in a prime location. Situated close to all essential services and just a few steps from the (...)
€450,000
TSEA4955734
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 117 Lot Size: 167 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Lot Size: 167 Area: Casares Region: Andalucía
*Apartment for Sale in Casares Golf Gardens - Your Private Oasis on the Costa del Sol**
Discover this spectacular ground floor apartment with a huge 165 m² private garden, ideal for enjoying the (...)
€529,000
TSEA4955722
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 126 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 126 Area: Marbella West Region: Andalucía
Spacious 3-Bedroom Apartment for Sale in the Modern Residential Complex Jardines de Guadaiza, Nueva Andalucía. We are pleased to present this stunning 3-bedroom apartment in the prestigious Jardines (...)
€910,000
TSEA4955575
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
This development is part of a perfectly established community with fully operational common areas. This project has a total of 82 houses to be developed in 2 phases. Phase I corresponds to blocks 1 (...)
€680,000
TSEA4955554
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
This development is part of a perfectly established community with fully operational common areas. This project has a total of 82 houses to be developed in 2 phases. Phase I corresponds to blocks 1 (...)
€855,000
TSEA4955536
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 3 M2: 177 Area: Casares Region: Andalucía
Beds: 4 Baths: 3 M2: 177 Area: Casares Region: Andalucía
A private beach right on your doorstep. Turquoise waters in a tropical setting. An exclusive Mediterranean-style residential complex. Homes with large terraces and high-quality finishes. 38 (...)
€1,190,000
TSEA4407847
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,190,000 € to 1,530,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 130.00 m2 - 130.00 m2]
Have the privilege of living in just 19 residences of 2 floor modules. (...)
€965,000
TSEA4955521
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 167 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 167 Area: Casares Region: Andalucía
A private beach right on your doorstep. Turquoise waters in a tropical setting. An exclusive Mediterranean-style residential complex. Homes with large terraces and high-quality finishes. 38 (...)
€695,000
TSEA4955506
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 126 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 126 Area: Benalmadena Region: Andalucía
Stunning penthouse with exceptional terraces and panoramic views of the Mediterranean Sea and the beautiful Andalusian mountains near Benalmádena Pueblo.
This penthouse offers a rare combination (...)
€2,500,000
TSEA4955482
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 81 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Marbella Region: Andalucía
Amazing Opportunity in Puente Romano, Ready to move in!
This spectacular ground floor, corner unit includes: 2 bedrooms with en-suite shower rooms, open plan kitchen with dining and living room (...)
€399,000
TSEA4955473
- 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
Top Floor Apartment, Estepona, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 100 m², Terrace 18 m².
Setting : Close To Port, Close To Shops, Close To Sea, Close To Town, Close To Schools, Close To (...)
€1,700,000
TSEA4955452
- Ojén, Costa Del Sol, Ojen
Beds: 3 Baths: 2 M2: 148 Area: Ojen Region: Andalucía
Beds: 3 Baths: 2 M2: 148 Area: Ojen Region: Andalucía
Luxurious Duplex Penthouse in Palo Alto with Breathtaking Views
Perched atop the prestigious Granados Block in the exclusive Palo Alto community, this brand-new duplex penthouse offers an (...)
€649,000
TSEA4955404
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 113 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 113 Area: Casares Region: Andalucía
A private beach right on your doorstep. Turquoise waters in a tropical setting. An exclusive Mediterranean-style residential complex. Homes with large terraces and high-quality finishes. 38 (...)
€429,000
TSEA4955347
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 115 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Benalmadena Region: Andalucía
Newly refurbished flat, with extraordinary qualities and high quality finishes in Puerto Marina!
It has two spacious bedrooms with fitted wardrobes and two bathrooms, one of them with en suite (...)
€426,000
TSEA4955293
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 84 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 84 Area: Estepona Region: Andalucía
Contemporary 2 bedroom apartment for sale in Estepona west
Ready to move in! Brand new, modern 2 bedroom apartment at walking distance of all kinds of amenities such as supermarkets, restaurants, (...)
€280,000
TSEA4955245
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Live in Paradise!
Discover the tranquillity and luminosity of this spectacular penthouse in Calahonda. With its huge corner terrace, you can enjoy the Mediterranean climate all year round. Perfect to (...)
Current Featured Properties
€1,015,000
Top Floor Apartment in Nueava Andalucia
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
LAST PENTHOUSE REMAINING!!!!
Situated in a privileged position on a hill with the best panoramic views over the "Viejo del Angel" water reservoir, the Marbella coastline and the golf (...)
€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 (...)
€487,000
TSEA4646767
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 81 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Estepona Region: Andalucía
This is a magnificent development comprising fifty-one 2-, 3- and 4-bedroom homes, which also include penthouses with suntrap terraces and community facilities featuring a kiddies' paddling pool, a (...)
