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 621 - 640 of 3305 €1,449,000
TSEA5106082
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 324 Lot Size: 1,322 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 324 Lot Size: 1,322 Area: Marbella East Region: Andalucía
SPACIOUS 4-5 BEDROOM VILLA IN ELVIRIA-MARBELLA
This well-maintained villa, built by its original owners, offers an exceptional opportunity to live in the sought-after area of Elviria, (...)
€695,000
TSEA5106079
- Cómpeta, Costa Del Sol East
Beds: 5 Baths: 4 M2: 438 Lot Size: 2,082 Region: Andalucía
Beds: 5 Baths: 4 M2: 438 Lot Size: 2,082 Region: Andalucía
Superb Business Opportunity – Bar & Restaurant with Owner's Accommodation and Guest Apartment Between Cómpeta & Torrox
An exceptional opportunity to acquire a successful bar and (...)
€360,000
TSEA5105935
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 106 Lot Size: 700 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 106 Lot Size: 700 Area: Mijas and Mijas Costa Region: Andalucía
Detached Villa,In the Village of Alqueria close to Alhaurín de la Torre, and Alhaurin el Grande Inland Malaga
4 Bedrooms, 2 Bathrooms, Built 100 m², Garden/Plot 700 m².
Beautiful house for sale (...)
€449,000
TSEA5105896
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 107 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Area: Mijas and Mijas Costa Region: Andalucía
Charming Townhouse in the Idyllic Puebla Aida Community!
Welcome to this tastefully decorated townhouse in the highly sought-after and picturesque community of Puebla Aida—an area reminiscent of (...)
€1,500,000
TSEA5105860
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 282 Lot Size: 454 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 282 Lot Size: 454 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,500,000 € to 1,500,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 282.00 m2 - 282.00 m2]
This brand-new detached villa combines modern design, spaciousness, and (...)
€599,000
TSEA5105836
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 115 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 115 Area: Marbella West Region: Andalucía
Spacious 3-Bedroom Duplex in Miragolf, Nueva Andalucía – Steps from the Golf Course
Located within the sought-after Miragolf complex in Nueva Andalucía, this elegant duplex townhouse offers the (...)
€9,500,000
TSEA5105767
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 8 Baths: 7 M2: 1,202 Lot Size: 1,741 Area: Marbella East Region: Andalucía
Beds: 8 Baths: 7 M2: 1,202 Lot Size: 1,741 Area: Marbella East Region: Andalucía
Spectacular 8-Bedroom Villa in Bahia de Marbella, Los Monteros
Nestled in the exclusive and secure neighbourhood of Bahia de Marbella. This stunning 8-bedroom, 7-bathroom villa offers the ultimate (...)
€1,400,000
TSEA5105752
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 3 M2: 209 Lot Size: 452 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 3 M2: 209 Lot Size: 452 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,400,000 € to 1,400,000 €. [Beds: 2 - 2] [Baths: 3 - 3] [Built size: 209.00 m2 - 209.00 m2]
Luxury Villa in La Sierrezuela, Mijas Costa
Discover this exclusive (...)
€1,975,000
TSEA5105731
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 8 Baths: 8 M2: 762 Lot Size: 1,703 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 8 Baths: 8 M2: 762 Lot Size: 1,703 Area: Mijas and Mijas Costa Region: Andalucía
BEST BUY ALERT - (massively reduced) Spectacular 8 bed Mediterranean Villa / Mansion with incredible golf, mountain & sea views. Enormous / impressive home on a large 1703 m2 raised plot and (...)
€395,000
TSEA5105716
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 3 M2: 217 Lot Size: 100 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 3 M2: 217 Lot Size: 100 Area: Alhaurin el Grande Region: Andalucía
Price reduction!
Fantastic 3 storey townhouse for sale in Las brisas, Alhaurin golf, Alhaurin el Grande.
The property has a private parking space out front and only a few stairs down to the front (...)
€6,250,000
TSEA5105377
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 616 Lot Size: 1,427 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 616 Lot Size: 1,427 Area: Benahavis Region: Andalucía
Stunning contemporary villa with panoramic mountain, golf and sea views in La Alqueria, Benahavis
This exclusive masterpiece, a designer villa by Carlos Lamas, houses a total of 5 bedrooms and 6 (...)
€725,000
TSEA5105368
- Arenas, Costa Del Sol East
Beds: 4 Baths: 2 M2: 246 Lot Size: 4,750 Region: Andalucía
Beds: 4 Baths: 2 M2: 246 Lot Size: 4,750 Region: Andalucía
Exclusive Villa for Sale in Arenas, Vélez-Málaga. Escape the hustle and bustle and discover this exceptional villa, located in the quiet countryside (campo) of the white village of Arenas in the (...)
€1,495,000
TSEA5105251
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 240 Lot Size: 60 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 240 Lot Size: 60 Area: Marbella West Region: Andalucía
Welcome to this charming 4-bedroom townhouse! Nestled in the cozy residential development of Los Potros, this luxuriously renovated home exudes Spanish charm and boasts beautifully landscaped (...)
€4,950,000
TSEA5105161
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 444 Lot Size: 1,950 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 444 Lot Size: 1,950 Area: Marbella West Region: Andalucía
Located in one of Marbella's most sought-after residential areas, this five-bedroom, five-bathroom villa offers panoramic, frontal views of the Mediterranean Sea, La Concha mountain, and Puerto (...)
€1,450,000
TSEA5105056
- Entrerrios, Costa Del Sol
Beds: 4 Baths: 4 M2: 400 Lot Size: 19,000 Region: Andalucía
Beds: 4 Baths: 4 M2: 400 Lot Size: 19,000 Region: Andalucía
Charming Andalusian Cortijo with Lush Fruit Gardens and Large Pool in Mijas
Nestled in the serene countryside of Mijas, this beautiful Andalusian-style cortijo offers a rare combination of rustic (...)
€3,300,000
TSEA5105029
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 7 Baths: 8 M2: 720 Lot Size: 1,250 Area: Marbella West Region: Andalucía
Beds: 7 Baths: 8 M2: 720 Lot Size: 1,250 Area: Marbella West Region: Andalucía
Introducing an exclusive investment opportunity in the heart of Nueva Andalucía — Marbella's prime residential area.
This villa project is available for 3,300,000 euros, with a fully approved (...)
€1,490,000
TSEA5105011
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 223 Lot Size: 601 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 223 Lot Size: 601 Area: Marbella East Region: Andalucía
Charming Villa for Sale – Artola, Cabopino (Marbella)
We present this cozy villa located in one of the quietest and most exclusive areas of Marbella, surrounded by pine forests, protected dunes, (...)
€425,000
TSEA5104858
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 150 Lot Size: 60 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Lot Size: 60 Area: Mijas and Mijas Costa Region: Andalucía
TOWNHOUSE WITH SOUL AND GREAT POTENTIAL IN LA CASITA COLORADA – HACIENDA DE MIJAS
We present this charming townhouse located in one of the most peaceful and green areas of the Costa del Sol: La (...)
€1,150,000
TSEA5104783
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 378 Lot Size: 2,559 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 378 Lot Size: 2,559 Area: Mijas and Mijas Costa Region: Andalucía
Mediterranean Villa with Sea Views and Expansive Garden in La Cala de Mijas!!
Just 4 minutes by car (2.5 km) from the vibrant centre of La Cala de Mijas, this elegant villa offers 378 m² of built (...)
€249,000
TSEA5104723
- Coín, Costa Del Sol, Coin
Beds: 3 Baths: 2 M2: 115 Area: Coin Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Coin Region: Andalucía
Nice townhouse with three bedrooms in a very central area of Coín.
Comfortable house distributed on two floors with 115 m2 useful approximately. On the first floor we find a toilet, living room, (...)
Current Featured Properties
€1,400,000
TSEA4954306
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 372 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 372 Area: Estepona Region: Andalucía
An exclusive development of seventeen designer villas located in the Estepona golf course, where luxury and sustainability come together to create unique, welcoming homes with expansive open spaces (...)
€957,000
TSEA4390957
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 143 Lot Size: 54 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 143 Lot Size: 54 Area: Mijas and Mijas Costa Region: Andalucía
A NATURAL BEAUTY!!!
The architecture of these sixty-nine villas blends with nature and reinvents the traditional Andalusian style. A refuge where the natural beauty of the environment merges with a (...)
€1,675,000
TSEA4939003
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 221 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 221 Area: Marbella Region: Andalucía
This is the opportunity of living in Spain, in the best equipped residential complex in Marbella, located in a privileged spot near the golf club and with premium quality specifi cations. You will (...)
