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 (42,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 (42,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 (42,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 1861 - 1880 of 5891
€1,800,000
TSEA5073133
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 213 Lot Size: 950 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 213 Lot Size: 950 Area: Mijas and Mijas Costa Region: Andalucía
DETACHED LUXURY VILLA WITH PANORAMIC SEA VIEWS AND PRIVATE POOL – EL CHAPARRAL - WALKING DISTANCE TO THE BEACH
3 Bedrooms | 3.5 Bathrooms | Private Pool | Sea Views | Renovated 2025
This stylish (...)
€239,000
TSEA5073109
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 37 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 37 Area: Fuengirola Region: Andalucía
OPPORTUNITY
Apartment for sale for personal use or investment in a 4-star hotel in Fuengirola.
Furnished apartment with equipped kitchen, bathroom, and 1 bedroom facing east with sea views, beach and (...)
€529,000
TSEA5073091
- Los Monteros, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 226 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 226 Area: Marbella East Region: Andalucía
*** Viewings possible now until the 17th of September ***
REFURB OPPORTUNITY IN LOS MONTEROS BEACH, EAST MARBELLA!
Motivated Seller, keen to sell now and will listen to offers !
Lowest priced (...)
€630,000
TSEA5073061
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 232 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 232 Area: Estepona Region: Andalucía
Stunning Duplex Penthouse in Las Olas – La Gaspara, Estepona
Welcome to this exceptional duplex penthouse in the exclusive Las Olas development, nestled in the highly sought-after area of La (...)
€415,000
TSEA5073058
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
This beautiful apartment is located in the popular Alamar with walking distance to La Cala city centre and the beach. It features 2 bedrooms, 2 bathrooms, a utilityroom, a modern kitchen, a large (...)
€420,000
TSEA5073046
- La Cala Hills, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 116 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Area: Mijas and Mijas Costa Region: Andalucía
Stunning Ultra Luxurious Large 3-bedroom, 2-bathroom Apartment in Fase 1, La Cala Hills, Mijas Golf, Mijas Costa.
South Facing with Sun All Day! - and a transferableTourist License!
La Cala Hills (...)
€550,000
TSEA5073013
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 103 Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Region: Andalucía
Great New Sea View Apartment in EL Higueron with TL
Description
Luxury Apartment with Panoramic Sea Views – El Higuerón, Fuengirola Experience elevated coastal living in this fully furnished, (...)
€750,000
TSEA5072998
- Los Flamingos, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 162 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 162 Area: Estepona Region: Andalucía
Located in the prestigious Los Flamingos Golf Resort, perfectly positioned between Marbella and Estepona, this spacious and beautifully presented first-floor apartment enjoys stunning views across (...)
€949,000
TSEA5072992
- Torremuelle, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 288 Lot Size: 1,201 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 288 Lot Size: 1,201 Area: Mijas and Mijas Costa Region: Andalucía
Charming Villa with Sea Views & Huge Potential – Torremuelle, Benalmádena
Located in the sought-after residential area of Torremuelle, this charming villa offers the perfect opportunity to (...)
€2,300,000
TSEA5072962
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 333 Lot Size: 2,991 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 333 Lot Size: 2,991 Area: Marbella Region: Andalucía
The unbeatable location of a house in the center of Marbella with a 2,992 m2 plot.
4 bedrooms, 3 bathrooms
It's a perfect investment.
€429,000
TSEA5072950
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 133 Lot Size: 30 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Lot Size: 30 Area: Casares Region: Andalucía
Neat, Tidy, Modern, Fresh…Welcome to Royal Casares.
A frontline golf urbanization on the Casares Costa 9 Hole Golf course.
This ground floor apartment is 86m2 internal, and 121m2 including covered (...)
€3,300,000
TSEA5072929
- Cancelada, Costa Del Sol, Estepona
Beds: 6 Baths: 6 M2: 460 Lot Size: 1,067 Area: Estepona Region: Andalucía
Beds: 6 Baths: 6 M2: 460 Lot Size: 1,067 Area: Estepona Region: Andalucía
Modern newly built villa with 6 bedrooms and 6 en-suite bathrooms, spread over 3 floors and located in an exclusive area, designed for those seeking luxury, comfort, and style. With 460sqm of built (...)
€419,000
TSEA5072887
- Riviera del Sol, 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
This penthouse offers a bright and relaxed living experience on the third floor with elevator access, standing out for its fresh, summery atmosphere. Its location, just a few minutes' walk from Bombo (...)
€450,000
TSEA5072878
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 122 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 122 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful apartment located in a fantastic community. This large bright apartment has two very good size bedrooms with filled wardrobes, two bathrooms the ensuite has a shower and the second bathroom (...)
€399,000
TSEA5072875
- Nagüeles, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 99 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 99 Area: Marbella Region: Andalucía
Cozy 2-Bedroom Apartment with Spacious Terrace in Nagüeles
Located in one of Marbella's most peaceful and residential areas, this bright 100 m² apartment offers comfort, space, and excellent (...)
€415,000
TSEA5072791
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 90 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 90 Area: Marbella Region: Andalucía
Great Opportunity in the Heart of Marbella
Property with Huge Potential on Ricardo Soriano – Unbeatable Location
Located in the very centre of Marbella, on the well-known Avenida Ricardo Soriano, (...)
€1,349,000
TSEA5072686
- La Zagaleta, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 110 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Benahavis Region: Andalucía
This charming ground-floor apartment is located in the exclusive La Zagaleta Urbanization, within a small, unique complex of just seven apartments known as "EL PARADOR"—the only one with (...)
€1,695,000
TSEA5072626
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 180 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: San Pedro Region: Andalucía
Step into this beautifully renovated 3-bedroom, 3.5-bathroom duplex penthouse, ideally situated just steps from the beach and within easy walking distance to shops, the town center, restaurants, and (...)
€995,000
TSEA5072506
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 118 Lot Size: 58 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Lot Size: 58 Area: Estepona Region: Andalucía
This residence is part of an exclusive beachfront complex that offers an extensive range of sports facilities, including a gym, paddle tennis, indoor and outdoor swimming pools and a spa. You can (...)
€2,250,000
TSEA5072482
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 291 Lot Size: 850 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 291 Lot Size: 850 Area: Benahavis Region: Andalucía
Step into your dream home with this breathtaking Andalusian-style villa, which perfectly blends timeless elegance with modern luxury. Nestled in a serene setting with partial sea views, this stunning (...)
Current Featured Properties
€2,695,000
TSEA5143117
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Located between Marbella and Estepona, Bahía del Velerín is a prestigious community with a beautiful pool area, a snack bar, lush tropical gardens, and 24/7 security.
This fully renovated penthouse (...)
€480,000
TSEA4646746
- Estepona, 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
This is a magnificent development comprising fifty-one 2-, 3- and 4-bedroom homes, which also include penthouses with suntrap terraces and community facilities featuring a kiddies' paddling pool, a (...)
€907,852
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA.
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 Area: Estepona Region: Andalucía
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA.
A luxury resort style apartment complex with the best in leisure facilities. This new development has been landscaped to create TOP QUALITY with (...)
