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,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 (31,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 (31,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (2652), Middle Floor - (2652), Penthouse - (2652), Top Floor Apartment - (2652), Penthouse Duplex - (2652)Properties
Results 381 - 400 of 3992 €320,000
TSEA5142181
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful 2 bedroom top floor apartment with large sunny terrace in the well-known Lew Hoad Village, located on the road towards Mijas in beautiful surroundings with views of the mountains and a (...)
€530,000
TSEA5142139
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 91 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 91 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 91 m².
Setting : Beachfront, Town, Beachside, Close To Sea.
Orientation : South.
Condition : Excellent.
Climate (...)
€530,000
TSEA5142130
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
This bright apartment combines comfort and location in an exclusive setting in the Resina/Selwo area. Located in a private residential complex surrounded by gardens and tranquility, it is perfect for (...)
€1,095,000
TSEA5141947
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 130 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Marbella East Region: Andalucía
Welcome to Sierra Club Residence, a luxurious apartment located in the exclusive gated community of Urbanization Club Sierra. Thanks to its prime location, this apartment ensures you are always in (...)
€415,000
TSEA5141866
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 93 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Benalmadena Region: Andalucía
Discover your new home in the heart of the Costa del Sol! This stunning, brand-new apartment boasts 2 spacious bedrooms and 2 modern bathrooms, designed for comfort and style. Its undeniable (...)
€449,000
TSEA5141815
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 3 M2: 140 Area: Casares Region: Andalucía
Beds: 4 Baths: 3 M2: 140 Area: Casares Region: Andalucía
Penthouse Duplex, Casares, Costa del Sol.
4 Bedrooms, 3 Bathrooms, Built 140 m², Terrace 12 m².
Setting : Town, Close To Shops, Close To Schools, Close To Forest.
Orientation : South East, North (...)
€449,000
TSEA5141803
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 79 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 79 Area: Fuengirola Region: Andalucía
PROBABLY THE BEST TERRACE IN THE AREA WITH ALL DAY SUN!
This beautiful penthouse boasts a spectacular terrace with breathtaking views of the mountains, the sea, and the castle. The terrace is (...)
€395,000
TSEA5141773
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 4 M2: 195 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 4 M2: 195 Area: Benahavis Region: Andalucía
A very well presented and spacious 5 bedroom /4 bathroom apartment in the heart of beautiful Benahavis.
This large property is situated in the most perfect location for access to all amenities (...)
€449,000
TSEA5141710
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 90 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 90 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 90 m², Terrace 15 m².
Setting : Town, Commercial Area, Beachside, Village, Close To Port, Close To Shops, Close To (...)
€265,000
TSEA5141695
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 60 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 60 Area: Benahavis Region: Andalucía
Location Location Location!
Discover this charming 2-bedroom, 2-bathroom penthouse apartment nestled in the picturesque mountain pueblo of Benahavís, just around 8 mins drive from Marbella and the (...)
€530,000
TSEA5141686
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 145 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 145 Area: Marbella Region: Andalucía
Apartment for Sale in the Heart of Marbella - Unique Opportunity
Discover this impressive apartment in the center of Marbella, located on the corner of Nuestra Señora de Gracia and Ricardo Soriano. (...)
€192,000
TSEA5141674
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 2 Baths: 1 M2: 88 Area: Manilva Region: Andalucía
Beds: 2 Baths: 1 M2: 88 Area: Manilva Region: Andalucía
2-BEDROOM GROUND FLOOR APARTMENT IN SABINILLAS JUST A FEW STEPS FROM THE BEACH
This property is located in San Luis de Sabinillas, just 40 meters from the beach, close to supermarkets, shops, (...)
€495,000
TSEA5141665
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 53 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 53 Area: Marbella Region: Andalucía
Charming Renovated Apartment in the Heart of Marbella
✨ Renovated Apartment in Marbella Center ✨
Magnificent apartment, completely renovated in a modern and elegant style, located on the (...)
€655,000
TSEA5141662
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 109 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 109 Area: Marbella Region: Andalucía
Stunning Ground Floor Apartment in Nueva Andalucía's Prestigious Aloha Golf Valley
Discover your dream home in the heart of Marbella's exclusive Nueva Andalucía Golf Valley! This beautiful 109 m² (...)
€299,000
TSEA5141659
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 94 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic raised ground-floor apartment situated in a sought-after and very well-maintained complex in the upper part of Calahonda. The property has stunning panoramic views of the coast and the (...)
€760,000
TSEA5141653
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 165 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 165 Area: Marbella East Region: Andalucía
Duplex-Penthouse in Marbella's Golden Mile
Situated in the heart of Marbella's prestigious Golden Mile, this elegant 199 m² duplex-penthouse offers spacious interiors, abundant natural light, and (...)
€325,000
TSEA5141644
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Top floor apartment in the popular complex of Nordic Royal Club. Situated on the 5th floor gives the apartment beautiful views over the well kept garden towards the sea. There are 2 well sized (...)
€479,000
TSEA5141638
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 146 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 146 Area: Mijas and Mijas Costa Region: Andalucía
Triplex apartment in Torrequebrada Golf, Benalmádena.
This elegant 3-bedroom, 3-bathroom duplex apartment has three terrace areas, communal pool, TWO parking spaces, a storage room and three (...)
€245,000
TSEA5141551
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 75 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 75 Area: Marbella Region: Andalucía
Stunning high-floor Apartment for Sale in Marbella
Tourist license for 3 rooms (up to 6 people)
Impressive sea views
Secure building with two new elevators
Prime Location:
Steps away from (...)
€315,000
TSEA5141524
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
This stunning and impeccably maintained apartment is perched in the upper part of Calahonda and boasts the most spectacular panoramic sea views in the entire development. It features two spacious (...)
Current Featured Properties
€2,075,000
TSEA4980892
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 174 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 174 Area: La Duquesa Region: Andalucía
This is a complex of 2 and 3 bedroom apartments, 3 and 4 bedroom penthouses and 5 large bungalows with 3 bedrooms 3 bathrooms plus a guest cloakroom. located on the first line of the beach.
All homes (...)
€440,000
TSEA4184722
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 106 Lot Size: 81 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Lot Size: 81 Area: Mijas and Mijas Costa Region: Andalucía
This new development is located only 5 minutes away from La Cala de Mijas, one of the most popular holiday locations at the moment on the Costa del Sol. La Cala de Mijas has everything to offer. Wide (...)
€626,500
TSEA4557622
- Aloha, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 114 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Area: Marbella West Region: Andalucía
Private residential complex with an innovative design inspired by the architecture of the area. 70 spacious 2 and 3 bedroom flats with magnificent terraces and 24 hour security. Each flat offers an (...)
