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`.`golf_view` IN ('1') AND p.approved = 1 AND pm.cat_id IN (40,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67)
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`.`golf_view` IN ('1') AND `p`.`featured` IN ('1') AND p.approved = 1 AND pm.cat_id IN (40,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67)
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`.`golf_view` IN ('1') AND p.approved = 1 AND pm.cat_id IN (40,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67)
GROUP BY p.id
ORDER BY p.created DESC
Golf properties for sale on the Costa Del Sol
Special Selection
€345,000
2 Beds | 2 Baths
Habitable Size 69 m2 | Terrace Space : 20 m2 | Land Size : 22 m2
Sea View
Pool
More Info
€165,000
2 Beds | 2 Baths
Habitable Size 91 m2 | Terrace Space : 35 m2
Pool
More Info
€1,995,000
9 Beds | 11 Baths
Habitable Size 817 m2 | Land Size : 522 m2
Pool
More Info
Special Selection
€683,000
3 Beds | 2 Baths
Habitable Size 124 m2 | Terrace Space : 83 m2
Sea View
Pool
More Info
Special Selection
€464,500
2 Beds | 2 Baths
Habitable Size 84 m2 | Terrace Space : 53 m2
Sea View
Pool
More Info
Special Selection
€310,000
3 Beds | 2 Baths
Habitable Size 90 m2 | Terrace Space : 26 m2
Pool
More Info
Special Selection
€279,000
2 Beds | 2 Baths
Habitable Size 77 m2 | Terrace Space : 7 m2
Pool
More Info
€550,000
3 Beds | 2 Baths
Habitable Size 120 m2 | Terrace Space : 30 m2
Sea View
Pool
More Info
Special Selection
€850,000
2 Beds | 2 Baths
Habitable Size 133 m2 | Terrace Space : 59 m2
Pool
More Info
€1,400,000
2 Beds | 2 Baths
Habitable Size 129 m2 | Terrace Space : 75 m2
Sea View
Pool
More Info
€382,000
2 Beds | 2 Baths
Habitable Size 113 m2 | Terrace Space : 37 m2
Sea View
Pool
More Info
€2,300,000
4 Beds | 5 Baths
Habitable Size 617 m2 | Terrace Space : 200 m2 | Land Size : 4,331 m2
Sea View
Pool
More Info
Special Selection
€444,000
3 Beds | 2 Baths
Habitable Size 137 m2 | Terrace Space : 27 m2
Pool
More Info
€575,000
2 Beds | 2 Baths
Habitable Size 102 m2 | Terrace Space : 28 m2
Pool
More Info
Special Selection
€445,000
2 Beds | 2 Baths
Habitable Size 87 m2 | Terrace Space : 28 m2
Pool
More Info
Special Selection
€735,000
3 Beds | 2 Baths
Habitable Size 133 m2 | Terrace Space : 88 m2
Sea View
Pool
More Info
Special Selection
€430,000
3 Beds | 2 Baths
Habitable Size 103 m2 | Terrace Space : 28 m2
Pool
More Info
Special Selection
€732,000
3 Beds | 2 Baths
Habitable Size 121 m2 | Terrace Space : 29 m2
Pool
More Info
€1,150,000
4 Beds | 3 Baths
Habitable Size 567 m2 | Terrace Space : 200 m2
Pool
More Info
Special Selection
€470,000
3 Beds | 2 Baths
Habitable Size 115 m2 | Terrace Space : 27 m2
Pool
More Info