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 2661 - 2680 of 3915 €769,000
TSEA4967248
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 189 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 189 Area: Marbella East Region: Andalucía
This exclusive duplex penthouse, located in the prestigious Costa Nagüeles II urbanization on Marbella's Golden Mile, Málaga, offers a unique opportunity to enjoy a privileged location near the sea (...)
€1,200,000
TSEA4967110
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 185 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 185 Area: Marbella West Region: Andalucía
Welcome to your home in Nueva Andalucia! This elegant and spacious 3 bedroom, 3 bathroom en-suite apartment offers an experience of comfort on the Costa del Sol.
Walking distance to the beach and (...)
€624,000
TSEA4967056
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 106 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 106 Area: Mijas and Mijas Costa Region: Andalucía
Duplex for sale in La Cala de Mijas, 20 mn from Marbella centre and 30 mn from the airport. Close to schools, supermarkets, bus stop, only 10mn walking distance to the beach.
The property consists of (...)
€340,000
TSEA4966957
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 133 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Estepona Region: Andalucía
EXCLUSIVE LISTING LOCATED IN FLAMINGO PARK- EL PARAISO
Magnificent apartment located in the Flamingo Park community - Paraiso Medio urbanization. One of the most sought-after communities in the (...)
€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 (...)
Current Featured Properties
€1,110,000
TSEA3948409
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 151 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 151 Area: Fuengirola Region: Andalucía
THE ESSENCE OF THE MEDITERRANEAN LIFESTYLE.
Located in the northern area of the Torreblanca del Sol, in the municipality of Fuengirola. An open block multi-family building with a total of 30 (...)
€310,000
TSEA4452208
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 90 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 90 Area: Manilva Region: Andalucía
This innovative real estate project consists of 60 multi-family dwellings, offering 2 and 3-bedroom apartments, all equipped with garage and storage room in the basement. The blocks are distributed (...)
€325,000
TSEA5073991
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
This development consists of 79 luminous 2 and 3 bedroom apartments and penthouses.
Located only 3 minutes away from the picturesque village La Cala de Mijas, with an abundance of bars, shops, (...)
