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 (57,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 (57,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 (57,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 161 - 180 of 2651 €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 (...)
€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 (...)
€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 (...)
€1,750,000
TSEA5139844
- Setenil de las Bodegas, Costa de la Luz
Beds: 6 Baths: 6 M2: 648 Lot Size: 5,101 Region: Andalucía
Beds: 6 Baths: 6 M2: 648 Lot Size: 5,101 Region: Andalucía
Looking for a new project? Discover this magnificent historic watermill, just 24km from Ronda. This beautiful property combines character, history, and modern comfort in an idyllic natural (...)
€895,000
TSEA5139811
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 310 Lot Size: 708 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 310 Lot Size: 708 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Andalusian Villa with Panoramic Sea Views – Buenavista, Mijas,
Nestled within the prestigious Buenavista urbanisation on the slopes of Mijas, this meticulously maintained villa combines (...)
€650,000
TSEA5139805
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 262 Lot Size: 180 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 262 Lot Size: 180 Area: Casares Region: Andalucía
MAGNIFICENT 3-BEDROOM SEMI-DETACHED HOUSE WITH LARGE GARDEN 30 METERS FROM THE BEACH
Excellently located in a beachfront development with access to the Coastal Path that connects the entire Costa del (...)
€455,000
TSEA5139772
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 5 Baths: 2 M2: 161 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 2 M2: 161 Area: Benalmadena Region: Andalucía
Spacious 5-Bedroom House with Flexible Layout and Mountain Views – Arroyo de la Miel
Located in the popular town of Arroyo de la Miel, this 5-bedroom property offers generous space and a versatile (...)
€235,000
TSEA5139712
- Estacion de Cartama, Costa Del Sol, Cartama
Beds: 3 Baths: 1 M2: 98 Lot Size: 7,000 Area: Cartama Region: Andalucía
Beds: 3 Baths: 1 M2: 98 Lot Size: 7,000 Area: Cartama Region: Andalucía
Finca - Cortijo, Estacion de Cartama, Costa del Sol.
3 Bedrooms, 1 Bathroom, Built 99 m², Garden/Plot 7000 m².
Cortijo located in the mountains, opposite the village of Cártama, (Málaga).
2.5 (...)
Current Featured Properties
€1,900,000
TSEA5005987
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 8 M2: 480 Lot Size: 1,878 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 8 M2: 480 Lot Size: 1,878 Area: Benahavis Region: Andalucía
ELEGANT VILLA WITH LARGE PLOT WITH SEA VIEWS AND SPA AREA
Fantastic villa with an elegant Mediterranean style, located in a quiet and private area next to San Pedro de Alcántara, La Quinta, Monte (...)
€4,600,000
TSEA4679626
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 5 M2: 474 Lot Size: 11 Area: Estepona Region: Andalucía
Beds: 4 Baths: 5 M2: 474 Lot Size: 11 Area: Estepona Region: Andalucía
Located in a picturesque and coveted setting amidst nature's splendour, This luxury development comprises a collection of twelve sophisticated and exclusive villas boasting contemporary aesthetics. (...)
€7,900,000
TSEA4328788
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 12 M2: 348 Lot Size: 814 Area: Marbella Region: Andalucía
Beds: 7 Baths: 12 M2: 348 Lot Size: 814 Area: Marbella Region: Andalucía
This is a collection of six exclusive luxury villas in the Cascada de Camojan urbanization, in the surroundings of Sierra Blanca, in the heart of Marbella's Golden Mile. The homes will be located (...)
