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 (42,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 (42,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 (42,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 2721 - 2740 of 5891 €669,000
TSEA5032123
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 124 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful newly buildt apartment within 5 minutes walk to the centre of La Cala de Mijas. This bright completely renovated property are sold with Scandinavian style modern furnitures worth 40.000 Eur (...)
€4,200,000
TSEA5032111
- Atalaya, Costa Del Sol, Estepona
Beds: 10 Baths: 10 M2: 1,750 Lot Size: 4,000 Area: Estepona Region: Andalucía
Beds: 10 Baths: 10 M2: 1,750 Lot Size: 4,000 Area: Estepona Region: Andalucía
We are very excited to offer this outstanding opportunity to purchase this once in a lifetime plot with 2 Villas Located on it, both Villas are independent, this an opportunity that must be seen to (...)
€650,000
TSEA5032051
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 160 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Area: Mijas and Mijas Costa Region: Andalucía
Fully Renovated 3-Bed Ground Floor Apartment with Sea Views, Just 50 Metres from the Beach
This beautifully renovated ground floor apartment offers three spacious bedrooms and two stylish bathrooms, (...)
€575,000
TSEA5032048
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 2 Baths: 3 M2: 210 Lot Size: 500 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 3 M2: 210 Lot Size: 500 Area: Fuengirola Region: Andalucía
Charming Detached House with Sea Views in Torreblanca
Located in a quiet and well-established residential area of Torreblanca, this detached property offers an excellent opportunity to create a (...)
€379,000
TSEA5032042
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 96 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 96 Area: Estepona Region: Andalucía
EL PARAISO MEDIO (ESTEPONA)
This delightful south facing 2 bedroom, 2 bathroom Ground Floor Apartment is set within large communal gardens and located in a residential area of El Paraiso (...)
€1,149,000
TSEA5031946
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 135 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 135 Area: Estepona Region: Andalucía
Elegant Beachside Penthouse with Panoramic Sea and Mountain Views in Costalita
Just 100 metres from the golden sands of the Mediterranean, this exceptional penthouse offers a rare combination of (...)
€600,000
TSEA5031892
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 142 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 142 Area: Marbella Region: Andalucía
Wonderful totally exterior apartment where light is the protagonist. Located one foot from the beach and the old town of Marbella.
It is distributed in a spacious living room with access to the (...)
€675,000
TSEA5027194
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 166 Lot Size: 792 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 166 Lot Size: 792 Area: Benalmadena Region: Andalucía
Beautiful Family Villa with Modern-Rustic Style and Stunning Sea Views in Monte Alto.
Situated in the highly desirable area of Monte Alto, this remarkable villa seamlessly combines modern amenities (...)
€720,000
TSEA4876399
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 88 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Fuengirola Region: Andalucía
New Development: Prices from 720,000 € to 1,825,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 88.00 m2 - 150.00 m2]
Essential Connection with Nature and the Sea
As its name suggests, this (...)
€695,000
TSEA4195054
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 89 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Fuengirola Region: Andalucía
New Development: Prices from 695,000 € to 1,850,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 89.00 m2 - 133.00 m2]
This development located just 3 minutes walking from Sport Club heading (...)
€350,000
TSEA5027179
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 147 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 147 Area: Manilva Region: Andalucía
Superb apartment located on the top floor of a pleasant urbanization, offering an ideal living environment for families or those who enjoy bright and open spaces.
This property features 3 comfortable (...)
€2,150,000
TSEA5027161
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 5 Baths: 4 M2: 410 Lot Size: 1,280 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 4 M2: 410 Lot Size: 1,280 Area: Sotogrande Region: Andalucía
Immerse yourself in the charm of this new house, nestled in the heart of the sought-after Zone F of Sotogrande. Spanning a vast 1280 m² plot, this 410 m² residence offers an ideal living (...)
€450,000
TSEA5027140
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 2 M2: 365 Area: Casares Region: Andalucía
Beds: 4 Baths: 2 M2: 365 Area: Casares Region: Andalucía
Discover a luxurious and exclusive lifestyle with this stunning 365 m² penthouse, perched high above Casares. Boasting breathtaking views of the Mediterranean Sea and the surrounding golf course, (...)
€1,700,000
TSEA5027131
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 168 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 168 Area: Manilva Region: Andalucía
We present to you this charming duplex penthouse located in one of the most prestigious and elegant urbanizations in La Duquesa, offering one of the finest 180º sea views and located along the (...)
€640,000
TSEA4808326
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 66 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 66 Area: Estepona Region: Andalucía
New Development: Prices from 640,000 € to 1,600,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 66.00 m2 - 88.00 m2]
This development offers 36 beautiful single-storey homes with large rooms, (...)
€625,000
TSEA5027101
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 70 Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Region: Andalucía
A luxury ground floor apartment in the sought after Reserva Del Higueron with its Sports Club, Spa and 5* hotel. A gated complex, with 24-hour security, video phone access, controlled access to (...)
€649,000
TSEA5027092
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 135 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 135 Area: Estepona Region: Andalucía
Penthouse with Panoramic Sea & Golf Views – Estepona
Discover this spectacular south-facing penthouse in an exclusive frontline golf development in Estepona, offering abundant natural light (...)
€425,000
TSEA5027077
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 59 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 59 Area: Torremolinos Region: Andalucía
New Development: Prices from 425,000 € to 590,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 59.00 m2 - 81.00 m2]
Discover the dream of living in the new development!
Your oasis by the sea in (...)
€495,000
TSEA5027068
- Arenas, Costa Del Sol East
Beds: 3 Baths: 2 M2: 279 Lot Size: 5,033 Region: Andalucía
Beds: 3 Baths: 2 M2: 279 Lot Size: 5,033 Region: Andalucía
Exclusive Villa with Breathtaking 360° Views in Arenas, Málaga
Discover one of the most unique villas in the Axarquía region, boasting panoramic views of the Mediterranean Sea and the surrounding (...)
€505,000
TSEA4199632
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 91 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Casares Region: Andalucía
New Development: Prices from 505,000 € to 649,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 91.00 m2 - 116.00 m2]
Apartments with spectacular sea views. Strategically located 250m from the (...)
Current Featured Properties
€4,300,000
EMPTY
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 7 Baths: 5 M2: 330 Area: Marbella West Region: Andalucía
Beds: 7 Baths: 5 M2: 330 Area: Marbella West Region: Andalucía
URB. NINE LIONS, NUEVA ANDALUCIA, MARBELLA
A truly unique and stunning fully private 7-bed apartment located in urb. Nine Lions, Nueva Andalucia, a sought after and well secured urbanisation with 53 (...)
€585,000
TSEA4556254
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 80 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Fuengirola Region: Andalucía
EVERY DETAIL HAS BEEN TAKEN CARE OF!!!
Located in the northern area of the Torreblanca del Sol Development, in the municipality of Fuengirola. An open block multi-family building with a total of 30 (...)
€570,000
TSEA3922510
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
LAST OPPORUNITY TO ACQUIRE!!!!
One of the last opportunities to acquire a newly built property in the centre of Estepona, seaside and just 1 minute from the beach. A dream lifestyle which can be (...)
