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 (42,36,37,38)
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 (42,36,37,38)
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 (42,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 121 - 140 of 2008 €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 (...)
€254,500
TSEA5141122
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 27 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 27 Area: Mijas and Mijas Costa Region: Andalucía
This beachfront studio apartment is an excellent opportunity for those seeking a property in a prime location. The apartment is south-east facing, offering spectacular views of the Mediterranean, the (...)
€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 (...)
€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 (...)
€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 (...)
€1,900,000
TSEA5139067
- Los Monteros, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 172 Lot Size: 723 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 172 Lot Size: 723 Area: Marbella East Region: Andalucía
INVESTMENT OPPORTUNITY
Elegant one-storey villa set within the exclusive Los Monteros urbanisation.
Located in the prestigious gated community of Los Monteros, just steps from Marbella's finest (...)
€1,200,000
TSEA5139046
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 467 Lot Size: 796 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 467 Lot Size: 796 Area: Estepona Region: Andalucía
Exceptional Opportunity to Build Your Dream Villa in Valle Romano
Discover a rare chance to create your perfect home in the exclusive and highly sought-after private urbanization of Valle Romano. (...)
Current Featured Properties
€1,750,000
Detached Villa in Benahavis
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 372 Lot Size: 626 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 372 Lot Size: 626 Area: Benahavis Region: Andalucía
AMAZING VIEWS THAT GO ON FOREVER!!!.
This contemporary Mediterranean style villa on the frontline GOLF COURSE of Atalaya with fantastic sea views and views to Gibraltar. 626m2 plot at one level, (...)
€2,300,240
Detached Villa in Mijas
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
NO MORE NEED TO DREAM ABOUT THE PERFECT VIEW!!!
This upscale development with the best views in Fuengirola and Mijas consists of thirteen individual villas, each offering no less than four en-suite (...)
€1,500,000
TSEA4563568
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 581 Lot Size: 1,420 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 581 Lot Size: 1,420 Area: Mijas and Mijas Costa Region: Andalucía
Situated on a plot of 1,420 m², this single-family home offers unparalleled panoramic views of the sea and the mountains. Surrounded by a landscaped garden area, the property has large terraces at (...)
