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 (163,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 (163,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 (163,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 441 - 460 of 3899 €611,000
TSEA5138941
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
This is not simply a place to live. It's a lifestyle ecosystem. From sunrise swims in your private pool to sunset walks along the coastal path, this is more than just a home — it's a (...)
€1,099,000
TSEA5138932
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 133 Lot Size: 110 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 133 Lot Size: 110 Area: San Pedro Region: Andalucía
New apartment for sale in a newly built building.
Fantastic ground floor apartment with private garden.
A resale of the new apartment. Take advantage of the opportunity!
It is a new residential (...)
€494,000
TSEA5138920
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
This is not simply a place to live. It's a lifestyle ecosystem. From sunrise swims in your private pool to sunset walks along the coastal path, this is more than just a home — it's a (...)
€395,000
TSEA5138917
- Riviera del Sol, 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
Charming 2-Bedroom Apartment – 5 Minutes from the Beach
Enjoy relaxed coastal living in this beautifully renovated 2-bedroom, 2-bathroom apartment in the heart of Riviera del Sol. Bright and (...)
€610,000
TSEA5138908
- 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
NEW ON THE MARKET! Fantastic apartment that combines a modern and elegant style to create the perfect space for your future home.
The property welcomes you at the entrance with a bright, modern (...)
€379,000
TSEA5138899
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 51 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Estepona Region: Andalucía
This is not simply a place to live. It's a lifestyle ecosystem. From sunrise swims in your private pool to sunset walks along the coastal path, this is more than just a home — it's a (...)
€298,000
TSEA5138887
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 2 Baths: 1 M2: 82 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 1 M2: 82 Area: Sotogrande Region: Andalucía
Modern 2-bedroom apartment just a 1-minute walk to restaurants, bars, shops, and a supermarket. The bus station is only meters away, and Sotogrande Port is within walking distance. Includes a fully (...)
€565,000
TSEA5138848
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 67 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 67 Area: Estepona Region: Andalucía
Your Dream Beachfront Home in Estepona
Imagine waking up every day with the sound of the waves just steps away. This beautifully renovated 2-bedroom, 2-bathroom apartment is set within one of (...)
€226,000
TSEA5138821
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 68 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 68 Area: Estepona Region: Andalucía
We are pleased to present this charming two-bedroom, one-bathroom apartment located in the sought-after area of Estepona Golf. An ideal opportunity, whether as a holiday home, permanent residence, or (...)
€500,000
TSEA5138818
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Spacious and Bright Apartment in the Heart of Marbella, Just Steps from the Beach
For sale: a magnificent 2-bedroom, 1-bathroom apartment located in the very center of Marbella, just a few meters (...)
€294,455
TSEA5138815
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 93 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Fuengirola Region: Andalucía
Brand-New Apartment in Fuengirola – 2 Bedrooms, 2 Bathrooms
Located on the second floor, this apartment features approximately 70 m² of usable space and 93 m² of built area. It includes a (...)
€845,000
TSEA5138809
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 174 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 174 Area: Benahavis Region: Andalucía
Penthouse Los Balcones de la Quinta – Benahavís
3 Bedrooms | 2 Bathrooms | 174 m² Interior | 150 m² Rooftop Terrace | Frontline Golf
A Penthouse for True Bon Vivants
This spectacular (...)
€259,000
TSEA5138674
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 60 Area: Mijas and Mijas Costa Region: Andalucía
Brand-New 2-Bedroom Apartment in Las Laguna de Mijas.
This spacious 2-bedroom apartment combines modern architecture, premium-quality finishes, and a practical layout, creating the perfect home on (...)
€285,000
TSEA5138665
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 81 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: La Duquesa Region: Andalucía
Beautiful 2-Bedroom Apartment with Sea Views. This elegant 2-bedroom, 2-bathroom apartment boasts stunning sea views from its spacious terrace. Located just a 5-minute drive from La Duquesa port, the (...)
€495,000
TSEA5138662
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 69 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 69 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to this beautifully refurbished penthouse in the sought-after Los Prados del Golf complex, located in the charming town of La Cala de Mijas. Meticulously modernized to an exceptional standard (...)
€495,000
TSEA5138635
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Located in the sought-after beachside area of Carib Playa, this spacious 3-bedroom, 2-bathroom apartment offers the perfect blend of comfort and convenience.
The property is situated within a secure (...)
€670,000
TSEA5138605
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 195 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 195 Area: Casares Region: Andalucía
Luxury front line beach middle floor apartment. Located mid way between Estepona and the La Duquesa Marina, 5 minutes drive to all amenities and leisure areas, including excellent golf courses, one (...)
€242,000
TSEA5138587
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 72 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 72 Area: Mijas and Mijas Costa Region: Andalucía
This cozy 2 bedroom apartment and 1 bathroom is ideal for those who seek comfort and functionality. It has a perfect 7 m² terrace to enjoy the outdoors. The independent kitchen offers a practical (...)
€347,000
TSEA5138530
- Torrequebrada, 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
This beautifully renovated 2-bedroom, 2-bathroom apartment is situated in the highly desirable Torrequebrada area of Benalmádena. Offering style, comfort, and an unbeatable location, it's the (...)
€312,900
TSEA5138083
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 95 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 95 Area: San Pedro Region: Andalucía
This property is situated in a highly desirable location in the heart of San Pedro, facing east, and is well connected with a wide range of amenities and services in the vicinity. The property is (...)
Current Featured Properties
€325,000
TSEA5073991
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
This development consists of 79 luminous 2 and 3 bedroom apartments and penthouses.
Located only 3 minutes away from the picturesque village La Cala de Mijas, with an abundance of bars, shops, (...)
€398,000
TSEA5008441
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 89 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 89 Area: Casares Region: Andalucía
STUNNING VIEWS OF THE MOUNTAINS AND SEA!!!
This brand new development consists of 47 apartments with 2 and 3 bedrooms, distributed in 3 blocks with ground floor and 2 floors. All of them with garage (...)
€568,700
TSEA4856224
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
A STUNNING GATED DEVELOPMENT!!!
It is a modern project of 50 homes of 2 and 3 bedrooms, each with its own parking space and storage room. The construction will always respect our commitment to the (...)
