• RESIDENTIAL COMMUNITIES COMMERCIAL PROPERTIES GOLF COURSES INVESTOR RELATIONS OUR COMPANY CONTACT US

      • QUICK SEARCH

      • VIEW PROPERTIES

    • Office
      • Calgary and Area
        • Chestermere
          • Chestermere Professional Building
        • Calgary
          • Greenwich (Office)
          • The District at North Deerfoot (Office)
          • Crowfoot Business Centre
          • Kensington Building
      • Edmonton and Area
        • Edmonton
          • Melton Block
          • The Village at Blackmud Creek (Office)
          • 100 Street Place
          • Birks Building
          • Capilano Centre
          • Melton Building
          • Princeton Place
          • Royal Bank Building
          • Stanley Building #1
          • Stanley Building #2
          • Sterling Business Centre
          • Trail Business Centre
          • Westcor Building
          • Westgate Business Park
      • Kelowna
        • Kelowna Business Centre
        • Richter Street Building
      • Red Deer
        • Clearview Market Square (Office)
      • Regina
        • Executive Terrace
        • Parliment Place
    • Retail
      • Calgary and Area
        • Airdrie
          • Kingsview Market
        • Chestermere
          • Chestermere Station
        • Calgary
          • Greenwich
          • Keystone Common
          • The District at North Deerfoot
          • West Calgary Marketplace
      • Edmonton and Area
        • Edmonton
          • The Shoppes at Jagare Ridge
          • The Village at Blackmud Creek (Retail)
          • West Henday Promenade
          • Miller Crossing
        • Leduc
          • Leduc Common
          • Corinthia Plaza
        • Spruce Grove
          • Westgrove Common
      • Fort McMurray
        • Stoneycreek Village
      • Lethbridge
        • The Shoppes at Canyons
        • West Pointe Marketplace
        • LethCentre
      • Red Deer
        • Clearview Market Square (Retail)
      • Regina
        • Market Mall
        • Towers Mall
        • University Park Shopping Centre
    • Industrial
      • Calgary and Area
        • Airdrie
          • Kingsview Market (Industrial)
        • Calgary
          • The District at North Deerfoot (Industrial)
      • Edmonton and Area
        • Leduc
          • Telford Industrial Park
        • Spruce Grove
          • Campsite Business Park
      • Red Deer
        • McKenzie Industrial Business Park
     
  • You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and active='Y'' at line 1 QUERY:SELECT * FROM m_comm_properties WHERE commId= and active='Y'