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 (48,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 (48,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 (48,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 2621 - 2640 of 2656 €1,995,000
TSEA2608520
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 4 M2: 380 Lot Size: 4,700 Area: Estepona Region: Andalucía
Beds: 6 Baths: 4 M2: 380 Lot Size: 4,700 Area: Estepona Region: Andalucía
This country villa located on the new golden mile has stunning views to the sea,set on a hill
it is very private with a large mature garden,as well as an indoor garage for 13 cars.
The property has (...)
€3,500,000
TSEA2607917
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 4 M2: 600 Lot Size: 1,080 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 4 M2: 600 Lot Size: 1,080 Area: Marbella West Region: Andalucía
Charming 5 bed villa situated in the heart of the Luxurious Puerto Banús area, close to the Casino and all amenities
Long Term- from September
Property:
High quality built villa with outstanding (...)
€1,200,000
TSEA2598008
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 200 Lot Size: 2,800 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 200 Lot Size: 2,800 Area: Estepona Region: Andalucía
Very special bungalow villa on 2800 square meters land in Estepona. 1600 square meters are built up area. All on one level and beautiful panoramic views of the Mediterranean. Huge eat-in kitchen with (...)
€6,500,000
TSEA2576927
- Costabella, Costa Del Sol, Marbella East
Beds: 6 Baths: 4 M2: 436 Lot Size: 750 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 4 M2: 436 Lot Size: 750 Area: Marbella East Region: Andalucía
Stunning Frontline Beach 6 Bedroom 4 Bathroom Contemporary villa, located right on the beach at Costabella, East Marbella and only a 10 minute drive to the centre of Marbella and Puerto Banus.
The (...)
€895,000
TSEA2573192
- El Padron, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 311 Lot Size: 1,118 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 311 Lot Size: 1,118 Area: Estepona Region: Andalucía
Located just a few minutes away from all services, beach and the center of Estepona, this wonderfull contemporary (rustic style) villa, would be the ideal investment for those seeking for a home (...)
€2,660,000
TSEA2550770
- Ronda, Costa Del Sol, Ronda
Beds: 10 Baths: 8 M2: 992 Lot Size: 194,607 Area: Ronda Region: Andalucía
Beds: 10 Baths: 8 M2: 992 Lot Size: 194,607 Area: Ronda Region: Andalucía
Opportunity!
Andalusian Cortijo with wonderful panoramic views, 5.000 olives trees, excellent road access, 3 separate Bungalows and 10 stables, on an impressive flat and fully fenced plot of almost (...)
€1,200,000
TSEA2545199
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 154 Lot Size: 628 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 154 Lot Size: 628 Area: Marbella East Region: Andalucía
A nice rustic style villa, well located for either relocation or a holiday home in a pleasant area that is within walking distance to shops, restaurants, schools and the beach.
It's usual to find (...)
€1,700,000
TSEA2509538
- Churriana, Costa Del Sol, Malaga
Beds: 5 Baths: 3 M2: 300 Lot Size: 10,000 Area: Malaga Region: Andalucía
Beds: 5 Baths: 3 M2: 300 Lot Size: 10,000 Area: Malaga Region: Andalucía
Country house for sale in Churriana , Málaga with 10.000square meters located between Malaga and Torremolinos. This lovely house is not far away from the Malaga International Airport. It is situated (...)
€1,490,000
TSEA2422430
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 350 Lot Size: 2,850 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 350 Lot Size: 2,850 Area: Estepona Region: Andalucía
Wonderful Andalusian villa consisting of 3000 meters of land, located in one of the best developments in Estepona "Don Pedro". The villa has its own swimming pool, tennis court, 5 bedrooms (...)
€2,995,000
TSEA2386847
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 481 Lot Size: 1,300 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 481 Lot Size: 1,300 Area: San Pedro Region: Andalucía
Brand new contemporary villa for sale in Guadalmina Baja, Marbella Costa del Sol.
This stunning south facing villa is very close to the Guadalmina Golf Course, 350 meters distance to the beach, (...)
€1,378,000
TSEA2379206
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 4 M2: 328 Lot Size: 1,024 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 4 M2: 328 Lot Size: 1,024 Area: Marbella East Region: Andalucía
Big modern villa, with spectacular mountain views. Set in a magical cork oak forest.
328 m square. 1024 m plot.
Solar heated infinity pool, big wooden deck around the pool, big terrace upstairs next (...)
€2,725,000
TSEA2323622
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 470 Lot Size: 1,000 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 470 Lot Size: 1,000 Area: Benahavis Region: Andalucía
This stunning Mediterranean villa is situated within one of the most exclusive private estates in the Marbella area. Los Arqueros Golf is a mature gated community with 24 hour security. It has it's (...)
€1,900,000
TSEA457566
- Coín, Costa Del Sol, Coin
Beds: 6 Baths: 2 M2: 893 Lot Size: 75,000 Area: Coin Region: Andalucía
Beds: 6 Baths: 2 M2: 893 Lot Size: 75,000 Area: Coin Region: Andalucía
EQUESTRIAN Centre
. Loads of POTENTIAL
. Excellent communication links
. Close to the popular town of Coin
. Close to many TAPAS Bars
. Walking distance to local bar-restaurant
. EXPERIENCE THE (...)
€1,600,000
TSEA2308304
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 614 Lot Size: 2,233 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 614 Lot Size: 2,233 Area: Marbella Region: Andalucía
Impressive independent villa with very large spaces built on one floor and located near the center of Marbella.
Elegant Mediterranean-style villa built in 1986 with vast spaces in all its rooms, (...)
€3,200,000
TSEA2171156
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 350 Lot Size: 31,000 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 350 Lot Size: 31,000 Area: Marbella East Region: Andalucía
UNIQUE VILLA IN SPECTACULAR SETTING
Delightful Villa situated in an area of natural beauty, in one of the most private areas close to Marbella situated on 31.000m² of rural paradise in Elviria and (...)
€3,000,000
TSEA2139857
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 10 Baths: 10 M2: 658 Lot Size: 2,780 Area: Benalmadena Region: Andalucía
Beds: 10 Baths: 10 M2: 658 Lot Size: 2,780 Area: Benalmadena Region: Andalucía
Special opportunity to acquire a very large property with separate outbuildings and very generous grounds, all within close proximity to the charming Pueblo of Benalmádena. Fitted with champagne (...)
€10,000,000
TSEA2133839
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 610 Lot Size: 8,400 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 610 Lot Size: 8,400 Area: Estepona Region: Andalucía
PRICE REDUCED FROM €11.000.000 ! A magnificent beachfront estate ideal for development of up to 4 beachfront villas located within walking distance to Estepona port, consisting of two large plots (...)
€4,500,000
Villa privately situated in prestigious area just 5 minutes walk from the beach and golf club
- Los Monteros, Costa Del Sol, Marbella East
Beds: 6 Baths: 5 M2: 450 Lot Size: 1,000 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 5 M2: 450 Lot Size: 1,000 Area: Marbella East Region: Andalucía
Privately situated villa in the prestigious Los Monteros offering 6 bedrooms with 5 bathrooms and a total constructed area 450 square meters on a plot of 1.000 square meters. Just a 5 minute walk to (...)
€1,850,000
TSEA1954860
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 470 Lot Size: 2,100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 470 Lot Size: 2,100 Area: Mijas and Mijas Costa Region: Andalucía
Situated near the charming white village of Mijas Pueblo, this elegant villa offers a rare blend of traditional character and refined luxury. With breathtaking views stretching from the Mediterranean (...)
€2,200,000
TSEA1939148
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 650 Lot Size: 4,450 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 650 Lot Size: 4,450 Area: Estepona Region: Andalucía
Private Estate of 4,250 m²** with a swimming pool, covered parking, sea-view lookout, barbecue oven, and terrace with views. The house spans 650 m² over three floors: equipped kitchen, living room, (...)
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, (...)
€559,500
TSEA5019097
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 4 M2: 161 Lot Size: 500 Area: Manilva Region: Andalucía
Beds: 3 Baths: 4 M2: 161 Lot Size: 500 Area: Manilva Region: Andalucía
Charming South-Facing Villa in Peaceful Manilva – Where Comfort Meets Coastal Living
Welcome to your new sanctuary in the heart of Manilva, a quiet and picturesque corner of the Costa del Sol. This (...)
€1,645,000
TSEA4719550
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M2: 418 Lot Size: 10,000 Area: Casares Region: Andalucía
Beds: 4 Baths: 4 M2: 418 Lot Size: 10,000 Area: Casares Region: Andalucía
STUNNING VILLA IN CASARES WITH BREATHTAKING VIEWS.
This magnificent villa is located in the beautiful landscape of Casares, offering a perfect blend of elegance and modern luxury. Set on a spacious (...)
