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 (39)
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 (39)
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 (39)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 1069
€489,000
TSEA5159650
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 80 Lot Size: 39 Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Lot Size: 39 Region: Andalucía
Exclusive Ground-Floor Apartment with Private Garden in Las Lomas del Higuerón – Fuengirola
Located in one of the most sought-after residential areas on the Costa del Sol, this spectacular (...)
€620,000
TSEA5159194
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 113 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Fuengirola Region: Andalucía
Located just 100 metres from the beach and close to Castillo Sohail Fuengirola this spacious three bedroom apartment offers the perfect blend of coastal living and urban convenience. Situated on the (...)
€495,000
TSEA5158228
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 127 Lot Size: 28 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 28 Area: Algeciras Region: Andalucía
Everyone wants outside space.
Everyone wants walk to beach, shops, a few restaurants.
And every wants a sea view. These are our common requests.
What if you can get all of the above, a little sea (...)
€750,000
TSEA5158210
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 227 Lot Size: 270 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 227 Lot Size: 270 Area: Benahavis Region: Andalucía
Spectacular ground floor duplex flat located in the exclusive gated community of Riverside, in the village of Benahavís, a secure environment where residents enjoy peace and privacy. One of the most (...)
€745,000
TSEA5158165
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 106 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 106 Area: Estepona Region: Andalucía
Apartment for sale – Benatalaya Urbanization
Discover this spacious and bright ground floor apartment, ideal for enjoying life on the coast. With 250 m² built and 206 m² useful, this property (...)
€299,000
TSEA5158045
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Beautiful 2 bedroom ground floor apartment in the old town of Estepona, The property has a large living room with semi open plan kitchen, two double bedrooms, large bathroom and courtyard patio,
It (...)
€965,000
TSEA5157901
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Nestled in a prestigious beachfront urbanization in Estepona, walking distance to the port, this luxurious fully renovated apartment offers an unparalleled living experience on the Costa del Sol. (...)
€399,800
TSEA5157616
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 3 M2: 116 Lot Size: 100 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 3 M2: 116 Lot Size: 100 Area: La Duquesa Region: Andalucía
This exceptional ground floor apartment is situated in the sought-after Duquesa Suites complex in Manilva, Malaga. The property offers a blend of comfort, security, and convenience, making it an (...)
€269,000
TSEA5157136
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 112 Lot Size: 23 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Lot Size: 23 Area: Casares Region: Andalucía
Charming ground floor apartment in Casares Costa with two bedrooms and two bathrooms, within a small, quiet urbanisation. The property stands out for its spacious, south-facing terrace and private (...)
€265,000
TSEA5157067
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 56 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Fuengirola Region: Andalucía
New Development: Prices from 265,000 € to 1,100,000 €. [Beds: 1 - 4] [Baths: 1 - 3] [Built size: 56.00 m2 - 188.00 m2]
Boutique Sea-View Apartments in Torreblanca del Sol
Features:
Sea-facing (...)
€660,000
TSEA5157052
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 135 Lot Size: 28 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 135 Lot Size: 28 Area: Benahavis Region: Andalucía
Elegant ground-floor apartment with a large terrace and private garden in a prestigious gated community Benatalya.
The property features a spacious layout with 3 bedrooms and 3 bathrooms, a bright (...)
€340,000
TSEA5156938
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 55 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 55 Area: Mijas and Mijas Costa Region: Andalucía
Modern 2-Bedroom Apartment in the Heart of La Cala de Mijas – Steps from the Beach ✨
Discover your ideal coastal home with this beautifully presented 2 bed, 1 bath apartment located just a few (...)
€410,000
TSEA5156911
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 120 Lot Size: 25 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Lot Size: 25 Area: Casares Region: Andalucía
Fantastic ground floor apartment with large private garden in Casares Costa
Wonderful corner property with golf views and partial sea views, located in one of the most privileged areas of the Costa (...)
€2,950,000
TSEA5156527
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 662 Lot Size: 191 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 662 Lot Size: 191 Area: Benahavis Region: Andalucía
Modern ground floor 3-bedroom apartment is offered for sale in a new gated resort-style development situated in idyllic countryside of Benahavís, behind the Costa del Sol beaches.
Nestled amidst (...)
€299,000
TSEA5156344
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 116 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Benalmadena Region: Andalucía
Located in the heart of charming Benalmádena Pueblo, this beautifully maintained 2-bedroom apartment offers a blend of modern comfort, relaxed coastal living, and investment potential.
Situated in (...)
€695,000
TSEA5156257
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 101 Lot Size: 50 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Lot Size: 50 Area: Marbella East Region: Andalucía
An amazing opportunity to acquire a property in East Marbella´s most iconic complex. This luxury modern apartment is an elevated ground floor property offering the benefit of a large terrace and (...)
€450,000
TSEA5156191
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 66 Lot Size: 84 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 66 Lot Size: 84 Area: Estepona Region: Andalucía
For Sale – €450,000
2-Bedroom Ground Floor Apartment in Aranya, Selwo – Estepona
This brand-new, fully furnished 2-bedroom, 2-bathroom apartment is located in the highly desirable Aranya (...)
€390,000
TSEA5156089
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 96 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 96 Area: Estepona Region: Andalucía
Charming Ground-Floor Apartment in Estepona's Vibrant Calvario District – Central Location and 10 Minutes from the Beach!
Nestled in the heart of Zona Calvario, Estepona, this delightful 96 m² (...)
€556,762
TSEA5156053
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
An exceptional apartment located in the Locrimar area of Marbella.
This ground floor apartment features 3 double bedrooms with built-in wardrobes, 2 bathrooms, a separate furnished kitchen, a (...)
€510,000
TSEA5155954
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
???? Attention investors
New listing in Puerto Banús, Marbella!
Spacious 114 m² apartment with terrace and private parking space, located in one of the most exclusive and peaceful complexes in the (...)
Current Featured Properties
€399,000
TSEA4693576
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 86 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Torremolinos Region: Andalucía
LOCATED IN ONE OF THE BEST AREAS OF TORREMOLINOS!!!
Bringing to life a new residential concept in Torremolinos. Designed to enjoy the Mediterranean and the endless light of the Costa del Sol. A (...)
€416,000
TSEA5042008
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 62 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 62 Area: San Pedro Region: Andalucía
In an exceptional location in San Pedro Alcántara, just a short walk from the beach and with views of the sea and the impressive La Concha peak. Discover a new way of living in San Pedro Alcántara (...)
€365,000
TSEA4545550
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 78 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Marbella West Region: Andalucía
CLOSE TO FABULOUS PUERTO BANUS AND THE BEACHES.
Offering homes from 90m2 to 150m2 with finishes of first QUALITY AND MODERN design. All have a large private terrace, garage space in the building (...)
