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,42,43,44,45)
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,42,43,44,45)
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,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 221 - 240 of 3420 €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 (...)
€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 (...)
€208,000
TSEA5141512
- San Enrique, Costa Del Sol, Sotogrande
Beds: 4 Baths: 2 M2: 104 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 2 M2: 104 Area: Sotogrande Region: Andalucía
Renovated Apartment in San Enrique (Sotogrande, Costa del Sol)
In the quiet, residential area of San Enrique (Sotogrande), surrounded by amenities and with excellent connections to La Línea, (...)
€570,000
TSEA5141206
- Valle de Abdalajis, Costa Del Sol, Älora
Beds: 4 Baths: 2 M2: 155 Lot Size: 9,573 Area: Älora Region: Andalucía
Beds: 4 Baths: 2 M2: 155 Lot Size: 9,573 Area: Älora Region: Andalucía
CCharming single-story chalet in Valle de Abdalajís, Málaga, offering 155 m² of living space on a 9,573 m² plot. The 288 m² property features a 39 m² porch, 4 spacious bedrooms with fitted (...)
€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 (...)
€5,799,000
TSEA5141032
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 522 Lot Size: 1,545 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 522 Lot Size: 1,545 Area: Benahavis Region: Andalucía
SNEAK PEEK AT CASA ARTOLA: A statement of lifestyle and exclusivity in the hills of Benahavís.
Set on a generous 1,550 m² south-facing plot, CASA ARTOLA captures the essence of refined
Andalusian (...)
€160,000
TSEA5141029
- Casares Pueblo, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 80 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Casares Region: Andalucía
This beautiful house is located in the picturesque village of Casares, in one of its best areas, just 25 meters from a spacious public parking area — a rare convenience in the historic center. (...)
€645,000
TSEA5141023
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 166 Lot Size: 1,150 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 166 Lot Size: 1,150 Area: Marbella Region: Andalucía
Magnificent opportunity! GUADALMINA ALTA. -
Villa to be renovated with a large plot and many opportunities, located in Guadalmina Alta, one of the most sought-after areas of Marbella. Next to the (...)
€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 (...)
€7,500,000
TSEA5140987
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 17 Baths: 11 M2: 1,727 Lot Size: 3,400 Area: Marbella West Region: Andalucía
Beds: 17 Baths: 11 M2: 1,727 Lot Size: 3,400 Area: Marbella West Region: Andalucía
An exceptionally prestigious and exclusive luxury residence with 17 rooms and 11 bathrooms – far beyond the ordinary!
Outstanding social areas designed for recreation, entertaining, and gatherings. (...)
€1,595,000
TSEA5140984
- Elviria, Costa Del Sol, Marbella East
Beds: 5 Baths: 3 M2: 251 Lot Size: 1,755 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 3 M2: 251 Lot Size: 1,755 Area: Marbella East Region: Andalucía
Discover your dream home in this beautifully designed one-level residence, bathed in natural light and featuring direct access to a stunning pool. With five spacious bedrooms and three modern (...)
€2,000,000
TSEA5140972
- Tarifa, Costa de la Luz
Beds: 6 Baths: 6 M2: 750 Lot Size: 3,200 Region: Andalucía
Beds: 6 Baths: 6 M2: 750 Lot Size: 3,200 Region: Andalucía
Located in one of the most sought-after areas of Tarifa, this stunning recently renovated villa offers a unique experience of luxury, comfort, and privacy. Surrounded by a peaceful and natural (...)
€5,400,000
TSEA5140960
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 612 Lot Size: 230 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 612 Lot Size: 230 Area: Marbella West Region: Andalucía
Exclusive Villa in Puerto Banús, Marbella
Now available in the prestigious Vilas 6 gated complex:
Villa 2, unfurnished
Villa 6, fully furnished corner unit
Live in absolute luxury in this (...)
€3,985,000
TSEA5140945
- El Madroñal, Costa Del Sol, San Pedro
Beds: 5 Baths: 5 M2: 380 Lot Size: 1,161 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 5 M2: 380 Lot Size: 1,161 Area: San Pedro Region: Andalucía
This elegantly renovated luxury villa offers a refined lifestyle within an exclusive, secure gated complex. Enjoying a desirable south to south- east orientation, the property boasts breathtaking sea (...)
€2,475,000
TSEA5140903
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 5 Baths: 6 M2: 506 Lot Size: 1,924 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 6 M2: 506 Lot Size: 1,924 Area: Sotogrande Region: Andalucía
Exclusive villa with private garden and pool in Sotogrande Alto Central
A truly unique residence, designed and custom-built by its owner with a tasteful renovation that keeps it current while (...)
€1,395,000
TSEA5140897
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 183 Lot Size: 318 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 183 Lot Size: 318 Area: Marbella West Region: Andalucía
This beautifully renovated villa offers the perfect blend of modern style, comfort, and an unbeatable location in the heart of Nueva Andalucía.
Spanning over two floors, the home features three (...)
€300,000
TSEA5140843
- Coín, Costa Del Sol, Coin
Beds: 2 Baths: 1 M2: 129 Area: Coin Region: Andalucía
Beds: 2 Baths: 1 M2: 129 Area: Coin Region: Andalucía
Discover this beautiful house in Andalusia, Málaga, ideal for enjoying the peace and quiet of the countryside. With 129 m² of space, this nearly new property offers a bright and welcoming (...)
€890,000
TSEA5140837
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 134 Lot Size: 1,020 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 134 Lot Size: 1,020 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 890,000 € to 930,000 €. [Beds: 4 - 4] [Baths: 3 - 3] [Built size: 134.00 m2 - 137.00 m2]
KEY READY!!!
VILLAS IN PINOS DE ALHAURÍN. MÁLAGA.
These villas are 2 (...)
€399,000
TSEA5140819
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 89 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Mijas and Mijas Costa Region: Andalucía
Top Floor Apartment for Sale in Calahonda – Prime Location on the Costa del Sol
This bright and spacious top floor apartment offers the perfect combination of comfort, convenience, and coastal (...)
€379,000
TSEA5140816
- Alora, Costa Del Sol, Älora
Beds: 3 Baths: 2 M2: 148 Lot Size: 35,400 Area: Älora Region: Andalucía
Beds: 3 Baths: 2 M2: 148 Lot Size: 35,400 Area: Älora Region: Andalucía
Beautiful Villa for Sale in Álora – Perfect to Live, Invest, or Rent Out
Set in the rolling hills of Álora, this spacious single-level villa offers comfort, charm, and endless potential. With (...)
Current Featured Properties
€6,895,000
World class design-led villas with spectacular views
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 482 Lot Size: 2,406 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 482 Lot Size: 2,406 Area: Benahavis Region: Andalucía
400,000€ discount if you purchase before completion! This is a sustainable luxury development of 18 individually designed villas situated in the 200-hectare country club estate of Real de La (...)
€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 (...)
€1,100,000
TSEA4638103
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 138 Lot Size: 34 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Lot Size: 34 Area: Fuengirola Region: Andalucía
This project represents an outstanding commitment in the development of a boutique proposal located just 500 meters from the beach, with easy and unobstructed access.
This exclusive development (...)
