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 1 - 20 of 6631
€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 (...)
€739,000
TSEA5159641
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 470 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 470 Area: Mijas and Mijas Costa Region: Andalucía
This exceptional triplex penthouse with 470 m² of floor space and 270 m² of usable space plus terraces, garages and storage rooms redefines the concept of living on the Costa del Sol. Located in a (...)
€419,000
TSEA5159587
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Semi-detached house with no community fees in Las Lagunas (Mijas Costa)
Cozy and bright semi-detached home located in one of the most sought-after areas of Las Lagunas, close to all amenities and (...)
€220,000
TSEA5159560
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 46 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 46 Area: Marbella Region: Andalucía
We offers a SUPERB STUDIO IN MARBELLA.
Located 5 minutes from the beach and the hospital, just 1 minute from the Old Town.
Property located in the heart of Puerto Banús, Marbella, in one of the (...)
€869,000
TSEA5159548
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 150 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 150 Area: Estepona Region: Andalucía
Modern Corner Apartment in the Heart of Estepona!
Located right in the vibrant center of Estepona, just steps away from everything this charming coastal town has to offer and within easy reach of (...)
€459,000
TSEA5159533
- 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
Spectacular Seafront Apartment in the Best Area of Fuengirola
Located on the ninth floor, this magnificent apartment boasts unbeatable panoramic views of the sea, the mountains, and the iconic (...)
€525,000
TSEA5159521
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 56 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 56 Area: Mijas and Mijas Costa Region: Andalucía
SECOND LINE BEACH. This is a lovely 2 bedroom penthouse apartment with fantastic pool, garden and sea views from the enclosed terrace and solarium. Situated in a great location very close to the (...)
€735,000
TSEA5159485
- Istán, Costa Del Sol, Istan
Beds: 2 Baths: 2 M2: 203 Area: Istan Region: Andalucía
Beds: 2 Baths: 2 M2: 203 Area: Istan Region: Andalucía
Lake and Sea View Villa for Sale in Sierra Blanca Country Club, Istan – Investment Opportunity Near Marbella
Set within the prestigious gated community of Sierra Blanca Country Club in Istan, this (...)
€1,290,000
TSEA5159458
- La Capellania, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 130 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Fuengirola Region: Andalucía
Penthouse, La Capellania, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 100 m².
Setting : Close To Sea, Urbanisation.
Orientation : South, South West.
Condition : Excellent.
Pool : (...)
€7,800,000
TSEA5159374
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 5 Baths: 8 M2: 734 Lot Size: 1,000 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 8 M2: 734 Lot Size: 1,000 Area: Marbella East Region: Andalucía
This fully renovated Andalusian-style villa is set in Rocío de Nagüeles, one of the most prestigious enclaves of Marbella's Golden Mile. Positioned on a 1,965m² south-facing plot beneath the (...)
€279,000
TSEA5159371
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 98 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 98 Area: Fuengirola Region: Andalucía
Bright corner apartment next to Plaza Hispanidad and the market square in Fuengirola. In the area there are several grocery stores, cafes, bakery, pharmacy, etc.
The apartment has a proper entrance (...)
€359,000
TSEA5159335
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Two bedroom apartment in the popular Calazul complex central to amenities and public transport. The apartment has a sunny terrace and park views. There are two bathrooms one is ensuite with a bath (...)
€395,000
TSEA5159308
- Cártama, Costa Del Sol, Cartama
Beds: 2 Baths: 2 M2: 155 Lot Size: 2,500 Area: Cartama Region: Andalucía
Beds: 2 Baths: 2 M2: 155 Lot Size: 2,500 Area: Cartama Region: Andalucía
Charming 2/3 Bedroom Country Finca, Orchard, Stunning Gardens, A1 Condition
A wonderful opportunity to purchase a deceptively spacious, detached country finca with stunning panoramic views, located (...)
€1,100,000
TSEA5159263
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 137 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 137 Area: Estepona Region: Andalucía
EXCEPTIONAL BEACHFRONT PENTHOUSE WITH PANORAMIC VIEWS OF THE SEA, MOUNTAINS, AND THE AFRICAN COASTLINE, FEATURING TWO SPACIOUS TERRACES TOTALING 100m². This exclusive property is located in the (...)
€375,000
TSEA5159209
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 2 M2: 115 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 2 M2: 115 Area: Benalmadena Region: Andalucía
In the heart of Arroyo de la Miel, just a few steps from the commuter train station and only 1.5 km from the beach, lies this magnificent 115 m² apartment an ideal home for families looking for (...)
€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 (...)
€510,000
TSEA5159173
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic opportunity to buy a Duplex penthouse in front line golf with open panoramic views
Ample 3 bedrooms and 3 bathrooms, with highest quality finishes and outstanding views to the three golf (...)
€1,250,000
TSEA5159074
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Stunning, south-facing fully renovated, three bedroom beachfront apartment in the heart of Estepona's charming Old Town offering spectacular panoramic sea views. With a large usable space, the home (...)
€1,700,000
TSEA5159005
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
Apartment for sale in Los Granados del Mar, Estepona with 3 bedrooms, 3 bathrooms, 2 en suite bathrooms and with orientation south/east, with communal swimming pool, communal garage (1 parking (...)
€640,000
TSEA5158999
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 2 M2: 177 Lot Size: 222 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 2 M2: 177 Lot Size: 222 Area: San Pedro Region: Andalucía
We invite you to visit this two-level, south-west facing property in the heart of San Pedro, conveniently located close to a wide range of services and infrastructure, nestled in a tranquil (...)
Current Featured Properties
€1,995,000
TSEA5143639
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Bahía del Velerín is a prestigious community located between Marbella and Estepona. It boasts a beautiful pool area with a snack bar, lush tropical gardens, and 24/7 security. Set in a prime (...)
€1,250,000
TSEA5115490
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
NEW DEVELOPMENT – Elegance and Exclusivity on the Costa del Sol!
Discover this new luxury project, a prestigious complex of 14 independent villas located in an exceptional setting in Estepona, (...)
€2,350,000
TSEA5080762
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Menara Beach is a luxury beachfront community on the New Golden Mile, located between Marbella and Estepona. Designed by Melvin Villaroel, it features tropical gardens, two outdoor pools, a heated (...)
