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,68,69,70)
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,68,69,70)
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,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1821 - 1840 of 2740 €2,475,000
TSEA4854190
- Pinares de San Antón, Costa Del Sol
Beds: 4 Baths: 3 M2: 309 Lot Size: 915 Region: Andalucía
Beds: 4 Baths: 3 M2: 309 Lot Size: 915 Region: Andalucía
Villa Acacia is a beautifully designed, newly built residence located in the prestigious Pinares de San Antón neighbourhood in the eastern part of Málaga. Developed by the renowned Cogitari Group, (...)
€3,800,000
TSEA4854184
- Pinares de San Antón, Costa Del Sol
Beds: 5 Baths: 4 M2: 391 Lot Size: 915 Region: Andalucía
Beds: 5 Baths: 4 M2: 391 Lot Size: 915 Region: Andalucía
Located in the prestigious gated community of Pinares Hills in Pinares de San Antón, Villa Arce is a striking example of modern architecture meeting Mediterranean tranquility. Set on a generous 915 (...)
€2,800,000
TSEA4854178
- Pinares de San Antón, Costa Del Sol
Beds: 4 Baths: 3 M2: 348 Lot Size: 920 Region: Andalucía
Beds: 4 Baths: 3 M2: 348 Lot Size: 920 Region: Andalucía
Introducing Villa Haya, a luxurious new development in the highly desirable gated community of Pinares Hills, nestled in the prestigious Pinares de San Antón area of Málaga Este. This modern (...)
€2,400,000
TSEA4854166
- Pinares de San Antón, Costa Del Sol
Beds: 4 Baths: 3 M2: 318 Lot Size: 869 Region: Andalucía
Beds: 4 Baths: 3 M2: 318 Lot Size: 869 Region: Andalucía
Set within the secure and highly desirable gated community of Pinares Hills in Pinares de San Antón, Villa Castaño offers a sophisticated lifestyle in the tranquil hills just minutes from Málaga's (...)
€2,750,000
TSEA4854160
- Pinares de San Antón, Costa Del Sol
Beds: 4 Baths: 3 M2: 341 Lot Size: 916 Region: Andalucía
Beds: 4 Baths: 3 M2: 341 Lot Size: 916 Region: Andalucía
Located in the prestigious Pinares Hills enclave within the gated community of Pinares de San Antón, Villa Cípres presents a rare opportunity to own a contemporary home just minutes from Málaga's (...)
€2,800,000
TSEA4854148
- Pinares de San Antón, Costa Del Sol
Beds: 4 Baths: 3 M2: 341 Lot Size: 914 Region: Andalucía
Beds: 4 Baths: 3 M2: 341 Lot Size: 914 Region: Andalucía
Villa Olivo is the first of its kind in the exclusive gated enclave of Pinares Hills, located within the sought-after neighbourhood of Pinares de San Antón, just north of Málaga City Centre. This (...)
€2,500,000
TSEA4853701
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 7 Baths: 5 M2: 697 Lot Size: 5,000 Area: Benalmadena Region: Andalucía
Beds: 7 Baths: 5 M2: 697 Lot Size: 5,000 Area: Benalmadena Region: Andalucía
Stunning 7-Bedroom Mansion in Carvajal
Location: Prime spot just minutes from the beach and local amenities, with no road noise!
This exquisite 7-bedroom, 5-bathroom mansion is nestled within (...)
€1,500,000
TSEA4853638
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 4 M2: 252 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 4 M2: 252 Area: Marbella East Region: Andalucía
This beautiful 3-bedroom, 4-bathroom modern townhouse is located right on the first line of Cabopino Golf Course, offering stunning sea views from every bedroom.
Spread over three levels, the home (...)
€2,100,000
TSEA4853425
- Pinares de San Antón, Costa Del Sol
Beds: 5 Baths: 3 M2: 487 Lot Size: 1,651 Region: Andalucía
Beds: 5 Baths: 3 M2: 487 Lot Size: 1,651 Region: Andalucía
Discover the charm of this unique, single-story villa nestled in the highly sought-after neighborhood of Pinares de San Antón. Set on a large, private plot, this property offers a tranquil escape (...)
€8,800,000
TSEA4853365
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 6 Baths: 8 M2: 1,906 Lot Size: 2,451 Area: Sotogrande Region: Andalucía
Beds: 6 Baths: 8 M2: 1,906 Lot Size: 2,451 Area: Sotogrande Region: Andalucía
This exceptional luxury home in La Reserva de Sotogrande blends modern architecture with sustainability, offering unparalleled comfort in a first-line golf course location with views of both the (...)
€2,285,000
TSEA4851694
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 5 M2: 504 Lot Size: 1,006 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 5 M2: 504 Lot Size: 1,006 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to beautiful new house, an exclusive oasis of luxury and serenity, offering breathtaking views and unmatched comfort. Nestled in a prime location, this stunning residential development (...)
€865,000
TSEA4851436
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 4 M2: 237 Lot Size: 356 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 4 M2: 237 Lot Size: 356 Area: Nerja and Malaga East Region: Andalucía
This charming villa is located in the peaceful urbanization of Fuente del Baden in Nerja, offering a perfect balance between space and comfort. Set on a 356.51 m² plot, it is ideal for those seeking (...)
€8,800,000
TSEA4851052
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 8 Baths: 10 M2: 1,742 Lot Size: 4,047 Area: Sotogrande Region: Andalucía
Beds: 8 Baths: 10 M2: 1,742 Lot Size: 4,047 Area: Sotogrande Region: Andalucía
Nestled in the heart of a tranquil cork-oak forestm within the serene embrace of Sotogrande in Altos de Valderrama, this two-story mansion stands as a symphony of luxury design and sustainable (...)
€2,500,000
TSEA4850854
- Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 200 Lot Size: 650 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 200 Lot Size: 650 Area: Marbella East Region: Andalucía
La Finca de Marbella 2 is a natural continuation of the phenomenal success of the La Finca de Marbella project. The new project includes 36 modern luxury villas, each on a separate plot with its own (...)
€374,900
TSEA4850842
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 170 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 170 Area: Mijas and Mijas Costa Region: Andalucía
Townhouse in the heart of Las Lagunas de Mijas, in the Doña Ermita area.
Discover your new home in Las Lagunas de Mijas! This charming townhouse in the Doña Ermita area offers you everything you (...)
€599,000
TSEA4849948
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 165 Lot Size: 980 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 165 Lot Size: 980 Area: Manilva Region: Andalucía
South Facing Villa / Bungalow situated on a large corner plot,
Detached Villa, Manilva, Costa del Sol.
4 Bedrooms, 3 Bathrooms, Built 165 m², Terrace 60 m², Garden/Plot 980 m².
Setting : (...)
€2,970,000
TSEA4407826
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 4 M2: 280 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 4 M2: 280 Area: Fuengirola Region: Andalucía
New Development: Prices from 2,970,000 € to 3,960,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 280.00 m2 - 400.00 m2]
Where architecture and nature merge in a dream project in southern (...)
€659,000
TSEA4849066
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 320 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 320 Area: Estepona Region: Andalucía
!!! NEW ON THE MARKET!!!
Beautiful four-story townhouse, with three large rooms, located in the La Reserva de Atalaya urbanization made up of 20 semi-detached homes.
Magnificent urbanization, with (...)
€1,998,000
TSEA4848973
- El Paraiso, Costa Del Sol, Estepona
Beds: 5 Baths: 4 M2: 235 Lot Size: 1,065 Area: Estepona Region: Andalucía
Beds: 5 Baths: 4 M2: 235 Lot Size: 1,065 Area: Estepona Region: Andalucía
Purchase Opportunity in Paraíso Alto.
Located in Paraíso Alto, between Marbella and Estepona, this villa combines the timeless charm of Andalusian style with a touch of modernity. The white walls (...)
€1,275,000
TSEA4848967
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 320 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 320 Area: Marbella East Region: Andalucía
Stunning Luxury 4-Story Townhouse
Discover this modern, luxury 3-bedroom, semi-detached townhouse that offers everything you've ever dreamed of, from magnificent panoramic views to exceptional (...)
Current Featured Properties
€1,250,000
TSEA5115490
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
NEW DEVELOPMENT – Elegance and Exclusivity on the Costa del Sol!
Discover this new luxury project, a prestigious complex of 14 independent villas located in an exceptional setting in Estepona, (...)
€8,096,900
TSEA4372201
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 583 Lot Size: 1,150 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 583 Lot Size: 1,150 Area: Benahavis Region: Andalucía
This is a luxury residential complex of 53 unique 4, 5 villas sitting gently on the side of a hill, with every villa standing on a different height. The prestigious position is over looking the (...)
€1,500,000
TSEA4689550
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 341 Lot Size: 31 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 341 Lot Size: 31 Area: Marbella West Region: Andalucía
The projects itself as an exclusive residential complex of 15 spacious semi-detached homes, with boutique- style amenities - a fully equipped gym, spa and outdoor swimming pool - enjoying spectacular (...)
