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 (39,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 (39,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 (39,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 941 - 960 of 3899 €495,000
TSEA5116888
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Elegant Duplex Penthouse with 2 Private Garage Spaces + Storage Room
This beautifully maintained duplex penthouse is move-in ready — perfect as a holiday retreat, year-round residence, or (...)
€335,000
TSEA5116693
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic apartment with sea views located in El Faro.
It features two double bedrooms with built-in wardrobes and two full bathrooms.
This sunny apartment faces south and offers beautiful sea views. (...)
€360,000
TSEA5116687
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
STUNNING ULTRA LUXURY/MODERN APARTMENT in front line Mijas Golf location. Refurbished to the very highest of standards. The property consists of a spacious lounge/dining room, modern fully fitted (...)
€895,000
TSEA5116642
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 168 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 168 Area: San Pedro Region: Andalucía
3 bed duplex penthouse in La Gavia, San Pedro, Marbella
THE PROPERTY:
Beautiful beachside west facing 3 bedroom duplex penthouse apartment walking distance to the San Pedro village and just 200 (...)
€380,000
TSEA5116609
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 76 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 76 Area: Marbella Region: Andalucía
Newly renovated apartment with aprox 5 min walk to the beach. It is a farmacy in the building. Parking is outside.
There is parking space in the basement that you can purchase upon (...)
€235,000
TSEA5116597
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 1 M2: 103 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 1 M2: 103 Area: Fuengirola Region: Andalucía
Discover this delightful 3-bedroom apartment in the heart of Andalucía, Málaga, priced at €235,000. Spanning 103m², this residence boasts high ceilings and abundant natural light, creating a (...)
€257,000
TSEA5116588
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Charming apartment located in Cerros de Águila in a quiet complex offering the perfect combination of comfort and convenience.
All exterior, with a 23 m2 living-dining room, terrace, and separate, (...)
€320,000
TSEA5116579
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 106 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Casares Region: Andalucía
Spectacular Home in Casares Costa
We are delighted to present this magnificent property located in one of the most sought-after areas of the Costa del Sol, just 10 minutes from the beach and (...)
€375,000
TSEA5116570
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 152 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 152 Area: Estepona Region: Andalucía
Elegant Ground-Floor Apartment with Private Terrace, Two En-Suite Bedrooms, and Direct Garden Access – Perfect for Living or Investment
Located in the exclusive residential complex La Cartuja del (...)
€995,000
TSEA5116504
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 148 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 148 Area: Fuengirola Region: Andalucía
Unique property with AMAZING SEA VIEWS located in the lower area of El Higuerón (Fuengirola). PRIME LOCATION at only 400 mts from the beach and 250 mts from Carvajal train station.
Modern CORNER (...)
€849,000
TSEA5116498
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 103 Lot Size: 95 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Lot Size: 95 Area: Marbella West Region: Andalucía
ELEGANT GROUND FLOOR RETREAT WITH PRIVATE GARDEN IN NUEVA ANDALUCÍA
Discover this beautifully renovated three-bedroom apartment in Jardines de Andalucía, ideally located in the heart of Nueva (...)
€300,000
TSEA5116489
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 73 Lot Size: 1 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 73 Lot Size: 1 Area: Fuengirola Region: Andalucía
Fuengirola center, Costa del Sol- Brand new apartment, fantastic price. Ideal as a holiday apartment!
4th floor with panoramic views
You will have the exclusive opportunity to own a beautiful modern (...)
€529,000
TSEA5116465
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 120 Lot Size: 40 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Lot Size: 40 Area: Estepona Region: Andalucía
Elegant Ground-Floor Apartment with Large Terrace and Private Garden in a Prestigious Gated Community
Discover refined living in this luxurious ground-floor apartment, located within one of the (...)
€1,065,000
TSEA5116462
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 124 Lot Size: 320 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Lot Size: 320 Area: Torremolinos Region: Andalucía
Luxury Ground Floor Apartment in Playamar – Resort-Style Living All Year Round
Exclusivity, space, and elegance await you!
Discover this stunning luxury ground floor residence in the prestigious (...)
€1,195,000
TSEA5116420
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 134 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Benahavis Region: Andalucía
DESCRIPTION
Discover this exceptional 280 m² apartment (including terraces) on the top floor of the sought-after Cataleya Phase I residential complex, located in the prestigious New Golden Mile of (...)
€849,000
TSEA5116408
- Aloha, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 129 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 129 Area: Marbella West Region: Andalucía
Penthouse Duplex, Aloha, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 129 m², Terrace 58 m².
Setting : Close To Golf, Close To Schools, Urbanisation.
Orientation : South, South West.
Condition : (...)
€795,000
TSEA5116339
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 152 Lot Size: 70 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 152 Lot Size: 70 Area: Benahavis Region: Andalucía
Beautifully Renovated Ground Floor Apartment in Gazules del Sol
Located in the sought-after gated development of Gazules del Sol, this stunning ground floor apartment blends modern living with (...)
€1,495,000
TSEA5116210
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 220 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 220 Area: Marbella East Region: Andalucía
Exclusive Apartment 260 m² (186m2 inside en 75m2 outside) MarbellaGolden Beach, Marbella, with Stunning Rooftop Terrace and Pool
Just a 2-minute walk from the beach, this fully renovated luxury (...)
€1,200,000
TSEA5116174
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 175 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 175 Area: Marbella West Region: Andalucía
Contemporary Elegance in Nueva Andalucía – Corner Apartment with Large Terrace and Panoramic Sea Views
Welcome to this stunning corner apartment, located in one of Nueva Andalucía's most (...)
€565,000
TSEA5116066
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 135 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: Estepona Region: Andalucía
This newly refurbished apartment is located right in the heart of Estepona, in the charming historic town, full of pedestrian streets known for their colorful flower pots and poetry murals.
This (...)
Current Featured Properties
€321,000
TSEA5078176
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 83 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 83 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
This development is the vision of renowned architect — an architectural masterpiece that reimagines residential living as a seamless extension of the Mediterranean.
THE ESSENCE OF THE COSTA DEL (...)
€704,000
TSEA4418647
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 107 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 107 Area: Benalmadena Region: Andalucía
Nestled amidst Benalmadena's vibrant centre and situated adjacent to its picturesque port, This new development offers the perfect blend of city living and seaside luxury. A distinctive project that (...)
€4,385,000
Luxury Beach-Side Apartments with Panoramic Views, Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 203 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 203 Area: Estepona Region: Andalucía
UNIQUE BOUTIQUE DEVELOPMENT BEACHSIDE ESTEPONA. A special opportunity to own one of 9 apartments in a new beachside development close to the marina of Estepona. This PREMIUM LUXURY apartment is (...)
