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,68,69,70)
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,68,69,70)
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,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 461 - 480 of 4730 €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 (...)
€287,000
TSEA5141515
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 89 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Manilva Region: Andalucía
Renovated Apartment with Terrace and Private Garden – Manilva, Costa del Sol
This elegant 2-bedroom, 2-bathroom apartment, with approximately 89 m² built area and 80 m² usable area, plus a (...)
€900,000
TSEA5141179
- La Quinta, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 112 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Area: Benahavis Region: Andalucía
This beautifully designed two-bedroom, two-bathroom apartment offers a harmonious blend of comfort and sophistication in one of the most sought-after areas of the Golf Valley. With 112 m² of (...)
€375,000
TSEA5141125
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 156 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 156 Area: Estepona Region: Andalucía
This beautifully presented west-facing penthouse is modern, stylish, and ready to move into, located within the secure gated community of Bel Air Gardens in Estepona. Enjoying a prime position just (...)
€335,000
TSEA5141053
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
This charming 2-bedroom, 1-bathroom property in Mijas Golf offers comfortable living in a peaceful and well-appointed community. The home features a bright and airy layout with a spacious living area (...)
€170,000
TSEA5141044
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 1 M2: 120 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 1 M2: 120 Area: Alhaurin el Grande Region: Andalucía
3-bedroom, 1-bathroom semi-detached house in Alhaurín el Grande. The property needs renovation, it offers excellent potential for customization. Located in a sought-after area, it's ideal for (...)
€595,000
TSEA5141020
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 64 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 64 Area: Marbella West Region: Andalucía
This apartment is the perfect combination of luxury, design and technology in one of Marbella's most sought-after locations. As soon as you walk in, natural light floods every corner and the direct (...)
€1,250,000
TSEA5141002
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 241 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 241 Area: Marbella West Region: Andalucía
This is a refined duplex penthouse set within the gated community of Aloha Gardens in Nueva Andalucía. This property presents a well-balanced combination of modern design and a prime location in one (...)
€749,995
TSEA5140993
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 281 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 281 Area: Fuengirola Region: Andalucía
Another amazing property in Higueron, with a strong rental history making it an attractive investment!
This unique corner apartment is located in one of the most sought-after areas on Costa del Sol. (...)
€355,000
TSEA5140963
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 82 Area: Marbella Region: Andalucía
✨ Living next to the Artola dunes and the best beach in Marbella ✨
Located in Artola Baja (Cabopino), just 200 meters from the protected natural area of the Artola Dunes and 450 meters (...)
Current Featured Properties
€490,000
TSEA4934416
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
An exclusive promotion of 25 units (1 to 3 bedrooms) in one of the expanding areas of Estepona. Located just minutes from the best beaches and offering access to a wide range of services, this (...)
€375,000
TSEA4428991
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
This is a place to start living, with an excellent location. Mijas has an environment in constant movement, offering a wide variety of services, leisure, health centers, schools or shopping centers. (...)
€3,695,000
TSEA5080774
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 187 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 187 Area: Estepona Region: Andalucía
This fully remodelled 4 bedroom and 3-bathroom apartment is an amazing opportunity for people who are looking for luxury and comfort in a stunning beachfront location. The spacious living and dining (...)
