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 7261 - 7280 of 7581
TSEA3979039
- Caleta de Vélez, Costa Del Sol East
Beds: 2 Baths: 2 M2: 90 Lot Size: 90 Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Lot Size: 90 Region: Andalucía
Beautiful duplex flat in first line beach, with wonderful views to the sea. It has an open plan kitchen, which opens onto a small balcony. It is next to the cosy living room. On the same floor there (...)
TSEA3978817
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 229 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 229 Area: La Duquesa Region: Andalucía
Magnificent FIRST FLOOR APARTMENT with spectacular sea views, located in an urbanization area at a short distance from Sotogrande harbour and close the beach. In impecable condiction, the apartment (...)
TSEA3975967
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 4 M2: 292 Lot Size: 3,500 Area: Estepona Region: Andalucía
Beds: 6 Baths: 4 M2: 292 Lot Size: 3,500 Area: Estepona Region: Andalucía
Great villa only minutes away from the center of Estepona with open sea and mountain views. Perfectly maintained ready to move in. Offers bedrooms in the ground floor and first floor. A total of six (...)
TSEA3974668
- Los Flamingos, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Lot Size: 23 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 23 Area: Estepona Region: Andalucía
A beautifully furnished 2 bedroom apartment in Hoyo 19 which is located in the wonderful and exclusive development of Los Flamingos Golf Resort Resort in Benahavis. The apartment has hot and cold air (...)
TSEA3972739
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 11 Baths: 8 M2: 1,028 Lot Size: 2,300 Area: Torremolinos Region: Andalucía
Beds: 11 Baths: 8 M2: 1,028 Lot Size: 2,300 Area: Torremolinos Region: Andalucía
Exclusive Villa in a Prestigious Urbanization Between Málaga and Torremolinos
Discover this magnificent villa, originally designed as a spacious family home, located in one of the most sought-after (...)
Middle Floor Apartment in Los Monteros
- Los Monteros, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
LUXURY TO ITS HIGHEST STANDARD!!!
A development of 39 luxury apartments. Located in the upper part of Los Monteros, this contemporary design development distributed over 5 floors plus an attic, has (...)
TSEA3969424
- Los Monteros, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 87 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Marbella East Region: Andalucía
SO PEACEFUL YOU WON'T HEAR A PIN DROP!!!
Come and see this fabulous development of 39 luxury apartments located in the upper part of Los Monteros. This contemporary design development distributed (...)
TSEA3968908
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 195 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 195 Area: Marbella Region: Andalucía
Very large penthouse in the center of Marbella. Sought after location with all services and amenities at door step and just a stroll to the beach. This ample and full of light top floor apartment (...)
TSEA3967933
- New Golden Mile, Costa Del Sol, Estepona
Beds: 5 Baths: 4 M2: 528 Lot Size: 1,525 Area: Estepona Region: Andalucía
Beds: 5 Baths: 4 M2: 528 Lot Size: 1,525 Area: Estepona Region: Andalucía
Very nice and ample traditional villa located close to ALDI and Burguer King and the beach on the New Golden Mile. Only 5Km from Estepona center and less than one kilometer to the beach. The large (...)
Detached Villa in Marbella
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 8 M2: 943 Lot Size: 1,850 Area: Marbella Region: Andalucía
Beds: 7 Baths: 8 M2: 943 Lot Size: 1,850 Area: Marbella Region: Andalucía
BUILDING LICENCE ON PLACE ! This project is a unique luxury south facing villas, which has an unbeatable location on the mountain peak of the most prestigious area of the Golden Mile,gated community (...)
TSEA3966214
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 520 Lot Size: 1,027 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 520 Lot Size: 1,027 Area: Mijas and Mijas Costa Region: Andalucía
spectacular villa for sale in Sierrazuela
entering through the main gate there is parking for 4 cars and a garage for 6 futher vehicles
on the lower level there is a bar, games room, fire place and (...)
TSEA3966163
- San Martín de Tesorillo, Costa Del Sol, Sotogrande
Beds: 6 Baths: 4 M2: 401 Lot Size: 170,012 Area: Sotogrande Region: Andalucía
Beds: 6 Baths: 4 M2: 401 Lot Size: 170,012 Area: Sotogrande Region: Andalucía
. Wonderful country estate (horses), 6 dorm, very close to Sotogrande . . Montenegral is located in the heart of the Horse Valley, a name which is not surprising in a landscape of green fields and (...)
TSEA3956707
- Alozaina, Costa Del Sol, Alozaina
Beds: 8 Baths: 6 M2: 850 Lot Size: 160,000 Area: Alozaina Region: Andalucía
Beds: 8 Baths: 6 M2: 850 Lot Size: 160,000 Area: Alozaina Region: Andalucía
A magic of the Andalusian countryside. Located at the foot of the Natural Park of the Sierra de las Nieves. With incredible views and 5 minutes from the village of Alozaina, with all (...)
TSEA3955906
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 118 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 118 Area: Estepona Region: Andalucía
ELEGANT AND MODERN IN THE HEART OF COSTA DEL SOL. This development is nestled in an incomparable natural environment where the sea meets the mountain and there is golf and all the services of (...)
TSEA3950773
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 159 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 159 Area: Estepona Region: Andalucía
Ggreat property in Alhambra del Golf ready to move in. High standards, perfect location, beach side, three bedrooms 3 baths, garage and storage. Closed gated secured complex. Beach side of the main (...)
TSEA3948409
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 151 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 151 Area: Fuengirola Region: Andalucía
THE ESSENCE OF THE MEDITERRANEAN LIFESTYLE.
Located in the northern area of the Torreblanca del Sol, in the municipality of Fuengirola. An open block multi-family building with a total of 30 (...)
TSEA3948304
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 92 Lot Size: 86 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 92 Lot Size: 86 Area: Fuengirola Region: Andalucía
EVERY DETAIL HAS BEEN TAKEN CARE OF!!!
Located in the northern area of the Torreblanca del Sol Development, in the municipality of Fuengirola. An open block multi-family building with a total of 30 (...)
TSEA3946663
- Elviria, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 579 Lot Size: 1,335 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 579 Lot Size: 1,335 Area: Marbella East Region: Andalucía
This unique luxury, very modern high-tech villa yet embracing Andalusian charm, is located first line golf to the Santa Maria Golf course offering breathtaking sea views. This very spacious property, (...)
TSEA3945406
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 7 M2: 441 Lot Size: 1,245 Area: Marbella Region: Andalucía
Beds: 7 Baths: 7 M2: 441 Lot Size: 1,245 Area: Marbella Region: Andalucía
Villa situated in a central position of Las Brisas, within walking distance of shops and restaurants.
Totally refurbished in the summer of 2018 to a luxury standard with the best quality and (...)
TSEA3944029
- Cómpeta, Costa Del Sol East
Beds: 2 Baths: 1 M2: 124 Lot Size: 12,000 Region: Andalucía
Beds: 2 Baths: 1 M2: 124 Lot Size: 12,000 Region: Andalucía
If you are looking for a country house that you can design according to your taste and needs, this is the perfect property for you - an old Andalusian farmhouse with lots of charm and character. (...)
