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 (70,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 (70,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 (70,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 661 - 680 of 4565
€240,000
TSEA5133175
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
BRAND NEW TO MARKET! 1BED/1BATH FULLY RENOVATED APT W SEA + MOUNTAIN VIEWS IN BENALMADENA-COSTA! €240,000.
Features:
- 6th floor
- 1 Bedroom and 1 Bathroom
- Open plan living room and kitchen
- (...)
€400,000
TSEA5133166
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 400,000 € to 1,523,000 €. [Beds: 1 - 4] [Baths: 1 - 4] [Built size: 60.00 m2 - 183.00 m2]
Nestled in vibrant Mijas Costa and overlooking the prestigious Cerrado del (...)
€948,500
TSEA5133157
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
New Development: Prices from 948,500 € to 1,051,500 €. [Beds: 2 - 3] [Baths: 2 - 3] [Built size: 71.00 m2 - 92.00 m2]
An exclusive complex of 116 new build flats, completed this spring - 2024. (...)
€349,000
TSEA5133154
- Diana Park, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
Townhouse to Renovate in Nueva Atalaya – Excellent Investment Opportunity
Type: Townhouse
Condition: To renovate
Built area: 109 m²
Bedrooms: 3
Bathrooms: 2
Terrace / Porch: Yes
Location: Nueva (...)
€1,250,000
TSEA5132818
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 203 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 203 Area: Marbella Region: Andalucía
Living in Marbella, just 50 meters from the Mediterranean Sea, and opposite the Old town is a privilege like few others in this world. Panoramic views of the city and mountains, and lateral views of (...)
€349,000
TSEA5132794
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 4 M2: 115 Area: Casares Region: Andalucía
Beds: 3 Baths: 4 M2: 115 Area: Casares Region: Andalucía
Located in the "Paraíso de la Bahia" residence, this stunning duplex penthouse was completely renovated in December 2024.
It is situated 300m from Casares beach and it's Chiringuito (...)
€1,795,000
TSEA5132776
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 155 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 155 Area: Marbella West Region: Andalucía
This exceptional 3-bedroom, 2.5-bathroom duplex penthouse is located in the prestigious gated community of Las Alamandas, at the heart of Nueva Andalucía's Golf Valley. Boasting spectacular views (...)
€750,000
TSEA5132773
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 144 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 144 Area: Marbella East Region: Andalucía
Beautiful south-facing, two-bedroom apartment located in the prestigious Hacienda Playa, Elviria. Designed for comfortable coastal living and filled with natural light, the property features two (...)
€540,000
TSEA5132767
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 240 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 240 Area: Benahavis Region: Andalucía
This beautifully appointed town house is situated in the desirable Paraiso Park, Benahavis, Malaga. Offering a harmonious blend of comfort and convenience, the property boasts three spacious bedrooms (...)
€799,000
TSEA5132674
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 285 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 285 Area: Benahavis Region: Andalucía
Situated in the exclusive, frontline golf complex of Las Encinas in La Quinta, Benahavís, this beautifully renovated three-level townhouse combines modern elegance with breathtaking views of the La (...)
€269,000
TSEA5132665
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 56 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 56 Area: Benahavis Region: Andalucía
Penthouse for sale in , Benahavis with 2 bedrooms, 2 bathrooms and with orientation east, with communal swimming pool, private garage and communal garden. Regarding property dimensions, it has 56.59 (...)
€1,795,000
TSEA5132626
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 165 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 165 Area: Marbella West Region: Andalucía
Corner Duplex Penthouse with Private Plunge Pool & Sea Views
Fully renovated and effortlessly stylish, this 3-bedroom, 3-bathroom corner penthouse blends sleek Scandinavian design with sweeping (...)
€1,450,000
TSEA5132605
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 231 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 231 Area: San Pedro Region: Andalucía
Modern beachfront apartment in prestigious gated complex, located in San Pedro de Alcantara.
This south facing apartment located on the elevated ground floor.
There is a spacious living & (...)
€369,000
TSEA5132542
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
Very large two bedroom two bathroom apartment with the most amazing views Wow !
This is a rare opportunity to purchase an apartment with such magnificent views.
Open plan kitchen with a lounge that (...)
€340,000
TSEA5132527
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 31 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 31 Area: Marbella Region: Andalucía
Second-Line Beachfront Apartment in Marbella Center
This charming 1-bedroom apartment is ideally situated in one of the most sought-after neighborhoods in Marbella Center, just steps from the beach. (...)
€475,000
TSEA5132521
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 2 Baths: 2 M2: 193 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 2 M2: 193 Area: Sotogrande Region: Andalucía
Beautiful 2-bedroom, 2-bathroom penthouse, perfectly situated in the prestigious area of Sotogrande Alto. Offering breathtaking panoramic views over the Almenara Golf Course and its peaceful lake, (...)
€659,000
TSEA5132518
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
Wake up to the sound of the waves and enjoy life on the beachfront in Los Boliches! This bright and spacious apartment with three bedrooms features an impressive terrace that wraps around the (...)
€340,000
TSEA5132512
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 119 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 119 Area: Marbella East Region: Andalucía
Outstanding large ground floor two bedroom apartment with superb panoramic views to sea and mountains.
Situated in one of the most privileged positions on this beautiful development set in manicured (...)
€480,000
TSEA5132461
- Málaga Centro, Costa Del Sol, Malaga
Beds: 4 Baths: 2 M2: 152 Area: Malaga Region: Andalucía
Beds: 4 Baths: 2 M2: 152 Area: Malaga Region: Andalucía
This spacious and welcoming 152 m² apartment, located just 5 minutes walking distance from the sea, 20 minutes from Málaga Airport, and 15 minutes from the María Zambrano high-speed train (...)
€350,000
TSEA5132416
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Apartment on 2nd Line of the Beach in Fuengirola – Only 150 Meters from the Promenade!
Located in one of the most sought-after areas of Fuengirola, this property represents an excellent (...)
Current Featured Properties
€370,500
TSEA4868902
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
YOU COULD NOT ASK FOR A BETTER LOCATION!!
Exclusive multi-family homes of 2 and 3 bedrooms located in the privileged surroundings of the Golden Mile of Estepona. The homes enjoy large terraces (...)
€438,000
TSEA3969424
- Los Monteros, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 87 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Marbella East Region: Andalucía
SO PEACEFUL YOU WON'T HEAR A PIN DROP!!!
Come and see this fabulous development of 39 luxury apartments located in the upper part of Los Monteros. This contemporary design development distributed (...)
€595,000
TSEA4227313
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 144 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 144 Area: Torremolinos Region: Andalucía
STYLE AND QUALITY!!
Bringing to life a new residential concept in Torremolinos. Designed to enjoy the Mediterranean and the endless light of the Costa del Sol. A natural and urban habitat, (...)
