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 (39,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 (39,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 (39,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 41 - 60 of 1080
€330,000
TSEA5152096
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 61 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 61 Area: Casares Region: Andalucía
Discover this modern Mediterranean 2 bedroom apartment in brand-new gated community in Casares. Ideally located just minutes from the prestigious Finca Cortesín Hotel & Golf Resort and a short (...)
€185,000
TSEA5151949
- La Campana, Costa Del Sol, Marbella West
Beds: 2 Baths: 1 M2: 47 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 1 M2: 47 Area: Marbella West Region: Andalucía
Ground Floor Apartment, La Campana, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 47 m².
Setting : Town, Suburban, Commercial Area, Village, Close To Shops, Close To Town, Close To (...)
€300,000
TSEA5151841
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Modern Renovated Apartment in Nueva Atalaya, Estepona – 2 Bedrooms, 2 Bathrooms, Private Terrace & Communal Pool
Located in the sought-after area of Nueva Atalaya, Estepona, this beautifully (...)
€250,000
TSEA5151781
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 96 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 96 Area: Estepona Region: Andalucía
Ground Floor Apartment, Estepona, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 96 m², Terrace 15 m².
Setting : Beachfront, Town, Commercial Area, Beachside, Port, Village, Close To Port, Close To (...)
€595,000
TSEA5151748
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 130 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 130 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Living in Finca San Antonio – A Rare Gem Near Mijas Pueblo
Step into elegance with this exceptional 2-bedroom, 2-bathroom apartment nestled in the prestigious Finca San Antonio community, (...)
€880,000
TSEA5151628
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 199 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 199 Area: Benahavis Region: Andalucía
Luxurious Ground-Floor Apartment in Capanes del Golf – Resort Living within El Higueral Golf course close to Marbella, Benahavis & Estepona
Discover this very spacious apartment in Capanes del (...)
€325,000
TSEA5151052
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 60 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Estepona Region: Andalucía
New Development: Prices from 325,000 € to 995,000 €. [Beds: 1 - 3] [Baths: 1 - 2] [Built size: 60.00 m2 - 147.00 m2]
This is an exclusive residential complex in the Las Mesas area, combining (...)
€495,000
TSEA5150911
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
This beautiful, fully exterior apartment stands out for its excellent location and natural brightness throughout. Located in a peaceful residential area of Marbella, it is just 400 meters from the (...)
€229,000
TSEA5150893
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 49 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Fuengirola Region: Andalucía
Breathe and enjoy life at your own rhythm. This brand new apartment development offers the space to be yourself, to focus on what matters, and to reconnect with a lifestyle that feels effort-less. (...)
€525,000
TSEA5150773
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Modern and spacious 3-bedroom apartment in exclusive Belaire, Estepona!
Welcome to thiS 3-bedroom apartment located in the sought-after Belaire community in Bel-Air, Estepona. With its modern (...)
€400,000
TSEA5150557
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 91 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Benahavis Region: Andalucía
This charming ground floor apartment is located in Benahavís, one of the most exclusive areas on the Costa del Sol, renowned for its peaceful surroundings, stunning landscapes, and proximity to (...)
€423,000
TSEA5150527
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 99 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 99 Area: Casares Region: Andalucía
New Development: Prices from 423,000 € to 721,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 99.00 m2 - 116.00 m2]
Set in an exceptional location between the highly sought-after towns of (...)
€551,460
TSEA5150488
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
OPPORTUNITY: Beachfront ground-floor apartment measuring 75 m² + 55 m² of private garden, with 2 large bedrooms, 2 bathrooms, a kitchen with a breakfast bar, and a spacious living-dining room with (...)
€500,000
TSEA5150452
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
New Development: Prices from 500,000 € to 969,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 94.00 m2 - 133.00 m2]
An exclusive residential complex: 36 apartments with 2 and 3 bedrooms, and 15 (...)
€222,900
TSEA5150437
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
**64 m² Studio Apartment for Sale – Riviera del Sol, Costa del Sol (Spain)**
This attractive ground floor studio is located in a gated and secure community, just 400 meters from the beach, (...)
€390,000
TSEA5150083
- Miraflores, 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
Exceptional 3-Bedroom Ground Floor Apartment with Expansive Terraces Surrounded by Tropical Gardens
This truly unique and one-of-a-kind property offers an extraordinary living experience. Originally (...)
€359,000
TSEA5149888
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
This is a very attractive modern apartment located in an elevated spot above the beaches of Elviria and East Marbella. Located in the high end enclave of La Maiirena an area occupied by luxury (...)
€779,900
TSEA5148277
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 143 Lot Size: 55 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 143 Lot Size: 55 Area: San Pedro Region: Andalucía
Luxury Beachside Golf Retreat in Guadalmina Baja
Just 5 minutes from Puerto Banús, discover the epitome of Mediterranean elegance in this spacious 5-bedroom, 4-bathroom retreat, perfectly (...)
€445,000
TSEA5148001
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 92 Lot Size: 30 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Lot Size: 30 Area: Estepona Region: Andalucía
Bright and Modern Ground-Floor Apartment in El Paraíso – New Golden Mile
This beautifully renovated ground-floor apartment is located in the sought-after El Paraíso district, on the New Golden (...)
€250,000
TSEA5147944
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
Well-Presented 1-Bedroom Apartment in Los Boliches, Fuengirola
This charming ground-floor apartment offers a fantastic opportunity to enjoy the vibrant lifestyle of Los Boliches, with all amenities (...)
Current Featured Properties
€570,000
TSEA4581883
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
New development. Two- and three-bedrooms apartments with all kinds of leisure services that will change your life.
Modern units with large spaces, big windows, and wide terraces. Southwest (...)
€476,700
TSEA4289707
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 118 Lot Size: 20 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Lot Size: 20 Area: Benahavis Region: Andalucía
A HOME YOU WILL NEVER WANT TO LEAVE!!!
The homes in this development are designed to offer you everything you need. On the ground floor you will have a garden and wine cellar, and on the top floor (...)
€398,000
TSEA5118049
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 105 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: Manilva Region: Andalucía
This new development of two and three-bedroom apartments in a magnificent urbanisation in an extraordinary location. The project combines modern design architecture with perfectly studied landscaping (...)
