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 961 - 980 of 3899
€1,150,000
TSEA5115613
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 170 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 170 Area: Marbella West Region: Andalucía
Exclusive 3-Bedroom Property with Sea Views in the Heart of Nueva Andalucía – Fully Renovated, Brand New
Welcome to this magnificent home, ideally situated in one of the most exclusive and secure (...)
€675,000
TSEA5115592
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 2 M2: 175 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 2 M2: 175 Area: Marbella West Region: Andalucía
BEAUTIFUL BRAND-NEW APARTMENT IN NUEVA ANDALUCÍA - READY TO MOVE IN
Welcome to your dream home in the heart of Nueva Andalucía, nestled in the highly sought-after Albatros XV development and just (...)
€675,000
TSEA5115586
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 110 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular Duplex Penthouse in the Ipanema urbanization of La Cala de Mijas.
One of the highest apartments of the complex with panoramic views all over the coast, mountains and Calanova Golf.
Only (...)
€283,160
TSEA5115583
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Bright 3‑bedroom apartment with pool views in Mijas – Ideal for families
For sale: fantastic apartment in one of the most convenient and well‑connected areas of Mijas, surrounded by (...)
€495,000
TSEA5115484
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 135 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: Marbella East Region: Andalucía
Spacious and luminous corner Penthouse Apartment in Elviria, Urb. Pino Golf. (Marbella East)
This urbanisation is walking distance to all shops, bus stop, Bars and Restaurants as well as the (...)
€485,000
TSEA5115463
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 106 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Mijas and Mijas Costa Region: Andalucía
Newly built apartment with 80m2 terrace in the southwest of Fuengirola.
The apartment has 3 bedrooms, one of which is the master bedroom and has its own bathroom. From all bedrooms you can access (...)
€299,000
TSEA5115421
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 102 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Marbella East Region: Andalucía
Charming 2-Bedroom, 2-Bath Apartment with Lovely Views & Great Amenities – €310,000 | Reserva de Marbella
Situated in the peaceful and well-kept Reserva de Marbella, this 2-bedroom, (...)
€320,000
TSEA5115409
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Located in the quiet and well-established area of Riviera del Sol, this apartment offers a clean, modern living space with easy access to the coast and everyday amenities.
The interior is bright and (...)
€240,000
TSEA5115388
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 118 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 118 Area: La Duquesa Region: Andalucía
Prime Investment Opportunity: This stylish middle floor apartment in La Duquesa, Costa del Sol, is perfect as a primary residence, vacation home, or rental investment. Nestled in a large residential (...)
€700,000
TSEA5115373
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 144 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 144 Area: Estepona Region: Andalucía
Luxurious 3-Bedroom Penthouse in Benahavís – Benatalaya
This elegant penthouse is located in the exclusive gated community of Benatalaya, in the Atalaya-Capanes Sur area of Benahavís, at the (...)
€230,000
TSEA5115370
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 70 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Casares Region: Andalucía
Exclusive Apartment with 80 m² Terrace and Panoramic Sea, Golf and Mountain Views – Doña Julia
We are pleased to present this exceptional property located in one of the most sought-after (...)
€264,000
TSEA5114770
- Calypso, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 65 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Mijas and Mijas Costa Region: Andalucía
This property boasts panoramic views of the Mediterranean and southwest orientation, situated just five minutes from the beach. The A-7 provides excellent access to the area, with a variety of (...)
€530,000
TSEA5114695
- Casares Playa, Costa Del Sol, Casares
Beds: 1 Baths: 1 M2: 150 Area: Casares Region: Andalucía
Beds: 1 Baths: 1 M2: 150 Area: Casares Region: Andalucía
Renovated Beachfront Apartment in Casares – Costa del Sol
This cozy apartment, approximately 60 m², combines the charm of beachfront living with the comfort of a modern home. Completely renovated (...)
€385,000
TSEA5114668
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 105 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 105 Area: Fuengirola Region: Andalucía
We present this property for sale located in Terrazas de Torreblanca. In a very peaceful area, we find Calle de las Perdices, where this apartment is situated in a building with an elevator. However, (...)
€478,000
TSEA5114638
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 119 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 119 Area: San Pedro Region: Andalucía
This property is located in the exclusive area Guadalmina Alta in urbanisation Campos de Guadalmina, one of Marbella's most sought-after areas. Surrounded by nature and golf courses, Campos de (...)
€450,000
TSEA5114620
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 72 Lot Size: 106 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Lot Size: 106 Area: Estepona Region: Andalucía
Elegant 200 m² apartment in the ARANYA ESTEPONA development: style, space, and tranquility between Estepona and San Pedro. A spacious and bright 2-bedroom apartment with a total area of 200 m² is (...)
€429,000
TSEA5114560
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 105 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Benalmadena Region: Andalucía
Just 20 minutes from Malaga Airport, less than 5 minutes from the beach of Benalmádena Costa, restaurants and shops, and directly adjacent to the famous Torrequebrada golf course, you will find the (...)
€320,000
TSEA5114557
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 118 Lot Size: 81 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 118 Lot Size: 81 Area: Marbella East Region: Andalucía
OPPORTUNITY IN MARBELLA WITH SEA VIEWS AND A LARGE PRIVATE GARDEN OF MORE THAN 80M2
Property located in Marbella East, next to the best beaches and the port of Cabopino, a few minutes' drive from the (...)
€570,000
TSEA5114494
- 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
Just 350 metres from the beach, this beautifully crafted 2-bedroom, 2-bathroom apartment offers the perfect blend of contemporary style and everyday comfort. Located in an exclusive development of (...)
€625,000
TSEA5114377
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
This is a fabulous 3 bedroom apartment in the front line beach complex of Las Mimosas in La Cala de Mijas. Set on the first floor with views over the beautiful gardens, pools and Mediterranean, this (...)
Current Featured Properties
€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 (...)
€382,000
TSEA5078233
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 94 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 94 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 (...)
€1,038,000
TSEA4965829
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 90 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 90 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 (...)
