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 (48,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 (48,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 (48,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 141 - 160 of 3916
€575,000
TSEA5152720
- Estepona, 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
Brand New Fully Furnished 2-Bedroom Apartment in Puerto de Estepona – Just One Minute from the Beach!
Step into modern coastal luxury with this stunning, brand-new apartment in a 2025-designed (...)
€138,500
TSEA5152705
- Antequera, Costa Del Sol, Antequera
Beds: 1 Baths: 1 M2: 51 Area: Antequera Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Antequera Region: Andalucía
Modern 1-Bedroom Apartment in the Historic Heart of Antequera
Located right in the centre of Antequera, this modern apartment offers the perfect combination of style, comfort, and (...)
€635,000
TSEA5152696
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 117 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 117 Area: Fuengirola Region: Andalucía
Location, Location! Bright Renovated Apartment Just Steps from Fuengirola's Stunning Seafront**
Welcome to this beautifully renovated home in the heart of Los Boliches – a place where everything (...)
€385,000
TSEA5152693
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Modern 2-bedroom apartment with golf & mountain Views
Beautiful new build 2-bedroom, 2-bathroom apartment in the prestigious Calanova Golf area. Enjoy stunning panoramic views of the golf course (...)
€790,000
TSEA5152687
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
LARGE PROPERTY IN MARBELLA CENTER, 300 METERS FROM THE PROMENADE AND THE BEACH
Fantastic property with a prime location in the center of Marbella, surrounded by all kinds of amenities and just 300 (...)
€680,000
TSEA5152669
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
FANTASTIC APARTMENT WITHIN WALKING DISTANCE OF LA CALA DE MIJAS!
This beautiful apartment in Jardinana Lotus is the ideal (holiday) apartment!
The apartment features 3 bedrooms, 2 bathrooms, a (...)
€415,000
TSEA5152627
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beautiful 90 m2 apartment with 2 bedrooms and 2 bathrooms, a terrace with garden views, and direct access to the beach in an exclusive Estepona development.
This ground-floor apartment with two (...)
€378,000
TSEA5152303
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 85 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 85 Area: Marbella Region: Andalucía
Newly refurbished 2-bedroom apartment in the heart of Marbella Centre.
This property features one en-suite bedroom and a smaller second bedroom, ideally located close to all amenities and just a (...)
€429,000
TSEA5152285
- Hacienda del Sol, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 152 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 152 Area: Estepona Region: Andalucía
Two bedroom ground floor apartment in the luxurious urbanisation Hacienda del Sol.
Layout:
- living room, dining room
- kitchen
- 2 bedrooms, 1 with bathroom en suite
- 2 bathrooms
On the (...)
€615,000
TSEA5152282
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 178 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 178 Area: Marbella West Region: Andalucía
Discover this charming 2-bedroom, 2-bathroom corner apartment, perfectly located within walking distance to both the beach and a selection of the area's most popular restaurants. Surrounded by (...)
€499,000
TSEA5152210
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 76 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 76 Area: Marbella Region: Andalucía
Here's a charming apartment located in the Golden Beach Urbanization, just 50 meters from the beach. This community features fantastic shared areas, including two large swimming pools surrounded by a (...)
€741,300
TSEA5152207
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
This is an opportunity not to be missed: a spectacular, fully furnished property located in a secure gated community with all kinds of services and infrastructure nearby. The property is just a few (...)
€450,000
TSEA5152114
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 130 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Casares Region: Andalucía
Exquisite Penthouse in Majestic, Casares del Sol – Casares Golf: Panoramic Sea and Mountain Views, Just 5 Minutes Walk to the Beach!
Elevate your lifestyle with this stunning penthouse in the (...)
€372,000
TSEA5152111
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 77 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 77 Area: Benalmadena Region: Andalucía
APARTMENT CLOSE TO PALOMA PARK, BENALMADENA: Nice 2 bedrooms, 1 bathroom apartment ideally located just a short stroll from the lush green haven of Parque de la Paloma and the vibrant heart of Arroyo (...)
€330,000
TSEA5152096
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 61 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 61 Area: Casares Region: Andalucía
Discover this modern Mediterranean 2 bedroom apartment in brand-new gated community in Casares. Ideally located just minutes from the prestigious Finca Cortesín Hotel & Golf Resort and a short (...)
€570,000
TSEA5152066
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 150 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Area: Estepona Region: Andalucía
In the heart of Estepona's New Golden Mile, where the Costa del Sol shows off its most sophisticated side, lies a unique opportunity for those looking to live or invest on the seafront. The Mar Azul (...)
€595,000
TSEA5152033
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 85 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Mijas and Mijas Costa Region: Andalucía
Stunning 2-Bedroom Beachfront Apartment in Sitio de Calahonda.
Discover coastal living at its finest with this beautiful 2-bedroom, 2-bathroom modern apartment located in an the sought-after (...)
€650,000
TSEA5152009
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Discover the perfect blend of convenience and coastal living with this fantastic apartment, located just 400 meters from the beach. This property is ideally suited for anyone seeking either a (...)
€420,000
TSEA5151979
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Elegant Apartment with Sea Views in Lower Carvajal
Property with rental license.
Welcome to this stylish two-bedroom, two-bathroom apartment nestled in the peaceful and sought-after area of Lower (...)
€525,000
TSEA5151970
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 135 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: Benahavis Region: Andalucía
Stunning Two-Bedroom Penthouse Apartment in Gazules del Sol
This bright and elegant two-bedroom penthouse is located in the sought-after urbanisation Gazules del Sol.
Upon entering, you are (...)
Current Featured Properties
€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, (...)
€384,000
TSEA4297042
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
NEW OFF PLAN DEVELOPMENT, ON THE EDGE OF ESTEPONA!
Consisting of seven housing blocks with a total of 132 homes with 1, 2, 3 and 4 bedrooms with a garage, storage room, community pool for adults and (...)
€485,850
TSEA4581442
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 112 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: San Pedro Region: Andalucía
The development in San Pedro de Alcantara is made up of 35 homes with 2 and 3 bedrooms, with duplexes with terraces-solariums. Garages in the basement and commercial premises on the ground floor, in (...)
