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 (40)
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 (40)
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 (40)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1421 - 1440 of 1767 €549,000
TSEA4885660
- Torrenueva, 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
Apartment, Frontline beach, Fitted Kitchen, Parking: Community, Communal Pool, Garden: Community,
This nicely refurbished front line 2 bedroom, 2 bathroom apartment is ready to move in. You always (...)
€425,000
TSEA4885213
- Bel Air, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Bright and Spacious Apartment in Bel Air with Sea and Mountain Views
Discover this spacious and modern second-floor apartment in one of Bel Air's most sought-after developments. Recently renovated (...)
€214,900
TSEA4885123
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 31 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 31 Area: Fuengirola Region: Andalucía
Opportunity in the heart of Fuengirola!
We present this cozy 31 square meter studio that offers great potential to customize to your liking. With an 8-meter terrace (without views), this space is (...)
€309,750
TSEA4885105
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 88 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 88 Area: Estepona Region: Andalucía
Apartment with 2 bedrooms, 1 full bathroom, fully furnished kitchen with all types of appliances including a dryer, laminate flooring throughout the apartment, air conditioning, ceiling fan, 6m2 (...)
€845,000
TSEA4884328
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 115 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Fuengirola Region: Andalucía
Exclusive 2-Bedroom Apartment in Higuerón West – Available for Sale
Experience the pinnacle of luxury living in the prestigious Higuerón West community with this bright and spacious 2-bedroom (...)
€266,000
TSEA4883794
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 4 Baths: 2 M2: 198 Area: Alhaurin el Grande Region: Andalucía
Beds: 4 Baths: 2 M2: 198 Area: Alhaurin el Grande Region: Andalucía
Unique Opportunity: Two Properties for Sale in an Excellent Location in Alhaurín el Grande.
The property comprises two independent apartments, ideal for a family or as an investment with potential (...)
€595,000
TSEA4883299
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 6 Baths: 5 M2: 174 Area: San Pedro Region: Andalucía
Beds: 6 Baths: 5 M2: 174 Area: San Pedro Region: Andalucía
Rental investment opportunity. Recently refurbished large flat in Central San Pedro de Alcántara.
Discover this recently renovated urban flat of 174 m2, perfectly situated in the heart of San Pedro (...)
€495,000
TSEA4882513
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 74 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Marbella West Region: Andalucía
A unique opportunity to acquire an investment or holiday property in the heart of Puerto Banus with direct access to the port and the central square and yet in a quiet position. The property benefits (...)
€430,000
TSEA4882504
- La Campana, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 115 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Marbella West Region: Andalucía
Apartment in the Heart of Nueva Andalucía
This magnificent apartment offers you the opportunity to live in the heart of Nueva Andalucía, on the second floor of a quiet urbanization. With its own (...)
€749,000
TSEA4881949
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
"This property is located in the lower part of Nueva Andalucía next the Casino. Just 5 minutes walking to Puerto Banús.
The property is very well connected to the National NA340 in both senses (...)
€795,000
TSEA4881811
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 122 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Fuengirola Region: Andalucía
HIGUERON WEST - LUXURY 3-BEDROOM APARTMENT WITH SEAVIEWS
Experience the "Wow" Factor. From the moment you step into this luxurious 3-bedroom apartment, you are greeted by an immediate (...)
€860,000
TSEA4881355
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
This modern luxury apartment is in the prestigious area of Marbella - Puerto Banus, in the beautiful city of Marbella, Malaga. With its prime location, this apartment offers breathtaking views of the (...)
€550,000
TSEA4880959
- Las Chapas, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 116 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Area: Marbella East Region: Andalucía
Discover this 3-bedroom apartment, ideally located in the sought-after Las Chapas Playa, just a short 200 meters from the beach. Offering both comfort and convenience, this property is perfect for (...)
€339,000
TSEA4880623
- El Faro, 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
Discover a charming two-bedroom apartment, thoughtfully designed to provide comfort and style. Both bedrooms feature built-in wardrobes, with the master bedroom enjoying an en-suite bathroom. The (...)
€255,000
TSEA4880038
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 70 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 70 Area: Benahavis Region: Andalucía
This stunning, fully furnished second-floor apartment overlooks the tranquil communal swimming pool. Ideally situated near El Paraíso Golf, Villa Padierna Golf, Tramores Golf, Atalaya Golf, and (...)
€990,000
TSEA4879495
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 180 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 180 Area: Marbella East Region: Andalucía
Beautiful apt. on the first floor with south orientation and guaranteed open views of the sea, in one of the safest and quietest areas of Marbella in the prestigious Urb. de Bahia de Marbella, a (...)
€545,000
TSEA4879267
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 247 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 247 Area: Sotogrande Region: Andalucía
Sotogrande Alto: Discover the highest level of comfort and elegance in this stunning 3-bedroom, 3-bathroom apartment with panoramic views of the prestigious Almenara Golf Course and its tranquil (...)
€249,000
TSEA4879213
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 1 M2: 70 Area: Manilva Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Manilva Region: Andalucía
A fantastic two bedroom, one bathroom beachfront apartment situated in an urbanisation with pool and sea views, only three minutes walk to the beach and within walking distance to the port of (...)
€565,000
TSEA4877320
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Stunning Beachside Flat in La Carolina, Golden Mile
Discover your dream home in the prestigious La Carolina complex, located in the heart of the Golden Mile! This beautifully renovated flat features (...)
€2,200,000
TSEA4877110
- Málaga Centro, Costa Del Sol, Malaga
Beds: 4 Baths: 2 M2: 172 Area: Malaga Region: Andalucía
Beds: 4 Baths: 2 M2: 172 Area: Malaga Region: Andalucía
Introducing an extraordinary apartment in the heart of Málaga, located on the 27th floor of the prestigious Urban Sky Towers. Offering sweeping panoramic views of the Mediterranean Sea, the city's (...)
Current Featured Properties
€550,000
TSEA5042059
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 96 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Area: San Pedro Region: Andalucía
In an exceptional location in San Pedro Alcántara, just a short walk from the beach and with views of the sea and the impressive La Concha peak. Discover a new way of living in San Pedro Alcántara (...)
€490,000
TSEA4721146
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 76 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 76 Area: Estepona Region: Andalucía
A BRAND NEW BOUTIQUE COMPLEX OF ONLY 15 PROPERTIES! Our architects have carefully designed this project, sparing no details. You won't find small windows here, only large glass panels that flood the (...)
€799,500
Amazing panoramic views of the Mediterranean
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 2 M2: 92 Lot Size: 21 Area: Ojen Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Lot Size: 21 Area: Ojen Region: Andalucía
EXCEPTIONAL LIVING ON THE COSTA DEL SOL!!!
These exciting new off-plan apartments are being built with the highest quality materials to ensure the best standard of completion. The apartments feature (...)
