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 7441 - 7460 of 7581
MORE THAN JUST A VILLA...A REFLECTION OF WHO YOU ARE !
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 602 Lot Size: 756 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 602 Lot Size: 756 Area: Benahavis Region: Andalucía
MORE THAN JUST A VILLA...A REFLECTION OF WHO YOU ARE!!!
A truly UNIQUE AND SPECIAL project. There is nowhere else quite like this. Designed especially for you where an authentic philosophy of life (...)
TSEA3319975
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 520 Lot Size: 2,188 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 520 Lot Size: 2,188 Area: Estepona Region: Andalucía
Estepona: Unique finca type property offered for sale, currently run as an events location and restaurant with living accommodation above. The ground floor has large outside area with bar, bbq area (...)
TSEA3313990
- Frigiliana, Costa Del Sol East
Beds: 2 Baths: 1 M2: 44 Lot Size: 14,797 Region: Andalucía
Beds: 2 Baths: 1 M2: 44 Lot Size: 14,797 Region: Andalucía
Situated just a 7 minutes drive from the beautiful mountain pueblo of Frigliana, this cortijo is surrounded by 15´000m2 of pristine avocado plantations.
Upon entering this property you are (...)
TSEA3306496
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 4 Baths: 4 M2: 358 Lot Size: 3,090 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 4 M2: 358 Lot Size: 3,090 Area: Sotogrande Region: Andalucía
Attractive and charming 4-bedroom Spanish-style villa, designed and built for the current owner/occupier to Northern European standards
Plot size 3,090 m2.
House built 385m2
Building completed in (...)
TSEA2964851
- Salares, Costa Del Sol East
Beds: 3 Baths: 4 M2: 300 Lot Size: 300 Region: Andalucía
Beds: 3 Baths: 4 M2: 300 Lot Size: 300 Region: Andalucía
Brand-new semi-detached house in Salares. The house has a large living room with fireplace and access to a terrace, spacious and fully equipped kitchen, it has three bedrooms with fitted wardrobes (...)
TSEA2425934
- Riogordo, Costa Del Sol East
Beds: 2 Baths: 1 M2: 167 Lot Size: 167 Region: Andalucía
Beds: 2 Baths: 1 M2: 167 Lot Size: 167 Region: Andalucía
Nice village house in Riogordo. Central location. Authentic country house. On the ground floor is a commercial space of 63.95m2. The house has 2 floors. It has living room with fireplace, 2 bedrooms (...)
TSEA3306343
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 120 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Benalmadena Region: Andalucía
Please be aware there is very limited outside space. Just a small patio. The upstairs terrace is converted to a enclosed gym area.
Townhouse, Arroyo de la Miel, Costa del Sol.
3 Bedrooms, 2 (...)
TSEA3105226
- Algarrobo, Costa Del Sol East
Beds: 8 Baths: 3 M2: 300 Lot Size: 450 Region: Andalucía
Beds: 8 Baths: 3 M2: 300 Lot Size: 450 Region: Andalucía
Fantastic opportunity to purchase a complete building of new construction in Algarrobo town. The building itself, gives to two streets, the ground floor consists of one apartment: living room, large (...)
TSEA3209428
- Benajarafe, Costa Del Sol East
Beds: 8 Baths: 5 M2: 460 Lot Size: 80,000 Region: Andalucía
Beds: 8 Baths: 5 M2: 460 Lot Size: 80,000 Region: Andalucía
Magnificent villa in Benajarafe alto, facing the Mediterranean Sea, on the Costa del Sol. Consists of seven rooms and four bathrooms and also an entire apartment for guests. All rooms with fitted (...)
TSEA3302554
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 265 Lot Size: 10,000 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 265 Lot Size: 10,000 Area: Estepona Region: Andalucía
Discover your dream home in the serene surroundings of Estepona!
This beautifully detached villa offers an unparalleled living experience with its high level of finishing and breathtaking views (...)
TSEA3302287
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 170 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 170 Area: Estepona Region: Andalucía
Middle Floor Apartment, Estepona, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 170 m², Terrace 50 m².
Setting : Beachfront, Beachside, Close To Shops, Close To Sea, Close To Town, Urbanisation, (...)
TSEA3301060
- Monda, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 277 Lot Size: 7,100 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 277 Lot Size: 7,100 Area: Marbella Region: Andalucía
Opportunity at Bargain price! Lovely country house set between the picturesque Andalusian villages of Monda and Guaro, just a few kilometres away from Marbella, with stunning views over the (...)
TSEA3288319
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 3 M2: 315 Lot Size: 2,148 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 3 M2: 315 Lot Size: 2,148 Area: Nerja and Malaga East Region: Andalucía
Country house in Nerja with a view of the sea and and mountains. The villa is distributed over 2 floors and both floors are accessed independantly.
From the main entrance there is a living-dining (...)
TSEA3287659
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 2 M2: 320 Lot Size: 28,640 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 2 M2: 320 Lot Size: 28,640 Area: Nerja and Malaga East Region: Andalucía
Fantastic Villa set in the countryside surrounded by an abundance of fruit trees and plants. The ground floor of the villa comprises of a spacious lounge with fireplace, dining area, fully fitted (...)
TSEA3278446
- Torrox, Costa Del Sol East
Beds: 8 Baths: 8 M2: 500 Lot Size: 3,000 Region: Andalucía
Beds: 8 Baths: 8 M2: 500 Lot Size: 3,000 Region: Andalucía
A rare opportunity to purchase one of the most outstanding properties in the Axarquia. The accommodation, both indoors and outdoors, offers everything the discerning buyer could wish for, including a (...)
TSEA3264607
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 6 Baths: 2 M2: 142 Lot Size: 800 Area: San Pedro Region: Andalucía
Beds: 6 Baths: 2 M2: 142 Lot Size: 800 Area: San Pedro Region: Andalucía
INVESTMENT PROJECT
For possible commercial use, 800 m2 PLOT
Location, location, location !!!
Walking disntance to the beach, San Pedro Playa.
Urb. Los Angeles
Roundabout Ctra. N340 and Ctra. de (...)
TSEA3262951
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 324 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 324 Area: Marbella East Region: Andalucía
Amazing front line beach penthouse in Hacienda Playa Phase 2 in Elviria, East Marbella. This stunning penthouse offers the most incredible sea views and spectacular sunsets every evening. The (...)
TSEA3258919
- Frigiliana, Costa Del Sol East
Beds: 5 Baths: 5 M2: 450 Lot Size: 2,239 Region: Andalucía
Beds: 5 Baths: 5 M2: 450 Lot Size: 2,239 Region: Andalucía
Nestled in the serene and sought-after community of Cortijos San Rafael, just off the Frigiliana road near Nerja, this outstanding detached villa—completed in 2008—offers an exceptional standard (...)
TSEA3250426
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 639 Lot Size: 939 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 639 Lot Size: 939 Area: Benahavis Region: Andalucía
Situated on a gated community just a short walk from the beautiful village of Benahavis and all its famous restaurants, and just seven kilometres inland from the glamourous coastal hotspots of Puerto (...)
TSEA3240280
- Coín, Costa Del Sol, Coin
Beds: 6 Baths: 3 M2: 473 Lot Size: 2,654 Area: Coin Region: Andalucía
Beds: 6 Baths: 3 M2: 473 Lot Size: 2,654 Area: Coin Region: Andalucía
CLOSE TO LA TROCHA COMERCIAL CENTER! Andalousian style villa in town with pool, tropical gardens and fruit trees. Has its own well.
The house offers a large outdoor space with patio, sitting area and (...)
