Access denied for user ''@'10.0.44.77' (using password: NO)SELECT p.*,a.logo, a.Name as agent_name, ps.name as status FROM properties p INNER JOIN agents a ON p.agent_id = a.id LEFT JOIN property_status ps ON ps.id = p.status_id WHERE p.sale = 1 AND p.price >= 0 AND (p.status_id IS NULL OR p.status_id NOT IN ('2','6','8') OR (p.status_id IN ('2', '8') AND p.sale = '1' AND p.rental = '1')) AND p.town <> 'NA' AND (p.country = 'Gibraltar' OR p.country = 'Spain') AND (p.status_id IS NULL OR p.status_id IN (1,3,4,5,7,9)) AND p.ref NOT LIKE 'S265' AND p.agent_id = '4' AND (p.price BETWEEN 50000 AND 1000000000) Access denied for user ''@'10.0.44.77' (using password: NO)SELECT p.*,a.logo, a.Name as agent_name, ps.name as status FROM properties p INNER JOIN agents a ON p.agent_id = a.id LEFT JOIN property_status ps ON ps.id = p.status_id WHERE p.sale = 1 AND p.price >= 0 AND (p.status_id IS NULL OR p.status_id NOT IN ('2','6','8') OR (p.status_id IN ('2', '8') AND p.sale = '1' AND p.rental = '1')) AND p.town <> 'NA' AND (p.country = 'Gibraltar' OR p.country = 'Spain') AND (p.status_id IS NULL OR p.status_id IN (1,3,4,5,7,9)) AND p.ref NOT LIKE 'S265' AND p.agent_id = '4' AND (p.price BETWEEN 50000 AND 1000000000) ORDER BY case when p.price = 0 then p.price end ASC,case when p.price > 0 then p.price end asc,createDate ASC LIMIT 0, 20 Gibraltar Property for sale | Gibraltar real estate for sale

Results 1 to of - Properties for sale

Show
Sort By
Show Only
Page of 0