Available Properties

admin

COMMERCIAL PROPERTY SEARCH

Available Commercial Properties

Join our mailing list and keep up-to-date with properties as they become available.

GRID | MAP
select p1.*,p2.* from wp_property_propertypilot as p1 LEFT join wp_property_propertypilot_meta_options as p2 on p1.property_id = p2.property_id where p1.property_status = '1' and property_name = 'status' and (p2.property_value NOT IN('Let','Sold','Sold STC')) and p1.property_leasehold > 0 GROUP By p1.property_id order by p1.id LIMIT 0, 12
Page 1 of 71 2 3 … 7
Register interest

Stay informed of opportunities to sell / lease or buy / let.

SIGN UP