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 (40,36,37,38)
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 (40,36,37,38)
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 (40,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 21 - 40 of 1780
€219,950
TSEA5158051
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 94 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Nerja and Malaga East Region: Andalucía
New Development: Prices from 219,950 € to 399,950 €. [Beds: 2 - 4] [Baths: 2 - 2] [Built size: 94.00 m2 - 225.00 m2]
A place designed for enjoyment, relaxation, and living with all the (...)
€955,000
TSEA5157919
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 161 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 161 Area: Estepona Region: Andalucía
Luxury Seafront Residence in the Exclusive Bahía de la Plata Complex, Estepona
Exclusive seafront residence located in the prestigious Bahía de la Plata complex in Estepona. The complex enjoys an (...)
€450,000
TSEA5157598
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 110 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: San Pedro Region: Andalucía
This 3 bedroom apartment is located on the boulevard of San Pedro, surrounded by shops and restaurants. The apartment consists of 3 bedrooms, 2 bathrooms, kitchen, living-dining room and terrace with (...)
€295,000
TSEA5157586
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 44 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 44 Area: Marbella West Region: Andalucía
First floor south and east-facing apartment surrounded by golf and amenities, Torres de Aloha, Nueva Andalucía. Comprising living/dining room, small kitchen and east-facing terrace, and a bedroom (...)
€795,000
TSEA5157580
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 114 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 114 Area: Marbella Region: Andalucía
Situated in one of the most picturesque parts of Marbella, this newly refurbished three-bedroom, three-bathroom apartment has been finished to the very highest standards. Modern yet understatedly (...)
€355,000
TSEA5157487
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 52 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: Mijas and Mijas Costa Region: Andalucía
LOCATION SITIO DE CALAHONDA ! FRONTLINE FIRSTLINE BEACH APARTMENT WITH PANORAMIC SEAVIEWS
Discover this beautifully newly renovated middle-floor apartment in a highly sought-after frontline beach (...)
€308,500
TSEA5157409
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola centre, Costa del Sol.
2.5 Bedrooms, 1 Bathroom, Built 61 m².
Setting : Town, Close To Sea.
Condition : Good.
Climate Control : Air Conditioning.
Features : (...)
€385,000
TSEA5157172
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Investment Opportunity – New on the Market!
Front line beach apartment in Calahonda with spectacular sea views.
Features:
• 3 bedrooms
• 2 bathrooms
• Complex with swimming pool
• (...)
€249,999
TSEA5157166
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
This beautifully presented 2 bedroom middle floor property has a bright open lounge and generous separate fully fitted kitchen. The large main bedroom and double guest bedroom both have built-in (...)
€699,000
TSEA5156986
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 83 Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Region: Andalucía
Med One, Higuerón West – Luxury 2-Bedroom Apartment with Panoramic Sea Views
Located within the prestigious Med One complex in Higuerón West, this elegant two-bedroom, two-bathroom apartment (...)
€250,000
TSEA5156914
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 52 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: Marbella Region: Andalucía
OPPORTUNITY IN MARBELLA – UNBEATABLE PRICE
Fantastic property in Marbella, next to the bus station and a few minutes from the centre, surrounded by all kinds of services. The apartment, with great (...)
€340,000
TSEA5156371
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 73 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 73 Area: Benahavis Region: Andalucía
Apartment for sale in , Benahavis with 2 bedrooms and 2 bathrooms, with communal swimming pool and private garage (1 parking spaces). Regarding property dimensions, it has 73 m² built, 60 m² (...)
€595,000
TSEA5156320
- Hacienda del Sol, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 168 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 168 Area: Estepona Region: Andalucía
This is a remarkable opportunity to acquire a superb property situated on the second line of the beach in one of the finest urbanizations on the Costa del Sol.
It is positioned in the Atalaya Baja (...)
€499,500
TSEA5156305
- Río Real, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 122 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Marbella East Region: Andalucía
UNIQUE OPPORTUNITY: Golf-front apartment just 350 meters from the beach in Río Real
Our client recently acquired this fantastic apartment through a public auction, but now needs to resell quickly (...)
€595,000
TSEA5156251
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Stunning 2-bed Apartment.
Presenting a rare opportunity to own this new, modern, recently constructed 2-bed apartment in Phase 2 of Oasis325. Positioned with south orientation which gives you sun (...)
€269,000
TSEA5156131
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Los Boliches downtown. Less then 200m to the Beach.
Middle Floor Apartment, Los Boliches, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 71 m².
Setting : Town, Commercial Area, Beachside, Close To (...)
€2,685,000
TSEA5156050
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 136 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Marbella West Region: Andalucía
Beautiful apartment in the heart of one of the most famous ports on the Costa del Sol - Puerto Banus, with spacious terraces offering ponoramnic views to the sea, sandy beaches, port, coast of (...)
€560,000
TSEA5156041
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 111 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 111 Area: Benalmadena Region: Andalucía
Apartment with magnificent views of the sea and the communal swimming pool.
The property has 3 bedrooms with fitted wardrobes and 2 full bathrooms, one of which is en suite in the master bedroom, a (...)
€335,000
TSEA5156005
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 57 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 57 Area: Fuengirola Region: Andalucía
One-bedroom, one-bathroom apartment on the beachfront, near the boliches area, with sea views from the bedroom and living room. Terrace with sea views, air conditioning in the living room and (...)
€225,000
TSEA5155978
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Rarely available one bed apartment
Totally reformed and spacious one bedroom apartment in this ever poplar development a very short walk to the village.
200 METRES WALK TO THE BEACH
One full (...)
Current Featured Properties
€2,395,000
TSEA5143105
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
This southwest-facing, fully renovated 3-bedroom, 2-bathroom apartment offers an exceptional blend of style, comfort, and panoramic views over subtropical gardens and the Mediterranean Sea. The (...)
€464,500
TSEA4557562
- Aloha, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 84 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 84 Area: Marbella West Region: Andalucía
Private residential complex with an innovative design inspired by the architecture of the area. 70 spacious 2 and 3 bedroom flats with magnificent terraces and 24 hour security. Each flat offers an (...)
€444,000
TSEA4324165
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
LOCATED IN BEAUTIFUL ESTEPONA!!!
One of the most attractive corners of the Costa del Sol. The town has become one of the most sought-after spots on the Costa del Sol, thanks to its quality of life (...)
