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 (56,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 (56,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 (56,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 2661 - 2680 of 3902 €550,000
TSEA4966876
- Selwo, 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
Luxury Apartment for Sale in Oasis 325 Phase 2 – Fully Furnished with Stunning Views
Discover this brand-new, fully furnished apartment in the exclusive Oasis 325 Phase 2, completed in 2024. (...)
€485,000
TSEA4966849
- Nagüeles, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 100 Lot Size: 130 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Lot Size: 130 Area: Marbella Region: Andalucía
Price reduced! Beautiful ground floor apartment within walking distance of the center and beach in Marbella for sale. The entrance gives direct access to the bright living room with open kitchen and (...)
€639,000
TSEA4966315
- La Quinta, 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
Nestled in the prestigious area of La Quinta, Benahavis, Malaga, this luxurious apartment offers an unparalleled living experience. Boasting a prime frontline golf location, the property is part of (...)
€2,950,000
TSEA4966189
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 208 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 208 Area: Marbella Region: Andalucía
Exclusive south facing duplex penthouse with frontal sea views in one of the most prestigious beachfront developments in Puerto Banus, Marbella.
Ventura del Mar is one of the most prestigious and (...)
€890,000
TSEA4966087
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 220 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 220 Area: Fuengirola Region: Andalucía
Superb 3 bedroom corner apartment Med One, el Higuerón, Fuengirola.
Welcome to the Med One Resort Collection apartment, which offers the perfect holiday home in the prestigious area of el (...)
€459,000
TSEA4965928
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 74 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Fuengirola Region: Andalucía
New apartment located in a new complex of 160 modern apartments in the Higueron area. The apartment has 2 bedrooms and 2 full bathrooms. The living room is bright with an open kitchen solution. From (...)
€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 (...)
€419,000
TSEA4965817
- Los Flamingos, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
FANTASTIC PROPERTY IN THE EXCLUSIVE AREA OF LOS FLAMINGOS
Elegant apartment located in the exclusive and prestigious area of Los Flamingos, next to the luxurious Hotel Villa Padierna and its (...)
€595,000
TSEA4965730
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 137 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 137 Area: Benalmadena Region: Andalucía
Dream penthouse with stunning seaviews in the cozy Mediterra community in Nueva Torrequebrada, Benalmadena!
Do you dream of a spacious and bright home with stunning panoramic views of the sea, (...)
€429,000
TSEA4965637
- La Cala de Mijas, 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
Well presented three bedroom, two bathroom, second floor apartment, perfect for family holidays or permanent living. Located in the centre of La Cala and only 230 metres to the beach, this is an (...)
€595,000
TSEA4965232
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 175 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 175 Area: Fuengirola Region: Andalucía
Discover your new home by the sea! This magnificent 4-bedroom, 3-bathroom apartment, located on the 7th floor, offers you the opportunity to live just 20 metres from Los Boliches beach. With 175 m² (...)
€425,000
TSEA4965169
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
EXCLUSIVE PROPERTY - 95m2 flat next to C/ Real, the most central and popular street in Estepona. This flat is distributed in 3 bedrooms, 2 bathrooms, hall, living-dining room and kitchen.
The area (...)
€489,000
TSEA4965163
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Stunning 2-Bedroom Corner Ground-Floor Apartment in Estepona
Located in a gated community just west of Estepona, this brand-new, never-lived-in ground-floor corner apartment offers breathtaking sea (...)
€670,000
TSEA4965058
- 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
Middle Floor Apartment, Puerto Banús, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 130 m².
Setting : Beachside, Port, Close To Schools, Marina.
Orientation : South.
Condition : Recently (...)
€1,241,100
TSEA4964773
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 174 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 174 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 (...)
€928,800
TSEA4964758
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 118 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 118 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 (...)
€910,000
TSEA4964749
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 94 Lot Size: 23 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Lot Size: 23 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 (...)
€415,000
TSEA4964677
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
This fantastic top-floor duplex penthouse is located in the heart of Calahonda, within walking distance to the beach, shops, restaurants, gym, padel courts, and all essential amenities.
The (...)
€3,850,000
TSEA4964386
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 136 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Area: Marbella East Region: Andalucía
Situated in the well-known Puente Romano Resort, this apartment offers a comfortable and stylish living space in one of Marbella's most desirable locations. Designed with an open-plan layout, it (...)
€1,150,000
TSEA4964227
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 90 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 90 Area: Marbella Region: Andalucía
Exclusive Luxury Penthouse Duplex in the Heart of Marbella
Discover this architectural gem in a prime location, just 100 metres from the beach and next to Marbella's charming Old Town. This (...)
Current Featured Properties
€560,000
TSEA4861441
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 99 Lot Size: 62 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 99 Lot Size: 62 Area: Estepona Region: Andalucía
A brand new project consisting of just 30 luxury apartments and penthouses. There are 2 and 3 bedroom options available in this exclusive community conveniently located just 5 minutes from the centre (...)
€266,000
TSEA3936250
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Lot Size: 53 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Lot Size: 53 Area: Estepona Region: Andalucía
BRAND NEW DEVELOPMENT IN ESTEPONA.
Don't miss out on an opportunity to buy in this development of 90 dwellings of 1, 2 and 3 bedrooms, all of them with garage space and storage room. It is an (...)
€720,000
TSEA5063449
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 139 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Area: Benalmadena Region: Andalucía
An exclusive boutique complex of 28 apartments in the highly sought-after area of Torremuelle, Benalmádena. Each residence has been carefully designed to offer a superior living experience, with (...)
