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 (31,42,43,44,45)
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 (31,42,43,44,45)
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 (31,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 201 - 220 of 6631
€499,000
TSEA5152912
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 125 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Marbella West Region: Andalucía
Magnificent 3-bedroom apartment for sale located in the Los Naranjos development, just 5 minutes from Puerto Banús, in a privileged area with golf courses surrounding the complex, and practically (...)
€230,000
TSEA5152852
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 65 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Benalmadena Region: Andalucía
Charming One-Bedroom Apartment in Torrequebrada in a Peaceful Area
Spacious living room with plenty of room for a dining table as well. A compact kitchen that still includes everything you need for (...)
€597,000
TSEA5152840
- Higueron, Costa Del Sol
Beds: 3 Baths: 2 M2: 152 Lot Size: 62 Region: Andalucía
Beds: 3 Baths: 2 M2: 152 Lot Size: 62 Region: Andalucía
For Sale: Ground Floor 3-Bedroom Apartment with Garden & Terrace in Las Lomas del Higuerón
Discover a beautifully designed ground floor apartment located in the prestigious Las Lomas del (...)
€670,000
TSEA5152753
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 2 Baths: 2 M2: 104 Area: Algeciras Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Algeciras Region: Andalucía
Links 2 Golf & Beach Heaven!
So you want modern, you want sea views, you want walk to the beach, and you want easy golf access.
You want it all dont you?! ????
Well you can have it all, here at (...)
€266,000
TSEA5152729
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 65 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 65 Area: Mijas and Mijas Costa Region: Andalucía
Charming Two-Bedroom Apartment with Excellent Location
This bright and comfortable two-bedroom apartment is situated on the first floor of a well-maintained building. It features a spacious living (...)
€575,000
TSEA5152720
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
Brand New Fully Furnished 2-Bedroom Apartment in Puerto de Estepona – Just One Minute from the Beach!
Step into modern coastal luxury with this stunning, brand-new apartment in a 2025-designed (...)
€138,500
TSEA5152705
- Antequera, Costa Del Sol, Antequera
Beds: 1 Baths: 1 M2: 51 Area: Antequera Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Antequera Region: Andalucía
Modern 1-Bedroom Apartment in the Historic Heart of Antequera
Located right in the centre of Antequera, this modern apartment offers the perfect combination of style, comfort, and (...)
€635,000
TSEA5152696
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 117 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 117 Area: Fuengirola Region: Andalucía
Location, Location! Bright Renovated Apartment Just Steps from Fuengirola's Stunning Seafront**
Welcome to this beautifully renovated home in the heart of Los Boliches – a place where everything (...)
€385,000
TSEA5152693
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Modern 2-bedroom apartment with golf & mountain Views
Beautiful new build 2-bedroom, 2-bathroom apartment in the prestigious Calanova Golf area. Enjoy stunning panoramic views of the golf course (...)
€790,000
TSEA5152687
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
LARGE PROPERTY IN MARBELLA CENTER, 300 METERS FROM THE PROMENADE AND THE BEACH
Fantastic property with a prime location in the center of Marbella, surrounded by all kinds of amenities and just 300 (...)
€680,000
TSEA5152669
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
FANTASTIC APARTMENT WITHIN WALKING DISTANCE OF LA CALA DE MIJAS!
This beautiful apartment in Jardinana Lotus is the ideal (holiday) apartment!
The apartment features 3 bedrooms, 2 bathrooms, a (...)
€415,000
TSEA5152627
- Estepona, 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
Beautiful 90 m2 apartment with 2 bedrooms and 2 bathrooms, a terrace with garden views, and direct access to the beach in an exclusive Estepona development.
This ground-floor apartment with two (...)
€378,000
TSEA5152303
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 85 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 85 Area: Marbella Region: Andalucía
Newly refurbished 2-bedroom apartment in the heart of Marbella Centre.
This property features one en-suite bedroom and a smaller second bedroom, ideally located close to all amenities and just a (...)
€429,000
TSEA5152285
- Hacienda del Sol, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 152 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 152 Area: Estepona Region: Andalucía
Two bedroom ground floor apartment in the luxurious urbanisation Hacienda del Sol.
Layout:
- living room, dining room
- kitchen
- 2 bedrooms, 1 with bathroom en suite
- 2 bathrooms
On the (...)
€615,000
TSEA5152282
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 178 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 178 Area: Marbella West Region: Andalucía
Discover this charming 2-bedroom, 2-bathroom corner apartment, perfectly located within walking distance to both the beach and a selection of the area's most popular restaurants. Surrounded by (...)
€499,000
TSEA5152210
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 76 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 76 Area: Marbella Region: Andalucía
Here's a charming apartment located in the Golden Beach Urbanization, just 50 meters from the beach. This community features fantastic shared areas, including two large swimming pools surrounded by a (...)
€741,300
TSEA5152207
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
This is an opportunity not to be missed: a spectacular, fully furnished property located in a secure gated community with all kinds of services and infrastructure nearby. The property is just a few (...)
€1,390,000
TSEA5152159
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 346 Lot Size: 534 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 346 Lot Size: 534 Area: Marbella West Region: Andalucía
Modern beautiful newly renovated 3 floor villa located in the heart of Nueva Andalucia very close to famous padelclub Real Club Padel.
The villa has a private pool beautiful garden and parking. (...)
€450,000
TSEA5152114
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 130 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Casares Region: Andalucía
Exquisite Penthouse in Majestic, Casares del Sol – Casares Golf: Panoramic Sea and Mountain Views, Just 5 Minutes Walk to the Beach!
Elevate your lifestyle with this stunning penthouse in the (...)
€372,000
TSEA5152111
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 77 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 77 Area: Benalmadena Region: Andalucía
APARTMENT CLOSE TO PALOMA PARK, BENALMADENA: Nice 2 bedrooms, 1 bathroom apartment ideally located just a short stroll from the lush green haven of Parque de la Paloma and the vibrant heart of Arroyo (...)
Current Featured Properties
€1,500,000
TSEA4689550
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 341 Lot Size: 31 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 341 Lot Size: 31 Area: Marbella West Region: Andalucía
The projects itself as an exclusive residential complex of 15 spacious semi-detached homes, with boutique- style amenities - a fully equipped gym, spa and outdoor swimming pool - enjoying spectacular (...)
€4,500,000
TSEA4218301
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 300 Lot Size: 92 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 300 Lot Size: 92 Area: Marbella West Region: Andalucía
The "central courtyard" of each "Vila", is undoubtedly the main axis, everything happens around this unique space, open to both, the inside and the outside. Everything in the (...)
€680,000
TSEA4955554
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
This development is part of a perfectly established community with fully operational common areas. This project has a total of 82 houses to be developed in 2 phases. Phase I corresponds to blocks 1 (...)
