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 (70,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 (70,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 (70,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 221 - 240 of 3305 €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 (...)
€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 (...)
€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 (...)
€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 (...)
€398,000
TSEA5140831
- Campo Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Partially renovated townhouse in Campo Mijas with panoramic views. Spread over 3 floors, it features 3 bedrooms, terraces on every level, a solarium, modern kitchen, and BBQ terrace. Community pool (...)
€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 (...)
€515,000
TSEA5140732
- Sierrezuela, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 272 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 272 Area: Mijas and Mijas Costa Region: Andalucía
Villa with Divisible Plot and Great Potential in La Sierrezuela (Mijas)
A unique opportunity in one of the most sought-after areas of the Costa del Sol!
Plot of 1,525 m² with topographic study (...)
€699,000
TSEA5140534
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 123 Lot Size: 149 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 123 Lot Size: 149 Area: Benalmadena Region: Andalucía
Townhouse for sale at La Capellanía - El Higuerón, Benalmádena
Discover this exclusive semi-detached house located in the prestigious Reserva El Higuerón complex, a privileged enclave on the (...)
€6,500,000
TSEA5139955
- Benahavís, Costa Del Sol, Benahavis
Beds: 6 Baths: 7 M2: 1,280 Lot Size: 5,260 Area: Benahavis Region: Andalucía
Beds: 6 Baths: 7 M2: 1,280 Lot Size: 5,260 Area: Benahavis Region: Andalucía
Exquisite Six-Bedroom Luxury Villa Project in Marbella Club Golf Resort
This exceptional brand-new luxury villa project is located in the prestigious Marbella Club Golf Resort in Benahavís, (...)
€3,600,000
TSEA5139934
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 450 Lot Size: 4,444 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 450 Lot Size: 4,444 Area: Marbella East Region: Andalucía
BRAND NEW VILLA TO THE MARKET IN EAST MARBELLA. VERY PRIVATE ONE LEVEL VILLA ON ONE OF THE BEST STREETS IN ELVIRIA BUILT ON A 4 PLOT EXTENSION WITH 4444M2. THIS VILLA HAS STUNNING PANORAMIC VIEWS AND (...)
Current Featured Properties
€1,440,000
TSEA4709815
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 226 Lot Size: 756 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 226 Lot Size: 756 Area: Estepona Region: Andalucía
This new project of villas stands out as an emblem of luxury in perfect harmony with nature, framed by a golf course, and with the charming golden beaches a stone's throw away. It offers the ideal (...)
€1,011,000
TSEA4391047
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 160 Lot Size: 63 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 160 Lot Size: 63 Area: Mijas and Mijas Costa Region: Andalucía
NATUTAL LIGHT FLOODS INTO THE PROPERTIES!!!
The architecture of these sixty-nine villas blends with nature and reinvents the traditional Andalusian style. A refuge where the natural beauty of the (...)
€2,995,000
TSEA4430326
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 4 M2: 400 Lot Size: 1,200 Area: Marbella Region: Andalucía
Beds: 5 Baths: 4 M2: 400 Lot Size: 1,200 Area: Marbella Region: Andalucía
Luxury Detached Villa Front line Golf in Nueva Andalucia, Marbella!
Spectacular house located on the front line of one of the most famous golf courses, Aloha Golf.
This villa offers panoramic views (...)
