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 41 - 60 of 4003
€965,000
TSEA5157901
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Nestled in a prestigious beachfront urbanization in Estepona, walking distance to the port, this luxurious fully renovated apartment offers an unparalleled living experience on the Costa del Sol. (...)
€399,800
TSEA5157616
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 3 M2: 116 Lot Size: 100 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 3 M2: 116 Lot Size: 100 Area: La Duquesa Region: Andalucía
This exceptional ground floor apartment is situated in the sought-after Duquesa Suites complex in Manilva, Malaga. The property offers a blend of comfort, security, and convenience, making it an (...)
€450,000
TSEA5157598
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 110 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: San Pedro Region: Andalucía
This 3 bedroom apartment is located on the boulevard of San Pedro, surrounded by shops and restaurants. The apartment consists of 3 bedrooms, 2 bathrooms, kitchen, living-dining room and terrace with (...)
€295,000
TSEA5157586
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 44 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 44 Area: Marbella West Region: Andalucía
First floor south and east-facing apartment surrounded by golf and amenities, Torres de Aloha, Nueva Andalucía. Comprising living/dining room, small kitchen and east-facing terrace, and a bedroom (...)
€795,000
TSEA5157580
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 114 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 114 Area: Marbella Region: Andalucía
Situated in one of the most picturesque parts of Marbella, this newly refurbished three-bedroom, three-bathroom apartment has been finished to the very highest standards. Modern yet understatedly (...)
€355,000
TSEA5157487
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 52 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: Mijas and Mijas Costa Region: Andalucía
LOCATION SITIO DE CALAHONDA ! FRONTLINE FIRSTLINE BEACH APARTMENT WITH PANORAMIC SEAVIEWS
Discover this beautifully newly renovated middle-floor apartment in a highly sought-after frontline beach (...)
€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 (...)
€308,500
TSEA5157409
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola centre, Costa del Sol.
2.5 Bedrooms, 1 Bathroom, Built 61 m².
Setting : Town, Close To Sea.
Condition : Good.
Climate Control : Air Conditioning.
Features : (...)
€1,095,000
TSEA5157376
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 125 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Fuengirola Region: Andalucía
Exclusive newly built penthouse with 3 bedrooms and a spacious south-facing terrace offering spectacular sea and mountain views.
The home comes fully furnished with high-end designer pieces created (...)
€1,090,000
TSEA5157190
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
This exclusive, brand-new penthouse with three bedrooms and a large south-facing terrace with sea and mountain views is fully furnished with high-end designer pieces by Ikonia Ilusion&Arte, which (...)
€385,000
TSEA5157172
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Investment Opportunity – New on the Market!
Front line beach apartment in Calahonda with spectacular sea views.
Features:
• 3 bedrooms
• 2 bathrooms
• Complex with swimming pool
• (...)
€249,999
TSEA5157166
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
This beautifully presented 2 bedroom middle floor property has a bright open lounge and generous separate fully fitted kitchen. The large main bedroom and double guest bedroom both have built-in (...)
€1,190,000
TSEA5157151
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
New exclusive 3-bedroom penthouse for sale with panoramic sea views and a south-facing location to enjoy sunlight, privacy, and uninterrupted views all day long.
Located in the exclusive residential (...)
€5,395,000
TSEA5157145
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 270 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 270 Area: Marbella East Region: Andalucía
Situated in the exclusive Puente Romano resort, this renovated south-facing corner penthouse offers a living experience that perfectly balances convenience with comfort. With stunning views from its (...)
€269,000
TSEA5157136
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 112 Lot Size: 23 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Lot Size: 23 Area: Casares Region: Andalucía
Charming ground floor apartment in Casares Costa with two bedrooms and two bathrooms, within a small, quiet urbanisation. The property stands out for its spacious, south-facing terrace and private (...)
€265,000
TSEA5157067
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 56 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Fuengirola Region: Andalucía
New Development: Prices from 265,000 € to 1,100,000 €. [Beds: 1 - 4] [Baths: 1 - 3] [Built size: 56.00 m2 - 188.00 m2]
Boutique Sea-View Apartments in Torreblanca del Sol
Features:
Sea-facing (...)
€660,000
TSEA5157052
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 135 Lot Size: 28 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 135 Lot Size: 28 Area: Benahavis Region: Andalucía
Elegant ground-floor apartment with a large terrace and private garden in a prestigious gated community Benatalya.
The property features a spacious layout with 3 bedrooms and 3 bathrooms, a bright (...)
€699,000
TSEA5156986
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 83 Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Region: Andalucía
Med One, Higuerón West – Luxury 2-Bedroom Apartment with Panoramic Sea Views
Located within the prestigious Med One complex in Higuerón West, this elegant two-bedroom, two-bathroom apartment (...)
€899,000
TSEA5156980
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 103 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: Fuengirola Region: Andalucía
Stunning 3-Bedroom Penthouse with Private Pool, Panoramic Views & Luxury Outdoor Living
Experience elevated coastal living in this one-of-a-kind penthouse, perfectly positioned just moments from (...)
Current Featured Properties
€420,000
TSEA5034892
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
The exclusive residential complex invites you to a modern lifestyle infused with traditional Andalusian charm, all within a community designed for those who appreciate quality and natural beauty. At (...)
€310,000
TSEA4452208
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 90 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 90 Area: Manilva Region: Andalucía
This innovative real estate project consists of 60 multi-family dwellings, offering 2 and 3-bedroom apartments, all equipped with garage and storage room in the basement. The blocks are distributed (...)
€1,195,000
TSEA4976017
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
