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 (41,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 (41,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 (41,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 3420
€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 (...)
€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 (...)
€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 (...)
€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 (...)
€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 (...)
€749,000
TSEA5158900
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 5 Baths: 3 M2: 315 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 3 M2: 315 Area: Benalmadena Region: Andalucía
Beautiful Semi-Detached Villa in Excellent Condition – 325 m² Built
This stunning villa offers space, comfort, and an unbeatable location:
• Ground floor: large, well-kept garden with fruit (...)
€530,000
TSEA5158819
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 104 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Marbella Region: Andalucía
Situated in the heart of Marbella Centro, this unique first floor apartment offers a rare opportunity with its south orientation and an large private terrace that spans the entire building and (...)
€375,000
TSEA5158255
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 1 M2: 120 Lot Size: 3,958 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 1 M2: 120 Lot Size: 3,958 Area: Alhaurin el Grande Region: Andalucía
Detached Villa with Pool and Large Plot – Fully Renovated
Discover this charming detached property, perfect for those seeking peace, privacy, and comfort. The house has been completely renovated, (...)
€719,000
TSEA5158141
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 228 Lot Size: 259 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 228 Lot Size: 259 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic semi-detached villa with private pool and two separate homes for sale on a single plot in the exclusive Capellanía residential area, Alhaurín de la Torre.
This spectacular semi-detached (...)
€399,000
TSEA5158069
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
Modern & Spacious 2-Bedroom Bungalow in Atalaya Aparta Golf Complex
Set within the prestigious Atalaya Golf Course, this modern and beautifully designed 2-bedroom bungalow combines comfort, (...)
€750,000
TSEA5158048
- Sotogrande Marina, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 137 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Sotogrande Region: Andalucía
???? Duplex Apartment with Solarium and Marina Views in Sotogrande
Located in one of the most exclusive areas of the Costa del Sol, this stunning apartment in the Sotogrande Marina offers generous (...)
€3,550,000
TSEA5157937
- Aloha, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 435 Lot Size: 1,038 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 435 Lot Size: 1,038 Area: Marbella West Region: Andalucía
Welcome to this exceptional modern villa located in the heart of Nueva Andalucía, offering a seamless blend of style, luxury and comfort.
Set on a generous plot of 1,038m², this beautifully (...)
€3,150,000
TSEA5157496
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 410 Lot Size: 728 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 410 Lot Size: 728 Area: Marbella West Region: Andalucía
Nestled in a quiet residential area of Nueva Andalucía and yet close to all local amenities we find this house for sale. The property has gone through an extensive refurbishment and updating (...)
€160,000
TSEA5157484
- El Padron, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 49 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Estepona Region: Andalucía
Spectacular panoramic views of the sea and mountains
Brand new, fully renovated duplex penthouse with a separate bedroom on the upper level, a full bathroom with a large shower and window.
Ground (...)
€620,000
TSEA5157445
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 106 Region: Andalucía
Beds: 2 Baths: 2 M2: 106 Region: Andalucía
Penthouse Living at Its Best
Step into a world of style and comfort with this stunning penthouse apartment. Featuring two elegant bathrooms – one with a sleek shower and the other with a luxurious (...)
Current Featured Properties
€1,380,000
TSEA4670587
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 149 Lot Size: 1,016 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 149 Lot Size: 1,016 Area: Mijas and Mijas Costa Region: Andalucía
Itś a energy-saving house in one level that combines an energy-efficient construction with materials of the highest quality and smart use of the surfaces. This smart, cost-effective villa with solar (...)
€678,000
TSEA4941382
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 187 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 187 Area: Estepona Region: Andalucía
PHASE II OUT NOW! ACT FAST.
An exclusive community comprising 84 luxury properties with generous indoor spaces, roomy terraces, spectacular views, community areas, swimming pool and club zone. A (...)
€725,000
EMPTY
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 139 Lot Size: 748 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 139 Lot Size: 748 Area: Estepona Region: Andalucía
NEW GOLDEN MILE, ESTEPONA
Villa/finca in urb. El Velerin next to Hospiten Hospital just accross the road of Emare. In need to reform.
South facing, walking distance to the beach and the paseo of (...)
