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 (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
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.approved = 1 AND pm.cat_id IN (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
GROUP BY p.id
ORDER BY p.created DESC
Results 7421 - 7440 of 7581
Control your home with your smart device!
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 371 Lot Size: 323 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 371 Lot Size: 323 Area: Benahavis Region: Andalucía
ULTIMATE IN DESIGNER LIVING IN BEAUTIFUL MARBELLA!!!
Villas in a unique project with an emphasis on design to meet the requirements of the most demanding client. Located on a privileged plot, the (...)
TSEA3397030
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 7 M2: 173 Lot Size: 980 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 7 M2: 173 Lot Size: 980 Area: Mijas and Mijas Costa Region: Andalucía
AN IMPRESSIVE, UNIQUE AND ORIGINAL VILLA WHICH IS TOTALLY FRONT-LINE BEACH IN EL CHAPARRAL WITH PRIVATE DIRECT ACCESS TO THE BEACH. IT HAS BEEN DESIGNED TO REPLICATE A BOAT WITH THE RESULTING (...)
TSEA3378064
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 4 M2: 700 Area: Estepona Region: Andalucía
Beds: 1 Baths: 4 M2: 700 Area: Estepona Region: Andalucía
Magnificent large industrial warehouse in the industrial estate of Estepona.
This warehouse is divided into two floors and the total surface is 700m.
On the ground floor there is a large open area (...)
TSEA3377995
- Coín, Costa Del Sol, Coin
Beds: 1 Baths: 1 M2: 376 Area: Coin Region: Andalucía
Beds: 1 Baths: 1 M2: 376 Area: Coin Region: Andalucía
Local about 376 m2 useful approximately, very large, toilet, office, needs cleaning, formerly was a factory, in the commercial area around the center.
IN THE PRICE IS NOT INCLUDED EXPENSES OR TAXES.
TSEA3377023
- Alora, Costa Del Sol, Älora
Beds: 3 Baths: 2 M2: 115 Lot Size: 10,000 Area: Älora Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Lot Size: 10,000 Area: Älora Region: Andalucía
Complete privacy and TRANQUILITY
. Perfect spot for a retreat
. Disconnect ......
Tucked away between low hills, this finca takes the word "hideaway" to its highest level.
Though there (...)
TSEA3370573
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 340 Lot Size: 970 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 340 Lot Size: 970 Area: Marbella Region: Andalucía
Unique, south facing villa with panoramic sea views .
Situated in a very peaceful and green hills of Marbella town .It is a perfect location for all year around living ,walking distance to a few well (...)
PALATIAL REFORMED VILLA, WALK TO THE BEACHES
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 8 Baths: 8 M2: 900 Area: San Pedro Region: Andalucía
Beds: 8 Baths: 8 M2: 900 Area: San Pedro Region: Andalucía
PALATIAL REFORMED VILLA, WALK TO THE BEACHES!!!
A totally reformed substantial palatial Arabian styled villa which offers 8 BEDROOM SUITES which incorporate 2 self-contained suites. The villa has (...)
TSEA3367234
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 5 M2: 1,080 Lot Size: 600 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 5 M2: 1,080 Lot Size: 600 Area: Mijas and Mijas Costa Region: Andalucía
Elegant Villa for Sale in Mijas Costa – Where Style Meets Lifestyle
If you've been dreaming of a luxury escape on Spain's sun-drenched Costa del Sol, this magnificent villa in Mijas Costa could be (...)
TSEA3363418
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 155 Lot Size: 832 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 155 Lot Size: 832 Area: Marbella East Region: Andalucía
Grand independent villa overlooking the Cabopino Golf course with panoramic views from the very expansive roof terrace. 3 fully fitted bedrooms with built in wardrobes and views from every room. The (...)
TSEA3362716
- Tolox, Costa Del Sol, Yunquera
Beds: 3 Baths: 2 M2: 156 Area: Yunquera Region: Andalucía
Beds: 3 Baths: 2 M2: 156 Area: Yunquera Region: Andalucía
MOVE-IN Ready
. Set in a pueblo close to the NATIONAL Park
. TRADITIONAL Spanish Environment
. Garage
. Double Glazing
. Close to many TAPAS Bars
Come and visit the hills of Tolox to view this (...)
TSEA3362083
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 108 Lot Size: 150 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Lot Size: 150 Area: San Pedro Region: Andalucía
Unique Investment Opportunity – Possible 4-Story Project
Located in the heart of San Pedro de Alcántara, this semi-detached house offers enormous development potential, with the possibility of (...)
TSEA3332437
- El Borge, Costa Del Sol East
Beds: 1 Baths: 1 M2: 84 Lot Size: 86,900 Region: Andalucía
Beds: 1 Baths: 1 M2: 84 Lot Size: 86,900 Region: Andalucía
This nice farm has a total extension of 86.900 m2 and has two sheds from 42 m2 each, also boasts 300 mangos, 100 avocado and along the entrance lane about 100 trees of tangerines. The property also (...)
TSEA3340210
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 90 Lot Size: 1,600 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 90 Lot Size: 1,600 Area: Marbella Region: Andalucía
Great little finca just minutes from San Pedro, set on a plot of 1600 m2 with an abundance of fruit trees and its own well, this 2 bedroom properties is perfect for nature lovers and very close to (...)
TSEA3339724
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 430 Lot Size: 1,000 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 430 Lot Size: 1,000 Area: Marbella Region: Andalucía
Modern five bedroom villa located steps to the beach,close to restaurants beachclubs and a short drive
to Marbella town centre.
TSEA3336544
- Casares Pueblo, Costa Del Sol, Casares
Beds: 17 Baths: 18 M2: 831 Area: Casares Region: Andalucía
Beds: 17 Baths: 18 M2: 831 Area: Casares Region: Andalucía
Charming hotel located in Casares, where you can see the white silhouette of its houses perched on the hillside. Its geographical location, between the Serrania de Ronda, the Strait of Gibraltar and (...)
TSEA3333502
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 8 Baths: 8 M2: 900 Lot Size: 4,100 Area: San Pedro Region: Andalucía
Beds: 8 Baths: 8 M2: 900 Lot Size: 4,100 Area: San Pedro Region: Andalucía
A totally reformed substantial palatial Arabian styled villa which offers eight-bedroom suites which incorporate 2 self-contained suites. The villa has four-meter height impressive double entrance (...)
TSEA3332302
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 2 M2: 129 Lot Size: 71 Area: Marbella Region: Andalucía
Beds: 5 Baths: 2 M2: 129 Lot Size: 71 Area: Marbella Region: Andalucía
Traditional Andalousian townhouse with charm in the heart of Marbella Old town, a stone's throw from the Orange Square and next to restaurants and shops.
The house is built on two floors, has an (...)
TSEA3330436
- San Martín de Tesorillo, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 200 Lot Size: 28,000 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Lot Size: 28,000 Area: Sotogrande Region: Andalucía
Incredible 28,000 square meters estate located in San Enrique del Tesorillo. This wonderful estate consists of a house of 200 square meters with outdoor garage, composed of three bedrooms, large (...)
TSEA3329614
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 7 Baths: 7 M2: 1,000 Lot Size: 4,500 Area: San Pedro Region: Andalucía
Beds: 7 Baths: 7 M2: 1,000 Lot Size: 4,500 Area: San Pedro Region: Andalucía
Detached Villa, Guadalmina Baja, Costa del Sol.
Built 1000 m², Terrace 250 m², Garden/Plot 4500 m².
Setting : Commercial Area, Beachside, Close To Golf, Close To Shops, Close To Sea, (...)
TSEA3329542
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 733 Lot Size: 6,860 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 733 Lot Size: 6,860 Area: Estepona Region: Andalucía
FANTASTIC VILLA OF HIGH ARCHITECTURAL LEVEL, on three floors with impressive panoramic views of the Mediterranean Sea and the mountains. Very exceptional details, such as its own winery, private (...)
