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 7321 - 7340 of 7581
TSEA3830872
- 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
Mediterranean style villa on the frontline golf course of Atalaya with fantastic sea views and views to Gibraltar. 626m2 plot at one level, splendid garden, private pool and whirlpool. From the main (...)
TSEA3830236
- Coín, Costa Del Sol, Coin
Beds: 8 Baths: 12 M2: 1,263 Lot Size: 13,640 Area: Coin Region: Andalucía
Beds: 8 Baths: 12 M2: 1,263 Lot Size: 13,640 Area: Coin Region: Andalucía
Exceptional Finca with guest apartment and stables located in Coin.
Main house is distributed as follow:
Entrance hall, guest toilet, separate fully equipped kitchen, dining room with fireplace, (...)
TSEA3812308
- Torrox, Costa Del Sol East
Beds: 3 Baths: 2 M2: 120 Lot Size: 120 Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Lot Size: 120 Region: Andalucía
Traditional village house in a quiet and charming location in the historic center of Torrox. The main square, the health center, banks and stores are within 15 minutes walking distance. There is a (...)
TSEA3811231
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 2 Baths: 1 M2: 44 Area: Manilva Region: Andalucía
Beds: 2 Baths: 1 M2: 44 Area: Manilva Region: Andalucía
Commercial premises on the corner with large windows facing the street.
Very busy area.
Commercial Premises, San Luis de Sabinillas, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 60 m².
Setting : (...)
TSEA3811195
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 103 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: Mijas and Mijas Costa Region: Andalucía
FRONT LINE GOLF PENTHOUSE WITH SEA VIEW!! No other apartment at that floor! This beautiful brand new three-bedroom penthouse stands out for its contemporary style and quality design, it is built with (...)
TSEA3800587
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 70 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 70 Area: Marbella West Region: Andalucía
Nice one bedroom apartment for sale is located in the best area of Nueva Andalucía a few minutes walk from Puerto Banus and all amenities such as shops, bars, restaurants. T
he apartment is in (...)
TSEA3797722
- Hacienda Las Chapas, Costa Del Sol, Marbella East
Beds: 6 Baths: 4 M2: 558 Lot Size: 2,000 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 4 M2: 558 Lot Size: 2,000 Area: Marbella East Region: Andalucía
Completely refurbished family villa located in Hacienda las Chapas, one of the most exclusive residential areas of Marbella, close to beaches, natural park, nightlife and services.
The southern (...)
TSEA3795868
- Coín, Costa Del Sol, Coin
Beds: 6 Baths: 3 M2: 803 Lot Size: 74,000 Area: Coin Region: Andalucía
Beds: 6 Baths: 3 M2: 803 Lot Size: 74,000 Area: Coin Region: Andalucía
This country house is at PARTIDO GUARO VIEJO, 29130, Coín, Málaga. It is a country house that has 803 m2 and has 6 rooms and 3 bathrooms. Actually it are 2 houses on top of each other with an own (...)
TSEA3795283
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 567 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 567 Area: Benahavis Region: Andalucía
This is an investment opportunity to purchase this amazing piece of Real Estate, under the Municipal of Benahavis. The property has been ran as a very successfull Restaurant for over 40 years, but (...)
TSEA3794710
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 3 M2: 450 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 3 M2: 450 Area: Alhaurin el Grande Region: Andalucía
A magnificent house located in Alhaurin el Grande town centre, Costa del Sol
Consisting of four floors with the possibility of making a pool on the top floor
- Ground floor: entrance hall and (...)
TSEA3794389
- Cortes de la Frontera, Costa Del Sol, Ronda
Beds: 3 Baths: 2 M2: 246 Lot Size: 12,100 Area: Ronda Region: Andalucía
Beds: 3 Baths: 2 M2: 246 Lot Size: 12,100 Area: Ronda Region: Andalucía
This lovely finca style in Cortes de la Frontera offers the perfect combination of size, quality, tranquility and much more only kilometers inland from the busy coast. Take flight from your home town (...)
TSEA3792964
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 17 Baths: 10 M2: 773 Lot Size: 4,078 Area: Torremolinos Region: Andalucía
Beds: 17 Baths: 10 M2: 773 Lot Size: 4,078 Area: Torremolinos Region: Andalucía
Unique Property with Tremendous Potential in an Exclusive Location!
Strategically situated between Málaga and Torremolinos, this property boasts an expansive plot of 4,078 m², surrounded by olive (...)
TSEA3787210
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 9 Baths: 10 M2: 1,089 Lot Size: 3,965 Area: Alhaurin el Grande Region: Andalucía
Beds: 9 Baths: 10 M2: 1,089 Lot Size: 3,965 Area: Alhaurin el Grande Region: Andalucía
¡GREAT INVESTMENT OPPORTUNITY! This private villa is about 70% completed and could also be used as a Boutique hotel or bed & breakfast. There are lots of possibilities with a build size of (...)
TSEA3784570
- Torrox, Costa Del Sol East
Beds: 2 Baths: 1 M2: 80 Lot Size: 30,000 Region: Andalucía
Beds: 2 Baths: 1 M2: 80 Lot Size: 30,000 Region: Andalucía
The property is 15 minutes from the coast and consists of a farmhouse of 82 m2 and a plot of land on terraces of 30,000 m2 of land, has good views of the sea and the mountains, very quiet area. (...)
TSEA3783982
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 161 Lot Size: 47 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 161 Lot Size: 47 Area: Marbella Region: Andalucía
Townhouse, Marbella, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 161 m², Terrace 27 m².
Setting : Town, Commercial Area, Close To Port, Close To Marina.
Orientation : South East.
Condition : (...)
TSEA3780094
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 4 M2: 382 Lot Size: 610 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 4 M2: 382 Lot Size: 610 Area: Marbella West Region: Andalucía
Location! Location! Location!
Large Mediterranean Villa with south orientation sea Views located in the upper part of Nueva Andalucía. The property has very easy access from the Main Street in (...)
TSEA3767719
- Arcos de la Frontera, Costa de la Luz
Beds: 6 Baths: 4 M2: 400 Lot Size: 2,435 Region: Andalucía
Beds: 6 Baths: 4 M2: 400 Lot Size: 2,435 Region: Andalucía
What a perfect location for Golf enthusiasts in Arcos Garden !!
This beautiful south facing villa is opposite the 17th hole of Arcos Golf, the Exclusive and spectacular golf course surrounded by a (...)
TSEA3761173
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 5 Baths: 5 M2: 450 Lot Size: 950 Area: Marbella Region: Andalucía
Beds: 5 Baths: 5 M2: 450 Lot Size: 950 Area: Marbella Region: Andalucía
This marvellous five bedroom family villa sits in the most prestigious resident hills of Marbella, in a quiet and private area, in Cascada de Camojan. Its design and decoration, in a mixture of (...)
TSEA3749149
- Las Brisas, Costa Del Sol, Marbella West
Beds: 6 Baths: 5 M2: 390 Lot Size: 1,653 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 5 M2: 390 Lot Size: 1,653 Area: Marbella West Region: Andalucía
Wonderful property with mountain views, near the Las Brisas Golf course!
Fabulous villa, built and designed in a contemporary style, with luxury purposes, high quality materials, designed to offer a (...)
TSEA3738733
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 152 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 152 Area: Marbella West Region: Andalucía
This is a High quality three bedrooms apartment on a first floor enjoy a fabulous location in the heart of the prestigious golf valley in Marbella, They are ideally situated within five minutes drive (...)
