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 (51,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 (51,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 (51,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 2581 - 2600 of 3915 €1,195,000
TSEA4976017
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
€1,525,000
TSEA4976002
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 121 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 121 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
€125,000
TSEA4975960
- Manilva, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 60 Lot Size: 50 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Lot Size: 50 Area: Manilva Region: Andalucía
BEST PRICE AROUND ! EASY, NO HASSLE * YEARLY RETURN * 60 DAYS FREE USE
***Very nice Tourist Apartment located in the urbanization of Bahía de las Rocas, Village Club site in Terrazas Costa del Sol (...)
€620,000
TSEA4975945
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to a stunning corner apartment in the modern Las Banderas complex in La Cala de Mijas!
This bright and modern home offers an open view and features 3 bedrooms, 2 bathrooms, and a terrace (...)
€595,000
TSEA4975873
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 102 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 102 Area: Fuengirola Region: Andalucía
THE APARTMENT IS NOW RENTED FOR LONG TERM. IT CAN BE PURCHASED WITH THE CURRENT LEASE CONTRACT.
Brand new east facing apartment, with 3 bedrooms, 2 bathrooms, spacious living-dining room, open plan (...)
€769,000
TSEA4975849
- Carvajal, 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
RESALE PROPERTY
Luxury 2-Bedroom Apartment with Private Plunge Pool
Experience a new standard of luxury living in this exquisite 2-bedroom apartment, where avant-garde design meets seamless (...)
€669,000
TSEA4975819
- Carvajal, 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
RESALE PROPERTY
Luxury 2-Bedroom Apartment with Private Plunge Pool
Experience a new standard of luxury living in this exquisite 2-bedroom apartment, where avant-garde design meets seamless (...)
€420,000
TSEA4975681
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 5 Baths: 3 M2: 302 Lot Size: 150 Area: Algeciras Region: Andalucía
Beds: 5 Baths: 3 M2: 302 Lot Size: 150 Area: Algeciras Region: Andalucía
Stunning flat located in an idyllic location in the urbanisation of La Alcaidesa within walking distance to Sotogrande.
The property with a total area of 342 m2 is distributed as follows: the main (...)
€390,000
TSEA4975354
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 88 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Casares Region: Andalucía
URB. ALCAZABA HILLS
ESTEPONA
Nice and cozy groundfloor apartment in urb. Alcazaba Hills, next to the Alcazaba Lagoon. South facing, quiet and private with views to the gardens and (...)
€4,500,000
TSEA4975186
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 6 Baths: 7 M2: 575 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 7 M2: 575 Area: Marbella West Region: Andalucía
Nestled in the prestigious Gray D'Albion complex in Marbella - Puerto Banus, this exceptional ground floor duplex offers an unparalleled beachfront living experience. With six spacious bedrooms and (...)
€890,000
TSEA4974928
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 100 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Marbella West Region: Andalucía
Luxury Penthouse with Sea, Golf and La Concha Views – Jardines de Nueva Andalucía
Discover this stunning penthouse, fully renovated in 2025, located in one of Marbella's most exclusive areas. (...)
€420,000
TSEA4893604
- Rincón de la Victoria, Costa Del Sol East
Beds: 2 Baths: 2 M2: 77 Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Region: Andalucía
New Development: Prices from 420,000 € to 564,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 77.00 m2 - 98.00 m2]
This is a development of 22 homes of 2 and 3 bedrooms distributed in 2 blocks, (...)
€309,000
TSEA4974811
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 116 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Marbella East Region: Andalucía
Exceptionally large two bedroom ground floor corner apartment.
Superb panoramic views.
Quality fittings throughout.
Small garden room extension.
Situated in thriving community with wonderful sub (...)
€260,000
TSEA4974757
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 48 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 48 Area: Estepona Region: Andalucía
Location, Location, Location! If you are looking for a property in the heart of Old Town Estepona, just yards away from the sandy beaches with all shops, bars and restaurants on the doorstep then (...)
€279,900
TSEA4974754
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 48 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 48 Area: Estepona Region: Andalucía
Location, Location, Location! If you are looking for a property in the heart of Old Town Estepona, just yards away from the sandy beaches with all shops, bars and restaurants on the doorstep then (...)
€710,000
TSEA4974682
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 143 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 143 Area: Marbella West Region: Andalucía
Ground floor apartment with three bedrooms and two bathrooms, featuring a large living room and direct access to a spacious garden, with ample bedrooms. One of the three bedrooms is currently (...)
€950,000
TSEA4974649
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 186 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 186 Area: Marbella West Region: Andalucía
This exquisite 3-bedroom, 3-bathroom luxury apartment is located in a small, exclusive complex of only 18 apartments, offering a serene and private living experience. Nestled in the heart of the (...)
€419,000
TSEA4974610
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 115 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful penthouse with 2 west facing terraces in Torrequebrada. 2 bedrooms, 2 bathrooms, one of them ensuite. 2 very big private garage spaces and a spacious storage room are included in the price. (...)
€998,000
TSEA4974484
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 194 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 194 Area: Benalmadena Region: Andalucía
"Discover paradise in Puerto Marina, Benalmádena! This impressive 231 m² apartment offers you a unique experience with 180-degree panoramic views of the sea and the port from its spacious (...)
€699,000
TSEA4974349
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 2 M2: 158 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 2 M2: 158 Area: Nerja and Malaga East Region: Andalucía
Exclusive penthouse in the heart of Nerja, spectacular sea views with both sunrise and sunset from the terraces.
Large well-planned penthouse with 3 bedrooms and 2 bathrooms, wonderful terraces with (...)
Current Featured Properties
€1,015,000
Top Floor Apartment in Nueava Andalucia
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
LAST PENTHOUSE REMAINING!!!!
Situated in a privileged position on a hill with the best panoramic views over the "Viejo del Angel" water reservoir, the Marbella coastline and the golf (...)
€510,000
TSEA4791997
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
We are delighted to introduce this fabulous new development in in the beautiful area of Arroyo Enmedio in Estepona – an exclusive new development featuring 48 two and 3-bedroom apartments and (...)
€1,195,000
TSEA4976017
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
