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,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 (31,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 (31,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 101 - 120 of 4003
€850,000
TSEA5155237
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Stunning 2-Bedroom Apartment with Sea Views in Estepona.
This exquisite 2-bedroom, 2-bathroom property perfectly blends elegance, comfort, and location. With a bright, open-plan living and dining (...)
€795,500
TSEA5155171
- 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
Beautiful duplex for sale in Marbella, Marbella with 3 bedrooms, 3 bathrooms, 1 terrace, 1 garage, 0.00 m2 of living space, 0.00 m2 built, 2nd hand with high-quality finishes, Optional furnished, (...)
€215,000
TSEA5155156
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Investment Opportunity – Las Lagunas de Mijas
Discover this excellent property located in the heart of Las Lagunas de Mijas, within a well-connected residential area and just steps away from all (...)
€284,500
TSEA5155150
- Málaga Este, Costa Del Sol, Nerja and Malaga East
Beds: 3 Baths: 1 M2: 73 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 1 M2: 73 Area: Nerja and Malaga East Region: Andalucía
8th Floor Apartment, Málaga East el Palo, Costa del Sol.
2.5 Bedrooms, 1 Bathroom, Built 73 m².
With turistic licence
Setting : Town, Close To Sea.
Condition : Excellent, Recently (...)
€340,000
TSEA5155144
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 72 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Area: Torremolinos Region: Andalucía
Beautifully Presented Elevated Duplex in Gated Urbanisation – Torremolinos
This elevated ground floor duplex, set within a desirable community combines comfort, style, and an unbeatable (...)
€2,600,000
TSEA5155126
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 201 Lot Size: 30 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 201 Lot Size: 30 Area: Marbella West Region: Andalucía
Welcome to this newly renovated duplex ground floor apartment in the heart of Nueva Andalucia, Marbella.
This property is very unique because of its spacious rooms , terraces , private garden and (...)
€546,500
TSEA5155111
- Málaga Centro, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 74 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 74 Area: Malaga Region: Andalucía
Middle Floor Apartment, Málaga Historic Centre Uncibay area, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 74 m².
Video
Setting : Town.
Condition : Excellent, Recently Renovated.
Features : Lift, (...)
€276,000
TSEA5155093
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 75 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 75 Area: Fuengirola Region: Andalucía
Modern Fully Renovated Apartment with Parking – Fuengirola
This stylish apartment, recently reformed to a high standard, is perfectly located in Fuengirola with excellent transport connections and (...)
€265,000
TSEA5155075
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
Apartment with two bedrooms, one bathroom, a fully equipped kitchen, a large living area with access to a terrace facing west, for sale in Riviera del Sol, Mijas Costa. This apartment is located in (...)
€249,900
TSEA5155027
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 55 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: Manilva Region: Andalucía
Lovely beachfront 1-bedroom apartment with sea views in La Noria, in Sabinillas.
We are welcomed by the large and bright living room that leads to a private covered terrace with beautiful sea and (...)
€590,000
TSEA5154937
- 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
Duplex in Nueva Andalucía, Costa del Sol
A unique opportunity in one of Marbella's most prestigious areas. This charming duplex with 3 bedrooms and 2 bathrooms is ideally located within walking (...)
€449,000
TSEA5154919
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 1 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
BEACHFRONT OPPORTUNITY and a Perfect rental investment.
This large 1-bedroom apartment can easily accommodate a family of 4 to 5.
There is an open room on the entrance that can be made into a small (...)
€559,000
TSEA5154883
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 138 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 138 Area: Marbella Region: Andalucía
Spacious Duplex ground floor with Renovation Potential in Xarblanca, Marbella
This charming Duplex ground floor, located in the popular residential area of Xarblanca in Marbella, offers an excellent (...)
€295,000
TSEA5154874
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Modern flat for sale in the centre of Fuengirola, just 150 metres from the beach and surrounded by all services, shops and transport links. Located in a contemporary building built in 2023, this (...)
€480,000
TSEA5154850
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Spacious corner ground floor apartment of 3 bedrooms, 2 bathrooms, big lounge and dining area with exit to a West facing terrace of 68 m2, fully fitted kitchen. Has cold and hot A/C, metallic (...)
€339,000
TSEA5154808
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 101 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Marbella Region: Andalucía
We are pleased to present a nicely maintained 3-bedroom, 2-bathroom apartment located in the prestigious La Reserva de Marbella. This property perfectly blends comfort, style, and Mediterranean (...)
€385,000
TSEA5154760
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Apartment in the centre of Marbella, on the second line of the beach. Privileged location, just a few metres from the Marina and the Real Club Marítimo de Marbella.
Ideal option for investors, with (...)
€1,360,000
TSEA5154649
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Beachfront apartment in a modern luxury residential complex in Estepona. Located 5 minutes drive from Estepona city center.
Avant-garde design complex of almost 10,000 m2, with large garden areas, 2 (...)
€315,000
TSEA5153794
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 132 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 132 Area: Mijas and Mijas Costa Region: Andalucía
Spacious Fully Renovated 3-Bedroom Apartment – Mijas Costa / Fuengirola Border
This bright apartment has been fully reformed and offers generous living space in a convenient location just 100 (...)
€740,000
TSEA5153692
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 212 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 212 Area: Marbella Region: Andalucía
New Development: Prices from 740,000 € to 1,020,000 €. [Beds: 2 - 3] [Baths: 2 - 3] [Built size: 212.00 m2 - 271.00 m2]
This development is an exclusive residential complex comprised of 88 (...)
Current Featured Properties
€626,500
TSEA4557622
- Aloha, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 114 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 114 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 (...)
€730,000
TSEA4819765
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 108 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Benahavis Region: Andalucía
The new residential is part of the renowned private urbanization "La Hacienda del Señorío de Cifuentes" with which they will share the enjoyment of its current four swimming pools with (...)
€630,000
TSEA4922707
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 102 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: San Pedro Region: Andalucía
Located at the heart of the most coveted luxury destination in the world, experience the year-round allure of Europe's finest climate, boasting an average temperature of 20°C and over 300 sun-kissed (...)
