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 161 - 180 of 4003
€741,300
TSEA5152207
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
This is an opportunity not to be missed: a spectacular, fully furnished property located in a secure gated community with all kinds of services and infrastructure nearby. The property is just a few (...)
€450,000
TSEA5152114
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 130 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Casares Region: Andalucía
Exquisite Penthouse in Majestic, Casares del Sol – Casares Golf: Panoramic Sea and Mountain Views, Just 5 Minutes Walk to the Beach!
Elevate your lifestyle with this stunning penthouse in the (...)
€372,000
TSEA5152111
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 77 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 77 Area: Benalmadena Region: Andalucía
APARTMENT CLOSE TO PALOMA PARK, BENALMADENA: Nice 2 bedrooms, 1 bathroom apartment ideally located just a short stroll from the lush green haven of Parque de la Paloma and the vibrant heart of Arroyo (...)
€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 (...)
€350,000
TSEA5152084
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 110 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Listings: Two Duplexes in Riviera, Costa del Sol
We are offering two attractive duplexes for sale in Riviera, each with:
- 2 bedrooms
- 2 bathrooms
- Spacious terraces with exceptional (...)
€330,000
TSEA5152069
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Listings: Two Duplexes in Riviera, Costa del Sol
We are offering two attractive duplexes for sale in Riviera, each with:
- 2 bedrooms
- 2 bathrooms
- Spacious terraces with exceptional (...)
€570,000
TSEA5152066
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 150 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Area: Estepona Region: Andalucía
In the heart of Estepona's New Golden Mile, where the Costa del Sol shows off its most sophisticated side, lies a unique opportunity for those looking to live or invest on the seafront. The Mar Azul (...)
€595,000
TSEA5152033
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 85 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Mijas and Mijas Costa Region: Andalucía
Stunning 2-Bedroom Beachfront Apartment in Sitio de Calahonda.
Discover coastal living at its finest with this beautiful 2-bedroom, 2-bathroom modern apartment located in an the sought-after (...)
€650,000
TSEA5152009
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Discover the perfect blend of convenience and coastal living with this fantastic apartment, located just 400 meters from the beach. This property is ideally suited for anyone seeking either a (...)
€420,000
TSEA5151979
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Elegant Apartment with Sea Views in Lower Carvajal
Property with rental license.
Welcome to this stylish two-bedroom, two-bathroom apartment nestled in the peaceful and sought-after area of Lower (...)
€525,000
TSEA5151970
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 135 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: Benahavis Region: Andalucía
Stunning Two-Bedroom Penthouse Apartment in Gazules del Sol
This bright and elegant two-bedroom penthouse is located in the sought-after urbanisation Gazules del Sol.
Upon entering, you are (...)
€355,000
TSEA5151955
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 71 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. (...)
€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 (...)
€550,000
TSEA5151799
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
Beautiful and spacious 2 bedroom apartment located in the five star urbanisation of Capanes Del Golf, Benahavis. This apartment enjoys wonderful golf, lake and mountain views. The kitchen has been (...)
€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 (...)
€380,000
TSEA5151766
- Valle Romano, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
An ideal setting...
2 bedroom, 2 bathroom open plan apartment on the fist floor of recently completed new development.
Habitat Valle Romano is perched on a gentle hilltop overlooking the bay of (...)
€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, (...)
€530,000
TSEA5151739
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 88 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 88 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. (...)
€850,000
TSEA5151736
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
The One Residence urbanisation is an exclusive, luxury complex next to the Calanova Golf Course. This fabulous apartment is one of the best within the urbanisation providing commanding PANORAMIC SEA (...)
Current Featured Properties
€400,000
TSEA4805725
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 56 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 56 Area: Estepona Region: Andalucía
This new development in the Estepona Centre comprising 43 one, two and three bedroom apartments and penthouses, terraces and magnificent communal areas. It boasts excellent finishes, a prime location (...)
€815,000
TSEA4856848
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 135 Lot Size: 72 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 135 Lot Size: 72 Area: Estepona Region: Andalucía
An imposing residential project in Estepona's New Golden Mile. Offering 72 superb 2, 3 and 4-bedroom apartments, each home boasts breathtaking sea and mountain views. Residents will indulge in a (...)
€1,660,000
TSEA4648282
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 114 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 114 Area: Fuengirola Region: Andalucía
This new development is an ambitious project consisting of 164 homes surrounded by the natural landscape of El Higueron. The properties are made up of 70 deluxe apartments, 49 garden villas, 25 sky (...)
