• Home
  • About Us
  • Development Opportunities
  • Investment Opportunities
  • Commercial Properties
    • - Freehold
    • - A1 General retail shops
    • - A2 Financial and professional services
    • - A3 Restaurant and cafes
    • - A4 Drinking establishments
    • - A5 Hot food takeaway
    • - Office
    • - D1
    • - Industrial
    • - Other
  • Commercial Management
  • Client List
  • The Team
  • News
  • Contact Us
  • Case Studies

Property Address

Options

Add to briefcase
SELECT SQL_CALC_FOUND_ROWS * FROM propertyfile pf WHERE pf.property_file_property_id = AND pf.property_file_active = 1 ORDER BY pf.property_file_disp DESC LIMIT 0, 1