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 241 - 260 of 2740 €4,000,000
TSEA5135635
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 6 Baths: 9 M2: 654 Lot Size: 2,097 Area: Marbella Region: Andalucía
Beds: 6 Baths: 9 M2: 654 Lot Size: 2,097 Area: Marbella Region: Andalucía
Located in Los Altos de los Monteros, Villa Los Altos is a stunning five-bedroom property spread across three levels, offering awe-inspiring views of the Mediterranean Sea and the African (...)
€2,950,000
TSEA5135599
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 580 Lot Size: 2,385 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 580 Lot Size: 2,385 Area: Estepona Region: Andalucía
Timeless Elegance on the New Golden Mile's Frontline Golf
Welcome to this exquisite four-bedroom residence in El Paraíso, set in the very heart of the prestigious New Golden Mile one of the Costa (...)
€1,995,000
TSEA5135491
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 430 Lot Size: 1,140 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 430 Lot Size: 1,140 Area: Estepona Region: Andalucía
Modern beachside Villa for sale on the New Golden Mile between Marbella and Estepona
Discover this modern luxury villa for sale in the New Golden Mile, Estepona, perfectly located between Marbella (...)
€370,000
TSEA5135440
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 141 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 141 Area: Estepona Region: Andalucía
Spacious townhouse set within a private well maintained gated community in Bel Air. Recently renovated property featuring an open plan kitchen, good size lounge with a fireplace, w.c., 3 bedrooms and (...)
€1,550,000
TSEA5135377
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 560 Lot Size: 1,025 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 560 Lot Size: 1,025 Area: Marbella Region: Andalucía
High-Quality Villa with Sea Views in a Quiet, Central Marbella Location.
Discover the perfect blend of peace and convenience in this exquisite, high-quality villa, ideally situated in a tranquil yet (...)
€235,000
TSEA5135368
- San Enrique, Costa Del Sol, Sotogrande
Beds: 2 Baths: 1 M2: 109 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 1 M2: 109 Area: Sotogrande Region: Andalucía
Single-story home. It has 109 m² of built area and a 100 m² outdoor patio, with a garage.
Fully furnished kitchen, appliances such as a refrigerator, washing machine, gas stove, and hot water (...)
€679,000
TSEA5135173
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 228 Lot Size: 826 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 228 Lot Size: 826 Area: Mijas and Mijas Costa Region: Andalucía
Stunning 4-Bedroom 3-bathroom Villa for Sale in Cerros del Águila
This spacious and versatile 4-bedroom, 3-bathroom villa is located in the peaceful and sought-after area of Cerros del Águila. (...)
€595,000
TSEA5135164
- Manilva, Costa Del Sol, Manilva
Beds: 5 Baths: 4 M2: 259 Lot Size: 1,200 Area: Manilva Region: Andalucía
Beds: 5 Baths: 4 M2: 259 Lot Size: 1,200 Area: Manilva Region: Andalucía
***Stunning Character Villa in Princesa Kristina, Duquesa*** Nestled in the desirable residential area of Princesa Kristina, Duquesa, this exceptional character villa offers elegant living with a (...)
€545,000
TSEA5134963
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 4 M2: 242 Lot Size: 30 Area: Manilva Region: Andalucía
Beds: 4 Baths: 4 M2: 242 Lot Size: 30 Area: Manilva Region: Andalucía
Unique Townhouse with Stunning Panoramic Sea Views.
This bright property is spread over four levels.
Ground Floor
A spacious living/dining area, a large fully fitted kitchen, a guest toilet, and two (...)
€1,595,000
TSEA5134954
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 4 M2: 565 Lot Size: 966 Area: Manilva Region: Andalucía
Beds: 4 Baths: 4 M2: 565 Lot Size: 966 Area: Manilva Region: Andalucía
New Development: Prices from 1,595,000 € to 1,595,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 565.00 m2 - 565.00 m2]
Set in an exclusive elevated position in Punta Chullera, this (...)
€1,690,000
TSEA5134837
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 316 Lot Size: 495 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 316 Lot Size: 495 Area: Estepona Region: Andalucía
Villa for sale in , Estepona with 5 bedrooms, 3 bathrooms, 2 en suite bathrooms, 1 toilet and with orientation west, with private swimming pool, private garage (1 parking spaces) and private garden. (...)
€495,000
TSEA5134831
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M2: 147 Lot Size: 600 Area: Coin Region: Andalucía
Beds: 4 Baths: 2 M2: 147 Lot Size: 600 Area: Coin Region: Andalucía
Renovated Villa with Pool & Mountain Views – Prime Location Between Coín & Alhaurín el GrandeLocated in one of the most desirable urbanisations in the area, this south facing charming (...)
€1,675,000
TSEA5134810
- Casares, Costa Del Sol, Casares
Beds: 5 Baths: 3 M2: 408 Lot Size: 981 Area: Casares Region: Andalucía
Beds: 5 Baths: 3 M2: 408 Lot Size: 981 Area: Casares Region: Andalucía
Wake up to endless horizons in this contemporary Mediterranean retreat, a home where clean modern design meets the timeless beauty of the sea.
Beyond the striking double gates, a cobbled driveway (...)
€540,000
TSEA5134789
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 177 Lot Size: 41 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 177 Lot Size: 41 Area: Fuengirola Region: Andalucía
This exceptional large corner townhouse offers space, comfort, and versatility for the entire family.
On the lower level, you'll find a generous 52 m² entertainment room, ideal for conversion into (...)
€450,000
TSEA5134780
- Arenas, Costa Del Sol East
Beds: 3 Baths: 2 M2: 120 Lot Size: 2,796 Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Lot Size: 2,796 Region: Andalucía
Exclusive Villa with Panoramic Views in Arenas (Málaga)
This beautiful villa is located on Mount Bentomiz in Arenas, Málaga, just 15 minutes from the coastal town of Torre del Mar and a 45-minute (...)
€3,800,000
TSEA5134450
- Atalaya, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 734 Lot Size: 1,843 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 734 Lot Size: 1,843 Area: Estepona Region: Andalucía
This Villa is a captivating Mediterranean residence ideally situated in the sought-after enclave of Atalaya, just 400 metres from the prestigious Atalaya Golf Club. Drawing inspiration from classic (...)
€475,000
TSEA5134435
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Discover this bright and welcoming semi-detached townhouse featuring:
Accommodations: 3 spacious bedrooms, 2 full bathrooms, and an additional guest toilet.
Orientation & Views: South-facing (...)
€425,000
TSEA5134426
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 5 Baths: 3 M2: 143 Lot Size: 168 Area: Nerja and Malaga East Region: Andalucía
Beds: 5 Baths: 3 M2: 143 Lot Size: 168 Area: Nerja and Malaga East Region: Andalucía
Property with apartment and premises in the center of Nerja, an exceptional investment opportunity.
This is a golden opportunity to acquire a two-story property in the center of Nerja,
where you (...)
€450,000
TSEA5134414
- Almogía, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 160 Lot Size: 2,500 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Lot Size: 2,500 Area: Malaga Region: Andalucía
Lion Hill – Luxury Villa with Private Pool and Panoramic Views
Lion Hill is a luxury villa with a private pool and panoramic views, located just a 10-minute drive from the charming villages of (...)
€1,875,000
TSEA5134288
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 4 M2: 306 Lot Size: 550 Area: Estepona Region: Andalucía
Beds: 6 Baths: 4 M2: 306 Lot Size: 550 Area: Estepona Region: Andalucía
A modern south facing 6-bedroom frontline golf villa located in El Campanario, Estepona East, within a short drive of beaches, a variety of golf courses, San Pedro de Alcantara, Puerto Banus and (...)
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, (...)
€483,000
TSEA3980794
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
NESTLED BETWEEN STUNNING LANDSCAPE GARDENS!!
An exclusive development of 46 townhouses of 2, 3 and 4 bedrooms, some of them semi-detached, built in a contemporary style, in a privileged location two (...)
€1,695,000
TSEA5107642
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 3 M2: 200 Lot Size: 1,000 Area: Casares Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Lot Size: 1,000 Area: Casares Region: Andalucía
BEAUTIFULLY DESIGNED LUXURY VILLA FRONT-LINE CASARES GOLF COURSE
BUILDING LICENSE GRANTED
Close to Finca Cortesin Golf and a 5-star hotel. An independent, energy-efficient and sustainably ready to (...)
