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,39,40,41,162,163)
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,39,40,41,162,163)
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,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 1521 - 1540 of 3894 €799,000
TSEA5064334
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 200 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Area: Estepona Region: Andalucía
Located just minutes from renowned golf courses and everyday amenities, this beautifully designed apartment in the prestigious Cataleya Complex blends modern minimalism with comfort and (...)
€399,000
TSEA5064301
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 98 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 98 Area: Estepona Region: Andalucía
This modern two-bedroom apartment is located in the heart of Estepona, near the beach, shops, schools, and parks. With easy access to both the A-7 coast road and the AP-7 motorway, the location is (...)
€365,000
TSEA5064169
- Bel Air, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 96 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 96 Area: Estepona Region: Andalucía
Beautiful 2-Bedroom First Floor Apartment in Bel Air, Estepona – Spectacular Sea and Mountain Views.
Nestled in the sought-after area of Bel Air on the Costa del Sol, this charming first-floor (...)
€618,000
TSEA5064103
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 220 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 220 Area: Fuengirola Region: Andalucía
This exceptional duplex penthouse, located just 70 m from the beach, offers not only a privileged location but also an unrivalled lifestyle in the vibrant Fuengirola.
- Total built: 220 m²
- (...)
€696,500
TSEA5064091
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Charming Elevated Ground Floor 3-Bedroom Apartment with Sea and Garden Views – Nueva Andalucía
Welcome to this beautifully presented elevated ground floor apartment located in the exclusive Las (...)
€741,000
TSEA5063980
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
This development is part of a perfectly established community with fully operational common areas. This project has a total of 82 houses to be developed in 2 phases. Phase I corresponds to blocks 1 (...)
€535,000
TSEA5063977
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
This development is part of a perfectly established community with fully operational common areas. This project has a total of 82 houses to be developed in 2 phases. Phase I corresponds to blocks 1 (...)
€368,400
TSEA5063941
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 58 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 58 Area: Mijas and Mijas Costa Region: Andalucía
A modern apartment complex is an innovative development of 116 one-bedroom loft-style apartments, designed for those seeking style, functionality, and excellent value for money. At this residential (...)
€251,300
TSEA5063932
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 53 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 53 Area: Mijas and Mijas Costa Region: Andalucía
A modern apartment complex is an innovative development of 116 one-bedroom loft-style apartments, designed for those seeking style, functionality, and excellent value for money. At this residential (...)
€229,000
TSEA5063896
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 45 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 45 Area: Estepona Region: Andalucía
Ground Floor Apartment, Estepona, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 45 m². It is sold with a valid tourist license.
Welcome to this bright and well-distributed 1-bedroom apartment, (...)
€205,000
TSEA5063851
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 45 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 45 Area: Fuengirola Region: Andalucía
Fuengirola center, Costa del Sol- Brand new apartment, fantastic price. Ideal as a holiday apartment!
You will have the opportunity to own a beautiful modern apartment in the centre of Fuengirola, (...)
€285,000
TSEA5063665
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 1 M2: 95 Area: Manilva Region: Andalucía
Beds: 3 Baths: 1 M2: 95 Area: Manilva Region: Andalucía
Charming 3-Bedroom Apartment with Stunning Sea Views – Manilva, Costa del Sol
Situated just west of the vibrant Duquesa Port, this beautifully presented middle-floor apartment offers breathtaking (...)
€1,060,000
TSEA5063608
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 201 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 201 Area: Benalmadena Region: Andalucía
An exclusive boutique complex of 28 apartments in the highly sought-after area of Torremuelle, Benalmádena. Each residence has been carefully designed to offer a superior living experience, with (...)
€280,000
TSEA5063596
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
100M FROM THE BEACH - 2 BEDROOMS 2 BATHROOMS SEAVIEW DUPLEX APARTMENT IN CALAHONDA BEACH
This unique stylish 2-bedroom, 2-bathroom apartment offers breathtaking sea views and an enviable location (...)
€470,000
TSEA5063590
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 1 M2: 72 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 1 M2: 72 Area: San Pedro Region: Andalucía
New Development: Prices from 470,000 € to 1,200,000 €. [Beds: 2 - 4] [Baths: 1 - 3] [Built size: 72.00 m2 - 129.00 m2]
THE DEVELOPMENT
This boutique development of 101 apartments in the new area (...)
€720,000
TSEA5063449
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 139 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Area: Benalmadena Region: Andalucía
An exclusive boutique complex of 28 apartments in the highly sought-after area of Torremuelle, Benalmádena. Each residence has been carefully designed to offer a superior living experience, with (...)
€949,000
TSEA5063374
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 260 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 260 Area: Estepona Region: Andalucía
The apartment is located in the heart of Estepona's old town – central yet peacefully tucked away. The charming little square outside has become a symbol of the house itself. Here, you live among (...)
€320,000
TSEA5063368
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 72 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Area: Mijas and Mijas Costa Region: Andalucía
Ground Floor 2-Bedroom Apartment for Sale
Prime Location | 5-Min Walk to Pirata Beach | Gated Community
Welcome to this charming ground floor 2-bedroom, 2-bathroom apartment, located in the highly (...)
€775,000
TSEA5063350
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Stunning Beachfront Penthouse in Estepona
Wake up to breathtaking views of Playa del Cristo and across the sea to Gibraltar from this beautifully renovated penthouse apartment. Boasting a prime (...)
€2,200,000
TSEA5063341
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 175 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 175 Area: Estepona Region: Andalucía
Experience luxury living in this spectacular and unique penthouse located in the heart of Estepona, just a 1-minute walk from the charming old town and a mere 5 minutes from the beach. This stunning (...)
Current Featured Properties
€649,000
TSEA4955404
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 113 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 113 Area: Casares Region: Andalucía
A private beach right on your doorstep. Turquoise waters in a tropical setting. An exclusive Mediterranean-style residential complex. Homes with large terraces and high-quality finishes. 38 (...)
€515,000
TSEA4814728
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 109 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Area: Istan Region: Andalucía
COUNTRY LIVING ONLY 10 MINS FROM EVERYTHING!
This is the first phase on sale, comprising 32 exclusive apartments with stunning panoramic views, situated in the most elevated part of the Almazara (...)
€1,525,000
TSEA4976002
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 121 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 121 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 (...)
