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
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
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
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1161 - 1180 of 7575
€379,000
TSEA5127223
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 106 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 106 Area: Manilva Region: Andalucía
Modern Apartment with Sea Views and Private Terrace – La Paloma Manilva, Costa del Sol
This elegant apartment, measuring 105.9 m² (plus a 15.08 m² terrace), offers light, comfort, and a peaceful (...)
€598,000
TSEA5127199
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 121 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 121 Area: Benalmadena Region: Andalucía
This is a resale unit, which will be completed at the end of 2025.
Be among the first to own a luxurious 3-bedroom, 2-bathroom apartment in one of Benalmadena's most sought-after new developments. (...)
€595,000
TSEA5127184
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 210 Lot Size: 715 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 210 Lot Size: 715 Area: Mijas and Mijas Costa Region: Andalucía
� Unique Opportunity on the Costa del Sol! Villa with Panoramic Sea Views Just Steps from the Beach �
Looking to invest in a property with a privileged location, breathtaking sea views, and (...)
€1,260,000
TSEA5127163
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 276 Lot Size: 770 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 276 Lot Size: 770 Area: Marbella Region: Andalucía
Investment Opportunity – Distinctive Villa Within Walking Distance to the Beach | Marbella East
This is your chance to acquire a truly unique villa in the desirable area of Marbella East, just a (...)
€598,000
TSEA5127148
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 5 Baths: 6 M2: 250 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 6 M2: 250 Area: Benalmadena Region: Andalucía
For sale: A wonderful detached house located in a quiet area of Benalmádena Pueblo, with stunning sea views. It is divided into three completely independent units, one of which is currently rented, (...)
€5,900,000
TSEA5127067
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 7 M2: 1,904 Lot Size: 36,498 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 7 M2: 1,904 Lot Size: 36,498 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic opportunity to adquire a villa located within 3 plots in Cerro del Aguila.
Villa with Islamic architecture, this wonderful property will surprise you! On the first floor we can find a (...)
€4,000,000
TSEA5127016
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 621 Lot Size: 1,600 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 621 Lot Size: 1,600 Area: Marbella West Region: Andalucía
Detached Villa, Nueva Andalucía, Costa del Sol.
6 Bedrooms, 6 Bathrooms, Built 621 m², Garden/Plot 1600 m².
Setting : Town, Commercial Area, Village, Close To Golf, Close To Shops, Close To Sea, (...)
€399,000
TSEA5127004
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 140 Lot Size: 40 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 140 Lot Size: 40 Area: Benahavis Region: Andalucía
Frontline Golf Apartment for Sale in La Quinta – Ground Floor with Garden and Pool Access
A rare opportunity to own a beautiful and spacious 2-bedroom, 2-bathroom ground floor apartment in one of (...)
€375,000
TSEA5126998
- Málaga, Costa Del Sol, Malaga
Beds: 1 Baths: 1 M2: 56 Area: Malaga Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Malaga Region: Andalucía
This exclusive flat is located in one of Malaga's most prestigious high-end buildings, Torre Martiricos. Situated on the 17th floor and facing west, it offers stunning views of the city and is a home (...)
€2,466,000
TSEA5126986
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 6 Baths: 7 M2: 995 Lot Size: 2,552 Area: Sotogrande Region: Andalucía
Beds: 6 Baths: 7 M2: 995 Lot Size: 2,552 Area: Sotogrande Region: Andalucía
Modern Villa in La Reserva de Sotogrande
Located in La Reserva, one of the most exclusive areas of Sotogrande, this spectacular detached villa offers elegance, comfort, and contemporary style in a (...)
€595,000
TSEA5126983
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 149 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 149 Area: Marbella Region: Andalucía
This amazing penthouse is located a top Marbella location in Altos de Marbella, Los Monteros from its elevated position one enjoys amazing views of the mediterranean coastline including Marbella, (...)
€690,000
TSEA5126974
- La Mairena, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 197 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 197 Area: Marbella East Region: Andalucía
Corner townhouse with panoramic views in La Mairena, Marbella East
This spacious corner townhouse is located in a quiet residential area in La Mairena, nestled in the hills above Elviria. Surrounded (...)
€345,000
TSEA5126956
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 107 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Area: Mijas and Mijas Costa Region: Andalucía
A SUPERB, HIGH QUALITY 1ST FLOOR APARTMENT IN A MUCH DEMANDED URBANIZATION.
WONDERFUL MOUNTAIN, GOLF AND COUNTRY VIEWS.
Westerly orientation, secure underground parking.
AT A GLANCE
2 BEDROOMS
2 (...)
€850,000
TSEA5126953
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 180 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: San Pedro Region: Andalucía
We are pleased to offer this distinguished townhouse in the prestigious Costa del Sol, located just a 5-minute walk from the emblematic seafront promenade of San Pedro de Alcántara.
Strategically (...)
€419,500
TSEA5126938
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
Bright and spacious three-storey townhouse, located in the charming Sitio de Calahonda. Just a short walk from the vibrant shopping centres and delicious restaurants along Avenida de España, this (...)
€845,000
TSEA5126926
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 189 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 189 Area: Mijas and Mijas Costa Region: Andalucía
The penthouse is on the first floor. It is stylishly furnished and has a large terrace plus a solarium with a private plunge pool where you can relax in the sun. The terrace also has an outdoor (...)
€615,000
TSEA5126917
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
Luxury Garden Apartment in Bahía de Marbella – Renovated Elegance, Open Spaces, and Unbeatable Location.
Discover the quintessential coastal lifestyle with this spectacular garden apartment, (...)
€2,500,000
TSEA5126911
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 6 M2: 516 Lot Size: 1,316 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 6 M2: 516 Lot Size: 1,316 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular 7-Bedroom Designer Villa in La Finca de La Cala
Welcome to one of the most exquisite villas in La Finca de La Cala — a truly unique, fully furnished 7-bedroom residence that blends (...)
€450,000
TSEA5126908
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 2 M2: 95 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 2 M2: 95 Area: San Pedro Region: Andalucía
UNIQUE OPPORTUNITY IN BEST AREA OF SAN PEDRO DE ALCÁNTARA
This magnificent penthouse is located in the fastest-growing area of San Pedro de Alcántara. One of the most coveted locations in this (...)
€299,900
TSEA5126890
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
This charming duplex, located in a residential building in Calahonda, Mijas, offers a comfortable and functional layout — ideal for enjoying the Mediterranean lifestyle.
The upper floor features (...)
Current Featured Properties
€495,000
TSEA5155090
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Located in the sought-after frontline beach development of Bahía Azul in Estepona West, this 2-bedroom townhouse offers an excellent opportunity to renovate and personalise a home in a prime coastal (...)
€1,100,000
TSEA4433068
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M2: 188 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 4 M2: 188 Area: San Pedro Region: Andalucía
Impressive Duplex Penthouse in Nueva Alcantara only 100 meters from the beach of San Pedro
Spacious duplex penthouse in the urbanization of La Gavia in Nueva Alcántara very close to all kinds of (...)
€2,695,000
TSEA5143117
- 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
Located between Marbella and Estepona, Bahía del Velerín is a prestigious community with a beautiful pool area, a snack bar, lush tropical gardens, and 24/7 security.
This fully renovated penthouse (...)
