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 (43,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 (43,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 (43,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 1021 - 1040 of 4189 €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, (...)
€529,000
TSEA5114656
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Semi-detached house with an apartment (separate studio, separate entrance). The house has three bedrooms and a studio.
Communal pools, paddle tennis court, and multipurpose court. Located very close (...)
€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 (...)
€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 (...)
€535,000
TSEA5114350
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 145 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 145 Area: Mijas and Mijas Costa Region: Andalucía
Stunning Ground Floor Apartment in Frontline Beach Community – Las Mimosas, La Cala de Mijas
Experience coastal living at its finest with this beautifully maintained 2-bedroom, 2-bathroom ground (...)
€845,000
TSEA5114314
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
Exclusive Ground Floor Apartment in Embrujo Playa, Between the Glamour of Puerto Banús and the Charm of San Pedro.
Welcome to a property that brings together everything that makes living in (...)
€298,000
TSEA5114308
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 92 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 92 Area: Benalmadena Region: Andalucía
We are pleased to offer you this exclusive apartment in Torrequebrada, with south-facing orientation, in an exceptional location and a quiet area. This magnificent property, with 92 m² built and 77 (...)
€750,000
TSEA5114269
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 99 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 99 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse, Riviera del Sol, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 99 m², Terrace 23 m².
Setting : Close To Sea, Close To Town, Urbanisation.
Orientation : West, North West.
Condition : (...)
€845,000
TSEA5113885
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 117 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Marbella West Region: Andalucía
Nestled in the heart of Marbella's sought-after Golf Valley in Nueva Andalucía, this completely renovated duplex penthouse corner unit offers a rare opportunity to experience refined Mediterranean (...)
€904,000
TSEA5113795
- Almayate Alto, Costa Del Sol East
Beds: 3 Baths: 3 M2: 196 Lot Size: 31,295 Region: Andalucía
Beds: 3 Baths: 3 M2: 196 Lot Size: 31,295 Region: Andalucía
This impressive finca near Almayate spans almost 32,000 m2 of land and offers ample space for peace, self-sufficiency or small-scale farming projects. At its heart lies a charming house of approx. (...)
€559,000
TSEA5113768
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 157 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 157 Area: Estepona Region: Andalucía
Discover this beautifully presented ground floor apartment, offering the perfect blend of space, comfort, and prime location. The property features a generous open-plan living and dining area that (...)
€190,000
TSEA5113753
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 80 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 80 Area: Manilva Region: Andalucía
Middle Floor Apartment, San Luis de Sabinillas, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 80 m², Terrace 9 m².
Setting : Beachfront, Town, Commercial Area, Beachside, Village, Close To Shops, (...)
€385,000
TSEA5113744
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 60 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 60 Area: Malaga Region: Andalucía
Located 150m from Plaza de La Constitución!
This spacious and modern 2 bed apartment with elevator is conveniently located near various transportation options, including a taxi station, train (...)
€470,000
TSEA5112667
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
With its smart and functional layout, this apartment offers two spacious bedrooms and two bathrooms — one of them en-suite — along with a separate kitchen and an independent utility room that (...)
Current Featured Properties
€850,000
TSEA5036305
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
The exclusive residential complex invites you to a modern lifestyle infused with traditional Andalusian charm, all within a community designed for those who appreciate quality and natural beauty. At (...)
€682,000
TSEA4941358
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 196 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 196 Area: Estepona Region: Andalucía
PHASE II OUT NOW! ACT FAST.
An exclusive community comprising 84 luxury properties with generous indoor spaces, roomy terraces, spectacular views, community areas, swimming pool and club zone. A (...)
€369,000
TSEA4930327
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 79 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 79 Area: Mijas and Mijas Costa Region: Andalucía
We welcome you to this new development in Mijas a large multi-family building that offers 76 homes distributed over five floors plus an attic. The residential complex has common areas that include a (...)
