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 (46)
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 (46)
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 (46)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 21 - 27 of 27 €299,000
TSEA4083685
- San Diego, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 Lot Size: 1,000 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 Lot Size: 1,000 Area: Sotogrande Region: Andalucía
Residential Plot, San Diego, Costa del Sol.
Garden/Plot 1000 m².
Setting : Urbanisation.
Orientation : South.
Pool : Room For Pool.
Views : Sea.
€570,000
TSEA4077820
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 200 Lot Size: 400 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Lot Size: 400 Area: Estepona Region: Andalucía
Residential Plot, Estepona, Costa del Sol.
Garden/Plot 400 m².
Setting : Town, Suburban, Commercial Area, Village, Close To Shops, Close To Sea, Close To Schools.
Orientation : South.
Condition : (...)
€589,500
TSEA4020820
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 5 Lot Size: 3,473 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 5 Lot Size: 3,473 Area: Benahavis Region: Andalucía
Plot+Project+License
Residential Plot, Benahavís, Costa del Sol.
Garden/Plot 3473 m².
Setting : Close To Golf, Urbanisation.
Orientation : South.
Condition : Excellent.
Views : Sea, Mountain, (...)
€440,000
TSEA3997876
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 280 Lot Size: 1,486 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 280 Lot Size: 1,486 Area: Mijas and Mijas Costa Region: Andalucía
Plot with building license.
Villa Cala Golf 43 is a contemporary luxury villa nestled within one of the most beautiful and popular locations on the Costa del Sol - La Cala Golf Resort in La Cala de (...)
€70,800
TSEA3325432
- La Viñuela, Costa Del Sol East
Beds: 1 Baths: 1 M2: 7,182 Lot Size: 7,182 Region: Andalucía
Beds: 1 Baths: 1 M2: 7,182 Lot Size: 7,182 Region: Andalucía
Several building plots close to the lake of la Viñuela. These plots are located in an area where are already several villas built, therefore we already have constituted the streets. Beautiful views (...)
€315,000
TSEA3472072
- Benajarafe, Costa Del Sol East
Beds: 1 Baths: 1 M2: 918 Lot Size: 918 Region: Andalucía
Beds: 1 Baths: 1 M2: 918 Lot Size: 918 Region: Andalucía
Fantastic urban plot of 918 m2, located in Benajarafe. Five minutes from the beach and the shops of the town. 15 minutes from Málaga and 25 from the airport. It has views to the sea and nothing else (...)
€1,200,000
TSEA2670191
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 6 M2: 578 Lot Size: 880 Area: Marbella Region: Andalucía
Beds: 5 Baths: 6 M2: 578 Lot Size: 880 Area: Marbella Region: Andalucía
Located within walking distance of less than 100 m. to the best beach in Marbella , Elviria with its fine sand dunes with kilometers of beach to walk and swim.
For sale including Basic and Execution (...)
